Mercurial > genshi > mirror
diff examples/trac/trac/upgrades/db19.py @ 39:93b4dcbafd7b trunk
Copy Trac to main branch.
author | cmlenz |
---|---|
date | Mon, 03 Jul 2006 18:53:27 +0000 |
parents | |
children |
line wrap: on
line diff
new file mode 100644 --- /dev/null +++ b/examples/trac/trac/upgrades/db19.py @@ -0,0 +1,22 @@ +from trac.db import Table, Column, Index, DatabaseManager + +def do_upgrade(env, ver, cursor): + """Rename the column `sql` in the `report` table for compatibity with MySQL. + """ + cursor.execute("CREATE TEMPORARY TABLE report_old AS SELECT * FROM report") + cursor.execute("DROP TABLE report") + + table = Table('report', key='id')[ + Column('id', auto_increment=True), + Column('author'), + Column('title'), + Column('query'), + Column('description') + ] + db_connector, _ = DatabaseManager(env)._get_connector() + for stmt in db_connector.to_sql(table): + cursor.execute(stmt) + + cursor.execute("INSERT INTO report (id,author,title,query,description) " + "SELECT id,author,title,sql,description FROM report_old") + cursor.execute("DROP TABLE report_old")