[Koha-patches] [PATCH] Minor updates to minor cronjob script.

Joe Atzberger joe.atzberger at liblime.com
Tue Dec 30 18:20:15 CET 2008


---
 misc/cronjobs/services_throttle.pl |   17 ++++++++++-------
 1 files changed, 10 insertions(+), 7 deletions(-)

diff --git a/misc/cronjobs/services_throttle.pl b/misc/cronjobs/services_throttle.pl
index 0d0d6be..cafc517 100755
--- a/misc/cronjobs/services_throttle.pl
+++ b/misc/cronjobs/services_throttle.pl
@@ -1,7 +1,9 @@
 #!/usr/bin/perl
-#run nightly -- resets the services throttle
+# run nightly -- resets the xisbn services throttle
+
+use strict;
+use warnings;
 
-use strict; use warnings;
 BEGIN {
     # find Koha's Perl modules
     # test carefully before changing this
@@ -10,9 +12,10 @@ BEGIN {
 }
 
 use C4::Context;
-my $dbh=C4::Context->dbh;
 my $fixit="UPDATE services_throttle SET service_count=0 WHERE service_type='xisbn'";
-my $sth=$dbh->prepare($fixit);
-my $res = $sth->execute() or die "can't execute";
-print "$res\n"; #did it work?
-$dbh->disconnect();
+my $sth = C4::Context->dbh->prepare($fixit);
+my $res = $sth->execute() or die "cannot execute query: $fixit";
+
+# There is no need to return anything if we succeeded, 
+# and the die message (or other more internal Context/mysql error) 
+# will get emailed to the cron user if we didn't.
-- 
1.5.5.GIT



More information about the Koha-patches mailing list