Mercurial > p > roundup > code
comparison roundup/backends/rdbms_common.py @ 1740:5ca448ff8052
don't have RDBMS backends list retired nodes [SF#767319]
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Tue, 12 Aug 2003 02:22:22 +0000 |
| parents | eeb167fb8faf |
| children | ab7760caf6ff 27917dce3814 |
comparison
equal
deleted
inserted
replaced
| 1739:c3f0b552a55a | 1740:5ca448ff8052 |
|---|---|
| 1 # $Id: rdbms_common.py,v 1.57 2003-07-03 23:43:46 richard Exp $ | 1 # $Id: rdbms_common.py,v 1.58 2003-08-12 02:18:46 richard Exp $ |
| 2 ''' Relational database (SQL) backend common code. | 2 ''' Relational database (SQL) backend common code. |
| 3 | 3 |
| 4 Basics: | 4 Basics: |
| 5 | 5 |
| 6 - map roundup classes to relational tables | 6 - map roundup classes to relational tables |
| 1477 self.db.addjournal(self.classname, nodeid, 'retired', None) | 1477 self.db.addjournal(self.classname, nodeid, 'retired', None) |
| 1478 | 1478 |
| 1479 self.fireReactors('retire', nodeid, None) | 1479 self.fireReactors('retire', nodeid, None) |
| 1480 | 1480 |
| 1481 def restore(self, nodeid): | 1481 def restore(self, nodeid): |
| 1482 '''Restpre a retired node. | 1482 '''Restore a retired node. |
| 1483 | 1483 |
| 1484 Make node available for all operations like it was before retirement. | 1484 Make node available for all operations like it was before retirement. |
| 1485 ''' | 1485 ''' |
| 1486 if self.db.journaltag is None: | 1486 if self.db.journaltag is None: |
| 1487 raise DatabaseError, 'Database open read-only' | 1487 raise DatabaseError, 'Database open read-only' |
| 1889 args = args + v | 1889 args = args + v |
| 1890 else: | 1890 else: |
| 1891 where.append('_%s=%s'%(k, a)) | 1891 where.append('_%s=%s'%(k, a)) |
| 1892 args.append(v) | 1892 args.append(v) |
| 1893 | 1893 |
| 1894 # don't match retired nodes | |
| 1895 where.append('__retired__ <> 1') | |
| 1896 | |
| 1894 # add results of full text search | 1897 # add results of full text search |
| 1895 if search_matches is not None: | 1898 if search_matches is not None: |
| 1896 v = search_matches.keys() | 1899 v = search_matches.keys() |
| 1897 s = ','.join([a for x in v]) | 1900 s = ','.join([a for x in v]) |
| 1898 where.append('id in (%s)'%s) | 1901 where.append('id in (%s)'%s) |