[Koha-bugs] [Bug 7167] updatedatabase improvements

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7167

--- Comment #5 from Paul Poulain <paul.poulain at biblibre.com> 2011-11-23 15:19:23 UTC ---
The 3 patch attached differs from what has been announced. 90% of the work had
already been done by Jonathan, so I keep his work.

Here is how it works:
* each database update is stored in a numbered file, in
installer/data/mysql/versions
* database updates can be .sql or .pl files. 2 skeletons are provided to
explain how it works
* there is no more automatic checking of the database update on each page. The
librarian/sysadmin must go to the admin/updatedatabase.pl page on each update.
* the updatedatabase.pl script keep track of all updates that have been
applied, how it went. And it's non-linear: 3.7.2.3 can be applied after 3.7.2.4
* The about.pl will display the highest db update applied, but maybe there are
some missing, it's only the highest applied


TEST PLAN:
* install a 3.6.x,
* checkout master branch
* apply the 3 patches attached to this bug
* go to admin > updatedatabase (last line on the right). You'll see 3 upgrades
(that are fakes, they are here just for testing purposes)
* install the 1st one. It should say "OK"
* check about the version is now 3.07.01.001
* install the 2nd one. It should say "OK and about should say 3.07.01.002
* install the 3rd one. It should say "already exist", you can force OK, version
should say 3.07.01.003

do it again:
* install a 3.6.x,
* checkout master branch
* apply the 3 patches attached to this bug
* go to admin > updatedatabase (last line on the right). You'll see 3 upgrades
(that are fakes, they are here just for testing purposes)
* install the 2st one. It should say "OK"
* check about the version is now 3.07.01.002
* install the 1nd one. It should say "OK and about should still say 3.07.01.002
* install the 3rd one. It should say "already exist", and you can force OK,
version should say 3.07.01.004

do it again:
* install a 3.6.x,
* checkout master branch
* apply the 3 patches attached to this bug
* go to admin > updatedatabase (last line on the right). You'll see 3 upgrades
(that are fakes, they are here just for testing purposes)
* install all of them by clicking UPDATE =>  it should say "OK" for 2 and "not
OK" for the 3rd one, and version should be 3.07.01.003

do it again:
* install a master
* apply the 3 patches attached to this bug
* go to admin > updatedatabase (last line on the right). You'll see 3 upgrades
(that are fakes, they are here just for testing purposes)
* Koha should say that they have already been applied, because they were here
on initial install

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.