o

�k�`��@s$dd
lm
Z

ddlmZ
dd�ZdS)�)
�DatabaseManager)
�schemac		s�t|�
j
�d
�
rk|j�V�dd�tD�
}|�dd�dt|�
�
�jg
|�
i}|D]
\}}|�|g��	|�

q*|�
�D]\}}d��f
dd	�|D�
�
}|�d
��|�
|f�

q<Wd�
dS1sdw



Y
dSdS)zZChange `text` type to `mediumtext` type in all columns
    only if MySQL database backend.zmysql:c
Ssg|]}
|
j�qS�)
�name)�.0�tabrr�4/usr/lib/python3/dist-packages/trac/upgrades/db37.py�
<listcomp>szdo_upgrade.<locals>.<listcomp>z�
                SELECT table_name, column_name FROM information_schema.columns
                WHERE table_schema=%%s AND table_name IN (%s)
                AND data_type='text' ORDER BY table_name, column_name
                �
,)
z%sz, c
3s�|]
}
d��|
�
V
qd
S)zMODIFY %s mediumtextN)
�quote)r�col�
�dbrr�	<genexpr>&s�
�zdo_upgrade.<locals>.<genexpr>zALTER TABLE %s %sN)r�connection_uri�
startswith�db_transactionr�execute�join�len�
setdefault�append�itemsr)	�env�version�cursor�tabs�text_columnsrr�cols�modsrr
r�
do_upgrades&


�
�



��"��r N)�trac.db.apir�trac.db_defaultrr rrrr�<module>
s