comparison flys-backend/ChangeLog @ 207:2b745b5e731c 0.1

merged flys-backend/0.1
author Thomas Arendsen Hein <thomas@intevation.de>
date Fri, 28 Sep 2012 12:14:07 +0200
parents 697d1faa8217
children 24e356cf9f6c
comparison
equal deleted inserted replaced
160:27d3d0093993 207:2b745b5e731c
1 2011-03-28 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2
3 * src/main/java/de/intevation/flys/model/Range.java:
4 Forgot to save the last change before commit.
5
6 2011-03-28 Sascha L. Teichmann <sascha.teichmann@intevation.de>
7
8 * src/main/java/de/intevation/flys/model/Range.java:
9 Added methods to find out if two ranges intersects.
10
11 2011-03-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
12
13 * src/main/java/de/intevation/flys/model/Gauge.java:
14 Added an one to many relation to the discharge tables of a gauge.
15
16 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
17
18 Finished import of WSTs.
19
20 TODO 1: Speed it up! It takes on a high end machine over 7(!)
21 minutes only for the data of the Saar.
22 TODO 2: Double precision floating point representations produced
23 by the the parsers leed to unique constraint violations
24 in the backend on a second run. So the import is currently
25 only working on freshly initialized data bases.
26 More consequent working with BigDecimal and some
27 rounding may be of help here.
28
29 * src/main/java/de/intevation/flys/model/WstColumnValue.java:
30 Added convinience constructors.
31
32 * src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java:
33 Added getPeer() method.
34
35 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
36 Add a list of the ImportWstColumnValues produced by the WST parser.
37
38 * src/main/java/de/intevation/flys/importer/WstParser.java: Add
39 the (km, w) values to the ImportWstColumns.
40
41 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
42
43 * src/main/java/de/intevation/flys/importer/WstParser.java:
44 Build models for wsts, wst columns and q ranges and
45 store them in the backend. TODO: store the w values.
46
47 * src/main/java/de/intevation/flys/model/WstQRange.java
48 src/main/java/de/intevation/flys/model/Wst.java,
49 src/main/java/de/intevation/flys/model/Range.java,
50 src/main/java/de/intevation/flys/model/WstColumnQRange.java,
51 src/main/java/de/intevation/flys/model/WstColumn.java:
52 Added convinience constructors.
53
54 * src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
55 src/main/java/de/intevation/flys/importer/ImportWst.java,
56 src/main/java/de/intevation/flys/importer/ImportRiver.java,
57 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
58 src/main/java/de/intevation/flys/importer/ImportWstColumn.java,
59 src/main/java/de/intevation/flys/importer/ImportRange.java:
60 Added getPeer() methods.
61
62 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
63
64 * src/main/java/de/intevation/flys/importer/WstParser.java:
65 The unit extraction in the WST parser of desktop FLYS
66 is broken! Add a hack here to repair this for our
67 importer. Desktop FLYS needs a fix, too!
68
69 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
70
71 * src/main/java/de/intevation/flys/importer/WstParser.java:
72 Ported some stuff ver from WSTSource.java of desktop flys to
73 parse WST files. TODO: create instances of the import models.
74
75 * src/main/java/de/intevation/flys/utils/StringUtil.java:
76 Copied from desktop flys. Used for some string operations
77 in WST parser.
78
79 * src/main/java/de/intevation/flys/importer/Importer.java:
80 Added system property 'flys.backend.importer.dry.run'.
81 Set to true only the parsing is done and no writing
82 to the backend. Default: false.
83
84 * src/main/java/de/intevation/flys/App.java,
85 src/main/java/de/intevation/flys/model/MainValueType.java:
86 Removed needless imports.
87
88 2011-03-22 Ingo Weinzierl <ingo@intevation.de>
89
90 * src/main/java/de/intevation/flys/model/DischargeTableValue.java,
91 src/main/java/de/intevation/flys/model/DischargeTable.java: Added new
92 constructors.
93
94 * src/main/java/de/intevation/flys/importer/AtFileParser.java: New. This
95 parser is used to '*.at' files.
96
97 * src/main/java/de/intevation/flys/importer/ImportGauge.java: Added code to
98 import discharge tables.
99
100 * src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java,
101 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java: New.
102 Helper models for import discharge tables.
103
104 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
105
106 * src/main/java/de/intevation/flys/importer/WstParser.java,
107 src/main/java/de/intevation/flys/importer/ImportRiver.java:
108 Added stub for WST parser.
109
110 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
111
112 * src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
113 src/main/java/de/intevation/flys/importer/ImportWst.java,
114 src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java,
115 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
116 src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
117 Added importer helper model stubs for WST imports.
118
119 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
120
121 Second part of parsing/storing main values. Should be finished now.
122
123 * src/main/java/de/intevation/flys/importer/ImportNamedMainValue.java,
124 src/main/java/de/intevation/flys/importer/ImportMainValue.java:
125 New. Helper models for import main values,
126
127 * src/main/java/de/intevation/flys/model/MainValue.java,
128 src/main/java/de/intevation/flys/model/NamedMainValue.java:
129 Added convinience constructors.
130
131 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
132 Write main values to backend, too.
133
134 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
135 Build importer models for main values.
136
137 * src/main/java/de/intevation/flys/importer/ImportMainValueType.java:
138 Data was called 'value'. Now it is 'name' to fit the
139 schema.
140
141 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
142
143 * doc/schema/postgresql.sql: Fixed wrong unique constraint.
144
145 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
146 Added some logging when storing gauges.
147
148 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
149
150 * src/main/java/de/intevation/flys/model/Gauge.java:
151 Add forgotten column river_id.
152
153 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
154 Small HQL fix.
155
156 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
157
158 * src/main/java/de/intevation/flys/model/Gauge.java:
159 Added convinience contructor.
160
161 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
162 Fixed getPeer() method.
163
164 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
165 Fixed parsing of STA files.
166
167 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
168
169 * src/main/java/de/intevation/flys/importer/ImportRiver.java,
170 src/main/java/de/intevation/flys/importer/ImportGauge.java:
171 Propagate river into storing of gauges.
172
173 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
174
175 * src/main/java/de/intevation/flys/importer/Importer.java:
176 Added code to store rivers not only annotations.
177
178 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
179 Added stub code to write gauges.
180
181 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
182
183 First part of parsing main values.
184
185 * src/main/java/de/intevation/flys/App.java: Commented out
186 creation of dummy rivers.
187
188 * src/main/java/de/intevation/flys/model/NamedMainValues.java:
189 Moved to NamedMainValue.
190
191 * src/main/java/de/intevation/flys/model/NamedMainValue.java:
192 New. Formerly NamedMainValues.
193
194 * src/main/java/de/intevation/flys/model/MainValue.java:
195 New. Forgotten part of the model.
196
197 * src/main/java/de/intevation/flys/model/MainValueType.java:
198 Data is String not BigDecimal
199
200 * src/main/java/de/intevation/flys/model/Range.java: Removed
201 contructor with double arguments. Using BigDecimal now.
202
203 * src/main/java/de/intevation/flys/importer/PegelGltParser.java:
204 Propagate BigDecimal usage.
205
206 * src/main/java/de/intevation/flys/importer/Importer.java:
207 Removed needless import. Added TODO
208
209 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
210 Parse the dependencies of the gauges, too.
211
212 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
213 New. Parser for STA files.
214
215 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
216 Call STA file parser.
217
218 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java,
219 src/main/java/de/intevation/flys/importer/ImportRange.java:
220 Uses BigDecimal now.
221
222 * src/main/java/de/intevation/flys/importer/ImportAttribute.java:
223 Fixed wrong type cast in equals.
224
225 * src/main/java/de/intevation/flys/importer/ImportMainValueType.java:
226 New. Helper model for importing main value types.
227
228 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
229 Register forgotten MainValue model.
230
231 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
232
233 Store annotations in backend.
234
235 * src/main/java/de/intevation/flys/model/Annotation.java:
236 New convinience constructor.
237
238 * src/main/java/de/intevation/flys/model/River.java:
239 Added toString() method.
240
241 * src/main/java/de/intevation/flys/model/Range.java:
242 Fixed nasty mistake in @OneToOne annotatation.
243 New convinience constructors.
244
245 * src/main/java/de/intevation/flys/importer/ImportPosition.java
246 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
247 src/main/java/de/intevation/flys/importer/ImportRange.java
248 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
249 Make storing to backend work. It's a bit too slow. :-/
250
251 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
252 Fetch peer from backend. Added method to store annotations.
253 * src/main/java/de/intevation/flys/importer/Importer.java:
254 Stored annotations into backend. More eloquent SQL exception
255 handling.
256
257 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
258
259 * src/main/java/de/intevation/flys/model/Attribute.java,
260 src/main/java/de/intevation/flys/model/Position.java:
261 Added convinience constructors.
262
263 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
264 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
265 Bound them to there backend peers.
266
267 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
268
269 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java:
270 New. Added parser to read *.KM files.
271
272 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
273 src/main/java/de/intevation/flys/importer/PegelGltParser.java,
274 src/main/java/de/intevation/flys/importer/ImportRiver.java,
275 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
276 src/main/java/de/intevation/flys/importer/ImportRange.java,
277 src/main/java/de/intevation/flys/importer/InfoGewParser.java,
278 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
279 Adjusted to load the annotations from *.KM files.
280
281 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
282
283 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
284 src/main/java/de/intevation/flys/importer/ImportRange.java,
285 src/main/java/de/intevation/flys/importer/ImportAttribute.java,
286 src/main/java/de/intevation/flys/importer/ImportAnnotation.java:
287 New helper models for import.
288
289 * src/main/java/de/intevation/flys/importer/PegelGltParser.java,
290 src/main/java/de/intevation/flys/importer/ImportGauge.java:
291 Use new models.
292
293 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
294
295 * src/main/java/de/intevation/flys/importer/PegelGltParser.java:
296 New. Parser for PEGEL.GLT files.
297
298 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
299 New. Import model for gauges.
300
301 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
302 Removed needless imports.
303
304 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
305 Added method to parse the gauges.
306
307 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
308 Trigger pegel glt file parsing.
309
310 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
311
312 * src/main/java/de/intevation/flys/importer/Importer.java:
313 Used thread local pattern to make sharing of session easier.
314
315 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
316
317 * src/main/java/de/intevation/flys/importer/Importer.java:
318 Fixed error in HQL statement.
319
320 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
321
322 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
323 Commented out a debug block because it leaks the db password.
324
325 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
326
327 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
328 Expose imported rivers.
329
330 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
331 Store imported rivers into database. Needs testing!
332
333 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
334
335 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
336 Default connection parameters are now overwritable with
337 system properties (defaults in brackets):
338 - user name: flys.backend.user (flys)
339 - user password: flys.backend.password (flys)
340 - db dialect: flys.backend.dialect (org.hibernate.dialect.PostgreSQLDialect)
341 - db driver: flys.backend.driver (org.postgresql.Driver)
342 - db url: flys.backend.url (jdbc:postgresql://localhost:5432/flys)
343
344 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
345
346 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
347 Expose createSessionFactory() as public to be usable without
348 a artifact database running.
349
350 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
351
352 * src/main/java/de/intevation/flys/utils/FileTools.java:
353 Tools for handling with filenames. Currently there is
354 a repair(File) method with repairs letter case errors
355 which is useful when reading windows filenames on a
356 un*x platform.
357
358 * src/main/java/de/intevation/flys/importer/Importer.java:
359 Standalone app to read data from the file system and
360 store it in a database. Currently it does not store
361 anything. It only loads info gew files.
362
363 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
364 Info gew parser.
365
366 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
367 Helper model of a river used produced by parsing the
368 info gew files.
369
370 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
371
372 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
373 New. SessionFactoryProvider.getSessionFactory() provides a
374 SessionFactory to use the Hibernate O/R mapper for the FLYS backend.
375
376 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
377
378 * pom.xml: Added dependency to artifacts-commons to
379 be able to use the global configuration of the artifact database.
380
381 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
382
383 * src/main/java/de/intevation/flys/App.java: Wire all POJOs
384 to corresponding factory.
385
386 * src/main/java/de/intevation/flys/model/*.java: Generate
387 all foreign key constraints. TODO: name them correctly
388 because the machine generated names are ugly and do
389 not fit the PostgreSQL names.
390
391 * doc/schema/postgresql.sql: Small quantifier fix in descriptions
392 of wst columns.
393
394 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
395
396 * doc/schema/postgresql.sql: Fixed wrong spelled
397 column references in foreign keys introduces with
398 last change.
399
400 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
401
402 * src/main/java/de/intevation/flys/model/*.java: Added
403 column annotations for simple fields. TODO: foreign keys.
404
405 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
406
407 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
408 Fixed inconsistent table names.
409
410 * src/main/java/de/intevation/flys/model/*.java: Added
411 entity and id annotations.
412
413 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
414
415 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
416 Added missing sequences.
417
418 * doc/schema/sqlite.sql: Deleted. Not longer supported.
419
420 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
421
422 * doc/schema/postgresql-cleanup.sql: Forgot to add.
423
424 * src/main/java/de/intevation/flys/App.java: Use
425 Apache Commons DBCP as Hibernate connection provide.
426
427 * src/main/java/de/intevation/flys/model/River.java:
428 Added a constructor with string argument. Set the
429 sequence increment to 1 (eat up 100 at a time before).
430
431 * pom.xml: Added PostgreSQL 8.4 driver as runtime dependency.
432
433 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
434
435 * doc/schema/postgresql-cleanup.sql: New. Tear down schema
436 for a postgres database.
437
438 * doc/schema/postgresql.sql: Added squence for
439 auto generating ids in river table. Cleaned up schema.
440
441 * src/main/java/de/intevation/flys/App.java: Simple
442 test app to interact with hibernate. Needs to be removed
443 because its only a toy.
444
445 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
446 New. Binds Apache Commons to Hibernate.
447
448 * pom.xml: Added dependencies to log4j, commons dbcp,
449 JPA of hibernate.
450
451 * src/main/java/de/intevation/flys/model/River.java: Added
452 JPA annotations.
453
454 * src/main/java/de/intevation/flys/model/*.java: Replaced
455 Long with Integer because column ids are only four bytes wide.
456
457 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
458
459 * doc/schema/sqlite.sql, doc/schema/postgresql.sql: Fixed
460 smaller issues in ddl.
461
462 * src/main/java/de/intevation/flys/model/*.java: Added POJOs
463 of to be mapped. TODO: Map them!
464
465 * pom.xml: Added plugin config for hibernate.
466
467 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
468
469 * pom.xml: Added dependency (and corresponding repository) to
470 Hibernate Core 3.6.1 Final
471
472 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
473
474 * pom.xml, src/**: Created a new empty maven project:
475 $ mvn archetype:create \
476 -DgroupId=de.intevation.flys \
477 -DartifactId=flys-backend
478
479 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
480
481 * README: New. Some setup instructions.
482
483 * doc/schema/postgresql.sql: New. Schema converted to PostgreSQL
484
485 * doc/schema/sqlite.sql: Fixed defect foreign key constraints.
486
487 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
488
489 * doc/schema/sqlite.sql: Factorized time intervals out into
490 a separated table.
491
492 2011-01-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
493
494 * contrib/import-kms.py, contrib/import-gew.py: Initial scripts
495 to import data into SQLite database. They still need some work.
496
497 2011-02-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>:
498
499 * doc/schema/sqlite.sql: Added initial schema for
500 FLYS database.

http://dive4elements.wald.intevation.org