Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 80:8447467cef86
Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT).
artifacts/trunk@799 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Fri, 19 Mar 2010 09:34:40 +0000 |
| parents | b8516aa3d8a1 |
| children | caf9f456f7e3 |
comparison
equal
deleted
inserted
replaced
| 79:f69e5b87f05f | 80:8447467cef86 |
|---|---|
| 12 artifacts.outdated=SELECT id, factory, data FROM artifacts WHERE ttl IS NOT NULL \ | 12 artifacts.outdated=SELECT id, factory, data FROM artifacts WHERE ttl IS NOT NULL \ |
| 13 AND DATEDIFF('MILLISECOND', last_access, CURRENT_TIMESTAMP) > ttl LIMIT 50 | 13 AND DATEDIFF('MILLISECOND', last_access, CURRENT_TIMESTAMP) > ttl LIMIT 50 |
| 14 | 14 |
| 15 artifacts.select.gid=SELECT id, last_access, ttl, factory, data FROM artifacts WHERE gid = ? | 15 artifacts.select.gid=SELECT id, last_access, ttl, factory, data FROM artifacts WHERE gid = ? |
| 16 | 16 |
| 17 artifacts.get.id=SELECT id FROM artifacts WHERE gid = ? | |
| 18 | |
| 19 artifacts.replace=UPDATE artifacts SET \ | |
| 20 creation = CURRENT_TIMESTAMP, last_access = CURRENT_TIMESTAMP, \ | |
| 21 ttl = ?, factory = ?, data = ? \ | |
| 22 WHERE id = ? | |
| 23 | |
| 17 artifacts.delete=DELETE FROM artifacts WHERE id = ? | 24 artifacts.delete=DELETE FROM artifacts WHERE id = ? |