Mercurial > p > roundup > code
diff roundup/backends/rdbms_common.py @ 1599:cc96bf971b33
extended date syntax to make range searches even more useful
| author | Andrey Lebedev <kedder@users.sourceforge.net> |
|---|---|
| date | Tue, 22 Apr 2003 20:53:55 +0000 |
| parents | 33a0d94c7658 |
| children | 3d627e34f18e |
line wrap: on
line diff
--- a/roundup/backends/rdbms_common.py Mon Apr 21 22:38:48 2003 +0000 +++ b/roundup/backends/rdbms_common.py Tue Apr 22 20:53:55 2003 +0000 @@ -1,4 +1,4 @@ -# $Id: rdbms_common.py,v 1.54 2003-04-20 11:58:45 kedder Exp $ +# $Id: rdbms_common.py,v 1.55 2003-04-22 20:53:54 kedder Exp $ ''' Relational database (SQL) backend common code. Basics: @@ -1852,10 +1852,10 @@ # Try to filter on range of dates date_rng = Range(v, date.Date, offset=timezone) if (date_rng.from_value): - where.append('_%s > %s'%(k, a)) + where.append('_%s >= %s'%(k, a)) args.append(date_rng.from_value.serialise()) if (date_rng.to_value): - where.append('_%s < %s'%(k, a)) + where.append('_%s <= %s'%(k, a)) args.append(date_rng.to_value.serialise()) except ValueError: # If range creation fails - ignore that search parameter @@ -1870,10 +1870,10 @@ # Try to filter on range of intervals date_rng = Range(v, date.Interval) if (date_rng.from_value): - where.append('_%s > %s'%(k, a)) + where.append('_%s >= %s'%(k, a)) args.append(date_rng.from_value.serialise()) if (date_rng.to_value): - where.append('_%s < %s'%(k, a)) + where.append('_%s <= %s'%(k, a)) args.append(date_rng.to_value.serialise()) except ValueError: # If range creation fails - ignore that search parameter