view flys-aft/src/main/resources/sql/flys-common.properties @ 4496:d8992459b408

Add method to return the facets of an artifact This methos should be used to get the facets of an artifact instead of accessing the facets member variable directly.
author Björn Ricks <bjoern.ricks@intevation.de>
date Wed, 14 Nov 2012 11:11:04 +0100
parents 8ba11e13ae8a
children a310aceb2e51
line wrap: on
line source
select.river = SELECT id, name FROM rivers 
select.gauges = SELECT id, name, official_number FROM gauges WHERE river_id = :river_id
next.gauge.id = SELECT NEXTVAL('GAUGES_ID_SEQ') AS gauge_id
insert.gauge = INSERT INTO gauges (id, name, river_id, station, aeo, official_number, datum) \
                      VALUES(:id, :name, :river_id, :station, :aeo, :official_number, :datum)
select.timeintervals = SELECT id, start_time, stop_time FROM time_intervals
next.timeinterval.id = SELECT NEXTVAL('TIME_INTERVALS_ID_SEQ') AS time_interval_id
insert.timeinterval = INSERT INTO time_intervals (id, start_time, stop_time) VALUES (:id, :start_time, :stop_time)
next.discharge.id = SELECT NEXTVAL('DISCHARGE_TABLES_ID_SEQ') AS discharge_table_id
insert.dischargetable = INSERT INTO discharge_tables (id, gauge_id, description, kind, time_interval_id) \
                        VALUES (:id, :gauge_id, :description, 1, :time_interval_id)
select.discharge.table.values = SELECT id, w, q FROM discharge_table_values WHERE table_id = :table_id
next.discharge.table.values.id = SELECT NEXTVAL('DISCHARGE_TABLE_VALUES_ID_SEQ') AS discharge_table_values_id
insert.discharge.table.value = INSERT INTO discharge_table_values (id, table_id, w, q) VALUES (:id, :table_id, :w, :q)
delete.discharge.table.value = DELETE FROM discharge_table_values WHERE id = :id
select.gauge.discharge.tables = SELECT dt.id AS id, dt.description AS description, ti.start_time AS start_time, ti.stop_time AS stop_time \
                               FROM discharge_tables dt LEFT OUTER JOIN time_intervals ti ON dt.time_interval_id = ti.id \
                               WHERE gauge_id = :gauge_id

http://dive4elements.wald.intevation.org