View Issue Details

IDProjectCategoryView StatusLast Update
0007277Talerexchange Postgres DB backendpublic2022-07-28 22:30
ReporterChristian Grothoff Assigned ToChristian Grothoff  
PriorityhighSeverityfeatureReproducibilityN/A
Status resolvedResolutionfixed 
Platformi7OSDebian GNU/LinuxOS Versionsqueeze
Product Versiongit (master) 
Target Version0.9Fixed in Version0.9 
Summary0007277: exchange-*.sql files confusing
DescriptionRight now, a lot of things (stored procedures, schema definitions) are mashed up together in those files and then they are concatenated. Plus we use the 000x-counting logic for drop, where it doesn't really apply. And we constantly have issues with the drop-files being outdated (leaving behind artifacts).

We can probably do better by:
1) moving stored procedures (at least those not relating to table creation) into their own resource file, and augmenting libgnunetpq to load such resource files "differently".
2) generating the drop logic from the CREATE statements
3) defining a nice and general way for schema migrations beyond "just drop SQL here".
TagsNo tags attached.

Activities

Christian Grothoff

2022-07-28 22:30

manager   ~0018973

Should be much cleaner now.

Issue History

Date Modified Username Field Change
2022-07-05 13:25 Christian Grothoff New Issue
2022-07-05 13:25 Christian Grothoff Assigned To => Christian Grothoff
2022-07-05 13:25 Christian Grothoff Status new => assigned
2022-07-05 13:26 Christian Grothoff Priority normal => high
2022-07-28 22:30 Christian Grothoff Status assigned => resolved
2022-07-28 22:30 Christian Grothoff Resolution open => fixed
2022-07-28 22:30 Christian Grothoff Fixed in Version => 0.9
2022-07-28 22:30 Christian Grothoff Note Added: 0018973
2022-07-28 22:30 Christian Grothoff Target Version => 0.9