aboutsummaryrefslogtreecommitdiff
path: root/src/main/java/io/trygvis/esper/testing/gitorious/GitoriousProjectDao.java
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/java/io/trygvis/esper/testing/gitorious/GitoriousProjectDao.java')
-rw-r--r--src/main/java/io/trygvis/esper/testing/gitorious/GitoriousProjectDao.java26
1 files changed, 5 insertions, 21 deletions
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 {