View Issue Details

IDProjectCategoryView StatusLast Update
0007277Talerexchangepublic2024-01-12 13:05
ReporterChristian Grothoff Assigned ToChristian Grothoff Resolution deadline
ImplementerReviewer 
Release signed byDeployed by 
VerifierCommunicator 
Data protection authority notification requiredNo  
CSIRT notification requiredNo  
Estimated effort (hours)Actual effort (hours)0 
Fast-trackNo
Work packagenone
PriorityhighSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
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.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Christian Grothoff

2022-07-28 20:30

manager   ~0018973

Should be much cleaner now.

Issue History

Date ModifiedUsernameFieldChange
2022-07-05 11:25Christian GrothoffNew Issue
2022-07-05 11:25Christian GrothoffAssigned To => Christian Grothoff
2022-07-05 11:25Christian GrothoffStatusnew => assigned
2022-07-05 11:26Christian GrothoffPrioritynormal => high
2022-07-28 20:30Christian GrothoffStatusassigned => informing
2022-07-28 20:30Christian GrothoffResolutionopen => fixed
2022-07-28 20:30Christian GrothoffFixed in Version => 0.9
2022-07-28 20:30Christian GrothoffNote Added: 0018973
2022-07-28 20:30Christian GrothoffTarget Version => 0.9
2022-11-04 19:53Christian GrothoffStatusinforming => closed
2024-01-12 13:05Christian GrothoffCategoryexchange Postgres DB backend => exchange