Mercurial > p > roundup > code
comparison roundup/backends/back_sqlite.py @ 3309:088c1792b7f6 maint-0.8
merge from maint-0-7
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Mon, 02 May 2005 05:48:59 +0000 |
| parents | 43675a5232b1 |
| children |
comparison
equal
deleted
inserted
replaced
| 3304:ae7ddb3eb091 | 3309:088c1792b7f6 |
|---|---|
| 1 # $Id: back_sqlite.py,v 1.36.2.4 2005-02-14 04:37:37 richard Exp $ | 1 # $Id: back_sqlite.py,v 1.36.2.5 2005-05-02 05:47:53 richard Exp $ |
| 2 '''Implements a backend for SQLite. | 2 '''Implements a backend for SQLite. |
| 3 | 3 |
| 4 See https://pysqlite.sourceforge.net/ for pysqlite info | 4 See https://pysqlite.sourceforge.net/ for pysqlite info |
| 5 | 5 |
| 6 | 6 |
| 323 return str(newid) | 323 return str(newid) |
| 324 | 324 |
| 325 def setid(self, classname, setid): | 325 def setid(self, classname, setid): |
| 326 ''' Set the id counter: used during import of database | 326 ''' Set the id counter: used during import of database |
| 327 | 327 |
| 328 We add one to make it behave like the seqeunces in postgres. | 328 We add one to make it behave like the sequences in postgres. |
| 329 ''' | 329 ''' |
| 330 sql = 'update ids set num=%s where name=%s'%(self.arg, self.arg) | 330 sql = 'update ids set num=%s where name=%s'%(self.arg, self.arg) |
| 331 vals = (int(setid)+1, classname) | 331 vals = (int(setid)+1, classname) |
| 332 self.sql(sql, vals) | 332 self.sql(sql, vals) |
| 333 | |
| 334 def clear(self): | |
| 335 rdbms_common.Database.clear(self) | |
| 336 | |
| 337 # set the id counters to 0 (setid adds one) so we start at 1 | |
| 338 for cn in self.classes.keys(): | |
| 339 self.setid(cn, 0) | |
| 333 | 340 |
| 334 def create_class(self, spec): | 341 def create_class(self, spec): |
| 335 rdbms_common.Database.create_class(self, spec) | 342 rdbms_common.Database.create_class(self, spec) |
| 336 sql = 'insert into ids (name, num) values (%s, %s)' | 343 sql = 'insert into ids (name, num) values (%s, %s)' |
| 337 vals = (spec.classname, 1) | 344 vals = (spec.classname, 1) |