o

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

ddlmZ
dd�ZdS)�)
�load_workflow_config_snippet)
�printoutcCs
|j�}|�
d
d�}Wd�
n1sw



Y
|�d�

|��}|D]3\}}}||}	}
|r>|	�dd�}	|	�d|d�}	|rF|
�d	d
�}
|	|ksN|
|krW|�d|	|
|f�
q$d|jv
r~t|jd
�
|j��
d}|j�	|�dd��dd
��

t
|�

dSdS)zUpgrade the workflow.�ownerz' *'Nz)SELECT id, query, description FROM reportz"IN ('new', 'assigned', 'reopened')z<> 'closed'z=(CASE status WHEN 'assigned' THEN %s ELSE owner END) AS ownerz
owner, statuszK * If a ticket has been accepted, a '*' is appended after the owner's name
�zX
                UPDATE report SET query=%s, description=%s WHERE id=%s
                zticket-workflowzoriginal-workflow.inia?


==== Upgrade Notice ====

The ticket Workflow is now configurable.

Your environment has been upgraded, but configured to use the original
workflow. It is recommended that you look at changing this configuration
to use basic-workflow.

Read TracWorkflow for more information
(don't forget to 'wiki upgrade' as well)

�

�
 z==)�db_query�concat�execute�fetchall�replace�configr�save�log�infor)�env�ver�cursor�dbr�reports�report�query�description�
q�
d�info_message�r�4/usr/lib/python3/dist-packages/trac/upgrades/db21.py�
do_upgrades<
�






�
�

�
��





�rN)�trac.ticket.default_workflowr�trac.util.textrrrrrr�<module>
s