diff artifact-database/src/main/resources/sql/org-h2-driver.properties @ 80:8447467cef86

Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). artifacts/trunk@799 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Fri, 19 Mar 2010 09:34:40 +0000
parents b8516aa3d8a1
children caf9f456f7e3
line wrap: on
line diff
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties	Tue Mar 16 16:03:06 2010 +0000
+++ b/artifact-database/src/main/resources/sql/org-h2-driver.properties	Fri Mar 19 09:34:40 2010 +0000
@@ -14,4 +14,11 @@
 
 artifacts.select.gid=SELECT id, last_access, ttl, factory, data FROM artifacts WHERE gid = ?
 
+artifacts.get.id=SELECT id FROM artifacts WHERE gid = ?
+
+artifacts.replace=UPDATE artifacts SET \
+    creation = CURRENT_TIMESTAMP, last_access = CURRENT_TIMESTAMP, \
+    ttl = ?, factory = ?, data = ? \
+    WHERE id = ?
+
 artifacts.delete=DELETE FROM artifacts WHERE id = ?

http://dive4elements.wald.intevation.org