U
    9ùgØ©  ã                   @   sH   d Z ddlmZ ddlZddlmZ dZdZdZ	dZ
dd„ Zd	d
„ ZdS )zbevatest

Revision ID: b50bdf52415f
Revises: 2b3e3a577edf
Create Date: 2024-12-18 10:34:40.746279

é    )ÚopN)Ú
postgresqlZb50bdf52415fZ2b3e3a577edfc                   C   sâ  t jddd t jddd t jddd t jddd t  d¡ t jddd t jd	dd t jd
dd t jddd t  d¡ t jddd t jddd t jddd t jddd t  d¡ t jddd t jddd t jddd t jddd t  d¡ t jddd t jddd t jddd t jddd t  d¡ t jddd t jddd t jddd t jddd t  d¡ t jd d!d t jd"d!d t jd#d!d t jd$d!d t jd%d!d t jd&d!d t jd'd!d t jd(d!d t jd)d!d t jd*d!d t jd+d!d t jd,d!d t jd-d!d t jd.d!d t jd/d!d t jd0d!d t jd1d!d t jd2d!d t jd3d!d4d5 t jd6d!d4d5 t jd7d!d4d5 t jd8d!d4d5 t jd9d!d4d5 t jd:d!d4d5 t jd;d!d4d5 t jd<d!d4d5 t jd=d!d4d5 t  d!d>¡ t  d!d?¡ t  d!d@¡ t  d!dA¡ t  d!dB¡ t  d!dC¡ t  d!dD¡ t  d!dE¡ t  d!dF¡ t  d!dG¡ t  d!dH¡ t  d!dI¡ t  d!dJ¡ t  d!dK¡ t  d!dL¡ t  d!dM¡ t  d!dN¡ t  d!dO¡ t  d!dP¡ t  d!dQ¡ t  d!dR¡ t  d!dS¡ t  d!dT¡ t  d!dU¡ t  d!dV¡ t  d!dW¡ t  d!dX¡ t  d!dY¡ t  d!dZ¡ t  d!d[¡ t  d!d\¡ t  d!d]¡ t  d!d^¡ t  d!d_¡ t  d!d`¡ t  d!da¡ t  d!db¡ t  d!dc¡ t  d!dd¡ t  d!de¡ t  d!df¡ t  d!dg¡ t  d!dh¡ t  d!di¡ t jdjdkd t jdldkd t jdmdkd t jdndkd t jdodkd t jdpdkd t jdqdkd t jdrdkd t jdsdkd t jdtdkd t jdudkd t jdvdkd t jdwdkd t jdxdkd t jdydkd t jdzdkd t jd{dkd t jd|dkd t jd}dkd t jd~dkd4d5 t jddkd4d5 t jd€dkd4d5 t jddkd4d5 t jd‚dkd4d5 t jdƒdkd4d5 t jd„dkd4d5 t jd…dkd4d5 t jd†dkd4d5 t  dkd>¡ t  dkd?¡ t  dkd@¡ t  dkdA¡ t  dkdB¡ t  dkdC¡ t  dkdD¡ t  dkdE¡ t  dkdF¡ t  dkdG¡ t  dkdH¡ t  dkdI¡ t  dkdJ¡ t  dkdK¡ t  dkdL¡ t  dkdM¡ t  dkdN¡ t  dkdO¡ t  dkdP¡ t  dkdQ¡ t  dkdR¡ t  dkdS¡ t  dkdT¡ t  dkdU¡ t  dkdV¡ t  dkdW¡ t  dkd‡¡ t  dkdX¡ t  dkdY¡ t  dkdZ¡ t  dkd[¡ t  dkd\¡ t  dkd]¡ t  dkd^¡ t  dkd_¡ t  dkd`¡ t  dkda¡ t  dkdb¡ t  dkdc¡ t  dkdd¡ t  dkde¡ t  dkdf¡ t  dkdg¡ t  dkdh¡ t  dkdi¡ d S )ˆNÚ'ix_cmf_testcase_run_local_links_left_idÚcmf_testcase_run_local_links)Ú
table_nameÚ)ix_cmf_testcase_run_local_links_parent_idÚ(ix_cmf_testcase_run_local_links_right_idÚ'ix_cmf_testcase_run_local_links_root_idÚ3ix_cmf_testcycle_testcase_result_spectators_left_idÚ(cmf_testcycle_testcase_result_spectatorsÚ5ix_cmf_testcycle_testcase_result_spectators_parent_idÚ4ix_cmf_testcycle_testcase_result_spectators_right_idÚ3ix_cmf_testcycle_testcase_result_spectators_root_idÚ=ix_cmf_testcycle_testcase_result_cmf_owner_assistants_left_idÚ2cmf_testcycle_testcase_result_cmf_owner_assistantsÚ?ix_cmf_testcycle_testcase_result_cmf_owner_assistants_parent_idÚ>ix_cmf_testcycle_testcase_result_cmf_owner_assistants_right_idÚ=ix_cmf_testcycle_testcase_result_cmf_owner_assistants_root_idÚ0ix_cmf_testcase_run_cmf_owner_assistants_left_idÚ%cmf_testcase_run_cmf_owner_assistantsÚ2ix_cmf_testcase_run_cmf_owner_assistants_parent_idÚ1ix_cmf_testcase_run_cmf_owner_assistants_right_idÚ0ix_cmf_testcase_run_cmf_owner_assistants_root_idÚ2ix_cmf_testcycle_testcase_result_executors_left_idÚ'cmf_testcycle_testcase_result_executorsÚ4ix_cmf_testcycle_testcase_result_executors_parent_idÚ3ix_cmf_testcycle_testcase_result_executors_right_idÚ2ix_cmf_testcycle_testcase_result_executors_root_idÚ4ix_cmf_testcycle_testcase_result_local_links_left_idÚ)cmf_testcycle_testcase_result_local_linksÚ6ix_cmf_testcycle_testcase_result_local_links_parent_idÚ5ix_cmf_testcycle_testcase_result_local_links_right_idÚ4ix_cmf_testcycle_testcase_result_local_links_root_idÚix_cmf_testcase_run_activity_idÚcmf_testcase_runÚix_cmf_testcase_run_alarm_dateÚix_cmf_testcase_run_approvedÚ'ix_cmf_testcase_run_cache_status_opt_idÚ%ix_cmf_testcase_run_cache_status_typeÚ"ix_cmf_testcase_run_cloned_from_idÚ*ix_cmf_testcase_run_cmf_owner_assistant_idÚix_cmf_testcase_run_company_idÚix_cmf_testcase_run_deadlineÚ,ix_cmf_testcase_run_default_task_workflow_idÚix_cmf_testcase_run_is_templateÚ ix_cmf_testcase_run_logic_prefixÚ!ix_cmf_testcase_run_logic_type_idÚ'ix_cmf_testcase_run_parent_logic_prefixÚ*ix_cmf_testcase_run_perm_security_level_idÚ!ix_cmf_testcase_run_resolution_idÚ ix_cmf_testcase_run_scheme_wf_idÚix_cmf_testcase_run_workflow_idÚ cmf_testcase_run_company_id_fkeyÚ
foreignkey)Útype_Ú#cmf_testcase_run_resolution_id_fkeyÚ!cmf_testcase_run_workflow_id_fkeyÚ)cmf_testcase_run_cache_status_opt_id_fkeyÚ#cmf_testcase_run_logic_type_id_fkeyÚ,cmf_testcase_run_perm_security_level_id_fkeyÚ.cmf_testcase_run_default_task_workflow_id_fkeyÚ"cmf_testcase_run_scheme_wf_id_fkeyÚ!cmf_testcase_run_activity_id_fkeyÚis_templateÚmarkÚ	is_publicÚlogic_type_idÚui_view_form_optionsÚperm_security_level_idÚ
alarm_dateÚcloned_from_idÚapprovedÚperiod_next_dateÚresolution_idÚplan_end_dateÚperm_policyÚstatus_review_atÚ
company_idÚis_public_editableÚstatus_closed_atÚdeadlineÚplan_start_dateÚparent_logic_prefixÚdefault_task_workflow_idÚcmf_owner_assistant_idÚlogic_prefixÚuser_rating_countÚ
is_penaltyÚstatus_in_progress_startÚis_public_commentsÚui_view_formÚworkflow_idÚstatus_modified_atÚsharelink_hashÚperm_policy_guestÚuser_ratingÚperm_policy_sharelinkÚcache_status_typeÚscheme_wf_idÚhas_children_archivedÚstatus_in_progress_endÚcache_fieldsÚperm_policy_anonymousÚcache_status_opt_idÚperiod_intervalÚ
no_controlÚactivity_idÚ,ix_cmf_testcycle_testcase_result_activity_idÚcmf_testcycle_testcase_resultÚ+ix_cmf_testcycle_testcase_result_alarm_dateÚ)ix_cmf_testcycle_testcase_result_approvedÚ4ix_cmf_testcycle_testcase_result_cache_status_opt_idÚ2ix_cmf_testcycle_testcase_result_cache_status_typeÚ/ix_cmf_testcycle_testcase_result_cloned_from_idÚ7ix_cmf_testcycle_testcase_result_cmf_owner_assistant_idÚ+ix_cmf_testcycle_testcase_result_company_idÚ)ix_cmf_testcycle_testcase_result_deadlineÚ9ix_cmf_testcycle_testcase_result_default_task_workflow_idÚ,ix_cmf_testcycle_testcase_result_is_templateÚ-ix_cmf_testcycle_testcase_result_logic_prefixÚ.ix_cmf_testcycle_testcase_result_logic_type_idÚ4ix_cmf_testcycle_testcase_result_parent_logic_prefixÚ7ix_cmf_testcycle_testcase_result_perm_security_level_idÚ.ix_cmf_testcycle_testcase_result_resolution_idÚ-ix_cmf_testcycle_testcase_result_scheme_wf_idÚ/ix_cmf_testcycle_testcase_result_waiting_for_idÚ,ix_cmf_testcycle_testcase_result_workflow_idÚ9cmf_testcycle_testcase_result_perm_security_level_id_fkeyÚ;cmf_testcycle_testcase_result_default_task_workflow_id_fkeyÚ0cmf_testcycle_testcase_result_resolution_id_fkeyÚ.cmf_testcycle_testcase_result_activity_id_fkeyÚ-cmf_testcycle_testcase_result_company_id_fkeyÚ6cmf_testcycle_testcase_result_cache_status_opt_id_fkeyÚ0cmf_testcycle_testcase_result_logic_type_id_fkeyÚ.cmf_testcycle_testcase_result_workflow_id_fkeyÚ/cmf_testcycle_testcase_result_scheme_wf_id_fkeyÚwaiting_for_id)r   Ú
drop_indexÚ
drop_tableÚdrop_constraintÚdrop_column© r   r   ú5/opt/eva-app/alembic/versions/b50bdf52415f_evatest.pyÚupgrade   s\   





