D. Berge
3c1a5da1a8
Suspend trigger during system data import
2020-09-30 15:39:37 +02:00
D. Berge
a7b4b70d59
Remove spurious semicolon
2020-09-27 19:19:19 +02:00
D. Berge
0e5e54b680
Ensure views are synchronised after re-import
2020-09-23 15:48:42 +02:00
D. Berge
6b52383056
Reset sequences after re-import
2020-09-23 15:48:21 +02:00
D. Berge
97104556b7
Do not hard fail if imports fail for one project.
...
It may be the case that we have already re-imported
some of the data, so we just move on to the next
project.
2020-09-23 15:46:17 +02:00
D. Berge
c9b9a009af
Speed up the events view.
...
We do this with the help of some denormalisation
and a handy trigger.
Closes #35 .
2020-09-14 03:01:55 +02:00
D. Berge
b5b91d41c9
Reset event serial ids after re-import.
...
When the database is recreated, the sequences
used in the events_timed and events_seq tables
will be at their initial values, which will
almost certainly conflict with existing data
when it is imported via COPY.
With this commit, we set the current value for
those sequences to something usable.
Fixes #33 .
2020-09-14 01:36:40 +02:00
D. Berge
3b5b200f08
Change address of system exports path
2020-09-10 20:37:52 +02:00
D. Berge
0fc795d1c4
Add commit after copy_from calls
2020-09-03 17:08:25 +02:00
D. Berge
a8830c9a05
Add system data import module
2020-09-02 15:05:43 +02:00