Mercurial > dive4elements > river
annotate etl/src/main/resources/sql/flys-oracle-jdbc-oracledriver.properties @ 9713:aef987124822 3.2.x
Do not rely on database default for setting hws_lines.official to 0
It's not under the control of the importer whether the field is rendered
into an INSERT statement, whether it's actually set or not. If it is
unset but rendered into the statement, the field would be set to NULL.
Thus, always set it explicitly.
While here, remove an unused import.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 12 Mar 2021 15:11:44 +0100 |
| parents | 5aa05a7a34b7 |
| children |
| rev | line source |
|---|---|
|
5258
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
1 next.gauge.id = \ |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
2 SELECT GAUGES_ID_SEQ.NEXTVAL AS gauge_id FROM DUAL |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
3 next.timeinterval.id = \ |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
4 SELECT TIME_INTERVALS_ID_SEQ.NEXTVAL AS time_interval_id FROM DUAL |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
5 next.discharge.id = \ |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
6 SELECT DISCHARGE_TABLES_ID_SEQ.NEXTVAL AS discharge_table_id FROM DUAL |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
7 next.discharge.table.values.id = \ |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
8 SELECT DISCHARGE_TABLE_VALUES_ID_SEQ.NEXTVAL AS discharge_table_values_id FROM DUAL |