Commit Graph

11 Commits

Author SHA1 Message Date
D. Berge
67af85eca9 Recognise PENDING status in sequence imports.
If a final sequence file or directory name matches a pattern
which is recognised to indicate a ‘pending acceptance’ status,
the final data (if any exists) for that sequence will be deleted
and a comment added to the effect that the sequence has been
marked as ‘pending’.

To accept the sequence, rename its final file or directory name
accordingly.

Note: it is the *final* data that is searched for a matching
pattern, not the raw.

Closes #91.
2021-05-21 15:15:15 +02:00
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