aboutsummaryrefslogtreecommitdiffstats
path: root/sanitycheck.cgi
diff options
context:
space:
mode:
authorMax Kanat-Alexander <mkanat@bugzilla.org>2010-10-07 03:58:28 -0700
committerMax Kanat-Alexander <mkanat@bugzilla.org>2010-10-07 03:58:28 -0700
commit02a049703de6055f09f44f89a5a821814696ce32 (patch)
tree5918c91ceea49d280c8c3c0ce795da549a8bf4c6 /sanitycheck.cgi
parent7307c8c748e3245d65a25c016e7d92c6c7ae2aa4 (diff)
downloadbugs-02a049703de6055f09f44f89a5a821814696ce32.tar
bugs-02a049703de6055f09f44f89a5a821814696ce32.tar.gz
bugs-02a049703de6055f09f44f89a5a821814696ce32.tar.bz2
bugs-02a049703de6055f09f44f89a5a821814696ce32.tar.xz
bugs-02a049703de6055f09f44f89a5a821814696ce32.zip
Bug 602165: Change sql_interval to sql_date_math, in preparation for
MS-SQL and SQLite support.
Diffstat (limited to 'sanitycheck.cgi')
-rwxr-xr-xsanitycheck.cgi8
1 files changed, 4 insertions, 4 deletions
diff --git a/sanitycheck.cgi b/sanitycheck.cgi
index 63872bd49..a4f9832b0 100755
--- a/sanitycheck.cgi
+++ b/sanitycheck.cgi
@@ -229,14 +229,14 @@ if ($cgi->param('rescanallBugMail')) {
require Bugzilla::BugMail;
Status('send_bugmail_start');
- my $time = $dbh->sql_interval(30, 'MINUTE');
+ my $time = $dbh->sql_date_math('NOW()', '-', 30, 'MINUTE');
my $list = $dbh->selectcol_arrayref(qq{
SELECT bug_id
FROM bugs
WHERE (lastdiffed IS NULL
OR lastdiffed < delta_ts)
- AND delta_ts < now() - $time
+ AND delta_ts < $time
ORDER BY bug_id});
Status('send_bugmail_status', {bug_count => scalar(@$list)});
@@ -857,12 +857,12 @@ BugCheck("bugs
Status('unsent_bugmail_check');
-my $time = $dbh->sql_interval(30, 'MINUTE');
+my $time = $dbh->sql_date_math('NOW()', '-', 30, 'MINUTE');
my $badbugs = $dbh->selectcol_arrayref(qq{
SELECT bug_id
FROM bugs
WHERE (lastdiffed IS NULL OR lastdiffed < delta_ts)
- AND delta_ts < now() - $time
+ AND delta_ts < $time
ORDER BY bug_id});