Database install/update (migration) scripts
Bug #492494 reported by
Matt Giuca
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
IVLE |
Triaged
|
Medium
|
Matt Giuca |
Bug Description
Provide a script (ivle-installdb) to install the database, and another one
to run all the necessary migrations (ivle-updatedb).
The database should store a table with every migration that's been applied.
The update script should automatically install any migrations which haven't
been applied, in order.
Note: Need to take into account how the debian package will use these.
tags: | added: feature |
To post a comment you must log in.
Update RE Debian package: The Debian package system (apparently) has a way of doing
database migrations which would supersede our own script (but only for debian packages).
This means this script is only required for non-Debian-package based installation.
Hence it is desirable, but not critical.
(A brief summary of the Debian way to do it, as I gather from Will's description: You installed version and the new
have a directory for each debian version, and this directory contains all of the
migrations between the last version and this. The installer automatically runs the
scripts in all the directories between the previously-
version. This is quite different from our non-Debian method, which would involve
keeping track of all the installed migrations.)