Mercurial > dive4elements > river

comparison flys-backend/ChangeLog @ 508:a9c7f6ec3a5a 2.3.1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merged flys-backend/2.3.1
author Thomas Arendsen Hein <thomas@intevation.de>
date Fri, 28 Sep 2012 12:14:12 +0200
parents 730f8500a73a
children 677a6fceea6e
comparison
equal deleted inserted replaced
462:ebf049a1eb53 508:a9c7f6ec3a5a
1 2011-05-20 Ingo Weinzierl <ingo@intevation.de>
2
3 Tagged RELEASE 2.3.1
4
5 2011-05-13 Ingo Weinzierl <ingo@intevation.de>
6
7 Tagged RELEASE 2.3
8
9 2011-05-13 Ingo Weinzierl <ingo@intevation.de>
10
11 * Changes: Changes for release 2.3 - see Changes file to get to know about
12 the version numbers of this software.
13
14 2011-05-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>
15
16 * doc/schema/postgresql.sql: Added a column which tells
17 if a river counts its km up or downwards.
18 To update existing databases:
19
20 ALTER TABLE rivers ADD COLUMN km_up BOOLEAN NOT NULL DEFAULT true;
21
22 * src/main/java/de/intevation/flys/model/River.java:
23 Adjust Hibernate mapping of new column.
24
25 2011-05-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>
26
27 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
28 Fixed flys/issue11 and flys51.
29
30 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
31
32 * src/main/java/de/intevation/flys/importer/ValueKey.java:
33 Add some unsharp comparison (eps = 1e-6) to avoid
34 numerical problems.
35
36 * src/main/java/de/intevation/flys/importer/IdValueKey.java:
37 Removed. Not need any longer.
38
39 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
40 Use unsharp lookup.
41
42 * src/main/java/de/intevation/flys/importer/ImportWst.java,
43 src/main/java/de/intevation/flys/importer/ImportRiver.java:
44 Flush more often. Hopefully this reduces hibernate sync
45 problems?!
46
47 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
48
49 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
50 Fixed silly bug. Set flush mode back to auto because
51 manual flushing causes some undetermined problems.
52
53 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
54
55 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
56 Do not load _all_ values from discharge tables and
57 wst columns. This is extremly slow and will lead
58 to OOM if more rivers are imported. Now only the
59 last 20 columns und discharge tables are cached.
60
61 * src/main/java/de/intevation/flys/importer/ValueKey.java:
62 New. Key for caching discharge table values and wst
63 column values.
64
65 * src/main/java/de/intevation/flys/importer/IdValueKey.java:
66 Fixed bug in equals().
67
68 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
69 Removed too eloquent debug output.
70
71 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
72
73 * src/main/java/de/intevation/flys/importer/IdValueKey.java:
74 Use BigDecimals as representation for the numeric components
75 which prevents running into unique constraint problems
76 caused by imprecision.
77
78 * src/main/java/de/intevation/flys/importer/ImportRange.java,
79 src/main/java/de/intevation/flys/importer/ImporterSession.java:
80 Ranges are now cached globally, too.
81
82 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
83 Improved logging.
84
85 * src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java:
86 Removed superfluous imports.
87
88 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
89
90 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
91 Only accept main value types 'Q', 'W', 'D' and 'T' by default.
92 '-' is not handled any more because it causes too much constraint
93 problems. You can overwrite the imported type with the
94 system property flys.backend.main.value.types" (default "QWTD")
95
96 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
97 Set session flush mode to manual. Hopefully this improves the
98 performance a bit.
99
100 * src/main/java/de/intevation/flys/importer/ImportWst.java,
101 src/main/java/de/intevation/flys/importer/ImportGauge.java,
102 src/main/java/de/intevation/flys/importer/ImportWstColumn.java,
103 src/main/java/de/intevation/flys/importer/ImportRange.java,
104 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
105 Improved logging.
106
107 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
108
109 * src/main/java/de/intevation/flys/importer/WstColumnValueKey.java: Deleted
110 * src/main/java/de/intevation/flys/importer/IdValueKey.java: Reinserted
111 here in a more generalized form.
112
113 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
114 Cache the discharge table value, too.
115
116 * src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java:
117 Use the global cache.
118
119 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
120
121 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
122 New. Centralized caching in the thread local context. Importing
123 the Elbe leads to OOM because the column values of the
124 WST files where loaded separately for every file.
125
126 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
127 src/main/java/de/intevation/flys/importer/Importer.java,
128 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
129 src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
130 src/main/java/de/intevation/flys/importer/ImportWst.java,
131 src/main/java/de/intevation/flys/importer/ImportMainValue.java,
132 src/main/java/de/intevation/flys/importer/ImportMainValueType.java,
133 src/main/java/de/intevation/flys/importer/ImportNamedMainValue.java,
134 src/main/java/de/intevation/flys/importer/ImportRiver.java,
135 src/main/java/de/intevation/flys/importer/ImportGauge.java,
136 src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java,
137 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
138 src/main/java/de/intevation/flys/importer/ImportWstColumn.java,
139 src/main/java/de/intevation/flys/importer/ImportRange.java,
140 src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java,
141 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java,
142 src/main/java/de/intevation/flys/importer/ImportAttribute.java,
143 src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
144 Adjusted to use the new global context.
145
146 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
147
148 * doc/schema/postgresql.sql: Dropped constraint which
149 forces discharge tables to have a unique time interval
150 for a given gauge and kind.
151
152 There are AT files (historical Mosel/Perl/Perl/1967-1981.at
153 and Mosel/Perl/1967-1981-1.at) which violate this
154 constraint. Its a technical question to the customer
155 how to handle these cases.
156
157 To adjust existing databases:
158
159 ALTER TABLE discharge_tables DROP CONSTRAINT discharge_tables_gauge_id_key;
160
161 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
162
163 * src/main/java/de/intevation/flys/importer/WstParser.java:
164 There are wst files where column names are not unique.
165 Make them unique by appending (1), (2) and so on.
166
167 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
168
169 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
170 Import the "HW-Schutzanlagen", too.
171
172 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
173
174 Make import of historical discharge tables work.
175
176 * doc/schema/postgresql.sql: Added forgotten column 'description'.
177
178 !!! You have to drop your database !!!
179
180 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
181 src/main/java/de/intevation/flys/model/DischargeTable.java:
182 Add the forgotten description property.
183
184 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
185 Fixed problems with date recognition.
186
187 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
188 Prefix the description of the historical discharge tables
189 with "Histor.Abflusstafeln".
190
191 * src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
192 Fixed silly programming error.
193
194 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
195
196 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
197 Inject 'kind' attribute.
198
199 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
200 Traverse the "Histor.Abflusstafeln" for the historical
201 discharge tables. too. TODO: Store them in the database.
202
203 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
204 Added convinience constructor to set the kind of the
205 discharge table.
206
207 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
208
209 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
210 Prefix "Zusätzliche Längsschnitte" with "Zus.Längsschnitte"
211 in description.
212
213 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
214
215 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
216 Import 'Hochwasser-Marken', too.
217
218 * src/main/java/de/intevation/flys/importer/WstParser.java:
219 Removed superfluous import.
220
221 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
222
223 * src/main/java/de/intevation/flys/importer/WstParser.java:
224 Ignore lines that contain km positions which were found
225 before in the same file.
226
227 2011-05-05 Ingo Weinzierl <ingo@intevation.de>
228
229 * src/main/java/de/intevation/flys/model/River.java: Added a method that
230 returns all gauges of the river intersected by a given start and end
231 point.
232
233 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
234
235 * src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
236 Forgot to fetch peer from result set.
237
238 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
239
240 * src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
241 New. Importer model help fetching the database peer.
242
243 * src/main/java/de/intevation/flys/model/TimeInterval.java:
244 Add convinience constructor with start and stop time.
245
246 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
247 Attach a time interval to a discharge table if we find one.
248
249 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
250 Store the reference to the importer model of the
251 time interval of the discharge table.
252
253 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
254
255 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
256 Try to extract time ranges from at files.
257
258 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
259
260 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
261 Parse and store "amtliche Linien" wst files.
262
263 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
264
265 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
266 Parse and store fixation wst files as well.
267
268 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
269
270 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
271 Parse the "zusaetzliche Laengsschnitte", too.
272
273 * src/main/java/de/intevation/flys/importer/ImportWst.java:
274 Add getter/setter for column 'kind'.
275
276 2011-05-02 Sascha L. Teichmann <sascha.teichmann@intevation.de>
277
278 * src/main/java/de/intevation/flys/importer/WstParser.java:
279 Fixed flys/issue19: Do not take km column in wst file as a water level.
280
281 2011-05-02 Ingo Weinzierl <ingo@intevation.de>
282
283 * src/main/java/de/intevation/flys/model/Gauge.java: Introduced a 'scale'
284 that is used to adjust the range of min/max W values.
285
286 2011-05-01 Sascha L. Teichmann <sascha.teichmann@intevation.de>
287
288 * src/main/java/de/intevation/flys/importer/WstParser.java:
289 Removed superfluous import.
290
291 2011-04-20 Ingo Weinzierl <ingo@intevation.de>
292
293 * src/main/java/de/intevation/flys/importer/WstColumnValueKey.java:
294 New. This class is used as distinct key of a WstColumnValue - e.g. as
295 key in a map.
296
297 * src/main/java/de/intevation/flys/importer/ImportWst.java: A
298 WstColumnValue cache is build up while initialization. This cache
299 contains all WstColumnValues that exist in the database.
300
301 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java: New
302 constructor that takes the WstColumnValues cache. It is used to
303 initialize new ImportWstColumnValue objects.
304
305 * src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java:
306 Speedup: A ImportWstColumnValue has a WstColumnValues cache that
307 contains all WstColumnValues existing in the database. This makes it
308 unnecessary to call an sql statement for each WstColumnValue to
309 determine its existence in the database.
310
311 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
312
313 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
314 Added a view 'wst_value_table' which aggregates the data
315 to build w/q value tables.
316
317 To update existing databases:
318
319 BEGIN;
320 CREATE VIEW wst_value_table AS
321 SELECT wcv.position AS position,
322 w,
323 (SELECT q
324 FROM wst_column_q_ranges wcqr
325 JOIN wst_q_ranges wqr
326 ON wcqr.wst_q_range_id = wqr.id
327 JOIN ranges r
328 ON r.id = wqr.range_id
329 WHERE wcqr.wst_column_id = wc.id
330 AND wcv.position BETWEEN r.a AND r.b) AS q,
331 wc.position AS column_pos,
332 w.id AS wst_id
333 FROM wst_column_values wcv
334 JOIN wst_columns wc
335 ON wcv.wst_column_id = wc.id
336 JOIN wsts w
337 ON wc.wst_id = w.id
338 ORDER BY wcv.position ASC,
339 wc.position DESC;
340 COMMIT;
341
342 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
343
344 * src/main/java/de/intevation/flys/model/Wst.java:
345 Add forgotten one to many relation Wst -> WstColumn.
346
347 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
348
349 * src/main/java/de/intevation/flys/importer/ImportWst.java,
350 src/main/java/de/intevation/flys/importer/WstParser.java:
351 Import of q ranges of wst files was totally broken. :-/
352 You have to reimport all your data.
353
354 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
355
356 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
357 Forgot kind parameter in peer fetching query.
358
359 2011-04-18 Ingo Weinzierl <ingo@intevation.de>
360
361 * src/main/java/de/intevation/flys/model/River.java::
362 Added a new method to determine the gauge based on a given start and end
363 point of the river.
364
365 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
366
367 * doc/schema/postgresql.sql: Added 'position' column to wst_columns
368 to allow order them by there column position in the original
369 wst file.
370
371 Update existing database with:
372
373 BEGIN;
374 ALTER TABLE wst_columns ADD COLUMN position int;
375 UPDATE wst_columns w SET
376 position = id - (SELECT min(id) FROM wst_columns WHERE wst_id = w.wst_id);
377 ALTER TABLE wst_columns ADD CONSTRAINT wst_columns_wst_id_position_key
378 UNIQUE (wst_id, position);
379 COMMIT;
380
381 * src/main/java/de/intevation/flys/model/Wst.java,
382 src/main/java/de/intevation/flys/model/WstColumn.java:
383 Adjusted models.
384
385 * src/main/java/de/intevation/flys/importer/ImportWst.java,
386 src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
387 Adjusted importer.
388
389 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
390
391 * doc/schema/postgresql.sql: Forget ',' in schema.
392
393 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
394
395 * src/main/java/de/intevation/flys/model/Wst.java (determineMinMaxQ):
396 Fixed index problem when an empty list is returned.
397
398 2011-04-15 Ingo Weinzierl <ingo@intevation.de>
399
400 * src/main/java/de/intevation/flys/model/Wst.java: A Wst is now able to
401 return its min and max Q values.
402
403 * src/main/java/de/intevation/flys/model/Gauge.java: A Gauge is now able
404 to return its min and max W values.
405
406 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
407
408 * doc/schema/postgresql.sql: Added new column 'kind' in
409 discharge tables and wst to distinguish between different
410 kinds like 'Haupt-WST', 'zusaetzliche Laengsschnitte',
411 'amtliche Daten' and so on.
412
413 Update existing databases with:
414 BEGIN;
415 ALTER TABLE discharge_tables ADD COLUMN kind int NOT NULL DEFAULT 0;
416 ALTER TABLE wsts ADD COLUMN kind int NOT NULL DEFAULT 0;
417 COMMIT;
418
419 * src/main/java/de/intevation/flys/model/DischargeTable.java
420 src/main/java/de/intevation/flys/model/Wst.java,
421 src/main/java/de/intevation/flys/importer/ImportWst.java,
422 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
423 Adjusted the models.
424
425 2011-04-15 Ingo Weinzierl <ingo@intevation.de>
426
427 * src/main/java/de/intevation/flys/backend/SessionHolder.java: Moved to
428 this module from flys-artifacts. This is necessary to get access to the
429 current session in this module as well.
430
431 2011-04-14 Ingo Weinzierl <ingo@intevation.de>
432
433 * src/main/java/de/intevation/flys/model/River.java: Added a method that
434 returns the min and max distance of a river.
435
436 2011-04-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
437
438 * src/**/*.java: Removed trailing whitespace.
439
440 2011-03-30 Ingo Weinzierl <ingo@intevation.de>
441
442 Tagged RELEASE 0.1
443
444 2011-03-28 Sascha L. Teichmann <sascha.teichmann@intevation.de>
445
446 * src/main/java/de/intevation/flys/model/Range.java:
447 Forgot to save the last change before commit.
448
449 2011-03-28 Sascha L. Teichmann <sascha.teichmann@intevation.de>
450
451 * src/main/java/de/intevation/flys/model/Range.java:
452 Added methods to find out if two ranges intersects.
453
454 2011-03-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
455
456 * src/main/java/de/intevation/flys/model/Gauge.java:
457 Added an one to many relation to the discharge tables of a gauge.
458
459 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
460
461 Finished import of WSTs.
462
463 TODO 1: Speed it up! It takes on a high end machine over 7(!)
464 minutes only for the data of the Saar.
465 TODO 2: Double precision floating point representations produced
466 by the the parsers leed to unique constraint violations
467 in the backend on a second run. So the import is currently
468 only working on freshly initialized data bases.
469 More consequent working with BigDecimal and some
470 rounding may be of help here.
471
472 * src/main/java/de/intevation/flys/model/WstColumnValue.java:
473 Added convinience constructors.
474
475 * src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java:
476 Added getPeer() method.
477
478 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
479 Add a list of the ImportWstColumnValues produced by the WST parser.
480
481 * src/main/java/de/intevation/flys/importer/WstParser.java: Add
482 the (km, w) values to the ImportWstColumns.
483
484 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
485
486 * src/main/java/de/intevation/flys/importer/WstParser.java:
487 Build models for wsts, wst columns and q ranges and
488 store them in the backend. TODO: store the w values.
489
490 * src/main/java/de/intevation/flys/model/WstQRange.java
491 src/main/java/de/intevation/flys/model/Wst.java,
492 src/main/java/de/intevation/flys/model/Range.java,
493 src/main/java/de/intevation/flys/model/WstColumnQRange.java,
494 src/main/java/de/intevation/flys/model/WstColumn.java:
495 Added convinience constructors.
496
497 * src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
498 src/main/java/de/intevation/flys/importer/ImportWst.java,
499 src/main/java/de/intevation/flys/importer/ImportRiver.java,
500 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
501 src/main/java/de/intevation/flys/importer/ImportWstColumn.java,
502 src/main/java/de/intevation/flys/importer/ImportRange.java:
503 Added getPeer() methods.
504
505 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
506
507 * src/main/java/de/intevation/flys/importer/WstParser.java:
508 The unit extraction in the WST parser of desktop FLYS
509 is broken! Add a hack here to repair this for our
510 importer. Desktop FLYS needs a fix, too!
511
512 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
513
514 * src/main/java/de/intevation/flys/importer/WstParser.java:
515 Ported some stuff ver from WSTSource.java of desktop flys to
516 parse WST files. TODO: create instances of the import models.
517
518 * src/main/java/de/intevation/flys/utils/StringUtil.java:
519 Copied from desktop flys. Used for some string operations
520 in WST parser.
521
522 * src/main/java/de/intevation/flys/importer/Importer.java:
523 Added system property 'flys.backend.importer.dry.run'.
524 Set to true only the parsing is done and no writing
525 to the backend. Default: false.
526
527 * src/main/java/de/intevation/flys/App.java,
528 src/main/java/de/intevation/flys/model/MainValueType.java:
529 Removed needless imports.
530
531 2011-03-22 Ingo Weinzierl <ingo@intevation.de>
532
533 * src/main/java/de/intevation/flys/model/DischargeTableValue.java,
534 src/main/java/de/intevation/flys/model/DischargeTable.java: Added new
535 constructors.
536
537 * src/main/java/de/intevation/flys/importer/AtFileParser.java: New. This
538 parser is used to '*.at' files.
539
540 * src/main/java/de/intevation/flys/importer/ImportGauge.java: Added code to
541 import discharge tables.
542
543 * src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java,
544 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java: New.
545 Helper models for import discharge tables.
546
547 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
548
549 * src/main/java/de/intevation/flys/importer/WstParser.java,
550 src/main/java/de/intevation/flys/importer/ImportRiver.java:
551 Added stub for WST parser.
552
553 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
554
555 * src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
556 src/main/java/de/intevation/flys/importer/ImportWst.java,
557 src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java,
558 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
559 src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
560 Added importer helper model stubs for WST imports.
561
562 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
563
564 Second part of parsing/storing main values. Should be finished now.
565
566 * src/main/java/de/intevation/flys/importer/ImportNamedMainValue.java,
567 src/main/java/de/intevation/flys/importer/ImportMainValue.java:
568 New. Helper models for import main values,
569
570 * src/main/java/de/intevation/flys/model/MainValue.java,
571 src/main/java/de/intevation/flys/model/NamedMainValue.java:
572 Added convinience constructors.
573
574 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
575 Write main values to backend, too.
576
577 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
578 Build importer models for main values.
579
580 * src/main/java/de/intevation/flys/importer/ImportMainValueType.java:
581 Data was called 'value'. Now it is 'name' to fit the
582 schema.
583
584 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
585
586 * doc/schema/postgresql.sql: Fixed wrong unique constraint.
587
588 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
589 Added some logging when storing gauges.
590
591 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
592
593 * src/main/java/de/intevation/flys/model/Gauge.java:
594 Add forgotten column river_id.
595
596 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
597 Small HQL fix.
598
599 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
600
601 * src/main/java/de/intevation/flys/model/Gauge.java:
602 Added convinience contructor.
603
604 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
605 Fixed getPeer() method.
606
607 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
608 Fixed parsing of STA files.
609
610 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
611
612 * src/main/java/de/intevation/flys/importer/ImportRiver.java,
613 src/main/java/de/intevation/flys/importer/ImportGauge.java:
614 Propagate river into storing of gauges.
615
616 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
617
618 * src/main/java/de/intevation/flys/importer/Importer.java:
619 Added code to store rivers not only annotations.
620
621 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
622 Added stub code to write gauges.
623
624 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
625
626 First part of parsing main values.
627
628 * src/main/java/de/intevation/flys/App.java: Commented out
629 creation of dummy rivers.
630
631 * src/main/java/de/intevation/flys/model/NamedMainValues.java:
632 Moved to NamedMainValue.
633
634 * src/main/java/de/intevation/flys/model/NamedMainValue.java:
635 New. Formerly NamedMainValues.
636
637 * src/main/java/de/intevation/flys/model/MainValue.java:
638 New. Forgotten part of the model.
639
640 * src/main/java/de/intevation/flys/model/MainValueType.java:
641 Data is String not BigDecimal
642
643 * src/main/java/de/intevation/flys/model/Range.java: Removed
644 contructor with double arguments. Using BigDecimal now.
645
646 * src/main/java/de/intevation/flys/importer/PegelGltParser.java:
647 Propagate BigDecimal usage.
648
649 * src/main/java/de/intevation/flys/importer/Importer.java:
650 Removed needless import. Added TODO
651
652 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
653 Parse the dependencies of the gauges, too.
654
655 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
656 New. Parser for STA files.
657
658 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
659 Call STA file parser.
660
661 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java,
662 src/main/java/de/intevation/flys/importer/ImportRange.java:
663 Uses BigDecimal now.
664
665 * src/main/java/de/intevation/flys/importer/ImportAttribute.java:
666 Fixed wrong type cast in equals.
667
668 * src/main/java/de/intevation/flys/importer/ImportMainValueType.java:
669 New. Helper model for importing main value types.
670
671 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
672 Register forgotten MainValue model.
673
674 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
675
676 Store annotations in backend.
677
678 * src/main/java/de/intevation/flys/model/Annotation.java:
679 New convinience constructor.
680
681 * src/main/java/de/intevation/flys/model/River.java:
682 Added toString() method.
683
684 * src/main/java/de/intevation/flys/model/Range.java:
685 Fixed nasty mistake in @OneToOne annotatation.
686 New convinience constructors.
687
688 * src/main/java/de/intevation/flys/importer/ImportPosition.java
689 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
690 src/main/java/de/intevation/flys/importer/ImportRange.java
691 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
692 Make storing to backend work. It's a bit too slow. :-/
693
694 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
695 Fetch peer from backend. Added method to store annotations.
696 * src/main/java/de/intevation/flys/importer/Importer.java:
697 Stored annotations into backend. More eloquent SQL exception
698 handling.
699
700 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
701
702 * src/main/java/de/intevation/flys/model/Attribute.java,
703 src/main/java/de/intevation/flys/model/Position.java:
704 Added convinience constructors.
705
706 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
707 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
708 Bound them to there backend peers.
709
710 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
711
712 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java:
713 New. Added parser to read *.KM files.
714
715 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
716 src/main/java/de/intevation/flys/importer/PegelGltParser.java,
717 src/main/java/de/intevation/flys/importer/ImportRiver.java,
718 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
719 src/main/java/de/intevation/flys/importer/ImportRange.java,
720 src/main/java/de/intevation/flys/importer/InfoGewParser.java,
721 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
722 Adjusted to load the annotations from *.KM files.
723
724 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
725
726 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
727 src/main/java/de/intevation/flys/importer/ImportRange.java,
728 src/main/java/de/intevation/flys/importer/ImportAttribute.java,
729 src/main/java/de/intevation/flys/importer/ImportAnnotation.java:
730 New helper models for import.
731
732 * src/main/java/de/intevation/flys/importer/PegelGltParser.java,
733 src/main/java/de/intevation/flys/importer/ImportGauge.java:
734 Use new models.
735
736 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
737
738 * src/main/java/de/intevation/flys/importer/PegelGltParser.java:
739 New. Parser for PEGEL.GLT files.
740
741 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
742 New. Import model for gauges.
743
744 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
745 Removed needless imports.
746
747 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
748 Added method to parse the gauges.
749
750 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
751 Trigger pegel glt file parsing.
752
753 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
754
755 * src/main/java/de/intevation/flys/importer/Importer.java:
756 Used thread local pattern to make sharing of session easier.
757
758 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
759
760 * src/main/java/de/intevation/flys/importer/Importer.java:
761 Fixed error in HQL statement.
762
763 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
764
765 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
766 Commented out a debug block because it leaks the db password.
767
768 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
769
770 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
771 Expose imported rivers.
772
773 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
774 Store imported rivers into database. Needs testing!
775
776 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
777
778 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
779 Default connection parameters are now overwritable with
780 system properties (defaults in brackets):
781 - user name: flys.backend.user (flys)
782 - user password: flys.backend.password (flys)
783 - db dialect: flys.backend.dialect (org.hibernate.dialect.PostgreSQLDialect)
784 - db driver: flys.backend.driver (org.postgresql.Driver)
785 - db url: flys.backend.url (jdbc:postgresql://localhost:5432/flys)
786
787 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
788
789 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
790 Expose createSessionFactory() as public to be usable without
791 a artifact database running.
792
793 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
794
795 * src/main/java/de/intevation/flys/utils/FileTools.java:
796 Tools for handling with filenames. Currently there is
797 a repair(File) method with repairs letter case errors
798 which is useful when reading windows filenames on a
799 un*x platform.
800
801 * src/main/java/de/intevation/flys/importer/Importer.java:
802 Standalone app to read data from the file system and
803 store it in a database. Currently it does not store
804 anything. It only loads info gew files.
805
806 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
807 Info gew parser.
808
809 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
810 Helper model of a river used produced by parsing the
811 info gew files.
812
813 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
814
815 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
816 New. SessionFactoryProvider.getSessionFactory() provides a
817 SessionFactory to use the Hibernate O/R mapper for the FLYS backend.
818
819 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
820
821 * pom.xml: Added dependency to artifacts-commons to
822 be able to use the global configuration of the artifact database.
823
824 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
825
826 * src/main/java/de/intevation/flys/App.java: Wire all POJOs
827 to corresponding factory.
828
829 * src/main/java/de/intevation/flys/model/*.java: Generate
830 all foreign key constraints. TODO: name them correctly
831 because the machine generated names are ugly and do
832 not fit the PostgreSQL names.
833
834 * doc/schema/postgresql.sql: Small quantifier fix in descriptions
835 of wst columns.
836
837 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
838
839 * doc/schema/postgresql.sql: Fixed wrong spelled
840 column references in foreign keys introduces with
841 last change.
842
843 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
844
845 * src/main/java/de/intevation/flys/model/*.java: Added
846 column annotations for simple fields. TODO: foreign keys.
847
848 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
849
850 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
851 Fixed inconsistent table names.
852
853 * src/main/java/de/intevation/flys/model/*.java: Added
854 entity and id annotations.
855
856 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
857
858 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
859 Added missing sequences.
860
861 * doc/schema/sqlite.sql: Deleted. Not longer supported.
862
863 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
864
865 * doc/schema/postgresql-cleanup.sql: Forgot to add.
866
867 * src/main/java/de/intevation/flys/App.java: Use
868 Apache Commons DBCP as Hibernate connection provide.
869
870 * src/main/java/de/intevation/flys/model/River.java:
871 Added a constructor with string argument. Set the
872 sequence increment to 1 (eat up 100 at a time before).
873
874 * pom.xml: Added PostgreSQL 8.4 driver as runtime dependency.
875
876 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
877
878 * doc/schema/postgresql-cleanup.sql: New. Tear down schema
879 for a postgres database.
880
881 * doc/schema/postgresql.sql: Added squence for
882 auto generating ids in river table. Cleaned up schema.
883
884 * src/main/java/de/intevation/flys/App.java: Simple
885 test app to interact with hibernate. Needs to be removed
886 because its only a toy.
887
888 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
889 New. Binds Apache Commons to Hibernate.
890
891 * pom.xml: Added dependencies to log4j, commons dbcp,
892 JPA of hibernate.
893
894 * src/main/java/de/intevation/flys/model/River.java: Added
895 JPA annotations.
896
897 * src/main/java/de/intevation/flys/model/*.java: Replaced
898 Long with Integer because column ids are only four bytes wide.
899
900 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
901
902 * doc/schema/sqlite.sql, doc/schema/postgresql.sql: Fixed
903 smaller issues in ddl.
904
905 * src/main/java/de/intevation/flys/model/*.java: Added POJOs
906 of to be mapped. TODO: Map them!
907
908 * pom.xml: Added plugin config for hibernate.
909
910 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
911
912 * pom.xml: Added dependency (and corresponding repository) to
913 Hibernate Core 3.6.1 Final
914
915 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
916
917 * pom.xml, src/**: Created a new empty maven project:
918 $ mvn archetype:create \
919 -DgroupId=de.intevation.flys \
920 -DartifactId=flys-backend
921
922 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
923
924 * README: New. Some setup instructions.
925
926 * doc/schema/postgresql.sql: New. Schema converted to PostgreSQL
927
928 * doc/schema/sqlite.sql: Fixed defect foreign key constraints.
929
930 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
931
932 * doc/schema/sqlite.sql: Factorized time intervals out into
933 a separated table.
934
935 2011-01-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
936
937 * contrib/import-kms.py, contrib/import-gew.py: Initial scripts
938 to import data into SQLite database. They still need some work.
939
940 2011-02-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>:
941
942 * doc/schema/sqlite.sql: Added initial schema for
943 FLYS database.
http://dive4elements.wald.intevation.org