Mercurial > dive4elements > river
view flys-aft/ChangeLog @ 4089:859b4781554a
Prefetch existing time intervals from FLYS db.
flys-aft/trunk@3574 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Tue, 03 Jan 2012 12:25:06 +0000 |
parents | 52cde7fe742a |
children | d556e29592f5 |
line wrap: on
line source
2012-01-03 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/aft/TimeInterval.java: New. Model for FLYS time intervls. * src/main/java/de/intevation/aft/SyncContext.java: Preload existing time intervals from FLYS. * src/main/java/de/intevation/aft/Sync.java: Call init() after construction to ensure that the db connections are closed properly. * src/main/resources/sql/flys-common.properties: Added statement to fetch the time intervals from FLYS. 2012-01-03 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/aft/River.java: Fetch discharge table infos from AFT. * src/main/resources/sql/aft-common.properties: Added statement to fetch infos from ABFLUSSTAFEL. 2012-01-02 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/resources/sql/flys-common.properties: Added statements to create gauges in FLYS. * src/main/java/de/intevation/aft/DIPSGauge.java: Make more fields accessible for gauge creation in FLYS. * src/main/java/de/intevation/aft/River.java: Store new gauges in FLYS. * src/main/java/de/intevation/db/ConnectedStatements.java: Added logging, make methods of transaction handling public. * src/main/java/de/intevation/db/SymbolicStatement.java(setDouble): Fixed argument type problem. 2012-01-02 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/db/ConnectionBuilder.java: Set auto commit of new connection to false to enable transaction. * src/main/java/de/intevation/db/ConnectedStatements.java: Added methods to begin, commit and rollback transactions. Relies on savepoint support which is check by database metadata. 2011-12-22 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/aft/River.java: Figure out which gauges must be updated, which must be created. * src/main/java/de/intevation/aft/DIPSGauge.java: Store info from AFT and FLYS, too. * src/main/resources/sql/flys-common.properties: Fetch the official number, too. 2011-12-20 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/aft/River.java: Removed index DIPS gauge number -> DIPS gauge. * src/main/java/de/intevation/aft/SyncContext.java: Readded here, because the index can be shared by all rivers. 2011-12-20 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * doc/repair.xsl: Repair XSL transform which brings the DIPS gauge numbers of the 15 FLYS gauges to the same numbers as they are used in "Pegel Online". !!! The purpose of this script is to do more repairing !!! * doc/pegelstationen.xml: Sub document of repair. Used for lookup the correct pegel numbers. * doc/conf.xml: Changed to optionally load the repair XSLT. * src/main/java/de/intevation/aft/Sync.java: Load the repair XSL transformation if configured. * src/main/java/de/intevation/utils/XML.java: Added code to make XSL transforms possible. * src/main/java/de/intevation/aft/River.java, src/main/java/de/intevation/aft/Rivers.java: Fixed logging. 2011-12-20 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/aft/River.java, src/main/java/de/intevation/aft/DIPSGauge.java: Make DIPS check more verbose. 2011-12-16 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/db/SymbolicStatement.java: Made the setX() methods cascadable. * src/main/java/de/intevation/aft/River.java: Fetches the gauges from the database. * src/main/resources/sql/aft-common.properties, src/main/resources/sql/flys-common.properties: Added gauges statements. 2011-12-14 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/db/SymbolicStatement.java: Added execute(), executeQuery() & Co. * src/main/java/de/intevation/aft/IdPair.java: New. Base class for id pairs to identify same object in both databases. * src/main/java/de/intevation/aft/River.java: New. To sync the objects of one river. * src/main/java/de/intevation/aft/Rivers.java: Figure out only the rivers which are in both databases and sync them. * src/main/java/de/intevation/aft/Sync.java: Only pass the connected statements to the sync. * src/main/resources/sql/flys-common.properties: Fixed SQL for fetching the rivers. * pom.xml: Added dependency to PostgreSQL. * doc/conf.xml: SQLite needs a driver class. 2011-12-13 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/db/ConnectionBuilder.java: Removed statements here. * src/main/java/de/intevation/db/Statements.java: Added method to access the hole map of statements. * src/main/java/de/intevation/db/ConnectedStatements.java: New. A cache that binds prepared statements to a connection. 2011-12-13 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/db/ConnectionBuilder.java: Added access to Statements. * src/main/java/de/intevation/db/SymbolicStatement.java: New. Made top level from inner class of Statements. * src/main/java/de/intevation/db/Statements.java: Moved SymbolicStatement out to top level class. * src/main/java/de/intevation/aft/Rivers.java: Syncing beginns at river level. * src/main/java/de/intevation/aft/Sync.java: Start the syncing with the rivers of both dbs. 2011-12-13 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * doc/conf.xml: Adjusted structure to be more generic. * src/main/java/de/intevation/utils/XML.java: Allow namespace aware file parsing. * src/main/java/de/intevation/db/ConnectionBuilder.java: New. Evaluate config and builds a new db connection. * src/main/java/de/intevation/aft/Sync.java: Load config file. * pom.xml: Added dependency to SQLite JDBC driver. 2011-12-13 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * doc/conf.xml: New. Configuration file. 2011-12-13 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * ChangeLog: New. Argh! Forgot to check it in before. * src/main/java/de/intevation/utils/XML.java: New. XML/XPath support. Mainly a stripped down version of de.intevation.artifacts.common.utils.XMLUtils 2011-12-12 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/db/Statements.java: Added support for symbolic prepared statements. 2011-12-12 Sascha L. Teichmann <sascha.teichmann@inteavtion.de> * src/main/java/de/intevation/db/Statements.java: New. Load statements from ressources. * src/main/resources/sql/aft-common.properties: New. Common statements for the AFT side of the sync. * src/main/resources/sql/flys-common.properties: New. Common statements for the FLYS side of the sync. * pom.xml: Added dependency to log4j