Mercurial > genshi > mirror
view examples/trac/trac/upgrades/db12.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 source
sql = [ #-- Some anonymous session might have been left over """DELETE FROM session WHERE username='anonymous';""", #-- Schema change: use an authenticated flag instead of separate sid/username #-- columns """CREATE TEMPORARY TABLE session_old AS SELECT * FROM session;""", """DROP TABLE session;""", """CREATE TABLE session ( sid text, authenticated int, var_name text, var_value text, UNIQUE(sid, var_name) );""", """INSERT INTO session(sid,authenticated,var_name,var_value) SELECT DISTINCT sid,0,var_name,var_value FROM session_old WHERE sid IS NULL;""", """INSERT INTO session(sid,authenticated,var_name,var_value) SELECT DISTINCT username,1,var_name,var_value FROM session_old WHERE sid IS NULL;""", """DROP TABLE session_old;""" ] def do_upgrade(env, ver, cursor): for s in sql: cursor.execute(s)