o

�k�`=
�@s$dd
lm
Z
mZmZmZ
dd�ZdS)�)�Table�Column�Index�DatabaseManagerc	
Cs�
|�d
�

dd�t
|�
D�
}|�d�

|�d�

|�d�

|�d�

|�d�

|�d	�

td
dd�td
dd�td�
td�
ftddd�tddd�tddd�tddd�td�
td�
tddg�
ftddd�tddd�tddd�tddd�tdd d!�td"d d#d$�td%�
td&�
tddg�
fg}t|�
��\}}|D]}|�|�
D]}|�|�

q�q�|�d'|�
|�d(|�
|�d)�

|�d*|�
|�d+�

|�d,|�
|�d-�

dS).NzvSELECT id FROM repository UNION SELECT repos AS id FROM revision UNION SELECT repos AS id FROM node_change ORDER BY idc
Ssg|]\}
\
}|
d|f�qS)
�
�)�.0�
i�namerr�4/usr/lib/python3/dist-packages/trac/upgrades/db24.py�
<listcomp>szdo_upgrade.<locals>.<listcomp>z;CREATE TEMPORARY TABLE repo_old AS SELECT * FROM repositoryzDROP TABLE repositoryz8CREATE TEMPORARY TABLE rev_old AS SELECT * FROM revisionzDROP TABLE revisionz:CREATE TEMPORARY TABLE nc_old AS SELECT * FROM node_changezDROP TABLE node_change�
repository)�idr
)
�keyr�int)
�typer
�value�revision)�repos�revrr�)
�key_size�time�author�message�node_change)rr�path�change_typer��	node_typer)
�sizer�)r r�	base_path�base_revz<INSERT INTO repository (id,name,value) VALUES (%s,'name',%s)zUINSERT INTO repository (id,name,value) SELECT %s,name,value FROM repo_old WHERE id=%szDROP TABLE repo_oldzrINSERT INTO revision (repos,rev,time,author,message) SELECT %s,rev,time,author,message FROM rev_old WHERE repos=%szDROP TABLE rev_oldz�INSERT INTO node_change (repos,rev,path,node_type,  change_type,base_path,base_rev) SELECT %s,rev,path,node_type,change_type,base_path,  base_rev FROM nc_old WHERE repos=%szDROP TABLE nc_old)	�execute�	enumeraterrrr�
get_connector�to_sql�executemany)	�env�ver�cursor�id_name_list�tables�db_connector�
_�table�stmtrrr�
do_upgradesn













��










��













���


�
��

�

�r2N)�trac.dbrrrrr2rrrr�<module>
s