Mercurial > gemma
annotate TODOs-historization_ng.md @ 4955:5c43427fc2bf fairway-marks-import
Do not rollback savepoint if statement returned no rows
Statements that might or might not return rows can modify the database
in both cases e.g. through DML in functions, CTEs or triggers.
Not returning any rows but modifying the database is not an error
in such a case. Thus, prevent ROLLBACK.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 26 Feb 2020 11:25:28 +0100 |
parents | 6bfe42f88638 |
children |
rev | line source |
---|---|
4029
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
1 # TODOs for HNG (Historization NextGen) |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
2 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
3 ## gauges-reference-water-levels |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
4 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
5 Could be seen as direct part of the gauge data and therefore kept with |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
6 the foll primary key reference... |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
7 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
8 ## Water level diagrams: |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
9 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
10 One time range might reference different verions of one gauge: |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
11 - How is that hanedled currently? |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
12 - How to handle it in HNG? |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
13 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
14 ## Map display: |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
15 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
16 Ensure only current gauges are shown in all situations |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
17 - Gauges layer |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
18 - Search |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
19 - more? |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
20 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
21 ## Bottlenecks: |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
22 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
23 Always associate the correct gauge, when: |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
24 - Uploading Sounding results (how is that currently handled?) |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
25 - Displaying Sounding data |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
26 - Creating/showing X-Cuts |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
27 - Unclear: what constraints shall we chekc for on bottleneck imports? |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
28 |
4039
9f9e62f6f4f9
Addition to historization TODOs.
Sascha Wilde <wilde@intevation.de>
parents:
4029
diff
changeset
|
29 Cut end of validit _after_ accepting the new one. |
9f9e62f6f4f9
Addition to historization TODOs.
Sascha Wilde <wilde@intevation.de>
parents:
4029
diff
changeset
|
30 |
4040
39441cdc5021
Addition to historization TODOs: SR
Sascha Wilde <wilde@intevation.de>
parents:
4039
diff
changeset
|
31 ## Sounding Results: |
39441cdc5021
Addition to historization TODOs: SR
Sascha Wilde <wilde@intevation.de>
parents:
4039
diff
changeset
|
32 |
4066
6bfe42f88638
Some thoughts on an extra SR constraint trigger to check for ref gauge..
Sascha Wilde <wilde@intevation.de>
parents:
4040
diff
changeset
|
33 - Maybe add a constraint to check, that a ref gauge is available? |
6bfe42f88638
Some thoughts on an extra SR constraint trigger to check for ref gauge..
Sascha Wilde <wilde@intevation.de>
parents:
4040
diff
changeset
|
34 Maybe not neccessary as import isn't possible anyway, as the |
6bfe42f88638
Some thoughts on an extra SR constraint trigger to check for ref gauge..
Sascha Wilde <wilde@intevation.de>
parents:
4040
diff
changeset
|
35 reference gauge is needed for the import process... (So the |
6bfe42f88638
Some thoughts on an extra SR constraint trigger to check for ref gauge..
Sascha Wilde <wilde@intevation.de>
parents:
4040
diff
changeset
|
36 constraint would never catch anything, as no data could be produced |
6bfe42f88638
Some thoughts on an extra SR constraint trigger to check for ref gauge..
Sascha Wilde <wilde@intevation.de>
parents:
4040
diff
changeset
|
37 without ref gauge) Only upside: we would triger if there is an error |
6bfe42f88638
Some thoughts on an extra SR constraint trigger to check for ref gauge..
Sascha Wilde <wilde@intevation.de>
parents:
4040
diff
changeset
|
38 in the backend generating SR with invalid ref data. |
4040
39441cdc5021
Addition to historization TODOs: SR
Sascha Wilde <wilde@intevation.de>
parents:
4039
diff
changeset
|
39 - Check during upload that matching bottleneck and reference gauge |
39441cdc5021
Addition to historization TODOs: SR
Sascha Wilde <wilde@intevation.de>
parents:
4039
diff
changeset
|
40 data is available (and use ist correctly) |
39441cdc5021
Addition to historization TODOs: SR
Sascha Wilde <wilde@intevation.de>
parents:
4039
diff
changeset
|
41 - Use correct reference gauge for X-Cuts |
39441cdc5021
Addition to historization TODOs: SR
Sascha Wilde <wilde@intevation.de>
parents:
4039
diff
changeset
|
42 - (Maybe later) use matching BN data for display |
39441cdc5021
Addition to historization TODOs: SR
Sascha Wilde <wilde@intevation.de>
parents:
4039
diff
changeset
|
43 |
4029
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
44 ## EVERYTHING ELSE |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
45 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
46 Not being mentioned here, doesn't mean something is done... |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
47 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
48 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
49 # DONE |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
50 |
9cfc6f478157
Added TODO file for Historization NextGen...
Sascha Wilde <wilde@intevation.de>
parents:
diff
changeset
|
51 Stuff done will bemoved moved here for reference: |