Mercurial > p > roundup > code
comparison roundup/backends/rdbms_common.py @ 2755:e3cd28cec23d
Clean out sessions / otks tables when migrating
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Thu, 14 Oct 2004 22:27:59 +0000 |
| parents | ef396596a24e |
| children | 3a2f138fcb28 |
comparison
equal
deleted
inserted
replaced
| 2754:1f89984c0ea5 | 2755:e3cd28cec23d |
|---|---|
| 1 # $Id: rdbms_common.py,v 1.136 2004-10-08 01:28:32 richard Exp $ | 1 # $Id: rdbms_common.py,v 1.137 2004-10-14 22:27:59 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 |
| 248 return 1 | 248 return 1 |
| 249 | 249 |
| 250 def fix_version_3_tables(self): | 250 def fix_version_3_tables(self): |
| 251 # drop the shorter VARCHAR OTK column and add a new TEXT one | 251 # drop the shorter VARCHAR OTK column and add a new TEXT one |
| 252 for name in ('otk', 'session'): | 252 for name in ('otk', 'session'): |
| 253 self.sql('DELETE FROM %ss'%name) | |
| 253 self.sql('ALTER TABLE %ss DROP %s_value'%(name, name)) | 254 self.sql('ALTER TABLE %ss DROP %s_value'%(name, name)) |
| 254 self.sql('ALTER TABLE %ss ADD %s_value TEXT'%(name, name)) | 255 self.sql('ALTER TABLE %ss ADD %s_value TEXT'%(name, name)) |
| 255 | 256 |
| 256 def fix_version_2_tables(self): | 257 def fix_version_2_tables(self): |
| 257 '''Default (used by sqlite): NOOP''' | 258 '''Default (used by sqlite): NOOP''' |