Bug 27059

Summary: Adding elapsed times/durations to updatedatabase would be nice.
Product: Koha Reporter: Martin Renvoize (ashimema) <martin.renvoize>
Component: Installation and upgrade (command-line installer)Assignee: Martin Renvoize (ashimema) <martin.renvoize>
Status: CLOSED WONTFIX QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: david.roberts, dcook, fridolin.somers, jon.turner, larry
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on: 24696    
Bug Blocks:    
Attachments: Bug 27059: Add elapsed times to updatedatabase.pl
Bug 27059: Add elapsed times to updatedatabase.pl

Description Martin Renvoize (ashimema) 2020-11-19 15:34:53 UTC
In bug 24696 we added completion times to each step in updatedatabase, it would also be useful to display the elapsed times or time taken per step.
Comment 1 Martin Renvoize (ashimema) 2020-11-19 16:06:34 UTC
Created attachment 113826 [details] [review]
Bug 27059: Add elapsed times to updatedatabase.pl
Comment 2 Martin Renvoize (ashimema) 2020-11-20 15:34:46 UTC
Created attachment 113896 [details] [review]
Bug 27059: Add elapsed times to updatedatabase.pl

This patch adds an elapsed time to the timestamp field for each update.

Test plan
1/ Apply patch
2/ Run updatedatebase
3/ Note the addition of an elapsed time in the output
Comment 3 Fridolin Somers 2021-06-16 15:23:39 UTC
Mmm does not work :

$ ./src/installer/data/mysql/updatedatabase.pl 
Use of uninitialized value $start_time in integer subtraction (-) at ./src/installer/data/mysql/updatedatabase.pl line 24474.
Upgrade to 20.12.00.045 done [17:22:25 (451071h:22m:25s)]: Bug 21249 - Adding new system preference SearchLimitLibrary
Upgrade to 20.12.00.046 done [17:22:25 (00h:00m:00s)]: Bug 14723 - Additional delivery notes to messages
Upgrade to 20.12.00.047 done [17:22:25 (00h:00m:00s)]: Bug 23215 - Remove core PayPal support in favor of the use of plugins
Upgrade to 20.12.00.048 done [17:22:25 (00h:00m:00s)]: Bug 26995 - [SKIP] Drop column relationship from borrower tables [not executed]
Upgrade to 20.12.00.049 done [17:22:25 (00h:00m:00s)]: Bug 28108 - Move action logs 'SERIAL CLAIM' and 'ACQUISITION CLAIM' to a new 'CLAIMS' module
Upgrade to 20.12.00.050 done [17:22:25 (00h:00m:00s)]: Bug 28108 - Add new systempreference OpacHiddenItemsHidesRecord