Mercurial > dive4elements > river

comparison flys-backend/ChangeLog @ 2386:cb7ebcadb214 2.6

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