From 02d24f0b9a74611ab2b0b0770188c1dd3a4f164d Mon Sep 17 00:00:00 2001 From: Max Kanat-Alexander Date: Wed, 2 Feb 2011 00:53:25 -0800 Subject: Bug 630681: Implement a MOD function for SQLite so collectstats.pl can run r=mkanat, a=mkanat (module owner) --- Bugzilla/DB/Sqlite.pm | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Bugzilla/DB/Sqlite.pm b/Bugzilla/DB/Sqlite.pm index 2c3448acf..e40a264f0 100644 --- a/Bugzilla/DB/Sqlite.pm +++ b/Bugzilla/DB/Sqlite.pm @@ -48,6 +48,8 @@ use constant WORD_END => '(?:$|\W)'; # not accent-insensitive). sub _sqlite_collate_ci { lc($_[0]) cmp lc($_[1]) } +sub _sqlite_mod { $_[0] % $_[1] } + sub _sqlite_now { my $now = DateTime->now(time_zone => Bugzilla->local_timezone); return $now->ymd . ' ' . $now->hms; @@ -135,6 +137,7 @@ sub new { # so that's what we use, and I don't know of any way in SQLite to # alias the SQL "substr" function to be called "SUBSTRING". $self->sqlite_create_function('substring', 3, \&CORE::substr); + $self->sqlite_create_function('mod', 2, \&_sqlite_mod); $self->sqlite_create_function('now', 0, \&_sqlite_now); $self->sqlite_create_function('localtimestamp', 1, \&_sqlite_now); $self->sqlite_create_function('floor', 1, \&POSIX::floor); -- cgit v1.2.3-24-g4f1b