Mercurial > genshi > mirror

annotate examples/trac/trac/upgrades/db15.py @ 39:93b4dcbafd7b trunk

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Copy Trac to main branch.
author cmlenz
date Mon, 03 Jul 2006 18:53:27 +0000
parents
children
rev   line source
39
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
1 from trac.db import Table, Column, Index, DatabaseManager
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
2
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
3 def do_upgrade(env, ver, cursor):
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
4 cursor.execute("CREATE TEMPORARY TABLE session_old AS SELECT * FROM session")
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
5 cursor.execute("DROP TABLE session")
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
6
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
7 db = env.get_db_cnx()
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
8 session_table = Table('session', key=('sid', 'authenticated', 'var_name'))[
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
9 Column('sid'),
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
10 Column('authenticated', type='int'),
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
11 Column('var_name'),
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
12 Column('var_value')]
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
13 db_backend, _ = DatabaseManager(env)._get_connector()
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
14 for stmt in db_backend.to_sql(session_table):
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
15 cursor.execute(stmt)
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
16
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
17 cursor.execute("INSERT INTO session (sid,authenticated,var_name,var_value) "
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
18 "SELECT sid,authenticated,var_name,var_value "
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
19 "FROM session_old")
93b4dcbafd7b Copy Trac to main branch.
cmlenz
parents:
diff changeset
20 cursor.execute("DROP TABLE session_old")
Copyright (C) 2012-2017 Edgewall Software