Mercurial > dive4elements > river
view etl/src/main/resources/sql/flys-oracle-jdbc-oracledriver.properties @ 6693:88bb0c794833
issue1391: Enable GaugeDischarge artifact to directly load a table by its ID
This allows us to use the GaugeDischargeArtifact for any discharge
tables that we have in our database. The name of the created facet
is taken from the ids string as is also usual in the WMS artifacts.
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Mon, 29 Jul 2013 12:19:57 +0200 |
parents | 5aa05a7a34b7 |
children |
line wrap: on
line source
next.gauge.id = \ SELECT GAUGES_ID_SEQ.NEXTVAL AS gauge_id FROM DUAL next.timeinterval.id = \ SELECT TIME_INTERVALS_ID_SEQ.NEXTVAL AS time_interval_id FROM DUAL next.discharge.id = \ SELECT DISCHARGE_TABLES_ID_SEQ.NEXTVAL AS discharge_table_id FROM DUAL next.discharge.table.values.id = \ SELECT DISCHARGE_TABLE_VALUES_ID_SEQ.NEXTVAL AS discharge_table_values_id FROM DUAL