Mercurial > p > roundup > code
comparison roundup/backends/rdbms_common.py @ 2756:b654a33346a6 maint-0.7 0.7.8
merge from HEAD, pre-release stuff
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Thu, 14 Oct 2004 22:28:02 +0000 |
| parents | 1e70e58cf763 |
| children | 638fc2dab5a1 |
comparison
equal
deleted
inserted
replaced
| 2752:e435d2b81547 | 2756:b654a33346a6 |
|---|---|
| 1 # $Id: rdbms_common.py,v 1.98.2.23 2004-10-08 01:29:30 richard Exp $ | 1 # $Id: rdbms_common.py,v 1.98.2.24 2004-10-14 22:28:02 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 |
| 229 return 1 | 229 return 1 |
| 230 | 230 |
| 231 def fix_version_3_tables(self): | 231 def fix_version_3_tables(self): |
| 232 # drop the shorter VARCHAR OTK column and add a new TEXT one | 232 # drop the shorter VARCHAR OTK column and add a new TEXT one |
| 233 for name in ('otk', 'session'): | 233 for name in ('otk', 'session'): |
| 234 self.sql('DELETE FROM %ss'%name) | |
| 234 self.sql('ALTER TABLE %ss DROP %s_value'%(name, name)) | 235 self.sql('ALTER TABLE %ss DROP %s_value'%(name, name)) |
| 235 self.sql('ALTER TABLE %ss ADD %s_value TEXT'%(name, name)) | 236 self.sql('ALTER TABLE %ss ADD %s_value TEXT'%(name, name)) |
| 236 | 237 |
| 237 def fix_version_2_tables(self): | 238 def fix_version_2_tables(self): |
| 238 '''Default (used by sqlite): NOOP''' | 239 '''Default (used by sqlite): NOOP''' |