From 8b3db6ef6307191609d2dab837032db16aa13375 Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Fri, 9 Nov 2012 12:55:43 +0100
Subject: wip

---
 .../testing/gitorious/GitoriousProjectDao.java     | 26 +++++-----------------
 1 file changed, 5 insertions(+), 21 deletions(-)

(limited to 'src/main/java/io/trygvis/esper/testing/gitorious/GitoriousProjectDao.java')

diff --git a/src/main/java/io/trygvis/esper/testing/gitorious/GitoriousProjectDao.java b/src/main/java/io/trygvis/esper/testing/gitorious/GitoriousProjectDao.java
index 432d154..262d23c 100644
--- a/src/main/java/io/trygvis/esper/testing/gitorious/GitoriousProjectDao.java
+++ b/src/main/java/io/trygvis/esper/testing/gitorious/GitoriousProjectDao.java
@@ -1,8 +1,5 @@
 package io.trygvis.esper.testing.gitorious;
 
-import fj.*;
-
-import java.net.*;
 import java.sql.*;
 import java.util.*;
 
@@ -21,18 +18,17 @@ public class GitoriousProjectDao extends Dao {
         }
     }
 
-    private final PreparedStatement insertProject = prepareStatement("INSERT INTO gitorious_project(slug, atom_feed) VALUES(?, ?)");
+    private final PreparedStatement insertProject = prepareStatement("INSERT INTO gitorious_project(slug) VALUES(?)");
 
-    public void insertProject(GitoriousProject project) throws SQLException {
-        insertProject.setString(1, project.slug);
-        insertProject.setString(2, project.atomFeed.toASCIIString());
+    public void insertProject(String slug) throws SQLException {
+        insertProject.setString(1, slug);
         insertProject.executeUpdate();
     }
 
-    private final PreparedStatement selectAll = prepareStatement("SELECT slug FROM gitorious_project");
+    private final PreparedStatement selectSlugs = prepareStatement("SELECT slug FROM gitorious_project");
 
     public List<String> selectSlugs() throws SQLException {
-        try (ResultSet rs = selectAll.executeQuery()) {
+        try (ResultSet rs = selectSlugs.executeQuery()) {
             List<String> list = new ArrayList<>();
             while (rs.next()) {
                 list.add(rs.getString(1));
@@ -41,18 +37,6 @@ public class GitoriousProjectDao extends Dao {
         }
     }
 
-    private final PreparedStatement selectFeeds = prepareStatement("SELECT slug, atom_feed FROM gitorious_project");
-
-    public List<P2<String, URI>> selectFeeds() throws SQLException {
-        try (ResultSet rs = selectFeeds.executeQuery()) {
-            List<P2<String, URI>> list = new ArrayList<>();
-            while (rs.next()) {
-                list.add(P.p(rs.getString(1), URI.create(rs.getString(2))));
-            }
-            return list;
-        }
-    }
-
     private final PreparedStatement delete = prepareStatement("DELETE FROM gitorious_project WHERE slug=?");
 
     public void delete(String slug) throws SQLException {
-- 
cgit v1.2.3