U
    jáÿgçC  ã                   @   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: 301e6ae52d16
Revises: 1f5c20582665
Create Date: 2025-02-13 10:30:00.355780

é    )ÚopN)Ú
postgresqlÚ301e6ae52d16Z1f5c20582665c                2   C   sú  t  dtjdtjddddtjdtjdd	ddtjd
tjdd	ddtjdtjdd	ddtjdtjdd	ddtjdt ¡ ddtjdt ¡ ddtjdtjddddtjdtjddddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt 	¡ ddtjdt ¡ ddtjdt ¡ ddtjd t ¡ ddtjd!tjddddtjd"tjddddtjd#tjddddtjd$t ¡ ddtjd%t ¡ ddtjd&tjddddtjd'tjddddtjd(tjddddtjd)tjddddtjd*tjddddtjd+tjddddtjd,tjddddtjd-tjddddtjd.tjddddtjd/tjddddtjd0tjddddtjd1tjddddt 
d,gd2g¡t 
d0gd3g¡t 
d/gd4g¡t d¡¡. t jt  d5¡dd'gdd6 t jt  d7¡dd
gdd6 t jt  d8¡ddgdd6 t jt  d9¡dd,gdd6 t jt  d:¡ddgdd6 t jt  d;¡dd+gdd6 t jt  d<¡ddgdd6 t jt  d=¡dd*gdd6 t jt  d>¡dd(gdd6 t jt  d?¡ddgdd6 t jt  d@¡ddgdd6 t jt  dA¡ddgdd6 t jt  dB¡ddgdd6 t jt  dC¡ddgdd6 t jt  dD¡dd)gdd6 t jt  dE¡dd0gdd6 t jt  dF¡dd1gdd6 t jt  dG¡dd/gdd6 t jt  dH¡dd.gdd6 t jt  dI¡dd-gdd6 t jdJdKdL t jdMdKdL t jdNdKdL t jdOdKdL t jdPdKdL t jdQdKdL t jdRdKdL t jdSdKdL t jdTdKdL t jdUdKdL t jdVdKdL t jdWdKdL t jdXdKdL t jdYdKdL t jdZdKdL t jd[dKdL t jd\dKdL t jd]dKdL t jd^dKdL t jd_dKdL t  d`¡ t jdadbdcdd t  d dbdd)gdg¡ t jdedfdcdd t  d dfddggdg¡ t  dK¡ d S )hNÚcmf_test_params_rowÚidé@   ©ÚlengthF)ÚnullableÚcmf_locked_atT©ÚtimezoneÚcmf_created_atÚcmf_modified_atÚcmf_viewed_atÚcmf_deletedÚcmf_versionÚnameé   ÚcodeÚsystemÚtextÚimport_originalÚimport_raw_jsonÚext_idÚcmf_archivedÚis_favoriteÚhas_tree_nodesÚtree_node_is_branchÚtree_hiddenÚsl_owner_lockÚordernoÚperm_publicÚperm_has_aclÚperm_inheritÚperm_parent_owner_idÚperm_inherit_acl_idÚperm_effective_acl_idÚ%perm_security_level_allowed_ids_cacheÚperm_encryptÚperm_encrypt_helpÚcmf_author_idÚcmf_owner_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idÚcmf_import_idÚtree_parent_idÚroot_parent_idÚ
project_idÚperm_acl_idÚperm_parent_idúcmf_import.idúcmf_access_list.idúcmf_project.idÚ$ix_cmf_test_params_row_cmf_author_id©ÚuniqueÚ%ix_cmf_test_params_row_cmf_created_atÚ"ix_cmf_test_params_row_cmf_deletedÚ$ix_cmf_test_params_row_cmf_import_idÚ$ix_cmf_test_params_row_cmf_locked_atÚ'ix_cmf_test_params_row_cmf_locked_by_idÚ&ix_cmf_test_params_row_cmf_modified_atÚ)ix_cmf_test_params_row_cmf_modified_by_idÚ#ix_cmf_test_params_row_cmf_owner_idÚ"ix_cmf_test_params_row_cmf_versionÚ$ix_cmf_test_params_row_cmf_viewed_atÚix_cmf_test_params_row_codeÚix_cmf_test_params_row_nameÚix_cmf_test_params_row_ordernoÚ ix_cmf_test_params_row_parent_idÚ"ix_cmf_test_params_row_perm_acl_idÚ%ix_cmf_test_params_row_perm_parent_idÚ!ix_cmf_test_params_row_project_idÚ%ix_cmf_test_params_row_root_parent_idÚ%ix_cmf_test_params_row_tree_parent_idÚ(ix_cmf_testcase_params_row_cmf_author_idÚcmf_testcase_params_row©Ú
table_nameÚ)ix_cmf_testcase_params_row_cmf_created_atÚ&ix_cmf_testcase_params_row_cmf_deletedÚ(ix_cmf_testcase_params_row_cmf_import_idÚ(ix_cmf_testcase_params_row_cmf_locked_atÚ+ix_cmf_testcase_params_row_cmf_locked_by_idÚ*ix_cmf_testcase_params_row_cmf_modified_atÚ-ix_cmf_testcase_params_row_cmf_modified_by_idÚ'ix_cmf_testcase_params_row_cmf_owner_idÚ&ix_cmf_testcase_params_row_cmf_versionÚ(ix_cmf_testcase_params_row_cmf_viewed_atÚix_cmf_testcase_params_row_codeÚix_cmf_testcase_params_row_nameÚ"ix_cmf_testcase_params_row_ordernoÚ$ix_cmf_testcase_params_row_parent_idÚ&ix_cmf_testcase_params_row_perm_acl_idÚ)ix_cmf_testcase_params_row_perm_parent_idÚ%ix_cmf_testcase_params_row_project_idÚ)ix_cmf_testcase_params_row_root_parent_idÚ)ix_cmf_testcase_params_row_tree_parent_idzTRUNCATE TABLE cmf_testcase_runÚ'cmf_test_param_row_value_parent_id_fkeyÚcmf_test_param_row_valueÚ
foreignkey©Útype_Ú#cmf_testcase_run_params_row_id_fkeyÚcmf_testcase_runÚparams_row_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
drop_indexÚexecuteÚdrop_constraintÚcreate_foreign_keyÚ
drop_table© r€   r€   ú5/opt/eva-app/alembic/versions/301e6ae52d16_evatest.pyÚupgrade   sº    Ó/
r‚   c                3   C   sR  t jd ddd t  ddddgdg¡ t jd ddd t  d	ddd
gdg¡ 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dtjdddddtjdt 	¡ dddtjdt 
¡ 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 	¡ dddtjdt ¡ dddtjdt 	¡ dddtjdt ¡ dddtjdt ¡ dddtjdt 	¡ dddtjd t 	¡ dddtjd!t 	¡ dddtjd"t 	¡ dddtjd#t 	¡ dddtjd$t 	¡ dddtjd%t ¡ dddtjd&t 	¡ dddtjd't 	¡ dddtjd(t 	¡ 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,t ¡ dddtjd-t 	¡ 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d0tjdddddtjd
tjdddddtjd1tjdddddtjd2tjdddddtjd3tjdddddtjd4tjdddddtjd5tjdddddtjd6tjdddddtjd7tjdddddtjd8tjdddddtjd3gd9gd:d;tjd7gd<gd=d;tjd6gd>gd?d;tjdd@d;¡. t jdAdd4gddB t jdCdd5gddB t jdDdd6gddB t jdEdd8gddB t jdFdd7gddB t jdGdd
gddB t jdHdd%gddB t jdIddgddB t jdJddgddB t jdKddgddB t jdLddgddB t jdMdd0gddB t jdNdd1gddB t jdOddgddB t jdPdd2gddB t jdQddgddB t jdRdd3gddB t jdSddgddB t jdTddgddB t jdUdd/gddB t jt  dV¡dWdX t jt  dY¡dWdX t jt  dZ¡dWdX t jt  d[¡dWdX t jt  d\¡dWdX t jt  d]¡dWdX t jt  d^¡dWdX t jt  d_¡dWdX t jt  d`¡dWdX t jt  da¡dWdX t jt  db¡dWdX t jt  dc¡dWdX t jt  dd¡dWdX t jt  de¡dWdX t jt  df¡dWdX t jt  dg¡dWdX t jt  dh¡dWdX t jt  di¡dWdX t jt  dj¡dWdX t jt  dk¡dWdX t  dW¡ d S )lNrl   rh   ri   rk   rP   rm   r   rg   rf   r-   r   r   F)Úautoincrementr
   r   Tr   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r    r!   r"   r#   r$   r%   r&   r'   r(   r)   r*   r+   r,   r.   r/   r0   r1   r2   r3   r4   r5   r6   Z*cmf_testcase_params_row_cmf_import_id_fkey)r   r7   Z(cmf_testcase_params_row_perm_acl_id_fkeyr8   Z'cmf_testcase_params_row_project_id_fkeyZcmf_testcase_params_row_pkeyre   r:   rd   rc   rb   ra   r`   r_   r^   r]   r\   r[   rZ   rY   rX   rW   rV   rU   rT   rS   rO   rN   r   rQ   rM   rL   rK   rJ   rI   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r9   )r   r}   r~   rn   ro   rp   ÚVARCHARr   rr   ÚBOOLEANrt   ru   ÚINTEGERrw   rx   ry   r{   rz   r   r€   r€   r€   r   Ú	downgradeu   s¸    Ó/r‡   )Ú__doc__Úalembicr   Ú
sqlalchemyro   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr‚   r‡   r€   r€   r€   r   Ú<module>   s   b