Mercurial > dive4elements > river
annotate artifacts/src/main/resources/datacage-sql/org-h2-driver.properties @ 7503:e11bf92bca4a
issue1658: New Processors for t/a and m^3/a -axis (stripped down from SedimentLoadProcessor).
author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
---|---|
date | Fri, 01 Nov 2013 16:30:52 +0100 |
parents | 5077fc1ace1c |
children |
rev | line source |
---|---|
984
2b05c4a0c6fd
Datacage: clear database before initial scan
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
983
diff
changeset
|
1 delete.all.users = DELETE FROM users |
996
f61fe8b561d2
Datacage: delete artifacts at initial scan, too. Fixed problem with writing content of state data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
992
diff
changeset
|
2 delete.all.artifacts = DELETE FROM artifacts |
986
70545233f8ee
Datacage: Add users at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
984
diff
changeset
|
3 user.id.nextval = SELECT NEXTVAL('USERS_ID_SEQ') |
70545233f8ee
Datacage: Add users at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
984
diff
changeset
|
4 user.by.gid = SELECT id FROM users WHERE gid = ? |
70545233f8ee
Datacage: Add users at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
984
diff
changeset
|
5 insert.user = INSERT INTO users (id, gid) VALUES (?, ?) |
987
82ef338fee91
Datacage: Add collections at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
986
diff
changeset
|
6 collection.by.gid = SELECT id FROM collections WHERE gid = ? |
82ef338fee91
Datacage: Add collections at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
986
diff
changeset
|
7 collection.id.nextval = SELECT NEXTVAL('COLLECTIONS_ID_SEQ') |
1025
02c327ffbad7
Datacage: Extended schema for artifacts and collections
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1006
diff
changeset
|
8 insert.collection = INSERT INTO collections (id, gid, user_id, name, creation) VALUES (?, ?, ?, ?, ?) |
988
dbe39e1fb5e7
Datacage: Add collection items at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
987
diff
changeset
|
9 artifact.by.gid = SELECT id FROM artifacts WHERE gid = ? |
dbe39e1fb5e7
Datacage: Add collection items at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
987
diff
changeset
|
10 collection.item.id.nextval = SELECT NEXTVAL('COLLECTION_ITEMS_ID_SEQ') |
dbe39e1fb5e7
Datacage: Add collection items at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
987
diff
changeset
|
11 insert.collection.item = INSERT INTO collection_items (id, collection_id, artifact_id) VALUES (?, ?, ?) |
989
f3be883325ce
Add artifacts into datacage db at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
988
diff
changeset
|
12 artifact.id.nextval = SELECT NEXTVAL('ARTIFACTS_ID_SEQ') |
1025
02c327ffbad7
Datacage: Extended schema for artifacts and collections
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1006
diff
changeset
|
13 insert.artifact = INSERT INTO artifacts (id, gid, state, creation) VALUES (?, ?, ?, ?) |
990
e573c4715d81
Add artifacts data into datacage db at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
989
diff
changeset
|
14 artifact.data.id.nextval = SELECT NEXTVAL('ARTIFACT_DATA_ID_SEQ') |
e573c4715d81
Add artifacts data into datacage db at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
989
diff
changeset
|
15 insert.artifact.data = INSERT INTO artifact_data (id, artifact_id, kind, k, v) VALUES (?, ?, ?, ?, ?) |
991
c675b4a87201
Store outs of artifacts into datacage db at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
990
diff
changeset
|
16 out.id.nextval = SELECT NEXTVAL('OUTS_ID_SEQ') |
c675b4a87201
Store outs of artifacts into datacage db at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
990
diff
changeset
|
17 insert.out = INSERT INTO outs (id, artifact_id, name, description, out_type) VALUES (?, ?, ?, ?, ?) |
992
5b467bc27eda
Datacage: Store
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
991
diff
changeset
|
18 facet.id.nextval = SELECT NEXTVAL('FACETS_ID_SEQ') |
5b467bc27eda
Datacage: Store
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
991
diff
changeset
|
19 insert.facet = INSERT INTO facets (id, out_id, name, num, state, description) VALUES (?, ?, ?, ?, ?, ?) |
6775
5077fc1ace1c
issue1415: Corrected update query and parameter setting.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
6660
diff
changeset
|
20 update.artifact.state = UPDATE artifacts SET state = ? WHERE id = ? |
1003
c58da6dd15ed
Datacage: Update collection names on change. Remove artifacts from collections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
996
diff
changeset
|
21 |
c58da6dd15ed
Datacage: Update collection names on change. Remove artifacts from collections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
996
diff
changeset
|
22 update.collection.name = UPDATE collections SET name = ? WHERE gid = ? |
c58da6dd15ed
Datacage: Update collection names on change. Remove artifacts from collections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
996
diff
changeset
|
23 delete.artifact.from.collection = DELETE FROM collection_items WHERE collection_id = ? AND artifact_id = ? |
1004
0e8c03b69627
Datacage: completed backend listener stuff.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1003
diff
changeset
|
24 delete.collection.by.gid = DELETE FROM collections WHERE gid = ? |
0e8c03b69627
Datacage: completed backend listener stuff.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1003
diff
changeset
|
25 delete.user.by.gid = DELETE FROM user WHERE gid = ? |
0e8c03b69627
Datacage: completed backend listener stuff.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1003
diff
changeset
|
26 delete.artifact.data.by.artifact.id = DELETE FROM artifact_data WHERE artifact_id = ? |
0e8c03b69627
Datacage: completed backend listener stuff.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1003
diff
changeset
|
27 delete.outs.by.artifact.id = DELETE FROM outs WHERE artifact_id = ? |
0e8c03b69627
Datacage: completed backend listener stuff.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1003
diff
changeset
|
28 delete.facets.by.artifact.id = DELETE FROM facets WHERE out_id IN (SELECT id FROM outs WHERE artifact_id = ?) |
1006
1917f32701dc
Forwarded kill collections and artifacts events to datacage.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1004
diff
changeset
|
29 |
1917f32701dc
Forwarded kill collections and artifacts events to datacage.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1004
diff
changeset
|
30 delete.artifact.by.gid = DELETE FROM artifacts WHERE gid = ? |