http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7167
--- Comment #5 from Paul Poulain <[email protected]> 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
