comparison artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 542:9497f58484a0

Ugly: Filter collection items in user land.
author Sascha L. Teichmann <teichmann@intevation.de>
date Thu, 03 Sep 2015 17:00:30 +0200
parents 4213dd6ca169
children e9abf747f6ce
comparison
equal deleted inserted replaced
541:3b1e48d22ce0 542:9497f58484a0
7 artifacts.update=UPDATE artifacts SET last_access = CURRENT_TIMESTAMP, \ 7 artifacts.update=UPDATE artifacts SET last_access = CURRENT_TIMESTAMP, \
8 data = ? WHERE id = ? 8 data = ? WHERE id = ?
9 9
10 artifacts.touch=UPDATE artifacts SET last_access = CURRENT_TIMESTAMP WHERE id = ? 10 artifacts.touch=UPDATE artifacts SET last_access = CURRENT_TIMESTAMP WHERE id = ?
11 11
12 collection.items.artifact.id=SELECT artifact_id FROM collection_items
13
12 artifacts.outdated=SELECT id, factory, data, gid FROM artifacts WHERE ttl IS NOT NULL \ 14 artifacts.outdated=SELECT id, factory, data, gid FROM artifacts WHERE ttl IS NOT NULL \
13 AND CURRENT_TIMESTAMP - last_access > (ttl || ' milliseconds')::interval \ 15 AND CURRENT_TIMESTAMP - last_access > (ttl || ' milliseconds')::interval \
14 AND id NOT IN (SELECT DISTINCT artifact_id FROM collection_items) \
15 AND id NOT IN ($LOCKED_IDS$) \ 16 AND id NOT IN ($LOCKED_IDS$) \
16 LIMIT 50 17 LIMIT 50
17 18
18 artifacts.select.gid=SELECT id, ttl, factory, data FROM artifacts WHERE gid = ?::uuid \ 19 artifacts.select.gid=SELECT id, ttl, factory, data FROM artifacts WHERE gid = ?::uuid \
19 AND (ttl IS NULL \ 20 AND (ttl IS NULL \

http://dive4elements.wald.intevation.org