diff options
author | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-10-07 12:58:28 +0200 |
---|---|---|
committer | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-10-07 12:58:28 +0200 |
commit | 02a049703de6055f09f44f89a5a821814696ce32 (patch) | |
tree | 5918c91ceea49d280c8c3c0ce795da549a8bf4c6 /Bugzilla/DB.pm | |
parent | 7307c8c748e3245d65a25c016e7d92c6c7ae2aa4 (diff) | |
download | bugzilla-02a049703de6055f09f44f89a5a821814696ce32.tar.gz bugzilla-02a049703de6055f09f44f89a5a821814696ce32.tar.xz |
Bug 602165: Change sql_interval to sql_date_math, in preparation for
MS-SQL and SQLite support.
Diffstat (limited to 'Bugzilla/DB.pm')
-rw-r--r-- | Bugzilla/DB.pm | 25 |
1 files changed, 19 insertions, 6 deletions
diff --git a/Bugzilla/DB.pm b/Bugzilla/DB.pm index 6f1d3e6de..27644fba5 100644 --- a/Bugzilla/DB.pm +++ b/Bugzilla/DB.pm @@ -307,7 +307,7 @@ EOT # List of abstract methods we are checking the derived class implements our @_abstract_methods = qw(new sql_regexp sql_not_regexp sql_limit sql_to_days - sql_date_format sql_interval bz_explain + sql_date_format sql_date_math bz_explain sql_group_concat); # This overridden import method will check implementation of inherited classes @@ -1904,13 +1904,13 @@ Formatted SQL for date formatting (scalar) =back -=item C<sql_interval> +=item C<sql_date_math> =over =item B<Description> -Outputs proper SQL syntax for a time interval function. +Outputs proper SQL syntax for adding some amount of time to a date. Abstract method, should be overridden by database specific code. @@ -1918,15 +1918,28 @@ Abstract method, should be overridden by database specific code. =over -=item C<$interval> - the time interval requested (e.g. '30') (integer) +=item C<$date> -=item C<$units> - the units the interval is in (e.g. 'MINUTE') (string) +C<string> The date being added to or subtracted from. + +=item C<$operator> + +C<string> Either C<-> or C<+>, depending on whether you're subtracting +or adding. + +=item C<$interval> + +C<integer> The time interval you're adding or subtracting (e.g. C<30>) + +=item C<$units> + +C<string> the units the interval is in (e.g. 'MINUTE') =back =item B<Returns> -Formatted SQL for interval function (scalar) +Formatted SQL for adding or subtracting a date and some amount of time (scalar) =back |