diff artifact-database/src/main/resources/sql/org-h2-driver.properties @ 303:190aa68ae7a8

Added method to artifact database to load all artifacts. artifacts/trunk@2408 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 27 Jul 2011 09:32:26 +0000
parents 942a54670a72
children a077bb098eb4
line wrap: on
line diff
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties	Tue Jul 26 10:19:19 2011 +0000
+++ b/artifact-database/src/main/resources/sql/org-h2-driver.properties	Wed Jul 27 09:32:26 2011 +0000
@@ -181,3 +181,10 @@
 
 collection.set.attribute= \
     UPDATE collections SET attribute = ? WHERE gid = ?
+
+all.artifacts = \
+    SELECT u.gid AS u_gid, c.gid AS c_gid, a.gid AS a_gid, a.factory AS factory, a.data AS data FROM \
+        users u INNER JOIN collections c       ON u.id = c.owner_id \
+                INNER JOIN collection_items ci ON c.id = ci.collection_id \
+                INNER JOIN artifacts a         ON a.if = ci.artifact_id \
+        ORDER BY u_gid, c_gid

http://dive4elements.wald.intevation.org