]> git.koha-community.org Git - koha.git/commit
Bug 37775: Remove delayed commits from update_totalissues.pl and add progress option
authorNick Clemens <nick@bywatersolutions.com>
Fri, 30 Aug 2024 12:47:07 +0000 (12:47 +0000)
committerLucas Gass <lucas@bywatersolutions.com>
Tue, 24 Sep 2024 15:25:26 +0000 (15:25 +0000)
commit8fd510cc567ec0dc1a87b6fa4abf8b5e9c208435
tree133f1d7aaaf5f59c0c4848f556d06c2b1bbaad99
parenta40b6d538d8e4b808cd9a65bca4f2281895fc186
Bug 37775: Remove delayed commits from update_totalissues.pl and add progress option

This patch removes setting AutoCommit to 0 and commiting only every X records.
Instead we commit as we go and report progress using a parameter.

Bug 36474 reduced the numebr of changes that are being committed, so this should be a reasonable change. The
use of commits without transactions was causing problems if the library was active while the script ran.

To test:
1 - perl misc/cronjobs/update_totalissues.pl -c
2 - Script runs, but with unknown parameter
3 - perl misc/cronjobs/update_totalissues.pl -p 10
4 - Script runs and reports every 10 records
5 - per; misc/cronjobs/update_totalissues.pl
6 - Script runs and reports every 100 records by default

Signed-off-by: Brendan Lawlor <blawlor@clamsnet.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit dba9dd405339691a8671c243518f16cb20f4777f)
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
misc/cronjobs/update_totalissues.pl