Mercurial > dive4elements > river

comparison flys-backend/ChangeLog @ 3807:d73c43798a99 pre2.6-2011-11-04

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merged flys-backend/pre2.6-2011-11-04
author Thomas Arendsen Hein <thomas@intevation.de>
date Fri, 28 Sep 2012 12:14:51 +0200
parents 9df06b88c079
children e9b0fd1de89d
comparison
equal deleted inserted replaced
3806:881fcd01e056 3807:d73c43798a99
1 2011-11-01 Ingo Weinzierl <ingo@intevation.de>
2
3 * src/main/java/de/intevation/flys/model/RiverAxisKm.java: New. Model class
4 for 'river_axes_km' relation.
5
6 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
7 Added mapping for RiverAxisKm.
8
9 2011-10-25 Bjoern Schilberg <bjoern.schilberg@intevation.de>
10
11 * doc/schema/oracle_create_user.sql:
12 Added explizit TABLESPACE definition for the user.
13
14 2011-10-25 Bjoern Schilberg <bjoern.schilberg@intevation.de>
15
16 * doc/schema/oracle_create_user.sql:
17 Adjusted oracle_create_user.sql script. Added USER SQL snippet to change
18 tablespace to users.
19
20 2011-10-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>:
21
22 * src/main/java/de/intevation/flys/utils/DateGuesser.java:
23 New. Date guesser from desktop FLYS.
24
25 * src/main/java/de/intevation/flys/importer/parsers/WstParser.java:
26 Try to parse the name of a WST column as a date and store
27 the date into the database
28
29 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
30 Added code to store the date of the column in the database.
31
32 2011-10-24 Bjoern Schilberg <bjoern.schilberg@intevation.de>
33
34 * doc/schema/postgresql-spatial.sql:
35 Adjusted geometry type for floodplain and hws in AddGeometryColumn.
36
37 2011-10-19 Bjoern Schilberg <bjoern.schilberg@intevation.de>
38
39 * doc/schema/oracle.sql:
40 Added missing views (wst_value_table,wst_w_values,wst_q_values).
41
42 2011-10-18 Bjoern Schilberg <bjoern.schilberg@intevation.de>
43
44 * doc/schema/oracle.sql:
45 Removed all CREATE OR REPLACE TRIGGER statements.
46
47 2011-10-17 Bjoern Schilberg <bjoern.schilberg@intevation.de>
48
49 * doc/schema/oracle.sql:
50 Adjusted NUMBER format for units, positions and cross_section_points tables.
51
52 2011-10-10 Bjoern Schilberg <bjoern.schilberg@intevation.de>
53
54 * doc/schema/oracle.sql:
55 Fix errors.
56
57 2011-10-10 Bjoern Schilberg <bjoern.schilberg@intevation.de>
58
59 * doc/schema/oracle.sql:
60 Adjust oracle schema [I382].
61
62 2011-10-10 Felix Wolfsteller <felix.wolfsteller@intevation.de>
63
64 * src/main/java/de/intevation/flys/importer/ImportWst.java,
65 src/main/java/de/intevation/flys/importer/ImportUnit.java:
66 Removed obsolete imports.
67
68 2011-10-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>:
69
70 * ChangeLog: Added database update statements.
71
72 To update existing databases:
73
74 BEGIN;
75 CREATE SEQUENCE UNITS_ID_SEQ;
76 CREATE TABLE units (
77 id int PRIMARY KEY NOT NULL,
78 name VARCHAR(32) NOT NULL UNIQUE
79 );
80 ALTER TABLE rivers ADD COLUMN wst_unit_id int REFERENCES units(id);
81 INSERT INTO units (id, name) VALUES (nextval('UNITS_ID_SEQ'), 'NN + m');
82 INSERT INTO units (id, name) VALUES (nextval('UNITS_ID_SEQ'), 'NHN + m');
83 UPDATE rivers SET wst_unit_id = (SELECT id FROM units WHERE name = 'NHN + m') WHERE name = 'Elbe';
84 UPDATE rivers SET wst_unit_id = (SELECT id FROM units WHERE name = 'NN + m') WHERE name <> 'Elbe';
85 ALTER TABLE rivers ALTER COLUMN wst_unit_id SET NOT NULL;
86 COMMIT;
87
88 2011-10-05 Ingo Weinzierl <ingo@intevation.de>
89
90 * contrib/dump-schema.sh: New. A small shell script that dumps the
91 database schema of a given database to SQL.
92
93 * pom.xml: Added dependency for hibernate-spatial-oracle stuff.
94
95 2011-10-04 Ingo Weinzierl <ingo@intevation.de>
96
97 * doc/schema/postgresql.sql: Removed unit column from wsts; added a
98 wst_unit_id column to rivers. We decided to support a single elevation
99 model for the whole river.
100
101 * src/main/java/de/intevation/flys/model/River.java: Added a WstUnit
102 column.
103
104 * src/main/java/de/intevation/flys/model/Wst.java: Removed the Unit
105 column.
106
107 * src/main/java/de/intevation/flys/importer/ImportWst.java: Provide a
108 getUnit() method that allows querying the elevation unit for this wst.
109
110 * src/main/java/de/intevation/flys/importer/ImportUnit.java: Removed
111 storeDependencies().
112
113 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Save the
114 Unit of the wst file or a default one into database before all other
115 dependencies as well as the river itself is saved to database.
116
117 2011-10-04 Ingo Weinzierl <ingo@intevation.de>
118
119 * doc/schema/postgresql.sql: Added a "units" table.
120
121 * src/main/java/de/intevation/flys/model/Unit.java: New. Model class that
122 represents a unit.
123
124 * src/main/java/de/intevation/flys/importer/ImportUnit.java: New. Model
125 class that is used to import units.
126
127 * src/main/java/de/intevation/flys/model/Wst.java: A Wst stores a Unit
128 which references "units" table now.
129
130 * src/main/java/de/intevation/flys/importer/parsers/WstParser.java: Set
131 units which have already been parsed on Wsts.
132
133 * src/main/java/de/intevation/flys/importer/ImportWst.java: Added setter
134 method for Units and call storeDependencies() for ImportUnits.
135
136 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
137 Registered new model class Unit.
138
139 2011-10-04 Ingo Weinzierl <ingo@intevation.de>
140
141 flys/issue333 (W-INFO / Berechnung Wasserspiegellage, Zuordnung Bezugspegel)
142
143 * src/main/java/de/intevation/flys/model/River.java: Modified
144 determination of gauge based on a km range. River.determineGauge(double,
145 double) will now return the gauge which matches the start km.
146
147 2011-09-28 Felix Wolfsteller <felix.wolfsteller@intevation.de>
148
149 * src/main/java/de/intevation/flys/utils/StringUtil.java:
150 (wWrap): New method (extracted from WaterlevelSelectState).
151
152 2011-09-28 Felix Wolfsteller <felix.wolfsteller@intevation.de>
153
154 * src/main/java/de/intevation/flys/utils/StringUtil.java:
155 (unbracket): New method (extracted from WaterlevelSelectState).
156
157 2011-09-27 Sascha L. Teichmann <sascha.teichmann@intevation.de>
158
159 * src/main/java/de/intevation/flys/model/CrossSectionLine.java:
160 Moved some logic from cross section demo app to this model.
161
162 2011-09-26 Ingo Weinzierl <ingo@intevation.de>
163
164 * src/main/java/de/intevation/flys/model/CrossSectionTrack.java:
165 Added new function that the nearest CrossSectionTrack of a river to a
166 given kilometer.
167
168 2011-09-23 Bjoern Schilberg <bjoern@intevation.de>
169
170 * doc/schema/postgresql-spatial.sql:
171 Added missing river_axes_km schema.
172 * doc/schema/oracle-spatial.sql:
173 Added missing dem and lines schema.
174
175 2011-09-22 Bjoern Schilberg <bjoern@intevation.de>
176
177 * doc/schema/postgresql-spatial.sql, doc/schema/oracle-spatial.sql:
178 Harmonized oracle and postgresql spatial schema.
179
180 2011-09-22 Bjoern Schilberg <bjoern@intevation.de>
181
182 * doc/schema/oracle-spatial.sql: Harmonized Extent for Saar and Mosel. Some cleanups.
183
184 2011-09-22 Ingo Weinzierl <ingo@intevation.de>
185
186 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
187 Added the possibility to enable JMX (/MBean) support for hibernate. By
188 default, this support is NOT enabled. To enable JMX support for
189 hibernate, set the system property "flys.backend.enablejmx=true".
190
191 2011-09-20 Bjoern Schilberg <bjoern@intevation.de>
192
193 * doc/schema/oracle_create_user.sql: Added right to create views.
194
195 2011-09-20 Bjoern Schilberg <bjoern@intevation.de>
196
197 * doc/schema/oracle-spatial.sql: Generalized oracle spatial schema.
198
199 2011-09-19 Ingo Weinzierl <ingo@intevation.de>
200
201 Tagged RELEASE 2.5
202
203 * Changes: Prepared changes for release.
204
205 2011-09-16 Ingo Weinzierl <ingo@intevation.de>
206
207 * src/main/java/de/intevation/flys/model/DGM.java: Added function to query
208 a DGM by Id.
209
210 2011-09-15 Bjoern Schilberg <bjoern@intevation.de>
211
212 * pom.xml: Removed oracle dependency.
213
214 2011-09-15 Bjoern Schilberg <bjoern@intevation.de>
215
216 * doc/schema/oracle.sql: Added inital oracle schema.
217
218 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
219
220 * doc/schema/oracle-spatial_idx.sql: Added inital oracle-spatial_idx.sql
221 script.
222
223 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
224
225 * doc/schema/oracle-spatial.sql: Deactivated spatial indexes.
226
227 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
228
229 * doc/schema/oracle_create_user.sql: Added inital oracle_create_user.sql
230 script.
231
232 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
233
234 * doc/schema/oracle-spatial.sql: Added schema floodplain.
235
236 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
237
238 * doc/schema/oracle-spatial.sql: Added schema hws.
239
240 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
241
242 * doc/schema/oracle-spatial.sql: Added schema cross_section_tracks.
243
244 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
245
246 * doc/schema/oracle-spatial.sql: Added schema river_axes.
247
248 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
249
250 * doc/schema/oracle-spatial.sql: Added schema fixpoints.
251
252 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
253
254 * doc/schema/oracle-spatial.sql: Added schema buildings.
255
256 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
257
258 * doc/schema/oracle-spatial.sql: Fixed table river_axes_km.
259
260 2011-09-13 Bjoern Schilberg <bjoern@intevation.de>
261
262 * doc/schema/oracle-spatial.sql: Added initial oracle schemas.
263
264 2011-09-12 Bjoern Schilberg <bjoern@intevation.de>
265
266 * doc/schema/postgresql-spatial.sql: Added initial schemas for
267 Hydrologie/Einzugsgebiete, Hydrologie/HW-Schutzanlagen, Hydrologie/Hydr.
268 Grenzen/Linien, BfG/hauptoeff_*.shp, BfG/MNQ-*.shp,
269 BfG/modellgrenze*.shp, BfG/uferlinie.shp, BfG/vorland_*.shp,
270 Hydrologie/Streckendaten, Hydrologie/UeSG/Berechnung,
271 Hydrologie/UeSG/Messung
272
273 2011-09-02 Ingo Weinzierl <ingo@intevation.de>
274
275 * doc/schema/postgresql-spatial.sql: Removed SERIALs from schema.
276 Auto-Increment is realized through SERIALs now.
277
278 * src/main/java/de/intevation/flys/model/DGM.java: The table for dem has
279 been renamed to 'dem' (before 'dgm').
280
281 2011-09-01 Hans Plum <hans@intevation.de>
282
283 * doc/schema/postgresql-spatial.sql:
284 Hint for unifying table names: dgm -> dem
285
286 2011-09-01 Hans Plum <hans@intevation.de>
287
288 * doc/schema/postgresql-spatial.sql:
289 Added mappings to existing data in file system (based on
290 river Saar); added TODOs for missing tables/mappings
291
292 2011-08-31 Ingo Weinzierl <ingo@intevation.de>
293
294 * doc/schema/postgresql-spatial.sql: New relation for floodplains (german
295 "Talaue").
296
297 * src/main/java/de/intevation/flys/model/Floodplain.java: New. Model class
298 that represents a floodplain.
299
300 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
301 Registered the Floodplain mapping.
302
303 2011-08-31 Ingo Weinzierl <ingo@intevation.de>
304
305 * doc/schema/postgresql-spatial.sql: Added a relation for DGMs. Note, that
306 no data of the DGM is stored in this relation, but only the file path to
307 the DGM file.
308
309 * src/main/java/de/intevation/flys/model/DGM.java: New. This class provides
310 information for a DGM (km range and file path).
311
312 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
313 Registered the DGM.
314
315 2011-08-30 Ingo Weinzierl <ingo@intevation.de>
316
317 * src/main/java/de/intevation/flys/model/CrossSectionTrack.java: New
318 static function to retrieve all CrossSectionTracks of a specific river.
319
320 2011-08-25 Ingo Weinzierl <ingo@intevation.de>
321
322 * src/main/java/de/intevation/flys/utils/FileTools.java: Moved to
323 artifacts-common module.
324
325 * src/main/java/de/intevation/flys/importer/parsers/PegelGltParser.java,
326 src/main/java/de/intevation/flys/importer/parsers/PRFParser.java,
327 src/main/java/de/intevation/flys/importer/parsers/HYKParser.java,
328 src/main/java/de/intevation/flys/importer/parsers/AnnotationsParser.java,
329 src/main/java/de/intevation/flys/importer/parsers/InfoGewParser.java,
330 src/main/java/de/intevation/flys/importer/ImportRiver.java,
331 src/main/java/de/intevation/flys/importer/ImportGauge.java: Adjusted
332 imports of FileTools.
333
334 2011-08-25 Felix Wolfsteller <felix.wolfsteller@intevation.de>
335
336 * src/main/java/de/intevation/flys/model/Gauge.java (getMainValues)
337 (setMainValues):
338 New method and mapping to get/set MainValues of a Gauge. Essentially
339 developed by Sascha L. Teichmann.
340
341 2011-08-22 Ingo Weinzierl <ingo@intevation.de>
342
343 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
344 Reverted the default db dialect to PostgreSQL - this has been changed to
345 PostGIS by accident.
346 Configure the dialect "org.hibernatespatial.postgis.PostgisDialect" to
347 use the PostGIS stuff.
348
349 2011-08-22 Ingo Weinzierl <ingo@intevation.de>
350
351 * src/main/java/de/intevation/flys/model/RiverAxis.java: Added a function
352 that returns the RiverAxis for a given River.
353
354 * src/main/java/de/intevation/flys/backend/SpatialInfo.java: Use the new
355 function of RiverAxis to retrieve the RiverAxis.
356
357 2011-08-18 Ingo Weinzierl <ingo@intevation.de>
358
359 * doc/schema/postgresql-spatial.sql: The PostGIS database schema for
360 FLYS spatial data.
361
362 * src/main/java/de/intevation/flys/model/CrossSectionTrack.java,
363 src/main/java/de/intevation/flys/model/RiverAxis.java,
364 src/main/java/de/intevation/flys/model/Line.java,
365 src/main/java/de/intevation/flys/model/Building.java,
366 src/main/java/de/intevation/flys/model/Fixpoint.java: Model classes that
367 represent FLYS spatial data.
368
369 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
370 Registered model classes.
371
372 * pom.xml: Added dependencies to HibernateSpatial and PostGIS.
373
374 * src/main/java/de/intevation/flys/backend/SpatialInfo.java,
375 contrib/spatial-info.sh: A small demo application that prints out some
376 information about spatial data of specific rivers. Modify the system
377 property -Dflys.backend.spatial.river to get information of a river of
378 your choice.
379
380 2011-07-31 Sascha L. Teichmann <sascha.teichmann@intevation.de>
381
382 Re-enabled Hibernate schema dumps.
383
384 * src/main/java/de/intevation/flys/App.java: Removed old code
385 and use new SessionFactoryProvider infrastructure.
386
387 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
388 Added methods to create db configurations without opening them.
389 Useful for introspection only purposes.
390
391 2011-07-31 Sascha L. Teichmann <sascha.teichmann@intevation.de>
392
393 * pom.xml: Bumped Apache DBCP up to 1.4 to use the same version
394 as artifact database.
395
396 2011-07-28 Sascha L. Teichmann <sascha.teichmann@intevation.de>
397
398 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
399 Make use of the LRU cache from artifacts common.
400
401 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
402
403 * doc/schema/postgresql.sql: Added missing foreign key contraint on hyks table.
404 To update existing databases:
405
406 ALTER TABLE hyks ADD CONSTRAINT hyks_river_id_fkey FOREIGN KEY (river_id) REFERENCES rivers(id);
407
408 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
409
410 * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java:
411 Check if zone coordinates in HYKs are swapped and warn the user.
412
413 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
414
415 * src/main/java/de/intevation/flys/model/HYK.java
416 src/main/java/de/intevation/flys/importer/parsers/HYKParser.java,
417 src/main/java/de/intevation/flys/importer/ImportHYKFormation.java,
418 src/main/java/de/intevation/flys/importer/ImportHYKEntry.java,
419 src/main/java/de/intevation/flys/importer/ImportHYK.java:
420 Various small fixes and some extra logging.
421
422 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
423
424 * src/main/java/de/intevation/flys/importer/Config.java: New.
425 Central singleton to configure the Importer.
426 Uses system properties by now:
427
428 flys.backend.importer.dry.run: boolean
429 default false. true: don't write to database.
430
431 flys.backend.importer.annotation.types: String
432 default unset. Filename of annotation type classifications.
433
434 flys.backend.importer.skip.gauges: boolean
435 default: false. true: don't parse/store *.glt, *.sta files
436
437 flys.backend.importer.skip.annotations: boolean
438 default: false. true: don't parse/store *.km files
439
440 flys.backend.importer.skip.prfs: boolean
441 default: false. true: don't parse/store *.prf files
442
443 flys.backend.importer.skip.hyks: boolean
444 default: false. true: don't parse/store *.hyk files
445
446 flys.backend.importer.skip.wst: boolean
447 default: false. true: don't parse/store river wst files
448
449 flys.backend.importer.skip.extra.wsts: boolean
450 default: false. true: don't parse/store extra *.zus, *.wst files
451
452 flys.backend.importer.skip.fixations: boolean
453 default: false. true: don't parse/store fixation *.wst files
454
455 flys.backend.importer.skip.official.lines: boolean
456 default: false. true: don't parse/store 'amtliche Linien' *.wst files
457
458 flys.backend.importer.skip.flood.water: boolean
459 default: false. true: don't parse/store 'HW-Marken' *.wst files
460
461 flys.backend.importer.skip.flood.protection: boolean
462 default: false. true: don't parse/store 'HW-Schutzanlagen' *.wst files
463
464 2011-07-18 Ingo Weinzierl <ingo@intevation.de>
465
466 * src/main/java/de/intevation/flys/model/HYKEntry.java: Fixed OrderBy
467 clause.
468
469 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
470
471 * src/main/java/de/intevation/flys/importer/ImportHYKFormation.java,
472 src/main/java/de/intevation/flys/importer/ImportHYKFlowZone.java,
473 src/main/java/de/intevation/flys/importer/ImportHYKEntry.java,
474 src/main/java/de/intevation/flys/importer/ImportRiver.java,
475 src/main/java/de/intevation/flys/importer/ImportHYK.java:
476 Store HYK data structures to database. Needs testing.
477
478 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
479
480 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
481 Parse the HYKs from the importer. TODO: Store them in database.
482
483 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
484
485 * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java:
486 Create data structures while parsing.
487
488 * src/main/java/de/intevation/flys/importer/ImportHYKFormation.java,
489 src/main/java/de/intevation/flys/importer/ImportHYK.java: Added
490 getters/setters to ease model wiring.
491
492 2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
493
494 * src/main/java/de/intevation/flys/importer/ImportHYKFormation.java,
495 src/main/java/de/intevation/flys/importer/ImportHYKFlowZone.java,
496 src/main/java/de/intevation/flys/importer/ImportHYKEntry.java,
497 src/main/java/de/intevation/flys/importer/ImportHYK.java: New.
498 Importer models for HYKs.
499
500 2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
501
502 * doc/schema/postgresql.sql: Each entry in a HYK can have
503 an optional 'Peilungsjahr' (measure) not only the whole HYK.
504 To update existing databases:
505 BEGIN;
506 ALTER TABLE hyks DROP COLUMN measure;
507 ALTER TABLE hyk_entries ADD COLUMN measure TIMESTAMP;
508 COMMIT;
509
510 * src/main/java/de/intevation/flys/model/HYKEntry.java,
511 src/main/java/de/intevation/flys/model/HYK.java:
512 Adjusted Hibernate models.
513
514 2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
515
516 * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java:
517 Added callback mechanism and recursive file search like in the PRF parser.
518 All BfG-HYK files seem to parse correctly now. TODO: Build the data structures.
519
520 * src/main/java/de/intevation/flys/importer/parsers/PRFParser.java:
521 Added x.canRead() before accepting files for parsing.
522
523 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
524
525 * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java:
526 Initial version of the HYK parser. Not ready, yet.
527
528 * src/main/java/de/intevation/flys/importer/ImportHYKFlowZoneType.java:
529 Importer model for HYK flow zone types.
530
531 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
532
533 * doc/schema/postgresql.sql: Argh! Added distance_{vl|hf|vr} to
534 wrong table.
535 To update existing databases:
536 BEGIN;
537 ALTER TABLE hyk_entries DROP COLUMN distance_vl;
538 ALTER TABLE hyk_entries DROP COLUMN distance_hf;
539 ALTER TABLE hyk_entries DROP COLUMN distance_vr;
540 ALTER TABLE hyk_formations ADD COLUMN distance_vl NUMERIC NOT NULL;
541 ALTER TABLE hyk_formations ADD COLUMN distance_hf NUMERIC NOT NULL;
542 ALTER TABLE hyk_formations ADD COLUMN distance_vr NUMERIC NOT NULL;
543 COMMIT;
544
545 * src/main/java/de/intevation/flys/model/HYKFormation.java,
546 src/main/java/de/intevation/flys/model/HYKEntry.java:
547 Adjusted Hibernate models.
548
549 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
550
551 * src/main/java/de/intevation/flys/utils/FileTools.java: Added method
552 walkTree() to traverse a directory tree. To be reused in HYK parser.
553
554 * src/main/java/de/intevation/flys/importer/parsers/PRFParser.java:
555 Uses the FileTools.walkTree() method now to find all PRF file.
556
557 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
558
559 * doc/schema/postgresql.sql: Added missing columns.
560 To update existing databases:
561 BEGIN;
562 ALTER TABLE hyks ADD COLUMN measure TIMESTAMP;
563 ALTER TABLE hyk_entries ADD COLUMN distance_vl NUMERIC NOT NULL;
564 ALTER TABLE hyk_entries ADD COLUMN distance_hf NUMERIC NOT NULL;
565 ALTER TABLE hyk_entries ADD COLUMN distance_vr NUMERIC NOT NULL;
566 COMMIT;
567
568 * src/main/java/de/intevation/flys/model/HYKEntry.java,
569 src/main/java/de/intevation/flys/model/HYK.java:
570 Adjusted Hibernate models.
571
572 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
573
574 * src/main/java/de/intevation/flys/importer/parsers/*.java:
575 New package. Moved the file parsers (*.gew, *.sta, *.at, *.glt, *.prf, *.km, *.wst)
576 into this package.
577
578 * src/main/java/de/intevation/flys/importer/*.java: Adjusted the imports.
579
580 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
581
582 * src/main/java/de/intevation/flys/model/HYKFormation.java,
583 src/main/java/de/intevation/flys/model/HYKEntry.java,
584 src/main/java/de/intevation/flys/model/HYKFlowZone.java,
585 src/main/java/de/intevation/flys/model/HYKFlowZoneType.java,
586 src/main/java/de/intevation/flys/model/HYK.java: New. The hibernate models
587 for the HYK structures.
588
589 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
590 Registered new models.
591
592 * src/main/java/de/intevation/flys/model/CrossSection.java: Added
593 'order by' annotation for fetching the cross section lines.
594
595 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
596
597 * doc/schema/postgresql.sql: Added structures for HYKs "Hydraulische Kenngroessen"
598 To update existing databases:
599
600 BEGIN;
601 CREATE SEQUENCE HYKS_ID_SEQ;
602 CREATE TABLE hyks (
603 id int PRIMARY KEY NOT NULL,
604 river_id int NOT NULL,
605 description VARCHAR(256) NOT NULL
606 );
607
608 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ;
609 CREATE TABLE hyk_entries (
610 id int PRIMARY KEY NOT NULL,
611 hyk_id int NOT NULL REFERENCES hyks(id),
612 km NUMERIC NOT NULL,
613 UNIQUE (hyk_id, km)
614 );
615
616 CREATE SEQUENCE HYK_FORMATIONS_ID_SEQ;
617 CREATE TABLE hyk_formations (
618 id int PRIMARY KEY NOT NULL,
619 formation_num int NOT NULL DEFAULT 0,
620 hyk_entry_id int NOT NULL REFERENCES hyk_entries(id),
621 top NUMERIC NOT NULL,
622 bottom NUMERIC NOT NULL,
623 UNIQUE (hyk_entry_id, formation_num)
624 );
625
626 CREATE SEQUENCE HYK_FLOW_ZONE_TYPES_ID_SEQ;
627 CREATE TABLE hyk_flow_zone_types (
628 id int PRIMARY KEY NOT NULL,
629 name VARCHAR(50) NOT NULL UNIQUE,
630 description VARCHAR(256)
631 );
632
633 CREATE SEQUENCE HYK_FLOW_ZONES_ID_SEQ;
634 CREATE TABLE hyk_flow_zones (
635 id int PRIMARY KEY NOT NULL,
636 formation_id int NOT NULL REFERENCES hyk_formations(id),
637 type_id int NOT NULL REFERENCES hyk_flow_zone_types(id),
638 a NUMERIC NOT NULL,
639 b NUMERIC NOT NULL,
640 CHECK (a <= b)
641 );
642 COMMIT;
643
644 2011-07-13 Sascha L. Teichmann <sascha.teichmann@intevation.de>
645
646 * pom.xml: Bumped Hibernate up to 3.6.5.
647
648 2011-07-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
649
650 * src/main/java/de/intevation/flys/utils/FileTools.java: Argh!
651 Forget to call the file hashing so only the file lengths were
652 compared.
653
654 2011-07-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
655
656 * src/main/java/de/intevation/flys/utils/FileTools.java:
657 Added a class HashedFile to compare files by there length
658 and a message digest. Digest can be set with system property
659 "flys.backend.file.cmp.digest" and defaults to MD5. Useful to
660 detect file duplicates.
661
662 * src/main/java/de/intevation/flys/importer/PRFParser.java: Added
663 method prfAccept(File) to callback to check if a found PRF file
664 should be parsed. Useful to prevent parsing file duplicates.
665
666 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
667 Use the HashedFile and the PRFParser.Callback to prevent
668 parsing of PRF duplicates.
669
670 2011-07-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
671
672 * doc/schema/postgresql.sql: Misspelled sequence.
673 To update existing databases:
674
675 DROP SEQUENCE CROSS_SECTION_LINES_SEQ;
676 CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
677
678 * src/main/java/de/intevation/flys/importer/ImportCrossSection.java:
679 Added some logging because importing is slow.
680
681 * src/main/java/de/intevation/flys/importer/ImportCrossSectionLine.java:
682 Prevent NPE if a cross section line from db has no points.
683
684 2011-07-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
685
686 Parse all PRFs in all subfolders of a river and store them
687 as cross sections into the database. Needs testing!
688
689 * src/main/java/de/intevation/flys/importer/ImportCrossSection.java,
690 src/main/java/de/intevation/flys/importer/ImportCrossSectionLine.java:
691 New. Importer models for cross sections.
692
693 * src/main/java/de/intevation/flys/importer/XY.java:
694 New. Made top level class from inner PRFParser.XY.
695
696 * src/main/java/de/intevation/flys/importer/PRFParser.java:
697 Moved out XY class. Renamed callback.
698
699 * src/main/java/de/intevation/flys/model/CrossSection.java,
700 src/main/java/de/intevation/flys/model/CrossSectionLine.java,
701 src/main/java/de/intevation/flys/model/CrossSectionPoint.java,
702 src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
703 Added convinience constructors.
704
705 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
706 Parse and store cross sections into database.
707
708 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
709
710 * doc/schema/postgresql.sql: Introduced a new table cross_section_line
711 holding the km of a set of points.
712
713 * src/main/java/de/intevation/flys/model/CrossSectionLine.java:
714 New. Model for a single line of a "Querprofil".
715
716 * src/main/java/de/intevation/flys/model/CrossSection.java: Removed
717 'km' and 'points' they are part of the line now.
718
719 * src/main/java/de/intevation/flys/model/CrossSectionPoint.java:
720 They reference to the containing line now.
721
722 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
723 Registered new model.
724
725 To update existing databases:
726 BEGIN;
727 DROP SEQUENCE CROSS_SECTIONS_ID_SEQ;
728 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
729 DROP TABLE cross_section_points;
730 DROP TABLE cross_sections;
731 CREATE SEQUENCE CROSS_SECTIONS_ID_SEQ;
732 CREATE TABLE cross_sections (
733 id int PRIMARY KEY NOT NULL,
734 river_id int NOT NULL REFERENCES rivers(id),
735 time_interval_id int REFERENCES time_intervals(id),
736 description VARCHAR(256)
737 );
738 CREATE SEQUENCE CROSS_SECTION_LINES_SEQ;
739 CREATE TABLE cross_section_lines (
740 id int PRIMARY KEY NOT NULL,
741 km NUMERIC NOT NULL,
742 cross_section_id int NOT NULL REFERENCES cross_sections(id),
743 UNIQUE (km, cross_section_id)
744 );
745 CREATE SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
746 CREATE TABLE cross_section_points (
747 id int PRIMARY KEY NOT NULL,
748 cross_section_line_id int NOT NULL REFERENCES cross_section_lines(id),
749 col_pos int NOT NULL,
750 x NUMERIC NOT NULL,
751 y NUMERIC NOT NULL,
752 UNIQUE (cross_section_line_id, col_pos)
753 );
754 COMMIT;
755
756 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
757
758 * doc/schema/postgresql.sql: Dropped constraint that enforces the
759 uniqueness of km and river. This is violated because there are
760 more than one sounding in different year at the same km of a river.
761 Added column 'description' to the cross section table to make it
762 human readable.
763
764 To update existing databases:
765
766 ALTER TABLE cross_sections DROP CONSTRAINT cross_sections_km_key;
767 ALTER TABLE cross_sections ADD COLUMN description VARCHAR(256);
768
769 * src/main/java/de/intevation/flys/model/CrossSection.java:
770 Added the description column to the Hibernate model.
771
772 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
773
774 * doc/schema/postgresql.sql: Dropped constraint that enforces the
775 uniqueness of x in a "Querprofil-Spur". There are vertical lines
776 in the soundings so this constraint is violated.
777
778 To update existing databases:
779
780 ALTER TABLE cross_section_points DROP CONSTRAINT cross_section_points_cross_section_id_key2;
781
782 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
783
784 * src/main/java/de/intevation/flys/importer/PRFParser.java:
785 Added a callback to be called from parsePRFs() if
786 a PRF was parsed successfully. Useful to scan whole
787 sub directories for PRF files.
788
789 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
790
791 * src/main/java/de/intevation/flys/importer/PRFParser.java:
792 Extract the year of sounding from file names. If not found
793 from the name of th containing directory. Description is made
794 of file name and parent directory file name.
795
796 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
797
798 * src/main/java/de/intevation/flys/importer/PRFParser.java:
799 Extracted the data. All BfG PRFs are parsed correctly, now.
800
801 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
802
803 * src/main/java/de/intevation/flys/importer/PRFParser.java:
804 Extract km from lines. TODO: extract data.
805
806 2011-07-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
807
808 * src/main/java/de/intevation/flys/importer/PRFParser.java: New.
809 Parser for PRF files. TODO extra data and station from data lines.
810
811 2011-07-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
812
813 * src/main/java/de/intevation/flys/model/Point3d.java: Deleted.
814 Not needed (braindead).
815
816 * src/main/java/de/intevation/flys/model/CrossSectionPoint.java:
817 Directly store the x/y values now.
818
819 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
820 Removed registration of Point3d.
821
822 To update existing databases:
823
824 BEGIN;
825 ALTER TABLE cross_section_points DROP COLUMN point3d_id;
826 DROP SEQUENCE POINTS3D_ID_SEQ;
827 DROP TABLE points3d;
828 ALTER TABLE cross_section_points ADD COLUMN x NUMERIC NOT NULL;
829 ALTER TABLE cross_section_points ADD COLUMN y NUMERIC NOT NULL;
830 ALTER TABLE cross_section_points ADD CONSTRAINT
831 cross_section_points_cross_section_id_key2 UNIQUE (cross_section_id, x);
832 COMMIT;
833
834 2011-07-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
835
836 * src/main/java/de/intevation/flys/model/CrossSection.java,
837 src/main/java/de/intevation/flys/model/CrossSectionPoint.java:
838 New. Hibernate models for cross-sections and their forming points.
839
840 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
841 Registered the new models.
842
843 2011-07-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
844
845 * src/main/java/de/intevation/flys/model/Point3d.java: New. point3d model
846 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
847 Registered point3d model.
848
849 2011-07-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
850
851 * doc/schema/postgresql.sql: Add relations for cross sections.
852 To update existing databases:
853 BEGIN;
854
855 CREATE SEQUENCE CROSS_SECTIONS_ID_SEQ;
856 CREATE TABLE cross_sections (
857 id int PRIMARY KEY NOT NULL,
858 km NUMERIC NOT NULL,
859 river_id int NOT NULL REFERENCES rivers(id),
860 time_interval_id int REFERENCES time_intervals(id),
861 UNIQUE (km, river_id)
862 );
863
864 CREATE SEQUENCE POINTS3D_ID_SEQ;
865 CREATE TABLE points3d (
866 id int PRIMARY KEY NOT NULL,
867 x NUMERIC NOT NULL,
868 y NUMERIC NOT NULL,
869 z NUMERIC NOT NULL
870 );
871
872 CREATE SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
873 CREATE TABLE cross_section_points (
874 id int PRIMARY KEY NOT NULL,
875 cross_section_id int NOT NULL REFERENCES cross_sections(id),
876 point3d_id int NOT NULL REFERENCES points3d(id),
877 col_pos int NOT NULL,
878 UNIQUE (cross_section_id, point3d_id, col_pos),
879 UNIQUE (cross_section_id, col_pos)
880 );
881
882 COMMIT;
883
884 2011-06-28 Ingo Weinzierl <ingo@intevation.de>
885
886 Tagged RELEASE 2.4
887
888 2011-06-27 Ingo Weinzierl <ingo@intevation.de>
889
890 * Changes: Prepared changes for the upcoming release.
891
892 2011-06-26 Sascha L. Teichmann <sascha.teichmann@intevation.de>
893
894 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java,
895 src/main/java/de/intevation/flys/importer/AnnotationClassifier.java,
896 src/main/java/de/intevation/flys/importer/AtFileParser.java,
897 src/main/java/de/intevation/flys/importer/ValueKey.java,
898 src/main/java/de/intevation/flys/importer/WstParser.java:
899 Removed trailing whitespace.
900
901 2011-06-26 Sascha L. Teichmann <sascha.teichmann@intevation.de>
902
903 * src/main/java/de/intevation/flys/importer/AnnotationClassifier.java:
904 Removed superfluous imports.
905
906 2011-06-26 Sascha L. Teichmann <sascha.teichmann@intevation.de>
907
908 * src/main/java/de/intevation/flys/model/River.java:
909 Added a method maxOverlap to determine the gauge which has
910 the max common length to a given interval. This is for
911 numerical stability in slightly overlapping gauge ranges.
912
913 2011-06-26 Sascha L. Teichmann <sascha.teichmann@intevation.de>
914
915 * src/main/java/de/intevation/flys/model/River.java: When
916 looking up a gauge by km containment use precision of 1e-6.
917
918 2011-06-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
919
920 * src/main/java/de/intevation/flys/model/River.java:
921 Added method to find gauge by its name.
922
923 2011-06-19 Sascha L. Teichmann <sascha.teichmann@intevation.de>
924
925 * doc/annotation-types.xml: Fixed some rules.
926
927 * src/main/java/de/intevation/flys/importer/Importer.java,
928 src/main/java/de/intevation/flys/importer/InfoGewParser.java,
929 src/main/java/de/intevation/flys/importer/ImportRiver.java:
930 Call the right constructors now.
931
932 * src/main/java/de/intevation/flys/importer/ImportAnnotationType.java:
933 Added getter/setter for name property.
934
935 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java:
936 Print duplicated at WARN level not as DEBUG.
937
938 * src/main/java/de/intevation/flys/importer/AnnotationClassifier.java:
939 Fixed XPath expression to build the internal lookup structures
940 correctly.
941
942 2011-06-19 Sascha L. Teichmann <sascha.teichmann@intevation.de>
943
944 Added classification of annotation types. Needs testing!
945
946 * doc/annotation-types.xml: New. Rules to classify the different
947 types of annotations. The classification works like this:
948
949 There are unique types like 'Bruecke', 'Pegel' and so on.
950 They are defined in the /annotation/type section and
951 identified by their name. One of the types can be set
952 as the default type if no rule applies.
953
954 In the /annotation/pattern section are two types of pattern.
955
956 1 - file pattern: If a KM file is opened its filename is
957 matched against the regular expressions of these
958 patterns. If a match is found the corresponding type
959 is used as the default type in the open file.
960 If no match is found the global default type is used
961 as the default type.
962
963 2 - line patterns: For each line of an open KM file these
964 patterns are applied to find a match. If a match is
965 found the corresponding type is used as the type of
966 the annotation. If no match is found the default
967 file default is assumed to be the right type. For
968 the file default see 1.
969
970 * src/main/java/de/intevation/flys/importer/Importer.java:
971 To activate the annotation type classification set
972 the system property
973
974 'flys.backend.importer.annotation.types'
975
976 to the path of a XML looking like the annotation-types.xml
977 file. If the system property is not set no classification
978 is done.
979
980 * src/main/java/de/intevation/flys/importer/AnnotationClassifier.java:
981 New. Implements the classification.
982
983 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java,
984 src/main/java/de/intevation/flys/importer/InfoGewParser.java,
985 src/main/java/de/intevation/flys/importer/ImportRiver.java:
986 Looped through the annotation type classification.
987
988 2011-06-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
989
990 * src/main/java/de/intevation/flys/model/River.java:
991 Added method to find gauge by a position lying in its range.
992
993 2011-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
994
995 First part of flys/issue18
996
997 * doc/schema/postgresql.sql: Add new table 'annotation_types'.
998 To update existing databases:
999 BEGIN;
1000 CREATE SEQUENCE ANNOTATION_TYPES_ID_SEQ;
1001 CREATE TABLE annotation_types (
1002 id int PRIMARY KEY NOT NULL,
1003 name VARCHAR(256) NOT NULL UNIQUE
1004 );
1005 ALTER TABLE annotations ADD COLUMN type_id int REFERENCES annotation_types(id);
1006 COMMIT;
1007
1008 * doc/schema/postgresql-cleanup.sql: Removed. Hopeless out-dated.
1009
1010 * src/main/java/de/intevation/flys/model/AnnotationType.java:
1011 New. Hibernate model to access the type.
1012
1013 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1014 Register the new backend type.
1015
1016 * src/main/java/de/intevation/flys/model/Annotation.java:
1017 References the annotation type.
1018
1019 * src/main/java/de/intevation/flys/importer/ImportAnnotationType.java:
1020 New. Model to help import the annotation type.
1021
1022 * src/main/java/de/intevation/flys/importer/ImportAnnotation.java:
1023 Uses the import type.
1024
1025 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java:
1026 Set the annotation type to 'null'. TODO: Do the classification!
1027
1028 2011-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1029
1030 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
1031 Fix for flys/issue110. start index was shifted by one.
1032
1033 2011-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1034
1035 * src/main/java/de/intevation/flys/importer/ImportAnnotation.java:
1036 Forgot to store reference to edge.
1037
1038 2011-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1039
1040 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1041 Register backend model.
1042
1043 * src/main/java/de/intevation/flys/importer/ImportEdge.java: New. Model
1044 for importing the edges.
1045
1046 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java:
1047 Parses the edges of an annotation, too.
1048
1049 2011-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1050
1051 * doc/schema/postgresql.sql: Added table edges to model 'Kanten' of an annotation.
1052 To update existing databases:
1053 BEGIN;
1054 CREATE SEQUENCE EDGES_ID_SEQ;
1055 CREATE TABLE edges (
1056 id int PRIMARY KEY NOT NULL,
1057 top NUMERIC,
1058 bottom NUMERIC);
1059 ALTER TABLE annotations ADD COLUMN edge_id int REFERENCES edges(id);
1060 COMMIT;
1061
1062 * src/main/java/de/intevation/flys/model/Edge.java: New. A 'Kanten'-Model.
1063 * src/main/java/de/intevation/flys/model/Annotation.java: References the
1064 edges.
1065
1066 2011-06-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1067
1068 * src/main/java/de/intevation/flys/model/River.java:
1069 Added method to find gauge only by station position.
1070
1071 2011-05-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1072
1073 * src/main/java/de/intevation/flys/model/River.java:
1074 Make search for gauges independent of from/to order.
1075
1076 2011-05-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1077
1078 * doc/schema/postgresql.sql: Added a new view to select qs of a WST.
1079 To update existing databases:
1080
1081 CREATE VIEW wst_q_values AS
1082 SELECT wc.position AS column_pos,
1083 wqr.q AS q,
1084 r.a AS a,
1085 r.b AS b,
1086 wc.wst_id AS wst_id
1087 FROM wst_column_q_ranges wcqr
1088 JOIN wst_q_ranges wqr ON wcqr.wst_q_range_id = wqr.id
1089 JOIN ranges r ON wqr.range_id = r.id
1090 JOIN wst_columns wc ON wcqr.wst_column_id = wc.id
1091 ORDER BY wc.position, wcqr.wst_column_id, r.a;
1092
1093 2011-05-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1094
1095 * doc/schema/postgresql.sql: Added a new view to select ws of a WST.
1096 To update existing databases:
1097
1098 CREATE VIEW wst_w_values AS
1099 SELECT wcv."position" AS km,
1100 wcv.w AS w,
1101 wc."position" AS column_pos,
1102 w.id AS wst_id
1103 FROM wst_column_values wcv
1104 JOIN wst_columns wc ON wcv.wst_column_id = wc.id
1105 JOIN wsts w ON wc.wst_id = w.id
1106 ORDER BY wcv."position", wc."position";
1107
1108 2011-05-23 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1109
1110 flys/issue76
1111
1112 * src/main/java/de/intevation/flys/importer/WstParser.java:
1113 Close gaps between q ranges.
1114
1115 2011-05-20 Ingo Weinzierl <ingo@intevation.de>
1116
1117 Tagged RELEASE 2.3.1
1118
1119 2011-05-13 Ingo Weinzierl <ingo@intevation.de>
1120
1121 Tagged RELEASE 2.3
1122
1123 2011-05-13 Ingo Weinzierl <ingo@intevation.de>
1124
1125 * Changes: Changes for release 2.3 - see Changes file to get to know about
1126 the version numbers of this software.
1127
1128 2011-05-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1129
1130 * doc/schema/postgresql.sql: Added a column which tells
1131 if a river counts its km up or downwards.
1132 To update existing databases:
1133
1134 ALTER TABLE rivers ADD COLUMN km_up BOOLEAN NOT NULL DEFAULT true;
1135
1136 * src/main/java/de/intevation/flys/model/River.java:
1137 Adjust Hibernate mapping of new column.
1138
1139 2011-05-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1140
1141 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
1142 Fixed flys/issue11 and flys51.
1143
1144 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1145
1146 * src/main/java/de/intevation/flys/importer/ValueKey.java:
1147 Add some unsharp comparison (eps = 1e-6) to avoid
1148 numerical problems.
1149
1150 * src/main/java/de/intevation/flys/importer/IdValueKey.java:
1151 Removed. Not need any longer.
1152
1153 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
1154 Use unsharp lookup.
1155
1156 * src/main/java/de/intevation/flys/importer/ImportWst.java,
1157 src/main/java/de/intevation/flys/importer/ImportRiver.java:
1158 Flush more often. Hopefully this reduces hibernate sync
1159 problems?!
1160
1161 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1162
1163 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
1164 Fixed silly bug. Set flush mode back to auto because
1165 manual flushing causes some undetermined problems.
1166
1167 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1168
1169 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
1170 Do not load _all_ values from discharge tables and
1171 wst columns. This is extremly slow and will lead
1172 to OOM if more rivers are imported. Now only the
1173 last 20 columns und discharge tables are cached.
1174
1175 * src/main/java/de/intevation/flys/importer/ValueKey.java:
1176 New. Key for caching discharge table values and wst
1177 column values.
1178
1179 * src/main/java/de/intevation/flys/importer/IdValueKey.java:
1180 Fixed bug in equals().
1181
1182 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
1183 Removed too eloquent debug output.
1184
1185 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1186
1187 * src/main/java/de/intevation/flys/importer/IdValueKey.java:
1188 Use BigDecimals as representation for the numeric components
1189 which prevents running into unique constraint problems
1190 caused by imprecision.
1191
1192 * src/main/java/de/intevation/flys/importer/ImportRange.java,
1193 src/main/java/de/intevation/flys/importer/ImporterSession.java:
1194 Ranges are now cached globally, too.
1195
1196 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
1197 Improved logging.
1198
1199 * src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java:
1200 Removed superfluous imports.
1201
1202 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1203
1204 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
1205 Only accept main value types 'Q', 'W', 'D' and 'T' by default.
1206 '-' is not handled any more because it causes too much constraint
1207 problems. You can overwrite the imported type with the
1208 system property flys.backend.main.value.types" (default "QWTD")
1209
1210 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
1211 Set session flush mode to manual. Hopefully this improves the
1212 performance a bit.
1213
1214 * src/main/java/de/intevation/flys/importer/ImportWst.java,
1215 src/main/java/de/intevation/flys/importer/ImportGauge.java,
1216 src/main/java/de/intevation/flys/importer/ImportWstColumn.java,
1217 src/main/java/de/intevation/flys/importer/ImportRange.java,
1218 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
1219 Improved logging.
1220
1221 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1222
1223 * src/main/java/de/intevation/flys/importer/WstColumnValueKey.java: Deleted
1224 * src/main/java/de/intevation/flys/importer/IdValueKey.java: Reinserted
1225 here in a more generalized form.
1226
1227 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
1228 Cache the discharge table value, too.
1229
1230 * src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java:
1231 Use the global cache.
1232
1233 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1234
1235 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
1236 New. Centralized caching in the thread local context. Importing
1237 the Elbe leads to OOM because the column values of the
1238 WST files where loaded separately for every file.
1239
1240 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
1241 src/main/java/de/intevation/flys/importer/Importer.java,
1242 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
1243 src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
1244 src/main/java/de/intevation/flys/importer/ImportWst.java,
1245 src/main/java/de/intevation/flys/importer/ImportMainValue.java,
1246 src/main/java/de/intevation/flys/importer/ImportMainValueType.java,
1247 src/main/java/de/intevation/flys/importer/ImportNamedMainValue.java,
1248 src/main/java/de/intevation/flys/importer/ImportRiver.java,
1249 src/main/java/de/intevation/flys/importer/ImportGauge.java,
1250 src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java,
1251 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
1252 src/main/java/de/intevation/flys/importer/ImportWstColumn.java,
1253 src/main/java/de/intevation/flys/importer/ImportRange.java,
1254 src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java,
1255 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java,
1256 src/main/java/de/intevation/flys/importer/ImportAttribute.java,
1257 src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
1258 Adjusted to use the new global context.
1259
1260 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1261
1262 * doc/schema/postgresql.sql: Dropped constraint which
1263 forces discharge tables to have a unique time interval
1264 for a given gauge and kind.
1265
1266 There are AT files (historical Mosel/Perl/Perl/1967-1981.at
1267 and Mosel/Perl/1967-1981-1.at) which violate this
1268 constraint. Its a technical question to the customer
1269 how to handle these cases.
1270
1271 To adjust existing databases:
1272
1273 ALTER TABLE discharge_tables DROP CONSTRAINT discharge_tables_gauge_id_key;
1274
1275 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1276
1277 * src/main/java/de/intevation/flys/importer/WstParser.java:
1278 There are wst files where column names are not unique.
1279 Make them unique by appending (1), (2) and so on.
1280
1281 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1282
1283 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1284 Import the "HW-Schutzanlagen", too.
1285
1286 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1287
1288 Make import of historical discharge tables work.
1289
1290 * doc/schema/postgresql.sql: Added forgotten column 'description'.
1291
1292 !!! You have to drop your database !!!
1293
1294 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
1295 src/main/java/de/intevation/flys/model/DischargeTable.java:
1296 Add the forgotten description property.
1297
1298 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
1299 Fixed problems with date recognition.
1300
1301 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
1302 Prefix the description of the historical discharge tables
1303 with "Histor.Abflusstafeln".
1304
1305 * src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
1306 Fixed silly programming error.
1307
1308 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1309
1310 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
1311 Inject 'kind' attribute.
1312
1313 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
1314 Traverse the "Histor.Abflusstafeln" for the historical
1315 discharge tables. too. TODO: Store them in the database.
1316
1317 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
1318 Added convinience constructor to set the kind of the
1319 discharge table.
1320
1321 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1322
1323 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1324 Prefix "Zusätzliche Längsschnitte" with "Zus.Längsschnitte"
1325 in description.
1326
1327 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1328
1329 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1330 Import 'Hochwasser-Marken', too.
1331
1332 * src/main/java/de/intevation/flys/importer/WstParser.java:
1333 Removed superfluous import.
1334
1335 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1336
1337 * src/main/java/de/intevation/flys/importer/WstParser.java:
1338 Ignore lines that contain km positions which were found
1339 before in the same file.
1340
1341 2011-05-05 Ingo Weinzierl <ingo@intevation.de>
1342
1343 * src/main/java/de/intevation/flys/model/River.java: Added a method that
1344 returns all gauges of the river intersected by a given start and end
1345 point.
1346
1347 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1348
1349 * src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
1350 Forgot to fetch peer from result set.
1351
1352 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1353
1354 * src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
1355 New. Importer model help fetching the database peer.
1356
1357 * src/main/java/de/intevation/flys/model/TimeInterval.java:
1358 Add convinience constructor with start and stop time.
1359
1360 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
1361 Attach a time interval to a discharge table if we find one.
1362
1363 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
1364 Store the reference to the importer model of the
1365 time interval of the discharge table.
1366
1367 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1368
1369 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
1370 Try to extract time ranges from at files.
1371
1372 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1373
1374 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1375 Parse and store "amtliche Linien" wst files.
1376
1377 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1378
1379 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1380 Parse and store fixation wst files as well.
1381
1382 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1383
1384 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1385 Parse the "zusaetzliche Laengsschnitte", too.
1386
1387 * src/main/java/de/intevation/flys/importer/ImportWst.java:
1388 Add getter/setter for column 'kind'.
1389
1390 2011-05-02 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1391
1392 * src/main/java/de/intevation/flys/importer/WstParser.java:
1393 Fixed flys/issue19: Do not take km column in wst file as a water level.
1394
1395 2011-05-02 Ingo Weinzierl <ingo@intevation.de>
1396
1397 * src/main/java/de/intevation/flys/model/Gauge.java: Introduced a 'scale'
1398 that is used to adjust the range of min/max W values.
1399
1400 2011-05-01 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1401
1402 * src/main/java/de/intevation/flys/importer/WstParser.java:
1403 Removed superfluous import.
1404
1405 2011-04-20 Ingo Weinzierl <ingo@intevation.de>
1406
1407 * src/main/java/de/intevation/flys/importer/WstColumnValueKey.java:
1408 New. This class is used as distinct key of a WstColumnValue - e.g. as
1409 key in a map.
1410
1411 * src/main/java/de/intevation/flys/importer/ImportWst.java: A
1412 WstColumnValue cache is build up while initialization. This cache
1413 contains all WstColumnValues that exist in the database.
1414
1415 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java: New
1416 constructor that takes the WstColumnValues cache. It is used to
1417 initialize new ImportWstColumnValue objects.
1418
1419 * src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java:
1420 Speedup: A ImportWstColumnValue has a WstColumnValues cache that
1421 contains all WstColumnValues existing in the database. This makes it
1422 unnecessary to call an sql statement for each WstColumnValue to
1423 determine its existence in the database.
1424
1425 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1426
1427 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
1428 Added a view 'wst_value_table' which aggregates the data
1429 to build w/q value tables.
1430
1431 To update existing databases:
1432
1433 BEGIN;
1434 CREATE VIEW wst_value_table AS
1435 SELECT wcv.position AS position,
1436 w,
1437 (SELECT q
1438 FROM wst_column_q_ranges wcqr
1439 JOIN wst_q_ranges wqr
1440 ON wcqr.wst_q_range_id = wqr.id
1441 JOIN ranges r
1442 ON r.id = wqr.range_id
1443 WHERE wcqr.wst_column_id = wc.id
1444 AND wcv.position BETWEEN r.a AND r.b) AS q,
1445 wc.position AS column_pos,
1446 w.id AS wst_id
1447 FROM wst_column_values wcv
1448 JOIN wst_columns wc
1449 ON wcv.wst_column_id = wc.id
1450 JOIN wsts w
1451 ON wc.wst_id = w.id
1452 ORDER BY wcv.position ASC,
1453 wc.position DESC;
1454 COMMIT;
1455
1456 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1457
1458 * src/main/java/de/intevation/flys/model/Wst.java:
1459 Add forgotten one to many relation Wst -> WstColumn.
1460
1461 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1462
1463 * src/main/java/de/intevation/flys/importer/ImportWst.java,
1464 src/main/java/de/intevation/flys/importer/WstParser.java:
1465 Import of q ranges of wst files was totally broken. :-/
1466 You have to reimport all your data.
1467
1468 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1469
1470 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
1471 Forgot kind parameter in peer fetching query.
1472
1473 2011-04-18 Ingo Weinzierl <ingo@intevation.de>
1474
1475 * src/main/java/de/intevation/flys/model/River.java::
1476 Added a new method to determine the gauge based on a given start and end
1477 point of the river.
1478
1479 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1480
1481 * doc/schema/postgresql.sql: Added 'position' column to wst_columns
1482 to allow order them by there column position in the original
1483 wst file.
1484
1485 Update existing database with:
1486
1487 BEGIN;
1488 ALTER TABLE wst_columns ADD COLUMN position int;
1489 UPDATE wst_columns w SET
1490 position = id - (SELECT min(id) FROM wst_columns WHERE wst_id = w.wst_id);
1491 ALTER TABLE wst_columns ADD CONSTRAINT wst_columns_wst_id_position_key
1492 UNIQUE (wst_id, position);
1493 COMMIT;
1494
1495 * src/main/java/de/intevation/flys/model/Wst.java,
1496 src/main/java/de/intevation/flys/model/WstColumn.java:
1497 Adjusted models.
1498
1499 * src/main/java/de/intevation/flys/importer/ImportWst.java,
1500 src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
1501 Adjusted importer.
1502
1503 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1504
1505 * doc/schema/postgresql.sql: Forget ',' in schema.
1506
1507 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1508
1509 * src/main/java/de/intevation/flys/model/Wst.java (determineMinMaxQ):
1510 Fixed index problem when an empty list is returned.
1511
1512 2011-04-15 Ingo Weinzierl <ingo@intevation.de>
1513
1514 * src/main/java/de/intevation/flys/model/Wst.java: A Wst is now able to
1515 return its min and max Q values.
1516
1517 * src/main/java/de/intevation/flys/model/Gauge.java: A Gauge is now able
1518 to return its min and max W values.
1519
1520 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1521
1522 * doc/schema/postgresql.sql: Added new column 'kind' in
1523 discharge tables and wst to distinguish between different
1524 kinds like 'Haupt-WST', 'zusaetzliche Laengsschnitte',
1525 'amtliche Daten' and so on.
1526
1527 Update existing databases with:
1528 BEGIN;
1529 ALTER TABLE discharge_tables ADD COLUMN kind int NOT NULL DEFAULT 0;
1530 ALTER TABLE wsts ADD COLUMN kind int NOT NULL DEFAULT 0;
1531 COMMIT;
1532
1533 * src/main/java/de/intevation/flys/model/DischargeTable.java
1534 src/main/java/de/intevation/flys/model/Wst.java,
1535 src/main/java/de/intevation/flys/importer/ImportWst.java,
1536 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
1537 Adjusted the models.
1538
1539 2011-04-15 Ingo Weinzierl <ingo@intevation.de>
1540
1541 * src/main/java/de/intevation/flys/backend/SessionHolder.java: Moved to
1542 this module from flys-artifacts. This is necessary to get access to the
1543 current session in this module as well.
1544
1545 2011-04-14 Ingo Weinzierl <ingo@intevation.de>
1546
1547 * src/main/java/de/intevation/flys/model/River.java: Added a method that
1548 returns the min and max distance of a river.
1549
1550 2011-04-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1551
1552 * src/**/*.java: Removed trailing whitespace.
1553
1554 2011-03-30 Ingo Weinzierl <ingo@intevation.de>
1555
1556 Tagged RELEASE 0.1
1557
1558 2011-03-28 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1559
1560 * src/main/java/de/intevation/flys/model/Range.java:
1561 Forgot to save the last change before commit.
1562
1563 2011-03-28 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1564
1565 * src/main/java/de/intevation/flys/model/Range.java:
1566 Added methods to find out if two ranges intersects.
1567
1568 2011-03-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1569
1570 * src/main/java/de/intevation/flys/model/Gauge.java:
1571 Added an one to many relation to the discharge tables of a gauge.
1572
1573 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1574
1575 Finished import of WSTs.
1576
1577 TODO 1: Speed it up! It takes on a high end machine over 7(!)
1578 minutes only for the data of the Saar.
1579 TODO 2: Double precision floating point representations produced
1580 by the the parsers leed to unique constraint violations
1581 in the backend on a second run. So the import is currently
1582 only working on freshly initialized data bases.
1583 More consequent working with BigDecimal and some
1584 rounding may be of help here.
1585
1586 * src/main/java/de/intevation/flys/model/WstColumnValue.java:
1587 Added convinience constructors.
1588
1589 * src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java:
1590 Added getPeer() method.
1591
1592 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
1593 Add a list of the ImportWstColumnValues produced by the WST parser.
1594
1595 * src/main/java/de/intevation/flys/importer/WstParser.java: Add
1596 the (km, w) values to the ImportWstColumns.
1597
1598 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1599
1600 * src/main/java/de/intevation/flys/importer/WstParser.java:
1601 Build models for wsts, wst columns and q ranges and
1602 store them in the backend. TODO: store the w values.
1603
1604 * src/main/java/de/intevation/flys/model/WstQRange.java
1605 src/main/java/de/intevation/flys/model/Wst.java,
1606 src/main/java/de/intevation/flys/model/Range.java,
1607 src/main/java/de/intevation/flys/model/WstColumnQRange.java,
1608 src/main/java/de/intevation/flys/model/WstColumn.java:
1609 Added convinience constructors.
1610
1611 * src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
1612 src/main/java/de/intevation/flys/importer/ImportWst.java,
1613 src/main/java/de/intevation/flys/importer/ImportRiver.java,
1614 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
1615 src/main/java/de/intevation/flys/importer/ImportWstColumn.java,
1616 src/main/java/de/intevation/flys/importer/ImportRange.java:
1617 Added getPeer() methods.
1618
1619 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1620
1621 * src/main/java/de/intevation/flys/importer/WstParser.java:
1622 The unit extraction in the WST parser of desktop FLYS
1623 is broken! Add a hack here to repair this for our
1624 importer. Desktop FLYS needs a fix, too!
1625
1626 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1627
1628 * src/main/java/de/intevation/flys/importer/WstParser.java:
1629 Ported some stuff ver from WSTSource.java of desktop flys to
1630 parse WST files. TODO: create instances of the import models.
1631
1632 * src/main/java/de/intevation/flys/utils/StringUtil.java:
1633 Copied from desktop flys. Used for some string operations
1634 in WST parser.
1635
1636 * src/main/java/de/intevation/flys/importer/Importer.java:
1637 Added system property 'flys.backend.importer.dry.run'.
1638 Set to true only the parsing is done and no writing
1639 to the backend. Default: false.
1640
1641 * src/main/java/de/intevation/flys/App.java,
1642 src/main/java/de/intevation/flys/model/MainValueType.java:
1643 Removed needless imports.
1644
1645 2011-03-22 Ingo Weinzierl <ingo@intevation.de>
1646
1647 * src/main/java/de/intevation/flys/model/DischargeTableValue.java,
1648 src/main/java/de/intevation/flys/model/DischargeTable.java: Added new
1649 constructors.
1650
1651 * src/main/java/de/intevation/flys/importer/AtFileParser.java: New. This
1652 parser is used to '*.at' files.
1653
1654 * src/main/java/de/intevation/flys/importer/ImportGauge.java: Added code to
1655 import discharge tables.
1656
1657 * src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java,
1658 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java: New.
1659 Helper models for import discharge tables.
1660
1661 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1662
1663 * src/main/java/de/intevation/flys/importer/WstParser.java,
1664 src/main/java/de/intevation/flys/importer/ImportRiver.java:
1665 Added stub for WST parser.
1666
1667 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1668
1669 * src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
1670 src/main/java/de/intevation/flys/importer/ImportWst.java,
1671 src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java,
1672 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
1673 src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
1674 Added importer helper model stubs for WST imports.
1675
1676 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1677
1678 Second part of parsing/storing main values. Should be finished now.
1679
1680 * src/main/java/de/intevation/flys/importer/ImportNamedMainValue.java,
1681 src/main/java/de/intevation/flys/importer/ImportMainValue.java:
1682 New. Helper models for import main values,
1683
1684 * src/main/java/de/intevation/flys/model/MainValue.java,
1685 src/main/java/de/intevation/flys/model/NamedMainValue.java:
1686 Added convinience constructors.
1687
1688 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
1689 Write main values to backend, too.
1690
1691 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
1692 Build importer models for main values.
1693
1694 * src/main/java/de/intevation/flys/importer/ImportMainValueType.java:
1695 Data was called 'value'. Now it is 'name' to fit the
1696 schema.
1697
1698 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1699
1700 * doc/schema/postgresql.sql: Fixed wrong unique constraint.
1701
1702 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1703 Added some logging when storing gauges.
1704
1705 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1706
1707 * src/main/java/de/intevation/flys/model/Gauge.java:
1708 Add forgotten column river_id.
1709
1710 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
1711 Small HQL fix.
1712
1713 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1714
1715 * src/main/java/de/intevation/flys/model/Gauge.java:
1716 Added convinience contructor.
1717
1718 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
1719 Fixed getPeer() method.
1720
1721 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
1722 Fixed parsing of STA files.
1723
1724 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1725
1726 * src/main/java/de/intevation/flys/importer/ImportRiver.java,
1727 src/main/java/de/intevation/flys/importer/ImportGauge.java:
1728 Propagate river into storing of gauges.
1729
1730 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1731
1732 * src/main/java/de/intevation/flys/importer/Importer.java:
1733 Added code to store rivers not only annotations.
1734
1735 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1736 Added stub code to write gauges.
1737
1738 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1739
1740 First part of parsing main values.
1741
1742 * src/main/java/de/intevation/flys/App.java: Commented out
1743 creation of dummy rivers.
1744
1745 * src/main/java/de/intevation/flys/model/NamedMainValues.java:
1746 Moved to NamedMainValue.
1747
1748 * src/main/java/de/intevation/flys/model/NamedMainValue.java:
1749 New. Formerly NamedMainValues.
1750
1751 * src/main/java/de/intevation/flys/model/MainValue.java:
1752 New. Forgotten part of the model.
1753
1754 * src/main/java/de/intevation/flys/model/MainValueType.java:
1755 Data is String not BigDecimal
1756
1757 * src/main/java/de/intevation/flys/model/Range.java: Removed
1758 contructor with double arguments. Using BigDecimal now.
1759
1760 * src/main/java/de/intevation/flys/importer/PegelGltParser.java:
1761 Propagate BigDecimal usage.
1762
1763 * src/main/java/de/intevation/flys/importer/Importer.java:
1764 Removed needless import. Added TODO
1765
1766 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1767 Parse the dependencies of the gauges, too.
1768
1769 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
1770 New. Parser for STA files.
1771
1772 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
1773 Call STA file parser.
1774
1775 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java,
1776 src/main/java/de/intevation/flys/importer/ImportRange.java:
1777 Uses BigDecimal now.
1778
1779 * src/main/java/de/intevation/flys/importer/ImportAttribute.java:
1780 Fixed wrong type cast in equals.
1781
1782 * src/main/java/de/intevation/flys/importer/ImportMainValueType.java:
1783 New. Helper model for importing main value types.
1784
1785 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1786 Register forgotten MainValue model.
1787
1788 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1789
1790 Store annotations in backend.
1791
1792 * src/main/java/de/intevation/flys/model/Annotation.java:
1793 New convinience constructor.
1794
1795 * src/main/java/de/intevation/flys/model/River.java:
1796 Added toString() method.
1797
1798 * src/main/java/de/intevation/flys/model/Range.java:
1799 Fixed nasty mistake in @OneToOne annotatation.
1800 New convinience constructors.
1801
1802 * src/main/java/de/intevation/flys/importer/ImportPosition.java
1803 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
1804 src/main/java/de/intevation/flys/importer/ImportRange.java
1805 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
1806 Make storing to backend work. It's a bit too slow. :-/
1807
1808 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1809 Fetch peer from backend. Added method to store annotations.
1810 * src/main/java/de/intevation/flys/importer/Importer.java:
1811 Stored annotations into backend. More eloquent SQL exception
1812 handling.
1813
1814 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1815
1816 * src/main/java/de/intevation/flys/model/Attribute.java,
1817 src/main/java/de/intevation/flys/model/Position.java:
1818 Added convinience constructors.
1819
1820 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
1821 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
1822 Bound them to there backend peers.
1823
1824 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1825
1826 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java:
1827 New. Added parser to read *.KM files.
1828
1829 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
1830 src/main/java/de/intevation/flys/importer/PegelGltParser.java,
1831 src/main/java/de/intevation/flys/importer/ImportRiver.java,
1832 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
1833 src/main/java/de/intevation/flys/importer/ImportRange.java,
1834 src/main/java/de/intevation/flys/importer/InfoGewParser.java,
1835 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
1836 Adjusted to load the annotations from *.KM files.
1837
1838 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1839
1840 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
1841 src/main/java/de/intevation/flys/importer/ImportRange.java,
1842 src/main/java/de/intevation/flys/importer/ImportAttribute.java,
1843 src/main/java/de/intevation/flys/importer/ImportAnnotation.java:
1844 New helper models for import.
1845
1846 * src/main/java/de/intevation/flys/importer/PegelGltParser.java,
1847 src/main/java/de/intevation/flys/importer/ImportGauge.java:
1848 Use new models.
1849
1850 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1851
1852 * src/main/java/de/intevation/flys/importer/PegelGltParser.java:
1853 New. Parser for PEGEL.GLT files.
1854
1855 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
1856 New. Import model for gauges.
1857
1858 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
1859 Removed needless imports.
1860
1861 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1862 Added method to parse the gauges.
1863
1864 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
1865 Trigger pegel glt file parsing.
1866
1867 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1868
1869 * src/main/java/de/intevation/flys/importer/Importer.java:
1870 Used thread local pattern to make sharing of session easier.
1871
1872 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1873
1874 * src/main/java/de/intevation/flys/importer/Importer.java:
1875 Fixed error in HQL statement.
1876
1877 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1878
1879 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
1880 Commented out a debug block because it leaks the db password.
1881
1882 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1883
1884 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
1885 Expose imported rivers.
1886
1887 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
1888 Store imported rivers into database. Needs testing!
1889
1890 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1891
1892 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1893 Default connection parameters are now overwritable with
1894 system properties (defaults in brackets):
1895 - user name: flys.backend.user (flys)
1896 - user password: flys.backend.password (flys)
1897 - db dialect: flys.backend.dialect (org.hibernate.dialect.PostgreSQLDialect)
1898 - db driver: flys.backend.driver (org.postgresql.Driver)
1899 - db url: flys.backend.url (jdbc:postgresql://localhost:5432/flys)
1900
1901 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1902
1903 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1904 Expose createSessionFactory() as public to be usable without
1905 a artifact database running.
1906
1907 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1908
1909 * src/main/java/de/intevation/flys/utils/FileTools.java:
1910 Tools for handling with filenames. Currently there is
1911 a repair(File) method with repairs letter case errors
1912 which is useful when reading windows filenames on a
1913 un*x platform.
1914
1915 * src/main/java/de/intevation/flys/importer/Importer.java:
1916 Standalone app to read data from the file system and
1917 store it in a database. Currently it does not store
1918 anything. It only loads info gew files.
1919
1920 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
1921 Info gew parser.
1922
1923 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
1924 Helper model of a river used produced by parsing the
1925 info gew files.
1926
1927 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1928
1929 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1930 New. SessionFactoryProvider.getSessionFactory() provides a
1931 SessionFactory to use the Hibernate O/R mapper for the FLYS backend.
1932
1933 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1934
1935 * pom.xml: Added dependency to artifacts-commons to
1936 be able to use the global configuration of the artifact database.
1937
1938 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1939
1940 * src/main/java/de/intevation/flys/App.java: Wire all POJOs
1941 to corresponding factory.
1942
1943 * src/main/java/de/intevation/flys/model/*.java: Generate
1944 all foreign key constraints. TODO: name them correctly
1945 because the machine generated names are ugly and do
1946 not fit the PostgreSQL names.
1947
1948 * doc/schema/postgresql.sql: Small quantifier fix in descriptions
1949 of wst columns.
1950
1951 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1952
1953 * doc/schema/postgresql.sql: Fixed wrong spelled
1954 column references in foreign keys introduces with
1955 last change.
1956
1957 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1958
1959 * src/main/java/de/intevation/flys/model/*.java: Added
1960 column annotations for simple fields. TODO: foreign keys.
1961
1962 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1963
1964 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
1965 Fixed inconsistent table names.
1966
1967 * src/main/java/de/intevation/flys/model/*.java: Added
1968 entity and id annotations.
1969
1970 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1971
1972 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
1973 Added missing sequences.
1974
1975 * doc/schema/sqlite.sql: Deleted. Not longer supported.
1976
1977 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1978
1979 * doc/schema/postgresql-cleanup.sql: Forgot to add.
1980
1981 * src/main/java/de/intevation/flys/App.java: Use
1982 Apache Commons DBCP as Hibernate connection provide.
1983
1984 * src/main/java/de/intevation/flys/model/River.java:
1985 Added a constructor with string argument. Set the
1986 sequence increment to 1 (eat up 100 at a time before).
1987
1988 * pom.xml: Added PostgreSQL 8.4 driver as runtime dependency.
1989
1990 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1991
1992 * doc/schema/postgresql-cleanup.sql: New. Tear down schema
1993 for a postgres database.
1994
1995 * doc/schema/postgresql.sql: Added squence for
1996 auto generating ids in river table. Cleaned up schema.
1997
1998 * src/main/java/de/intevation/flys/App.java: Simple
1999 test app to interact with hibernate. Needs to be removed
2000 because its only a toy.
2001
2002 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
2003 New. Binds Apache Commons to Hibernate.
2004
2005 * pom.xml: Added dependencies to log4j, commons dbcp,
2006 JPA of hibernate.
2007
2008 * src/main/java/de/intevation/flys/model/River.java: Added
2009 JPA annotations.
2010
2011 * src/main/java/de/intevation/flys/model/*.java: Replaced
2012 Long with Integer because column ids are only four bytes wide.
2013
2014 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2015
2016 * doc/schema/sqlite.sql, doc/schema/postgresql.sql: Fixed
2017 smaller issues in ddl.
2018
2019 * src/main/java/de/intevation/flys/model/*.java: Added POJOs
2020 of to be mapped. TODO: Map them!
2021
2022 * pom.xml: Added plugin config for hibernate.
2023
2024 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2025
2026 * pom.xml: Added dependency (and corresponding repository) to
2027 Hibernate Core 3.6.1 Final
2028
2029 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2030
2031 * pom.xml, src/**: Created a new empty maven project:
2032 $ mvn archetype:create \
2033 -DgroupId=de.intevation.flys \
2034 -DartifactId=flys-backend
2035
2036 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2037
2038 * README: New. Some setup instructions.
2039
2040 * doc/schema/postgresql.sql: New. Schema converted to PostgreSQL
2041
2042 * doc/schema/sqlite.sql: Fixed defect foreign key constraints.
2043
2044 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2045
2046 * doc/schema/sqlite.sql: Factorized time intervals out into
2047 a separated table.
2048
2049 2011-01-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2050
2051 * contrib/import-kms.py, contrib/import-gew.py: Initial scripts
2052 to import data into SQLite database. They still need some work.
2053
2054 2011-02-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>:
2055
2056 * doc/schema/sqlite.sql: Added initial schema for
2057 FLYS database.
http://dive4elements.wald.intevation.org