Mercurial > dive4elements > river
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. |