Mercurial > p > roundup > code
diff roundup/backends/indexer_rdbms.py @ 3718:0d561b24ceff
support sqlite3
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Wed, 04 Oct 2006 01:12:00 +0000 |
| parents | b31a2e35be80 |
| children | 82e116d515d2 |
line wrap: on
line diff
--- a/roundup/backends/indexer_rdbms.py Tue Oct 03 23:28:51 2006 +0000 +++ b/roundup/backends/indexer_rdbms.py Wed Oct 04 01:12:00 2006 +0000 @@ -1,4 +1,4 @@ -#$Id: indexer_rdbms.py,v 1.14 2006-05-06 16:19:27 a1s Exp $ +#$Id: indexer_rdbms.py,v 1.15 2006-10-04 01:12:00 richard Exp $ ''' This implements the full-text indexer over two RDBMS tables. The first is a mapping of words to occurance IDs. The second maps the IDs to (Class, propname, itemid) instances. @@ -95,7 +95,7 @@ a = ','.join([self.db.arg] * len(r)) sql = 'select _class, _itemid, _prop from __textids '\ 'where _textid in (%s)'%a - self.db.cursor.execute(sql, tuple([int(id) for (id,) in r])) + self.db.cursor.execute(sql, tuple([int(row[0]) for row in r])) else: # A more complex version for MySQL since it doesn't implement INTERSECT
