From 5c8c3467906d996c04210cc8350edbd027ccc32a Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Thu, 3 Jan 2013 17:10:30 +0100
Subject: o Skipping builds where the job is a <mavenModule>. o Using the
 build's timestamp instead of createdDate in the UI.

---
 src/main/java/io/trygvis/esper/testing/core/db/FileDao.java | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'src/main/java/io/trygvis/esper/testing/core/db')

diff --git a/src/main/java/io/trygvis/esper/testing/core/db/FileDao.java b/src/main/java/io/trygvis/esper/testing/core/db/FileDao.java
index affe1c8..a7d7199 100755
--- a/src/main/java/io/trygvis/esper/testing/core/db/FileDao.java
+++ b/src/main/java/io/trygvis/esper/testing/core/db/FileDao.java
@@ -41,4 +41,15 @@ public class FileDao {
             return some(rs.getBinaryStream(1));
         }
     }
+
+    public SqlOption<InputStream> loadByUrl(URI uri) throws SQLException {
+        try (PreparedStatement s = c.prepareStatement("SELECT data FROM file WHERE url=?")) {
+            s.setString(1, uri.toASCIIString());
+            ResultSet rs = s.executeQuery();
+            if(!rs.next()) {
+                return none();
+            }
+            return some(rs.getBinaryStream(1));
+        }
+    }
 }
-- 
cgit v1.2.3