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� dd� t|�D �}|� d� |� d� |� d� |� d� |� d� |� d � td dd�td dd�td�td�f tddd�tddd�tddd�tddd�td�td�tddg�f tddd�tddd�tddd�tddd�tdd d!�td"d d#d$�td%�td&�tddg�f g}t| ��� \}}|D ]}|�|�D ]}|� |� q�q�|�d'|� |�d(|� |� d)� |�d*|� |� d+� |�d,|� |� d-� d S ).NzvSELECT id FROM repository UNION SELECT repos AS id FROM revision UNION SELECT repos AS id FROM node_change ORDER BY idc S s g | ]\}\}|d |f�qS )� � )�.0�i�namer r �4/usr/lib/python3/dist-packages/trac/upgrades/db24.py� <listcomp> s zdo_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�revr r � )�key_size�time�author�message�node_change)r r �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� enumerater r r r � get_connector�to_sql�executemany) �env�ver�cursor�id_name_list�tables�db_connector�_�table�stmtr r r � do_upgrade sn �� �� ������ � �r2 N)�trac.dbr r r r r2 r r r r �<module> s