o k`O @s$ddlmZddlmZddZdS))load_workflow_config_snippet)printoutc Cs|j}|dd}Wdn1swY|d|}|D]3\}}}||} } |r>| dd} | d|d} |rF| d d } | |ksN| |krW|d | | |fq$d |jvr~t|jd |jd} |j | dddd 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_queryconcatexecutefetchallreplaceconfigrsaveloginfor) envvercursordbrreportsreportquery descriptionqd info_messager4/usr/lib/python3/dist-packages/trac/upgrades/db21.py do_upgrades<       rN)trac.ticket.default_workflowrtrac.util.textrrrrrrs