HEX

File: //usr/lib/python3/dist-packages/trac/upgrades/__pycache__/db18.cpython-310.pyc
o

�k�`��@s$ddlmZmZmZmZdd�ZdS)�)�Table�Column�Index�DatabaseManagerc	Cs~|�d�|�d�|�d�|�d�tddd�td�td	d
d�tdd
d�tdg�td	g�ftd
dd�td�td	d
d�td�td�ftddd�tdd
d�tdd
d�td�td�td�td�tdg�tdg�fg}t|���\}}|D]}|�|�D]}|�|�q}qv|�d�|j�}|�d|�dd
��Wd�n1s�wY|�d�|�d�|�d�|�d�dS) 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)�keyrr�int)�type�
last_visit�session_attribute)rr�namer�value�
ticket_change)�ticket�time�fieldrr�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
            zs2.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_oldzDROP TABLE ticket_change_old)	�executerrrr�
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_upgrades\






��

��


����

��


r'N)�trac.dbrrrrr'r%r%r%r&�<module>s