aboutsummaryrefslogtreecommitdiff
path: root/src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java
diff options
context:
space:
mode:
authorTrygve Laugstøl <trygvis@inamo.no>2013-01-03 15:09:43 +0100
committerTrygve Laugstøl <trygvis@inamo.no>2013-01-03 15:09:43 +0100
commit35ba1a6f765f72a1d91a5456c7556e6274f8c3a9 (patch)
tree18d069a4512cec4fca1c93964adcb039b9ee6167 /src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java
parent84fb49088a14cff8b453e0e32f6ad7007eb2184a (diff)
downloadesper-testing-35ba1a6f765f72a1d91a5456c7556e6274f8c3a9.tar.gz
esper-testing-35ba1a6f765f72a1d91a5456c7556e6274f8c3a9.tar.bz2
esper-testing-35ba1a6f765f72a1d91a5456c7556e6274f8c3a9.tar.xz
esper-testing-35ba1a6f765f72a1d91a5456c7556e6274f8c3a9.zip
o Moving Jenkins XML objects and parsing to it's own package.
o Removing fields from JenkinsBuild that's read from the XML later on.
Diffstat (limited to 'src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java')
-rwxr-xr-x[-rw-r--r--]src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java28
1 files changed, 10 insertions, 18 deletions
diff --git a/src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java b/src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java
index e94c7fd..aec9ab3 100644..100755
--- a/src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java
+++ b/src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java
@@ -1,19 +1,19 @@
package io.trygvis.esper.testing.jenkins;
import fj.data.*;
+import io.trygvis.esper.testing.jenkins.xml.*;
import io.trygvis.esper.testing.util.sql.*;
import org.joda.time.*;
import java.net.*;
import java.sql.*;
-import java.util.*;
import java.util.List;
+import java.util.*;
-import static fj.data.Option.*;
-import static io.trygvis.esper.testing.Util.toList;
-import static io.trygvis.esper.testing.Util.toUuidArray;
-import static io.trygvis.esper.testing.util.sql.ResultSetF.getInt;
-import static io.trygvis.esper.testing.util.sql.SqlOption.fromRs;
+import static fj.data.Option.fromNull;
+import static io.trygvis.esper.testing.Util.*;
+import static io.trygvis.esper.testing.util.sql.ResultSetF.*;
+import static io.trygvis.esper.testing.util.sql.SqlOption.*;
import static java.lang.System.*;
public class JenkinsDao {
@@ -53,7 +53,7 @@ public class JenkinsDao {
}
};
- public static final String JENKINS_BUILD = "uuid, created_date, job, file, entry_id, url, result, number, duration, timestamp, users";
+ public static final String JENKINS_BUILD = "uuid, created_date, job, file, entry_id, url, users";
public static final SqlF<ResultSet, JenkinsBuildDto> jenkinsBuild = new SqlF<ResultSet, JenkinsBuildDto>() {
public JenkinsBuildDto apply(ResultSet rs) throws SQLException {
@@ -65,10 +65,6 @@ public class JenkinsDao {
UUID.fromString(rs.getString(i++)),
rs.getString(i++),
URI.create(rs.getString(i++)),
- rs.getString(i++),
- rs.getInt(i++),
- rs.getInt(i++),
- new DateTime(rs.getTimestamp(i++).getTime()),
toUuidArray(rs, i));
}
};
@@ -191,8 +187,8 @@ public class JenkinsDao {
}
}
- public UUID insertBuild(UUID job, UUID file, String entryId, URI url, String result, int number, int duration, long timestamp, UUID[] users) throws SQLException {
- try (PreparedStatement s = c.prepareStatement("INSERT INTO jenkins_build(" + JENKINS_BUILD + ") VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {
+ public UUID insertBuild(UUID job, UUID file, String entryId, URI url, UUID[] users) throws SQLException {
+ try (PreparedStatement s = c.prepareStatement("INSERT INTO jenkins_build(" + JENKINS_BUILD + ") VALUES(?, ?, ?, ?, ?, ?, ?)")) {
UUID uuid = UUID.randomUUID();
int i = 1;
s.setString(i++, uuid.toString());
@@ -200,11 +196,7 @@ public class JenkinsDao {
s.setString(i++, job.toString());
s.setString(i++, file.toString());
s.setString(i++, entryId);
- s.setString(i++, url.toASCIIString());
- s.setString(i++, result);
- s.setInt(i++, number);
- s.setInt(i++, duration);
- s.setTimestamp(i++, new Timestamp(timestamp));
+ s.setString(i, url.toASCIIString());
s.setArray(i, c.createArrayOf("varchar", users));
s.executeUpdate();