<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 16366 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 189, Issue 10<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Improvement of our upgrade process (dcook@prosentient.com.au)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Wed, 18 Aug 2021 11:36:43 +1000<br>From: <dcook@prosentient.com.au><br>To: "'Jonathan Druart'" <jonathan.druart@bugs.koha-community.org>,<br> "'koha-devel'" <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Improvement of our upgrade process<br>Message-ID: <037e01d793d1$800d9260$8028b720$@prosentient.com.au><br>Content-Type: text/plain; charset="utf-8"<br><br>Sounds good to me.<br><br> <br><br>Is there a time when older versions will be taken out of updatedatabase.pl? At the moment, updatedatabase.pl is over 20,000 lines long. Maybe we could move the old entries into a 3to2105.pl script?<br><br> <br><br>David Cook<br><br>Senior Software Engineer<br><br>Prosentient Systems<br><br>Suite 7.03<br><br>6a Glen St<br><br>Milsons Point NSW 2061<br><br>Australia<br><br> <br><br>Office: 02 9212 0899<br><br>Online: 02 8005 0595<br><br> <br><br>From: Koha-devel <koha-devel-bounces@lists.koha-community.org> On Behalf Of Jonathan Druart<br>Sent: Tuesday, 17 August 2021 7:17 PM<br>To: koha-devel <koha-devel@lists.koha-community.org><br>Subject: [Koha-devel] Improvement of our upgrade process<br><br> <br><br>Hi devs,<br><br> <br><br>Bug 25078 was pushed yesterday and it modifies how we deal with our upgrade process.<br><br> <br><br>I adjusted the wiki page - https://wiki.koha-community.org/wiki/Database_updates<br><br> <br><br>The different things to know about it:<br><br>* The skeleton for atomic updates is modified [1]<br><br>* On push the atomic updates are no longer appended to updatedatabase.pl <http://updatedatabase.pl> but moved to a new db_revs directory (named by version, like 210600016.pl <http://210600016.pl> for the entry 21.06.00.016)<br><br>* Versions from 21.06.00.000 have been migrated to use this new mechanism, older are still in updatabase.pl <http://updatabase.pl> <br><br>* updatabase.pl <http://updatabase.pl> is still the script to call if you want to upgrade the DB<br><br>* Each DB rev (and atomic update) is executed in a transaction that rollbacks and stop the upgrade process if something went wrong<br><br>* Old atomicupdate format will still work (but require more work for the RM)<br><br>* Better error handling and better warnings possible<br><br>* Nicer UI during the upgrade step (step3)<br><br> <br><br>Let me know if you have any questions!<br><br> <br><br>Cheers,<br><br>Jonathan<br><br> <br><br>[1] https://git.koha-community.org/Koha-community/Koha/src/commit/85c395460687f7e359417711b6facd42e0a24f8f/installer/data/mysql/atomicupdate/skeleton.pl<br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210818/764e89b5/attachment-0001.htm><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 189, Issue 10<br>*******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>