Mercurial > p > roundup > code
comparison roundup/backends/back_sqlite.py @ 2645:8250c63c3963
remove space at EOL, add vim modeline
| author | Alexander Smishlajev <a1s@users.sourceforge.net> |
|---|---|
| date | Tue, 27 Jul 2004 11:11:03 +0000 |
| parents | a9e1fff1e793 |
| children | 1cd01cf106e1 |
comparison
equal
deleted
inserted
replaced
| 2644:dad35ada14ad | 2645:8250c63c3963 |
|---|---|
| 1 # $Id: back_sqlite.py,v 1.31 2004-07-27 00:57:18 richard Exp $ | 1 # $Id: back_sqlite.py,v 1.32 2004-07-27 11:11:03 a1s 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 |
| 170 sql = 'drop table %s'%tn | 170 sql = 'drop table %s'%tn |
| 171 self.sql(sql) | 171 self.sql(sql) |
| 172 | 172 |
| 173 # re-create and populate the new table | 173 # re-create and populate the new table |
| 174 self.create_multilink_table(spec, propname) | 174 self.create_multilink_table(spec, propname) |
| 175 sql = '''insert into %s (linkid, nodeid) values | 175 sql = '''insert into %s (linkid, nodeid) values |
| 176 (%s, %s)'''%(tn, self.arg, self.arg) | 176 (%s, %s)'''%(tn, self.arg, self.arg) |
| 177 for linkid, nodeid in rows: | 177 for linkid, nodeid in rows: |
| 178 self.sql(sql, (int(linkid), int(nodeid))) | 178 self.sql(sql, (int(linkid), int(nodeid))) |
| 179 elif old_has(propname): | 179 elif old_has(propname): |
| 180 # we copy this col over from the old table | 180 # we copy this col over from the old table |
| 326 pass | 326 pass |
| 327 | 327 |
| 328 class FileClass(sqliteClass, rdbms_common.FileClass): | 328 class FileClass(sqliteClass, rdbms_common.FileClass): |
| 329 pass | 329 pass |
| 330 | 330 |
| 331 | 331 # vim: set et sts=4 sw=4 : |