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