Mercurial > dive4elements > river
comparison flys-aft/src/main/resources/sql/flys-common.properties @ 5379:61bf64b102bc mapgenfix
Merge with default branch
| author | Christian Lins <christian.lins@intevation.de> |
|---|---|
| date | Fri, 22 Mar 2013 11:25:54 +0100 |
| parents | da1e897c7224 |
| children | 11fba4dabe05 |
comparison
equal
deleted
inserted
replaced
| 5175:cfc5540a4eec | 5379:61bf64b102bc |
|---|---|
| 4 JOIN wsts w ON r.id = w.river_id \ | 4 JOIN wsts w ON r.id = w.river_id \ |
| 5 JOIN wst_columns wc ON w.id = wc.wst_id \ | 5 JOIN wst_columns wc ON w.id = wc.wst_id \ |
| 6 JOIN wst_column_values wcv ON wcv.wst_column_id = wc.id \ | 6 JOIN wst_column_values wcv ON wcv.wst_column_id = wc.id \ |
| 7 WHERE w.kind = 0 \ | 7 WHERE w.kind = 0 \ |
| 8 GROUP BY r.id, r.name | 8 GROUP BY r.id, r.name |
| 9 select.gauges = SELECT id, name, official_number FROM gauges WHERE river_id = :river_id | 9 select.gauges = \ |
| 10 next.gauge.id = SELECT NEXTVAL('GAUGES_ID_SEQ') AS gauge_id | 10 SELECT id, name, official_number \ |
| 11 insert.gauge = INSERT INTO gauges (id, name, river_id, station, aeo, official_number, datum) \ | 11 FROM gauges \ |
| 12 VALUES(:id, :name, :river_id, :station, :aeo, :official_number, :datum) | 12 WHERE river_id = :river_id |
| 13 select.timeintervals = SELECT id, start_time, stop_time FROM time_intervals | 13 next.gauge.id = \ |
| 14 next.timeinterval.id = SELECT NEXTVAL('TIME_INTERVALS_ID_SEQ') AS time_interval_id | 14 SELECT NEXTVAL('GAUGES_ID_SEQ') AS gauge_id |
| 15 insert.timeinterval = INSERT INTO time_intervals (id, start_time, stop_time) VALUES (:id, :start_time, :stop_time) | 15 insert.gauge = \ |
| 16 next.discharge.id = SELECT NEXTVAL('DISCHARGE_TABLES_ID_SEQ') AS discharge_table_id | 16 INSERT INTO gauges (id, name, river_id, station, aeo, official_number, datum) \ |
| 17 VALUES(:id, :name, :river_id, :station, :aeo, :official_number, :datum) | |
| 18 select.timeintervals = \ | |
| 19 SELECT id, start_time, stop_time FROM time_intervals | |
| 20 next.timeinterval.id = \ | |
| 21 SELECT NEXTVAL('TIME_INTERVALS_ID_SEQ') AS time_interval_id | |
| 22 insert.timeinterval = \ | |
| 23 INSERT INTO time_intervals (id, start_time, stop_time) \ | |
| 24 VALUES (:id, :start_time, :stop_time) | |
| 25 next.discharge.id = \ | |
| 26 SELECT NEXTVAL('DISCHARGE_TABLES_ID_SEQ') AS discharge_table_id | |
| 17 insert.dischargetable = \ | 27 insert.dischargetable = \ |
| 18 INSERT INTO discharge_tables \ | 28 INSERT INTO discharge_tables \ |
| 19 (id, gauge_id, description, bfg_id, kind, time_interval_id) \ | 29 (id, gauge_id, description, bfg_id, kind, time_interval_id) \ |
| 20 VALUES (:id, :gauge_id, :description, :bfg_id, 1, :time_interval_id) | 30 VALUES (:id, :gauge_id, :description, :bfg_id, 1, :time_interval_id) |
| 21 select.discharge.table.values = SELECT id, w, q FROM discharge_table_values WHERE table_id = :table_id | 31 select.discharge.table.values = \ |
| 22 next.discharge.table.values.id = SELECT NEXTVAL('DISCHARGE_TABLE_VALUES_ID_SEQ') AS discharge_table_values_id | 32 SELECT id, w, q FROM discharge_table_values WHERE table_id = :table_id |
| 23 insert.discharge.table.value = INSERT INTO discharge_table_values (id, table_id, w, q) VALUES (:id, :table_id, :w, :q) | 33 next.discharge.table.values.id = \ |
| 24 delete.discharge.table.value = DELETE FROM discharge_table_values WHERE id = :id | 34 SELECT NEXTVAL('DISCHARGE_TABLE_VALUES_ID_SEQ') AS discharge_table_values_id |
| 35 insert.discharge.table.value = \ | |
| 36 INSERT INTO discharge_table_values (id, table_id, w, q) \ | |
| 37 VALUES (:id, :table_id, :w, :q) | |
| 38 delete.discharge.table.value = \ | |
| 39 DELETE FROM discharge_table_values WHERE id = :id | |
| 25 select.gauge.discharge.tables = \ | 40 select.gauge.discharge.tables = \ |
| 26 SELECT \ | 41 SELECT \ |
| 27 dt.id AS id, \ | 42 dt.id AS id, \ |
| 28 dt.description AS description, \ | 43 dt.description AS description, \ |
| 29 ti.start_time AS start_time, \ | 44 ti.start_time AS start_time, \ |
| 30 ti.stop_time AS stop_time, \ | 45 ti.stop_time AS stop_time, \ |
| 31 dt.bfg_id AS bfg_id \ | 46 dt.bfg_id AS bfg_id \ |
| 32 FROM discharge_tables dt \ | 47 FROM discharge_tables dt \ |
| 33 LEFT OUTER JOIN time_intervals ti ON dt.time_interval_id = ti.id \ | 48 LEFT OUTER JOIN time_intervals ti ON dt.time_interval_id = ti.id \ |
| 34 WHERE gauge_id = :gauge_id | 49 WHERE gauge_id = :gauge_id |
| 50 select.gauge.master.discharge.table = \ | |
| 51 SELECT \ | |
| 52 dt.id AS id, \ | |
| 53 dt.bfg_id AS bfg_id \ | |
| 54 FROM discharge_tables dt JOIN gauges g ON dt.gauge_id = g.id \ | |
| 55 WHERE g.id = :gauge_id AND g.kind = 0 | |
| 56 update.bfg.id.discharge.table = \ | |
| 57 UPDATE discharge_tables SET bfg_id = :bfg_id WHERE id = :id |