Mercurial > dive4elements > river
view artifacts/src/main/resources/datacage-sql/org-h2-driver.properties @ 9790:75dc4ea60938 3.2.x
Drop using explicit container names
Compose will generate names for the containers and containers can connect
each other on the network via the service names. This avoids the
unnecessary extra "name space" and prepares the application for usage
with different project names.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 20 Jul 2023 10:25:59 +0200 |
parents | 5077fc1ace1c |
children |
line wrap: on
line source
delete.all.users = DELETE FROM users delete.all.artifacts = DELETE FROM artifacts user.id.nextval = SELECT NEXTVAL('USERS_ID_SEQ') user.by.gid = SELECT id FROM users WHERE gid = ? insert.user = INSERT INTO users (id, gid) VALUES (?, ?) collection.by.gid = SELECT id FROM collections WHERE gid = ? collection.id.nextval = SELECT NEXTVAL('COLLECTIONS_ID_SEQ') insert.collection = INSERT INTO collections (id, gid, user_id, name, creation) VALUES (?, ?, ?, ?, ?) artifact.by.gid = SELECT id FROM artifacts WHERE gid = ? collection.item.id.nextval = SELECT NEXTVAL('COLLECTION_ITEMS_ID_SEQ') insert.collection.item = INSERT INTO collection_items (id, collection_id, artifact_id) VALUES (?, ?, ?) artifact.id.nextval = SELECT NEXTVAL('ARTIFACTS_ID_SEQ') insert.artifact = INSERT INTO artifacts (id, gid, state, creation) VALUES (?, ?, ?, ?) artifact.data.id.nextval = SELECT NEXTVAL('ARTIFACT_DATA_ID_SEQ') insert.artifact.data = INSERT INTO artifact_data (id, artifact_id, kind, k, v) VALUES (?, ?, ?, ?, ?) out.id.nextval = SELECT NEXTVAL('OUTS_ID_SEQ') insert.out = INSERT INTO outs (id, artifact_id, name, description, out_type) VALUES (?, ?, ?, ?, ?) facet.id.nextval = SELECT NEXTVAL('FACETS_ID_SEQ') insert.facet = INSERT INTO facets (id, out_id, name, num, state, description) VALUES (?, ?, ?, ?, ?, ?) update.artifact.state = UPDATE artifacts SET state = ? WHERE id = ? update.collection.name = UPDATE collections SET name = ? WHERE gid = ? delete.artifact.from.collection = DELETE FROM collection_items WHERE collection_id = ? AND artifact_id = ? delete.collection.by.gid = DELETE FROM collections WHERE gid = ? delete.user.by.gid = DELETE FROM user WHERE gid = ? delete.artifact.data.by.artifact.id = DELETE FROM artifact_data WHERE artifact_id = ? delete.outs.by.artifact.id = DELETE FROM outs WHERE artifact_id = ? delete.facets.by.artifact.id = DELETE FROM facets WHERE out_id IN (SELECT id FROM outs WHERE artifact_id = ?) delete.artifact.by.gid = DELETE FROM artifacts WHERE gid = ?