Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 274:92166f7c3842
#50 Added code on database level to recognize the oldest collection item in a collection (-> master artifact).
artifacts/trunk@2071 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 07 Jun 2011 17:09:25 +0000 |
| parents | 22a90706d32d |
| children | e92d5944fe4b |
comparison
equal
deleted
inserted
replaced
| 273:22a90706d32d | 274:92166f7c3842 |
|---|---|
| 49 | 49 |
| 50 # COLLECTION ITEMS | 50 # COLLECTION ITEMS |
| 51 collection.items.id.nextval=SELECT NEXTVAL('COLLECTION_ITEMS_ID_SEQ') | 51 collection.items.id.nextval=SELECT NEXTVAL('COLLECTION_ITEMS_ID_SEQ') |
| 52 | 52 |
| 53 collection.items.insert=INSERT INTO collection_items \ | 53 collection.items.insert=INSERT INTO collection_items \ |
| 54 (id, collection_id, artifact_id, attribute) \ | 54 (id, collection_id, artifact_id, attribute, creation) \ |
| 55 VALUES (?, ?, ?, ?) | 55 VALUES (?, ?, ?, ?, CURRENT_TIMESTAMP) |
| 56 | 56 |
| 57 collection.item.get.attribute= \ | 57 collection.item.get.attribute= \ |
| 58 SELECT ci.attribute FROM collection_items ci \ | 58 SELECT ci.attribute FROM collection_items ci \ |
| 59 INNER JOIN collections c ON ci.collection_id = c.id \ | 59 INNER JOIN collections c ON ci.collection_id = c.id \ |
| 60 INNER JOIN artifacts a ON ci.artifact_id = a.id \ | 60 INNER JOIN artifacts a ON ci.artifact_id = a.id \ |
| 83 collection.item.delete=DELETE FROM collection_items WHERE id = ? | 83 collection.item.delete=DELETE FROM collection_items WHERE id = ? |
| 84 | 84 |
| 85 collection.items.list.gid= \ | 85 collection.items.list.gid= \ |
| 86 SELECT a.gid, ci.attribute FROM collection_items ci \ | 86 SELECT a.gid, ci.attribute FROM collection_items ci \ |
| 87 INNER JOIN artifacts a ON ci.artifact_id = a.id \ | 87 INNER JOIN artifacts a ON ci.artifact_id = a.id \ |
| 88 WHERE ci.collection_id IN (SELECT id FROM collections WHERE gid = ?::uuid) | 88 WHERE ci.collection_id IN (SELECT id FROM collections WHERE gid = ?::uuid) \ |
| 89 ORDER BY ci.creation | |
| 89 | 90 |
| 90 # COLLECTIONS | 91 # COLLECTIONS |
| 91 | 92 |
| 92 collections.outdated= \ | 93 collections.outdated= \ |
| 93 SELECT c.id FROM collections c \ | 94 SELECT c.id FROM collections c \ |