ToDo #2839
Create a script/method to check the version of the database and propose to run the missing update scripts
Status:
New
Priority:
Normal
Assignee:
-
Start date:
26/10/2016
Due date:
% Done:
0%
Description
Add a new table "ispyb_schema_version" in pydb containing at least 3 columns: Version, Status, Date.
Each time an update script has been successfully executed, insert a new entry in this table with status = success
The "check" script will scroll all the update scripts present in the folder and compare them to the version stored in the table.
The script will propose to run the update scripts not already run.