diff options
| author | David A. Madore <david+git@madore.org> | 2011-09-05 16:22:54 +0200 |
|---|---|---|
| committer | David A. Madore <david+git@madore.org> | 2011-09-05 16:22:54 +0200 |
| commit | f86df60a550f6c8203e104f1dbbdb4afee2bc6b6 (patch) | |
| tree | bd79f3829e1a7d30a3e7aa610e92f3e4c9be1dfa | |
| parent | 3a45fb84f48846fc1e11b20e7e02a26cb3ae7f77 (diff) | |
| download | damlengine-f86df60a550f6c8203e104f1dbbdb4afee2bc6b6.tar.gz damlengine-f86df60a550f6c8203e104f1dbbdb4afee2bc6b6.tar.bz2 damlengine-f86df60a550f6c8203e104f1dbbdb4afee2bc6b6.zip | |
Allow the cdate attribute to override that in the database.
| -rw-r--r-- | org/madore/damlengine/WeblogPopulate.java | 19 |
1 files changed, 16 insertions, 3 deletions
diff --git a/org/madore/damlengine/WeblogPopulate.java b/org/madore/damlengine/WeblogPopulate.java index 0cc6620..c3b76b9 100644 --- a/org/madore/damlengine/WeblogPopulate.java +++ b/org/madore/damlengine/WeblogPopulate.java @@ -49,8 +49,10 @@ public final class WeblogPopulate { = conn.prepareStatement("INSERT INTO entries(id,edate,lang,title,title_xml,content,sha1) VALUES (?,?,?,?,?::xml,?::xml,?)"); final PreparedStatement insertCSt = conn.prepareStatement("INSERT INTO entries(id,edate,lang,title,title_xml,content,sha1,cdate) VALUES (?,?,?,?,?::xml,?::xml,?,?::timestamptz)"); - final PreparedStatement updateSt + final PreparedStatement updateNSt = conn.prepareStatement("UPDATE entries SET (edate,mdate,lang,title,title_xml,content,sha1)=(?,DEFAULT,?,?,?::xml,?::xml,?) WHERE id=?"); + final PreparedStatement updateCSt + = conn.prepareStatement("UPDATE entries SET (edate,mdate,lang,title,title_xml,content,sha1,cdate)=(?,DEFAULT,?,?,?::xml,?::xml,?,?::timestamptz) WHERE id=?"); final PreparedStatement clearCatSt = conn.prepareStatement("DELETE FROM incat WHERE id=?"); final PreparedStatement setCatSt @@ -97,13 +99,23 @@ public final class WeblogPopulate { conn.setAutoCommit(false); if ( exists ) { System.err.println("Updating entry "+id); + PreparedStatement updateSt; + if ( cdate == null ) + updateSt = updateNSt; + else + updateSt = updateCSt; updateSt.setString(1, date); updateSt.setString(2, lang); updateSt.setString(3, titleTxt); updateSt.setString(4, titleXml); updateSt.setString(5, content); updateSt.setString(6, digest); - updateSt.setInt(7, id); + if ( cdate != null ) { + updateSt.setString(7, cdate); + updateSt.setInt(8, id); + } else { + updateSt.setInt(7, id); + } updateSt.executeUpdate(); } else { System.err.println("Registering entry "+id); @@ -138,7 +150,8 @@ public final class WeblogPopulate { checkSt.close(); insertNSt.close(); insertCSt.close(); - updateSt.close(); + updateNSt.close(); + updateCSt.close(); clearCatSt.close(); setCatSt.close(); |