Mercurial > dive4elements > river

comparison flys-backend/ChangeLog @ 2426:f97e9b810e58 2.6.1

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