dive4elements/river: etl/ChangeLog annotate

annotate etl/ChangeLog @ 8764:d5917ff74d8a

(issue1838) Get min and max directly from database. The former implementation led to a connection leak.

author	Tom Gottfried <tom@intevation.de>
date	Mon, 17 Aug 2015 10:18:05 +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

Mercurial > dive4elements > river

annotate etl/ChangeLog @ 8764:d5917ff74d8a