view flys-aft/src/main/resources/sql/flys-common.properties @ 4740:fb135e1dfa35

Added 'type' attribute to <dc:variable/> element. If an optional 'type' attribute is given the result of the XPATH expression is interpreted as this type. Valid values are 'number', 'bool', 'node' and 'nodeset'. All other defaults to 'string' which also is the default if nor type is given.
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 02 Jan 2013 15:31:53 +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