--- a/hooks/syncschema.py Tue Dec 14 15:08:23 2010 +0100
+++ b/hooks/syncschema.py Sat Dec 18 23:11:58 2010 +0100
@@ -285,13 +285,15 @@
self.session.vreg.schema.rename_entity_type(oldname, newname)
# we need sql to operate physical changes on the system database
sqlexec = self.session.system_sql
- sqlexec('ALTER TABLE %s%s RENAME TO %s%s' % (SQL_PREFIX, oldname,
- SQL_PREFIX, newname))
+ dbhelper= self.session.pool.source('system').dbhelper
+ sql = dbhelper.sql_rename_table(SQL_PREFIX+oldname,
+ SQL_PREFIX+newname)
+ sqlexec(sql)
self.info('renamed table %s to %s', oldname, newname)
- sqlexec('UPDATE entities SET type=%s WHERE type=%s',
- (newname, oldname))
- sqlexec('UPDATE deleted_entities SET type=%s WHERE type=%s',
- (newname, oldname))
+ sqlexec('UPDATE entities SET type=%(newname)s WHERE type=%(oldname)s',
+ {'newname': newname, 'oldname': oldname})
+ sqlexec('UPDATE deleted_entities SET type=%(newname)s WHERE type=%(oldname)s',
+ {'newname': newname, 'oldname': oldname})
# XXX transaction records
def precommit_event(self):