Mercurial > dive4elements > river

annotate etl/ChangeLog @ 9111:ee77e544e890

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Where clause in bed-heights-statement extended by km range condition
author mschaefer
date Mon, 04 Jun 2018 08:32:25 +0200
parents 5aa05a7a34b7
children
rev   line source
4134
9c78264109ad AFT: Ignored tables with unset GUELTIG_VON or GUELTIG_BIS values.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4113
diff changeset
1 2012-09-15 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
9c78264109ad AFT: Ignored tables with unset GUELTIG_VON or GUELTIG_BIS values.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4113
diff changeset
2
9c78264109ad AFT: Ignored tables with unset GUELTIG_VON or GUELTIG_BIS values.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4113
diff changeset
3 * ../.hgignore: Add ignores for flys-aft, too.
9c78264109ad AFT: Ignored tables with unset GUELTIG_VON or GUELTIG_BIS values.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4113
diff changeset
4
9c78264109ad AFT: Ignored tables with unset GUELTIG_VON or GUELTIG_BIS values.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4113
diff changeset
5 * src/main/java/de/intevation/aft/DischargeTable.java: Ignore
9c78264109ad AFT: Ignored tables with unset GUELTIG_VON or GUELTIG_BIS values.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4113
diff changeset
6 tables with unset GUELTIG_VON or GUELTIG_BIS values.
9c78264109ad AFT: Ignored tables with unset GUELTIG_VON or GUELTIG_BIS values.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4113
diff changeset
7
4113
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
8 2012-09-11 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
9
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
10 * README.txt: Added infos how to build.
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
11
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
12 * doc/conf-oracle.xml: Demo config for Oracle.
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
13
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
14 * bin/run.sh: New start script.
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
15 * bin/log4j.properties: Demo log4j config.
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
16
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
17 * pom.xml: Added config for Maven assembly plugin.
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
18 * pom-oracle.xml: New. Has extra dependency to Oracle JDBC.
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
19
f72c253663fc FYLS/AFT/DIPS: Added start script.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4112
diff changeset
20 2012-09-11 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
4112
23677476fd09 FLYS-AFT/DIPS: Java 1.5 -> 1.6
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4111
diff changeset
21
23677476fd09 FLYS-AFT/DIPS: Java 1.5 -> 1.6
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4111
diff changeset
22 * pom.xml: Java 1.5 -> 1.6
23677476fd09 FLYS-AFT/DIPS: Java 1.5 -> 1.6
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4111
diff changeset
23 * README.txt: Removed new line.
23677476fd09 FLYS-AFT/DIPS: Java 1.5 -> 1.6
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4111
diff changeset
24
4111
b7059aca60a8 Added doc about function and configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4110
diff changeset
25 2012-02-16 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
b7059aca60a8 Added doc about function and configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4110
diff changeset
26
b7059aca60a8 Added doc about function and configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4110
diff changeset
27 * README.txt: Describe configuration and function. TODO:
b7059aca60a8 Added doc about function and configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4110
diff changeset
28 Write about running.
b7059aca60a8 Added doc about function and configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4110
diff changeset
29
4110
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
30 2012-02-16 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
31
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
32 * README.txt: New. Contains error messages by now. TODO: Write
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
33 more about the whole process.
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
34
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
35 * src/main/java/de/intevation/aft/SyncContext.java,
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
36 src/main/java/de/intevation/aft/DischargeTable.java,
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
37 src/main/java/de/intevation/aft/Notification.java,
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
38 src/main/java/de/intevation/aft/River.java,
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
39 src/main/java/de/intevation/aft/Sync.java:
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
40 Adjusted and improved error messages.
06891562e633 Extracted and documented the error messages of the process.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4109
diff changeset
41
4109
8ba11e13ae8a AFT-Import: Insert
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4108
diff changeset
42 2012-02-08 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
8ba11e13ae8a AFT-Import: Insert
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4108
diff changeset
43
8ba11e13ae8a AFT-Import: Insert
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4108
diff changeset
44 * src/main/resources/sql/flys-common.properties: Insert
8ba11e13ae8a AFT-Import: Insert
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4108
diff changeset
45 new discharge tables as 'Historische Abflusstafel' kind.
8ba11e13ae8a AFT-Import: Insert
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4108
diff changeset
46
4108
4c2b99d6af6c Oracle: Added 'FROM DUAL' when selecting new ids from sequences.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4107
diff changeset
47 2012-01-11 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
4c2b99d6af6c Oracle: Added 'FROM DUAL' when selecting new ids from sequences.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4107
diff changeset
48
4c2b99d6af6c Oracle: Added 'FROM DUAL' when selecting new ids from sequences.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4107
diff changeset
49 * src/main/resources/sql/flys-oracle-jdbc-oracledriver.properties:
4c2b99d6af6c Oracle: Added 'FROM DUAL' when selecting new ids from sequences.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4107
diff changeset
50 Added 'FROM DUAL' clause when selecting new ids from sequences.
4c2b99d6af6c Oracle: Added 'FROM DUAL' when selecting new ids from sequences.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4107
diff changeset
51 Sync process between AFT(Oracle) and FLYS(Oracle) is working now!
4c2b99d6af6c Oracle: Added 'FROM DUAL' when selecting new ids from sequences.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4107
diff changeset
52
4107
96fd7f83adfb Statements to make the FLYS database connection Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4106
diff changeset
53 2012-01-10 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
96fd7f83adfb Statements to make the FLYS database connection Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4106
diff changeset
54
96fd7f83adfb Statements to make the FLYS database connection Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4106
diff changeset
55 * src/main/resources/sql/flys-oracle-jdbc-oracledriver.properties: New.
96fd7f83adfb Statements to make the FLYS database connection Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4106
diff changeset
56 Statements to make the FLYS database connection Oracle compatible.
96fd7f83adfb Statements to make the FLYS database connection Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4106
diff changeset
57 Untested!
96fd7f83adfb Statements to make the FLYS database connection Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4106
diff changeset
58
4106
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4105
diff changeset
59 2012-01-10 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4105
diff changeset
60
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4105
diff changeset
61 * src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties: New.
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4105
diff changeset
62 Statements to make the AFT database connection Oracle compatible.
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4105
diff changeset
63
4105
309d4ca09816 Prevent redundant and ever growing discharge table lists in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4104
diff changeset
64 2012-01-09 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
309d4ca09816 Prevent redundant and ever growing discharge table lists in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4104
diff changeset
65
309d4ca09816 Prevent redundant and ever growing discharge table lists in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4104
diff changeset
66 * src/main/java/de/intevation/aft/DischargeTable.java: Write
309d4ca09816 Prevent redundant and ever growing discharge table lists in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4104
diff changeset
67 warning if there are discharge tables with same descriptions
309d4ca09816 Prevent redundant and ever growing discharge table lists in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4104
diff changeset
68 in FLYS or AFT and ignore the redundant ones. This led
309d4ca09816 Prevent redundant and ever growing discharge table lists in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4104
diff changeset
69 to an ever growing FLYS database.
309d4ca09816 Prevent redundant and ever growing discharge table lists in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4104
diff changeset
70
4104
cdcf98245e36 Commit/rollback changes if a gauge is only updated.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4103
diff changeset
71 2012-01-09 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
cdcf98245e36 Commit/rollback changes if a gauge is only updated.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4103
diff changeset
72
cdcf98245e36 Commit/rollback changes if a gauge is only updated.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4103
diff changeset
73 * src/main/java/de/intevation/aft/Sync.java: Log if modifications
cdcf98245e36 Commit/rollback changes if a gauge is only updated.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4103
diff changeset
74 are found or not.
cdcf98245e36 Commit/rollback changes if a gauge is only updated.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4103
diff changeset
75
cdcf98245e36 Commit/rollback changes if a gauge is only updated.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4103
diff changeset
76 * src/main/java/de/intevation/aft/River.java: Commit/rollback
cdcf98245e36 Commit/rollback changes if a gauge is only updated.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4103
diff changeset
77 changes on gauge if a gauge is updated.
cdcf98245e36 Commit/rollback changes if a gauge is only updated.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4103
diff changeset
78
4103
2305731f563c Store W/Q in sets to prevent value duplications.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4102
diff changeset
79 2012-01-09 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
2305731f563c Store W/Q in sets to prevent value duplications.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4102
diff changeset
80
2305731f563c Store W/Q in sets to prevent value duplications.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4102
diff changeset
81 * src/main/java/de/intevation/aft/DischargeTable.java: Store
2305731f563c Store W/Q in sets to prevent value duplications.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4102
diff changeset
82 the W/Q values in sets to prevent value duplications leading
2305731f563c Store W/Q in sets to prevent value duplications.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4102
diff changeset
83 to unique constraint violations in FLYS. Log a warning
2305731f563c Store W/Q in sets to prevent value duplications.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4102
diff changeset
84 when loading a W/Q value duplication.
2305731f563c Store W/Q in sets to prevent value duplications.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4102
diff changeset
85
2305731f563c Store W/Q in sets to prevent value duplications.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4102
diff changeset
86 This have the nice side effect that the W/Q values are
2305731f563c Store W/Q in sets to prevent value duplications.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4102
diff changeset
87 written sorted by Q/W which is of benefit for FLYS.
2305731f563c Store W/Q in sets to prevent value duplications.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4102
diff changeset
88
4102
e8967ee1cb05 Fixed logic bug when writing discharge tables of an gauge existing in both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4101
diff changeset
89 2012-01-09 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
e8967ee1cb05 Fixed logic bug when writing discharge tables of an gauge existing in both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4101
diff changeset
90
e8967ee1cb05 Fixed logic bug when writing discharge tables of an gauge existing in both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4101
diff changeset
91 * src/main/java/de/intevation/aft/River.java: Fixed logic bug
e8967ee1cb05 Fixed logic bug when writing discharge tables of an gauge existing in both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4101
diff changeset
92 when writing discharge tables of an gauge existing in both dbs.
e8967ee1cb05 Fixed logic bug when writing discharge tables of an gauge existing in both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4101
diff changeset
93
e8967ee1cb05 Fixed logic bug when writing discharge tables of an gauge existing in both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4101
diff changeset
94 * src/main/java/de/intevation/aft/DischargeTable.java: Moved
e8967ee1cb05 Fixed logic bug when writing discharge tables of an gauge existing in both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4101
diff changeset
95 some SQL code from River here to simplify the persistence.
e8967ee1cb05 Fixed logic bug when writing discharge tables of an gauge existing in both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4101
diff changeset
96
4101
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
97 2012-01-09 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
98
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
99 * src/main/java/de/intevation/aft/TimeInterval.java(toString): Added
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
100 toString() method.
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
101
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
102 * src/main/java/de/intevation/aft/SyncContext.java: Added debug
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
103 logging when creating a new time inteval.
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
104
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
105 * src/main/java/de/intevation/aft/DischargeTable.java: Added
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
106 warning when start and end of a time interval from AFT
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
107 are ordered start > end.
b6a18d706cbe Added debugging for AFT time intervals.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4100
diff changeset
108
4100
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
109 2012-01-07 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
110
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
111 * src/main/java/de/intevation/db/SymbolicStatement.java:
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
112 Added setLong() method. Used when setting the official number
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
113 of a gauge.
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
114
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
115 * src/main/java/de/intevation/aft/River.java: Store the new
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
116 discharge tables in FLYS when gauges exist in both
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
117 FLYS and AFT and there are discharge tables that are only in AFT.
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
118 Store official number as long.
981de0b77c6b If gauges exist in FLYS and AFT store the discharge tables in FLYS that are only in AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4099
diff changeset
119
4099
006e99437fb9 Store the W/Q differences o existing discharge tables to FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4098
diff changeset
120 2012-01-07 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
006e99437fb9 Store the W/Q differences o existing discharge tables to FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4098
diff changeset
121
006e99437fb9 Store the W/Q differences o existing discharge tables to FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4098
diff changeset
122 * src/main/java/de/intevation/aft/River.java: Store
006e99437fb9 Store the W/Q differences o existing discharge tables to FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4098
diff changeset
123 the W/Q differences of existing discharge tables
006e99437fb9 Store the W/Q differences o existing discharge tables to FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4098
diff changeset
124 to the FLYS database.
006e99437fb9 Store the W/Q differences o existing discharge tables to FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4098
diff changeset
125
006e99437fb9 Store the W/Q differences o existing discharge tables to FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4098
diff changeset
126 * src/main/java/de/intevation/aft/DischargeTable.java: Added
006e99437fb9 Store the W/Q differences o existing discharge tables to FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4098
diff changeset
127 getter/setter for W/Q values.
006e99437fb9 Store the W/Q differences o existing discharge tables to FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4098
diff changeset
128
4098
9215253ad0be Do the FLYS/AFT description pairing of discharge tables in case a gauge needs updates.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4097
diff changeset
129 2012-01-06 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
9215253ad0be Do the FLYS/AFT description pairing of discharge tables in case a gauge needs updates.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4097
diff changeset
130
9215253ad0be Do the FLYS/AFT description pairing of discharge tables in case a gauge needs updates.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4097
diff changeset
131 * src/main/java/de/intevation/aft/River.java: Do the pairing
9215253ad0be Do the FLYS/AFT description pairing of discharge tables in case a gauge needs updates.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4097
diff changeset
132 of discharge table of a gauge that needs updates. TODO:
9215253ad0be Do the FLYS/AFT description pairing of discharge tables in case a gauge needs updates.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4097
diff changeset
133 Build the W/Q difference of found FLYS/AFT matches and
9215253ad0be Do the FLYS/AFT description pairing of discharge tables in case a gauge needs updates.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4097
diff changeset
134 create the discharge tables in FLYS that are found in AFT.
9215253ad0be Do the FLYS/AFT description pairing of discharge tables in case a gauge needs updates.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4097
diff changeset
135
4097
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
136 2012-01-06 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
137
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
138 * src/main/resources/sql/flys-common.properties: Added statement
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
139 to load all discharge tables of a given gauge.
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
140
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
141 * src/main/java/de/intevation/aft/DischargeTable.java:
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
142
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
143 * src/main/java/de/intevation/aft/DIPSGauge.java: Store
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
144 the official number, too.
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
145
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
146 * src/main/java/de/intevation/aft/River.java: In case of
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
147 updating a gauge load all discharge tables of that gauge
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
148 from FLYS and AFT. TODO: Do pairing based on the descriptions.
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
149
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
150 * src/main/java/de/intevation/aft/DischargeTable.java: Code
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
151 to load the discharge table from FLYS and AFT.
83c72bc07591 Load all discharge tables from AFT and FLYS of a gauge which needs updating.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4096
diff changeset
152
4096
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
153 2012-01-06 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
154
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
155 * src/main/java/de/intevation/aft/WQDiff.java: New.
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
156 Calculates the difference of two W/Q value table of a
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
157 discharge table. This can be used to write an optimized
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
158 change set in terms of executed SQL to the FLYS database.
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
159
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
160 * src/main/java/de/intevation/aft/WQ.java: Changed the EPS_CMP
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
161 comparator to first sort by Q and then by W because the Qs
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
162 are more distinct and the dominant component.
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
163
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
164 * src/main/resources/sql/flys-common.properties: Added statement
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
165 to delete W/Q values.
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4095
diff changeset
166
4095
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
167 2012-01-06 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
168
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
169 * src/main/java/de/intevation/utils/XML.java: Added code
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
170 to send/receive documents from streams.
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
171
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
172 * src/main/java/de/intevation/aft/Notification.java: New.
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
173 Sends XML documents via HTTP POST to given URLs.
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
174
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
175 * src/main/java/de/intevation/aft/Sync.java: Send notifications
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
176 if the FLYS database was modified. Useful to invalidate caches
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
177 in the artifact server.
da9df3641578 Send XML messages via HTTP POST around if the FLYS database has changed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4094
diff changeset
178
4094
b20b710aa86f Bubble up modifications up to main().
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4093
diff changeset
179 2012-01-05 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
b20b710aa86f Bubble up modifications up to main().
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4093
diff changeset
180
b20b710aa86f Bubble up modifications up to main().
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4093
diff changeset
181 * doc/conf.xml: Added demo notification url.
b20b710aa86f Bubble up modifications up to main().
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4093
diff changeset
182
b20b710aa86f Bubble up modifications up to main().
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4093
diff changeset
183 * src/main/java/de/intevation/aft/River.java,
b20b710aa86f Bubble up modifications up to main().
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4093
diff changeset
184 src/main/java/de/intevation/aft/Rivers.java,
b20b710aa86f Bubble up modifications up to main().
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4093
diff changeset
185 src/main/java/de/intevation/aft/Sync.java: Modifications
b20b710aa86f Bubble up modifications up to main().
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4093
diff changeset
186 are bubbled up to main() to send notifactions.
b20b710aa86f Bubble up modifications up to main().
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4093
diff changeset
187
4093
7bddd4601707 Copy over W/Q values from AFT to FLYS for new discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4092
diff changeset
188 2012-01-05 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
4092
b3fc044f75ba Added code to store W/Q values into FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4091
diff changeset
189
b3fc044f75ba Added code to store W/Q values into FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4091
diff changeset
190 * src/main/java/de/intevation/aft/DischargeTable.java: Store
b3fc044f75ba Added code to store W/Q values into FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4091
diff changeset
191 W/Q values to FLYS.
b3fc044f75ba Added code to store W/Q values into FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4091
diff changeset
192
b3fc044f75ba Added code to store W/Q values into FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4091
diff changeset
193 * src/main/resources/sql/flys-common.properties: Added statements
b3fc044f75ba Added code to store W/Q values into FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4091
diff changeset
194 to store W/Q values into FLYS database.
b3fc044f75ba Added code to store W/Q values into FLYS database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4091
diff changeset
195
4093
7bddd4601707 Copy over W/Q values from AFT to FLYS for new discharge tables.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4092
diff changeset
196 2012-01-05 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
4091
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
197
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
198 * src/main/java/de/intevation/aft/WQ.java: New. W/Q model used
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
199 for AFT and FLYS.
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
200
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
201 * src/main/java/de/intevation/aft/DischargeTable.java: Holds
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
202 a list of its W/Q values now. Values are loadable from AFT
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
203 and FLYS.
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
204
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
205 * src/main/resources/sql/aft-common.properties,
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
206 src/main/resources/sql/flys-common.properties: Added statements
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
207 to load W/Q values for a given discharge table.
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
208
4090
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
209 2012-01-04 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
210
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
211 * src/main/java/de/intevation/aft/SyncContext.java(fetchOrCreateFLYSTimeInterval):
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
212 Create FLYS time intervals if they are not in the database.
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
213
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
214 * src/main/java/de/intevation/aft/DischargeTable.java: New. Model
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
215 for discharge tables.
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
216
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
217 * src/main/java/de/intevation/aft/TimeInterval.java: Added
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
218 convinience constructors.
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
219
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
220 * src/main/java/de/intevation/aft/River.java: Store discharge tables.
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
221
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
222 * src/main/java/de/intevation/aft/Sync.java: Exit with errorcode
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
223 if syncing fails.
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
224
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
225 * src/main/resources/sql/aft-common.properties: Fetch the
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
226 description of a discharge table, too.
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
227
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
228 * src/main/resources/sql/flys-common.properties: Added statements
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
229 to create time intevals and discharge tables.
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
230
4089
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
231 2012-01-03 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
232
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
233 * src/main/java/de/intevation/aft/TimeInterval.java: New.
4090
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4089
diff changeset
234 Model for FLYS time intervals.
4089
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
235
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
236 * src/main/java/de/intevation/aft/SyncContext.java: Preload
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
237 existing time intervals from FLYS.
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
238
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
239 * src/main/java/de/intevation/aft/Sync.java: Call init()
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
240 after construction to ensure that the db connections are
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
241 closed properly.
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
242
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
243 * src/main/resources/sql/flys-common.properties: Added statement
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
244 to fetch the time intervals from FLYS.
859b4781554a Prefetch existing time intervals from FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
245
4088
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4087
diff changeset
246 2012-01-03 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4087
diff changeset
247
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4087
diff changeset
248 * src/main/java/de/intevation/aft/River.java: Fetch discharge table
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4087
diff changeset
249 infos from AFT.
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4087
diff changeset
250
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4087
diff changeset
251 * src/main/resources/sql/aft-common.properties: Added statement to fetch
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4087
diff changeset
252 infos from ABFLUSSTAFEL.
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4087
diff changeset
253
4087
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
254 2012-01-02 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
255
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
256 * src/main/resources/sql/flys-common.properties: Added statements
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
257 to create gauges in FLYS.
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
258
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
259 * src/main/java/de/intevation/aft/DIPSGauge.java: Make more fields
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
260 accessible for gauge creation in FLYS.
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
261
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
262 * src/main/java/de/intevation/aft/River.java: Store new gauges
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
263 in FLYS.
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
264
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
265 * src/main/java/de/intevation/db/ConnectedStatements.java:
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
266 Added logging, make methods of transaction handling public.
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
267
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
268 * src/main/java/de/intevation/db/SymbolicStatement.java(setDouble):
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
269 Fixed argument type problem.
aad1886ea226 Store new gauges in FLYS db.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4086
diff changeset
270
4086
ee0c60757a94 Added transaction support
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4085
diff changeset
271 2012-01-02 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
ee0c60757a94 Added transaction support
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4085
diff changeset
272
ee0c60757a94 Added transaction support
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4085
diff changeset
273 * src/main/java/de/intevation/db/ConnectionBuilder.java:
ee0c60757a94 Added transaction support
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4085
diff changeset
274 Set auto commit of new connection to false to enable transaction.
ee0c60757a94 Added transaction support
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4085
diff changeset
275
ee0c60757a94 Added transaction support
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4085
diff changeset
276 * src/main/java/de/intevation/db/ConnectedStatements.java:
ee0c60757a94 Added transaction support
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4085
diff changeset
277 Added methods to begin, commit and rollback transactions.
ee0c60757a94 Added transaction support
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4085
diff changeset
278 Relies on savepoint support which is check by database metadata.
ee0c60757a94 Added transaction support
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4085
diff changeset
279
4085
067341e86375 Separate FLYS gauges to be updated or to create.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4084
diff changeset
280 2011-12-22 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
067341e86375 Separate FLYS gauges to be updated or to create.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4084
diff changeset
281
067341e86375 Separate FLYS gauges to be updated or to create.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4084
diff changeset
282 * src/main/java/de/intevation/aft/River.java: Figure out
067341e86375 Separate FLYS gauges to be updated or to create.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4084
diff changeset
283 which gauges must be updated, which must be created.
067341e86375 Separate FLYS gauges to be updated or to create.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4084
diff changeset
284
067341e86375 Separate FLYS gauges to be updated or to create.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4084
diff changeset
285 * src/main/java/de/intevation/aft/DIPSGauge.java: Store
067341e86375 Separate FLYS gauges to be updated or to create.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4084
diff changeset
286 info from AFT and FLYS, too.
067341e86375 Separate FLYS gauges to be updated or to create.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4084
diff changeset
287
067341e86375 Separate FLYS gauges to be updated or to create.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4084
diff changeset
288 * src/main/resources/sql/flys-common.properties: Fetch the
067341e86375 Separate FLYS gauges to be updated or to create.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4084
diff changeset
289 official number, too.
4084
9178beeb7b05 Moved DIPS gauge number -> DIPS gauge index.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4083
diff changeset
290 2011-12-20 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
9178beeb7b05 Moved DIPS gauge number -> DIPS gauge index.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4083
diff changeset
291
9178beeb7b05 Moved DIPS gauge number -> DIPS gauge index.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4083
diff changeset
292 * src/main/java/de/intevation/aft/River.java: Removed
9178beeb7b05 Moved DIPS gauge number -> DIPS gauge index.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4083
diff changeset
293 index DIPS gauge number -> DIPS gauge.
9178beeb7b05 Moved DIPS gauge number -> DIPS gauge index.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4083
diff changeset
294
9178beeb7b05 Moved DIPS gauge number -> DIPS gauge index.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4083
diff changeset
295 * src/main/java/de/intevation/aft/SyncContext.java: Readded
9178beeb7b05 Moved DIPS gauge number -> DIPS gauge index.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4083
diff changeset
296 here, because the index can be shared by all rivers.
9178beeb7b05 Moved DIPS gauge number -> DIPS gauge index.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4083
diff changeset
297
4083
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
298 2011-12-20 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
299
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
300 * doc/repair.xsl: Repair XSL transform which brings the
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
301 DIPS gauge numbers of the 15 FLYS gauges to the same
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
302 numbers as they are used in "Pegel Online".
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
303
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
304 !!! The purpose of this script is to do more repairing !!!
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
305
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
306 * doc/pegelstationen.xml: Sub document of repair. Used
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
307 for lookup the correct pegel numbers.
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
308
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
309 * doc/conf.xml: Changed to optionally load the repair XSLT.
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
310
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
311 * src/main/java/de/intevation/aft/Sync.java: Load the
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
312 repair XSL transformation if configured.
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
313
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
314 * src/main/java/de/intevation/utils/XML.java: Added code
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
315 to make XSL transforms possible.
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
316
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
317 * src/main/java/de/intevation/aft/River.java,
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
318 src/main/java/de/intevation/aft/Rivers.java: Fixed logging.
44dc38ca8492 Added an optional XSL transformation to fix the raw DIPS files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4082
diff changeset
319
4082
d13011e53022 Make DIPS check more verbose
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4076
diff changeset
320 2011-12-20 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
d13011e53022 Make DIPS check more verbose
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4076
diff changeset
321
d13011e53022 Make DIPS check more verbose
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4076
diff changeset
322 * src/main/java/de/intevation/aft/River.java,
d13011e53022 Make DIPS check more verbose
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4076
diff changeset
323 src/main/java/de/intevation/aft/DIPSGauge.java: Make DIPS check
d13011e53022 Make DIPS check more verbose
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4076
diff changeset
324 more verbose.
d13011e53022 Make DIPS check more verbose
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4076
diff changeset
325
4076
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
326 2011-12-16 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
327
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
328 * src/main/java/de/intevation/db/SymbolicStatement.java:
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
329 Made the setX() methods cascadable.
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
330
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
331 * src/main/java/de/intevation/aft/River.java: Fetches
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
332 the gauges from the database.
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
333
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
334 * src/main/resources/sql/aft-common.properties,
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
335 src/main/resources/sql/flys-common.properties: Added gauges
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
336 statements.
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4075
diff changeset
337
4075
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
338 2011-12-14 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
339
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
340 * src/main/java/de/intevation/db/SymbolicStatement.java:
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
341 Added execute(), executeQuery() & Co.
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
342
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
343 * src/main/java/de/intevation/aft/IdPair.java: New. Base class
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
344 for id pairs to identify same object in both databases.
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
345
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
346 * src/main/java/de/intevation/aft/River.java: New. To sync
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
347 the objects of one river.
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
348
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
349 * src/main/java/de/intevation/aft/Rivers.java: Figure out
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
350 only the rivers which are in both databases and sync them.
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
351
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
352 * src/main/java/de/intevation/aft/Sync.java: Only pass the
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
353 connected statements to the sync.
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
354
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
355 * src/main/resources/sql/flys-common.properties: Fixed SQL for
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
356 fetching the rivers.
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
357
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
358 * pom.xml: Added dependency to PostgreSQL.
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
359
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
360 * doc/conf.xml: SQLite needs a driver class.
dbd0b3b1b8b8 Sync each river.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4074
diff changeset
361
4074
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
362 2011-12-13 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
363
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
364 * src/main/java/de/intevation/db/ConnectionBuilder.java: Removed
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
365 statements here.
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
366
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
367 * src/main/java/de/intevation/db/Statements.java: Added method
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
368 to access the hole map of statements.
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
369
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
370 * src/main/java/de/intevation/db/ConnectedStatements.java: New.
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
371 A cache that binds prepared statements to a connection.
100c4e0a45e1 Improved infrastructure for prepared statements.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4073
diff changeset
372
4073
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
373 2011-12-13 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
374
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
375 * src/main/java/de/intevation/db/ConnectionBuilder.java: Added
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
376 access to Statements.
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
377
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
378 * src/main/java/de/intevation/db/SymbolicStatement.java: New.
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
379 Made top level from inner class of Statements.
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
380
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
381 * src/main/java/de/intevation/db/Statements.java: Moved SymbolicStatement
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
382 out to top level class.
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
383
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
384 * src/main/java/de/intevation/aft/Rivers.java: Syncing beginns at
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
385 river level.
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
386
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
387 * src/main/java/de/intevation/aft/Sync.java: Start the syncing with
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
388 the rivers of both dbs.
2c70fae83d0c start syncing at river level.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4072
diff changeset
389
4072
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
390 2011-12-13 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
391
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
392 * doc/conf.xml: Adjusted structure to be more generic.
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
393
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
394 * src/main/java/de/intevation/utils/XML.java: Allow namespace aware
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
395 file parsing.
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
396
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
397 * src/main/java/de/intevation/db/ConnectionBuilder.java: New. Evaluate
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
398 config and builds a new db connection.
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
399
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
400 * src/main/java/de/intevation/aft/Sync.java: Load config file.
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
401
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
402 * pom.xml: Added dependency to SQLite JDBC driver.
88f801888d85 load configuration an setup db connections.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4071
diff changeset
403
4071
0f5cc88a0f74 Added configuration file
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4070
diff changeset
404 2011-12-13 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
0f5cc88a0f74 Added configuration file
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4070
diff changeset
405
0f5cc88a0f74 Added configuration file
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4070
diff changeset
406 * doc/conf.xml: New. Configuration file.
0f5cc88a0f74 Added configuration file
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4070
diff changeset
407
4070
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
408 2011-12-13 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
409
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
410 * ChangeLog: New. Argh! Forgot to check it in before.
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
411
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
412 * src/main/java/de/intevation/utils/XML.java: New. XML/XPath support.
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
413 Mainly a stripped down version of
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
414 de.intevation.artifacts.common.utils.XMLUtils
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
415
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
416 2011-12-12 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
417
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
418 * src/main/java/de/intevation/db/Statements.java: Added support
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
419 for symbolic prepared statements.
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
420
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
421 2011-12-12 Sascha L. Teichmann <sascha.teichmann@inteavtion.de>
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
422
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
423 * src/main/java/de/intevation/db/Statements.java: New. Load statements
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
424 from ressources.
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
425
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
426 * src/main/resources/sql/aft-common.properties: New. Common statements
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
427 for the AFT side of the sync.
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
428
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
429 * src/main/resources/sql/flys-common.properties: New. Common statements
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
430 for the FLYS side of the sync.
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
431
d09adfa90942 Added XML/XPath support.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
432 * pom.xml: Added dependency to log4j
http://dive4elements.wald.intevation.org