|
Server : Apache System : Linux iad1-shared-b8-43 6.6.49-grsec-jammy+ #10 SMP Thu Sep 12 23:23:08 UTC 2024 x86_64 User : dh_edsupp ( 6597262) PHP Version : 8.2.26 Disable Function : NONE Directory : /lib/python3/dist-packages/trac/upgrades/__pycache__/ |
Upload File : |
o
�k�`� � @ s$ d dl mZmZmZmZ dd� ZdS )� )�Table�Column�Index�DatabaseManagerc C s~ |� d� |� d� |� d� |� d� tddd�td�td d
d �td d
d �td g�td g�f td
dd�td�td d
d �td�td�f tddd�tdd
d �tdd
d �td�td�td�td�tdg�tdg�f g}t| ��� \}}|D ]}|�|�D ]}|� |� q}qv|� d� | j�}|� d|�dd
� � W d � n1 s�w Y |� d � |� d � |� d � |� d � d S ) Nz;CREATE TEMPORARY TABLE session_old AS SELECT * FROM sessionzDROP TABLE sessionzGCREATE TEMPORARY TABLE ticket_change_old AS SELECT * FROM ticket_changezDROP TABLE ticket_change�session)�sid�
authenticated)�keyr r �int)�type�
last_visit�session_attribute)r r �namer �value�
ticket_change)�ticket�time�fieldr r �authorr �oldvalue�newvaluez4CREATE INDEX session_old_sid_idx ON session_old(sid)a,
INSERT INTO session (sid, last_visit, authenticated)
SELECT distinct s.sid,COALESCE(%s,0),s.authenticated
FROM session_old AS s LEFT JOIN session_old AS s2
ON (s.sid=s2.sid AND s2.var_name='last_visit')
WHERE s.sid IS NOT NULL
z s2.var_valuez�
INSERT INTO session_attribute (sid, authenticated, name, value)
SELECT s.sid, s.authenticated, s.var_name, s.var_value
FROM session_old s
WHERE s.var_name <> 'last_visit' AND s.sid IS NOT NULL
z�
INSERT INTO ticket_change (ticket, time, author, field, oldvalue,
newvalue)
SELECT ticket, time, author, field, oldvalue, newvalue
FROM ticket_change_old
zDROP TABLE session_oldz DROP TABLE ticket_change_old) �executer r r r �
get_connector�to_sql�db_query�cast) �env�ver�cursor�tables� db_connector�_�table�stmt�db� r% �4/usr/lib/python3/dist-packages/trac/upgrades/db18.py�
do_upgrade s\
��
��
��� �
� �
r' N)�trac.dbr r r r r' r% r% r% r& �<module> s