Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 167:c9c27aca2f70
Added code to list collections.
artifacts/trunk@1392 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 03 Mar 2011 17:01:04 +0000 |
| parents | db0d20440b92 |
| children | ac0f8bd97277 |
comparison
equal
deleted
inserted
replaced
| 166:89db80380f7f | 167:c9c27aca2f70 |
|---|---|
| 47 | 47 |
| 48 collections.insert= \ | 48 collections.insert= \ |
| 49 INSERT INTO collections (id, gid, name, owner_id, creation, last_access, ttl) \ | 49 INSERT INTO collections (id, gid, name, owner_id, creation, last_access, ttl) \ |
| 50 VALUES (?, ?::uuid, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?) | 50 VALUES (?, ?::uuid, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?) |
| 51 | 51 |
| 52 collections.select.user= \ | |
| 53 SELECT c.gid, c.name, c.creation, u.gid FROM \ | |
| 54 collections c OUTER LEFT JOIN user u ON c.owner_id = u.id \ | |
| 55 WHERE u.gid = ?::uuid | |
| 56 | |
| 57 collections.select.all= \ | |
| 58 SELECT c.gid, c.name, c.creation, u.gid FROM \ | |
| 59 collections c OUTER LEFT JOIN user u ON c.owner_id = u.id | |
| 60 | |
| 52 users.collections=SELECT collection_id, gid, name FROM collections WHERE owner_id = ? | 61 users.collections=SELECT collection_id, gid, name FROM collections WHERE owner_id = ? |
| 53 users.collection.ids=SELECT collection_id FROM collections WHERE owner_id = ? | 62 users.collection.ids=SELECT collection_id FROM collections WHERE owner_id = ? |
| 54 | 63 |
| 55 artifacts.in.one.collection.only=\ | 64 artifacts.in.one.collection.only=\ |
| 56 SELECT artifact_id FROM collection_items\ | 65 SELECT artifact_id FROM collection_items\ |