Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 253:a2df2b48d2aa
Enabled the artifact database to handle requests specific to collection attributes and collection item attributes.
artifacts/trunk@1746 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 26 Apr 2011 07:43:40 +0000 |
| parents | 33b9cc23ac9b |
| children | 22a90706d32d |
comparison
equal
deleted
inserted
replaced
| 252:6de74b0b878e | 253:a2df2b48d2aa |
|---|---|
| 158 collection_id IN (SELECT id FROM collections WHERE owner_id = ?) \ | 158 collection_id IN (SELECT id FROM collections WHERE owner_id = ?) \ |
| 159 AND artifact_id NOT IN \ | 159 AND artifact_id NOT IN \ |
| 160 (SELECT artifact_id FROM collection_items WHERE collection_id IN \ | 160 (SELECT artifact_id FROM collection_items WHERE collection_id IN \ |
| 161 (SELECT id FROM collections WHERE owner_id <> ?))) | 161 (SELECT id FROM collections WHERE owner_id <> ?))) |
| 162 | 162 |
| 163 collection.get.attribute= \ | |
| 164 SELECT c.attribute FROM collections c WHERE c.gid = ?::uuid | |
| 165 | |
| 166 collection.set.attribute= \ | |
| 167 UPDATE collections SET attribute = ? WHERE gid = ?::uuid |