Mercurial > dive4elements > framework
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 |