comparison artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 184:a22b7e367b25

Added Backend code to list the collection items in a collection. artifacts/trunk@1410 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 07 Mar 2011 11:37:49 +0000
parents 38fbbeffe8fe
children a85d889a1b0d
comparison
equal deleted inserted replaced
183:9b8923043a38 184:a22b7e367b25
73 WHERE id = ? AND \ 73 WHERE id = ? AND \
74 NOT EXSITS (SELECT id FROM collections_items WHERE <> collection_id = ?) 74 NOT EXSITS (SELECT id FROM collections_items WHERE <> collection_id = ?)
75 75
76 collection.item.delete=DELETE FROM collections_items WHERE id = ? 76 collection.item.delete=DELETE FROM collections_items WHERE id = ?
77 77
78 collection.items.list.gid= \
79 SELECT a.gid, ci.attribute FROM collections_items ci \
80 INNER JOIN artifacts a ON ci.artifact_id = a.id \
81 WHERE ci.id IN (SELECT id FROM collections WHERE gid = ?)
82
78 # COLLECTIONS 83 # COLLECTIONS
79 collections.touch.by.gid =\ 84 collections.touch.by.gid =\
80 UPDATE collection SET last_access = CURRENT_TIMESTAMP \ 85 UPDATE collection SET last_access = CURRENT_TIMESTAMP \
81 WHERE gid = ?::uuid 86 WHERE gid = ?::uuid
82 87

http://dive4elements.wald.intevation.org