o Slurping down the entire list of projects.

1 files changed, 27 insertions, 0 deletions

diff --git a/src/main/java/io/trygvis/esper/testing/gitorious/GitoriousDao.java b/src/main/java/io/trygvis/esper/testing/gitorious/GitoriousDao.java
new file mode 100644
index 0000000..766a4a9
--- /dev/null
+++ b/src/main/java/io/trygvis/esper/testing/gitorious/GitoriousDao.java
@@ -0,0 +1,27 @@
+package io.trygvis.esper.testing.gitorious;
+
+import java.sql.*;
+
+public class GitoriousDao {
+    private final PreparedStatement countEntryId;
+    private final PreparedStatement insertChange;
+
+    public GitoriousDao(Connection c) throws SQLException {
+        countEntryId = c.prepareStatement("SELECT count(entry_id) FROM gitorious_change WHERE entry_id=?");
+        insertChange = c.prepareStatement("INSERT INTO gitorious_change(entry_id, text) VALUES(?, ?)");
+    }
+
+    public int countEntryId(String entryId) throws SQLException {
+        countEntryId.setString(1, entryId);
+        try(ResultSet rs = countEntryId.executeQuery()) {
+            rs.next();
+            return rs.getInt(1);
+        }
+    }
+
+    public void insertChange(String entryId, String text) throws SQLException {
+        insertChange.setString(1, entryId);
+        insertChange.setString(2, text);
+        insertChange.executeUpdate();
+    }
+}