Mercurial > dive4elements > river
annotate etl/ChangeLog @ 6061:e9a76ffa0f9a
Use maxOverlap to get the correct gauge for the MainValues
Previously just the first matching gauge was taken even if it's
range ended with the minimum value. This code is clearly intended
to get one gauge for one range so the best match should be taken.
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Wed, 22 May 2013 18:10:48 +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 |