Trees	Indices	Help	Trac

Package trac :: Package upgrades :: Module db9

Source Code for Module trac.upgrades.db9

 1 import time 
 2 
 3 sql  = [ 
 4 #-- Remove the unused lock table 
 5 """DROP TABLE lock;""", 
 6 #-- Separate anonymous from authenticated sessions. 
 7 """CREATE TEMPORARY TABLE session_old AS SELECT * FROM session;""", 
 8 """DELETE FROM session;""", 
 9 """INSERT INTO session (username,var_name,var_value) 
10  SELECT username,var_name,var_value FROM session_old 
11  WHERE sid IN (SELECT DISTINCT sid FROM session_old 
12  WHERE username!='anonymous' AND var_name='last_visit' 
13  GROUP BY username ORDER BY var_value DESC);""", 
14 """INSERT INTO session (sid,username,var_name,var_value) 
15  SELECT sid,username,var_name,var_value FROM session_old 
16  WHERE username='anonymous';""", 
17 """DROP TABLE session_old;""" 
18 ] 
19 
20 - def do_upgrade (env, ver, cursor): 
21  for s in sql : 
22  cursor .execute (s) 
23 

Trees	Indices	Help	Trac