# HG changeset patch # User Sascha L. Teichmann # Date 1304698518 0 # Node ID 349c9bcdd91732869d0c24d95ac84718e2ff8d21 # Parent 1ed48e2ddc1bf9f978198186d738a290b0ae6666 Add data cage configuration for "Abflusskurve [NN + m]". flys-artifacts/trunk@1846 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r 1ed48e2ddc1b -r 349c9bcdd917 flys-artifacts/src/main/resources/metadata/template.xml --- a/flys-artifacts/src/main/resources/metadata/template.xml Fri May 06 14:20:26 2011 +0000 +++ b/flys-artifacts/src/main/resources/metadata/template.xml Fri May 06 16:15:18 2011 +0000 @@ -1,46 +1,185 @@ - - - - - SELECT id AS river_id, name as river_name FROM rivers - - - - + + + + SELECT id AS river_id, name as river_name FROM rivers + + + + + + - SELECT id AS wst_id, - kind AS wst_kind, - description AS wst_description - FROM wsts - WHERE river_id = ${river_id} + SELECT id AS gauge_id, + name AS gauge_name + FROM gauges WHERE river_id = ${river_id} - - - - Erzeugt aus der Datei: ${wst_description} + + + - SELECT id AS column_id, - name AS column_name - FROM wst_columns - WHERE wst_id = ${wst_id} - ORDER BY position + SELECT description AS gauge_desc, + d.id AS discharge_id, + ti.start_time AS g_start, + ti.stop_time AS g_stop + FROM discharge_tables d JOIN time_intervals ti + ON d.time_interval_id = ti.id + WHERE d.gauge_id = ${gauge_id} AND d.kind = 1 - + + + + + + - + - - - - - - + + + + + SELECT id AS fix_id, + description AS fix_description + FROM wsts WHERE kind = 2 AND river_id = ${river_id} + + + + + + + + + + + + SELECT id AS prot_id, + description AS prot_description + FROM wsts WHERE kind = 5 AND river_id = ${river_id} + + + + + + + + + SELECT id AS prot_column_id, + name AS prot_column_name + FROM wst_columns WHERE wst_id = ${prot_id} + ORDER by position + + + + + + + + + + + + + + + + SELECT id AS fw_id, + description AS fw_description + FROM wsts WHERE kind = 4 AND river_id = ${river_id} + + + + + + + + + SELECT id AS fw_column_id, + name AS fw_column_name + FROM wst_columns WHERE wst_id = ${fw_id} + ORDER by position + + + + + + + + + + + + + + + + SELECT id AS wl_id, + description AS wl_description + FROM wsts WHERE kind = 0 AND river_id = ${river_id} + + + + + + + + + SELECT id AS wl_column_id, + name AS wl_column_name + FROM wst_columns WHERE wst_id = ${wl_id} + ORDER by position + + + + + + + + + + + + + + + + SELECT id AS els_id, + description AS els_description + FROM wsts WHERE kind = 1 AND river_id = ${river_id} + + + + + + + + + SELECT id AS els_column_id, + name AS els_column_name + FROM wst_columns WHERE wst_id = ${els_id} + ORDER by position + + + + + + + + + + + + + + + + +