Mercurial > dive4elements > river

comparison flys-aft/ChangeLog @ 4114:ae5119da92cd

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