Mercurial > p > roundup > code
comparison roundup/backends/rdbms_common.py @ 3586:f47bddab5a49
date spec wasn't allowing week intervals
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Fri, 03 Mar 2006 02:02:50 +0000 |
| parents | 5e70726a86dd |
| children | 7b25567f0f54 |
comparison
equal
deleted
inserted
replaced
| 3585:438adf66eb1a | 3586:f47bddab5a49 |
|---|---|
| 13 # BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS | 13 # BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS |
| 14 # FOR A PARTICULAR PURPOSE. THE CODE PROVIDED HEREUNDER IS ON AN "AS IS" | 14 # FOR A PARTICULAR PURPOSE. THE CODE PROVIDED HEREUNDER IS ON AN "AS IS" |
| 15 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE, | 15 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE, |
| 16 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. | 16 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. |
| 17 # | 17 # |
| 18 #$Id: rdbms_common.py,v 1.167 2006-02-09 23:53:11 richard Exp $ | 18 #$Id: rdbms_common.py,v 1.168 2006-03-03 02:02:50 richard Exp $ |
| 19 ''' Relational database (SQL) backend common code. | 19 ''' Relational database (SQL) backend common code. |
| 20 | 20 |
| 21 Basics: | 21 Basics: |
| 22 | 22 |
| 23 - map roundup classes to relational tables | 23 - map roundup classes to relational tables |
| 2128 where.append('_%s._%s in (%s)'%(cn, k, s)) | 2128 where.append('_%s._%s in (%s)'%(cn, k, s)) |
| 2129 args = args + [dc(date.Date(v)) for x in v] | 2129 args = args + [dc(date.Date(v)) for x in v] |
| 2130 else: | 2130 else: |
| 2131 try: | 2131 try: |
| 2132 # Try to filter on range of dates | 2132 # Try to filter on range of dates |
| 2133 date_rng = propclass.range_from_raw (v, self.db) | 2133 date_rng = propclass.range_from_raw(v, self.db) |
| 2134 if date_rng.from_value: | 2134 if date_rng.from_value: |
| 2135 where.append('_%s._%s >= %s'%(cn, k, a)) | 2135 where.append('_%s._%s >= %s'%(cn, k, a)) |
| 2136 args.append(dc(date_rng.from_value)) | 2136 args.append(dc(date_rng.from_value)) |
| 2137 if date_rng.to_value: | 2137 if date_rng.to_value: |
| 2138 where.append('_%s._%s <= %s'%(cn, k, a)) | 2138 where.append('_%s._%s <= %s'%(cn, k, a)) |