r‘   c                   C   sÆ  t  dtjdtjddddd¡ t  dtjdt ¡ ddd¡ t  dtjd	tjd
dddd¡ t  dtjdtjddddd¡ t  dtjdtjd
dddd¡ t  dtjdt ¡ ddd¡ t  dtjdtjddddd¡ t  dtjdt ¡ ddd¡ t  dtjdtjddddd¡ t  dtjdtjd
dddd¡ t  dtjdtjd
dddd¡ t  dtjdtj	dddddd¡ t  dtjdtjd
dddd¡ t  dtjdtjd
dddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjdtjd
dddd¡ t  dtjdt ¡ ddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjd t ¡ ddd¡ t  dtjd!t 
¡ ddd¡ t  dtjd"t ¡ ddd¡ t  dtjd#tjddddd¡ t  dtjd$tjddddd¡ t  dtjd%t ¡ ddd¡ t  dtjd&tjddddd¡ t  dtjd'tjddddd¡ t  dtjd(tjddddd¡ t  dtjd)t ¡ ddd¡ t  dtjd*tjddddd¡ t  dtjd+tjddddd¡ t  dtjd,tjd
dddd¡ t  dtjd-tjddddd¡ t  dtjd.tjddddd¡ t  dtjd/tjddddd¡ t  dtjd0t ¡ ddd¡ t  dtjd1tjddddd¡ t  dtjd2tjddddd¡ t  dtjd3tjddddd¡ t  dtjd4t ¡ ddd¡ t  dtjd5tjddddd¡ t  dtjd6t ¡ ddd¡ t  dtjd7tjd
dddd¡ t  dtjd8t ¡ ddd¡ t  d9dd:dgd;g¡ t  d<dd=dgd;g¡ t  d>dd?d5gd;g¡ t  d@ddAdgd;g¡ t  dBddCd*gd;g¡ t  dDddEdgd;g¡ t  dFddGd.gd;g¡ t  dHdd=d$gd;g¡ t  dIddJd3gd;g¡ t jdKddgddL t jdMddgddL t jdNddgddL t jdOdd.gddL t jdPdd3gddL t jdQdd%gddL t jdRdd5gddL t jdSdd"gddL t jdTdd8gddL t jdUdd$gddL t jdVdd'gddL t jdWdd*gddL t jdXdd#gddL t jdYdd1gddL t jdZddgddL t jd[ddgddL t jd\dd0gddL t jd]dd2gddL t jd^ddgddL t  d_tjdtjddddd¡ t  d_tjdt ¡ ddd¡ t  d_tjd	tjd
dddd¡ t  d_tjdtjddddd¡ t  d_tjdtjd
dddd¡ t  d_tjdt ¡ ddd¡ t  d_tjdtjddddd¡ t  d_tjdt ¡ ddd¡ t  d_tjdtjddddd¡ t  d_tjdtjd
dddd¡ t  d_tjdtjd
dddd¡ t  d_tjdtj	dddddd¡ t  d_tjdtjd
dddd¡ t  d_tjdtjd
dddd¡ t  d_tjdtjddddd¡ t  d_tjdtjddddd¡ t  d_tjdtjd
dddd¡ t  d_tjdt ¡ ddd¡ t  d_tjdtjddddd¡ t  d_tjd t ¡ ddd¡ t  d_tjd!t 
¡ ddd¡ t  d_tjd"t ¡ ddd¡ t  d_tjd#tjddddd¡ t  d_tjd$tjddddd¡ t  d_tjd%t ¡ ddd¡ t  d_tjd&tjddddd¡ t  d_tjd'tjddddd¡ t  d_tjd(tjddddd¡ t  d_tjd)t ¡ ddd¡ t  d_tjd*tjddddd¡ t  d_tjd+tjddddd¡ t  d_tjd,tjd
dddd¡ t  d_tjd-tjddddd¡ t  d_tjd.tjddddd¡ t  d_tjd/tjddddd¡ t  d_tjd0t ¡ ddd¡ t  d_tjd1tjddddd¡ t  d_tjd2tjddddd¡ t  d_tjd3tjddddd¡ t  d_tjd4t ¡ ddd¡ t  d_tjd5tjddddd¡ t  d_tjd6t ¡ ddd¡ t  d_tjd7tjd
dddd¡ t  d_tjd8t ¡ ddd¡ t  d`d_dEdgd;g¡ t  dad_d:dgd;g¡ t  dbd_d=d$gd;g¡ t  dcd_dJd3gd;g¡ t  ddd_d?d5gd;g¡ t  ded_dAdgd;g¡ t  dfd_d=dgd;g¡ t  dgd_dGd.gd;g¡ t  dhd_dCd*gd;g¡ t jdid_dgddL t jdjd_dgddL t jdkd_d.gddL t jdld_d3gddL t jdmd_d%gddL t jdnd_d5gddL t jdod_d"gddL t jdpd_d8gddL t jdqd_d$gddL t jdrd_d'gddL t jdsd_d*gddL t jdtd_d#gddL t jdud_d1gddL t jdvd_dgddL t jdwd_dgddL t jdxd_d0gddL t jdyd_d2gddL t jdzd_dgddL t  d{tjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjd€ddddtjdtjdddddtjd‚tjdddddtjdƒtjd„ddddtjd…tjd„ddddtjd;d†d‡¡
 t jdˆd{d~gddL t jd‰d{d‚gddL t jdŠd{d}gddL t jd‹d{dgddL t  dŒtjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjd€ddddtjdtjdddddtjd‚tjdddddtjdƒtjd„ddddtjd…tjd„ddddtjd;dd‡¡
 t jdŽdŒd~gddL t jddŒd‚gddL t jddŒd}gddL t jd‘dŒdgddL t  d’tjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjd€ddddtjdtjdddddtjd‚tjdddddtjdƒtjd„ddddtjd…tjd„ddddtjd;d“d‡¡
 t jd”d’d~gddL t jd•d’d‚gddL t jd–d’d}gddL t jd—d’dgddL t  d˜tjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjd€ddddtjdtjdddddtjd‚tjdddddtjdƒtjd„ddddtjd…tjd„ddddtjd;d™d‡¡
 t jdšd˜d~gddL t jd›d˜d‚gddL t jdœd˜d}gddL t jdd˜dgddL t  džtjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjd€ddddtjdtjdddddtjd‚tjdddddtjdƒtjd„ddddtjd…tjd„ddddtjd;dŸd‡¡
 t jd džd~gddL t jd¡džd‚gddL t jd¢džd}gddL t jd£dždgddL t  d¤tjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjd€ddddtjdtjdddddtjd‚tjdddddtjdƒtjd„ddddtjd…tjd„ddddtjd;d¥d‡¡
 t jd¦d¤d~gddL t jd§d¤d‚gddL t jd¨d¤d}gddL t jd©d¤dgddL d S )ªNrn   rl   é@   )ÚlengthFT)ÚautoincrementÚnullablerk   rj   é    ri   rh   rg   rf   )Útimezonere   rd   rc   rb   ra   é   é   )Ú	precisionÚscaler`   r_   r^   r]   r\   r[   rŠ   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rI   rH   rG   rF   rE   rD   rC   rB   rA   r‰   Úcmf_scheme_wfÚidrˆ   Úcmf_workflowr‡   Úcmf_logic_typer†   Úcmf_status_optr…   Úcmf_companyr„   Úcmf_activityrƒ   Úcmf_resolutionr‚   r   Úcmf_security_levelr€   )Úuniquer   r~   r}   r|   r{   rz   ry   rx   rw   rv   ru   rt   rs   rr   rq   rp   ro   rm   r$   r@   r?   r>   r=   r<   r;   r:   r9   r6   r5   r4   r3   r2   r1   r0   r/   r.   r-   r,   r+   r*   r)   r(   r'   r&   r%   r#   r   é€   Ú	parent_idÚroot_idÚdescriptioni   Úleft_idÚright_idÚleft_name_cacheé   Úright_name_cacheZ.cmf_testcycle_testcase_result_local_links_pkey)Únamer"   r!   r    r   r   Z,cmf_testcycle_testcase_result_executors_pkeyr   r   r   r   r   Z*cmf_testcase_run_cmf_owner_assistants_pkeyr   r   r   r   r   Z7cmf_testcycle_testcase_result_cmf_owner_assistants_pkeyr   r   r   r   r   Z-cmf_testcycle_testcase_result_spectators_pkeyr   r   r   r
   r   Z!cmf_testcase_run_local_links_pkeyr	   r   r   r   )r   Ú
add_columnÚsaÚColumnÚVARCHARÚBOOLEANÚTEXTr   Ú	TIMESTAMPÚNUMERICÚINTEGERÚcreate_foreign_keyÚcreate_indexÚcreate_tableÚPrimaryKeyConstraintr   r   r   r   Ú	downgradeÆ   sÔ   """"""""$"""""""""""""""""""""""""""""""$""""""""""""""""""""""÷÷÷÷÷÷r½   )Ú__doc__Úalembicr   Ú
sqlalchemyr±   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr‘   r½   r   r   r   r   Ú<module>   s    4