Mercurial > p > roundup > code

comparison roundup/backends/rdbms_common.py @ 3821:5ed4c9d30148

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Handling of unset Link search in RDBMS backend
author Richard Jones <richard@users.sourceforge.net>
date Tue, 20 Feb 2007 05:30:17 +0000
parents 0d561b24ceff
children 8068eb6c704e
comparison
equal deleted inserted replaced
3820:771248aa8302 3821:5ed4c9d30148
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.182 2006-10-04 01:12:00 richard Exp $ 18 #$Id: rdbms_common.py,v 1.183 2007-02-20 05:30:17 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
2173 if entry == '-1': 2173 if entry == '-1':
2174 entry = None 2174 entry = None
2175 d[entry] = entry 2175 d[entry] = entry
2176 l = [] 2176 l = []
2177 if d.has_key(None) or not d: 2177 if d.has_key(None) or not d:
2178 del d[None] 2178 if d.has_key(None): del d[None]
2179 l.append('_%s._%s is NULL'%(pln, k)) 2179 l.append('_%s._%s is NULL'%(pln, k))
2180 if d: 2180 if d:
2181 v = d.keys() 2181 v = d.keys()
2182 s = ','.join([a for x in v]) 2182 s = ','.join([a for x in v])
2183 l.append('(_%s._%s in (%s))'%(pln, k, s)) 2183 l.append('(_%s._%s in (%s))'%(pln, k, s))
Roundup Issue Tracker: http://roundup-tracker.org/