U
    \ÚdQ  ã                   @   s<   d Z ddlmZ ddlZdZdZdZdZdd„ Z	dd	„ Z
dS )
zmautomation trigger

Revision ID: d0fb3f178c44
Revises: 1be38bc7c6d3
Create Date: 2022-11-27 21:01:44.108391

é    )ÚopNZd0fb3f178c44Z1be38bc7c6d3c                5   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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jdd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 
d*gd.g¡t 
d,gd/g¡t d¡¡) t jt  d0¡dd$gdd1 t jt  d2¡dd
gdd1 t jt  d3¡ddgdd1 t jt  d4¡dd*gdd1 t jt  d5¡ddgdd1 t jt  d6¡dd)gdd1 t jt  d7¡ddgdd1 t jt  d8¡dd(gdd1 t jt  d9¡dd&gdd1 t jt  d:¡dd%gdd1 t jt  d;¡ddgdd1 t jt  d<¡ddgdd1 t jt  d=¡ddgdd1 t jt  d>¡ddgdd1 t jt  d?¡ddgdd1 t jt  d@¡dd'gdd1 t jt  dA¡dd,gdd1 t jt  dB¡dd-gdd1 t jt  dC¡dd+gdd1 t  dDt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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dEtjdFdddtjdGtjdFdddtjd#t ¡ ddtjdHtjdFd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dItjddddtjdJtjddddtjdKtjddddt 
dIgdLg¡t 
dKgdMg¡t 
d*gd.g¡t 
d,gd/g¡t 
dJgdNg¡t d¡¡1 t jt  dO¡dDdIgdd1 t jt  dP¡dDdKgdd1 t jt  dQ¡dDd$gdd1 t jt  dR¡dDd
gdd1 t jt  dS¡dDdgdd1 t jt  dT¡dDd*gdd1 t jt  dU¡dDdgdd1 t jt  dV¡dDd)gdd1 t jt  dW¡dDdgdd1 t jt  dX¡dDd(gdd1 t jt  dY¡dDd&gdd1 t jt  dZ¡dDd%gdd1 t jt  d[¡dDdgdd1 t jt  d\¡dDdgdd1 t jt  d]¡dDdgdd1 t jt  d^¡dDdgdd1 t jt  d_¡dDdgdd1 t jt  d`¡dDd'gdd1 t jt  da¡dDd,gdd1 t jt  db¡dDd-gdd1 t jt  dc¡dDdJgdd1 t jt  dd¡dDd+gdd1 t  detjdtjdfdddtjd'tjddddtjdgtjddddtjdhtjdidddtjdjtjddddtjdktjddddtjdltjddddtjdmtjddddt 
djgdMg¡t 
dkgdng¡t d¡¡ t jt  do¡dedjgdd1 t jt  dp¡ded'gdd1 t jt  dq¡dedkgdd1 t jt  dr¡dedggdd1 t  dstjdtjdfdddtjd'tjddddtjdgtjddddtjdhtjdidddtjdjtjddddtjdktjddddtjdltjddddtjdmtjddddt 
djgdMg¡t 
dkgdtg¡t d¡¡ t jt  du¡dsdjgdd1 t jt  dv¡dsd'gdd1 t jt  dw¡dsdkgdd1 t jt  dx¡dsdggdd1 d S )yNÚcmf_automation_cron_triggerÚ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Úext_idÚis_favoriteÚhas_tree_nodesÚtree_node_is_branchÚtree_hiddenÚordernoÚperm_publicÚperm_has_aclÚperm_inheritÚperm_parent_owner_idÚperm_inherit_acl_idÚperm_effective_acl_idÚperm_encryptÚ	cron_ruleÚ	eval_codeÚcmf_author_idÚcmf_owner_idÚcmf_owner_assistant_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idÚcmf_import_idÚtree_parent_idÚperm_acl_idÚperm_parent_idzcmf_import.idzcmf_access_list.idÚ,ix_cmf_automation_cron_trigger_cmf_author_id)ÚuniqueÚ-ix_cmf_automation_cron_trigger_cmf_created_atÚ*ix_cmf_automation_cron_trigger_cmf_deletedÚ,ix_cmf_automation_cron_trigger_cmf_import_idÚ,ix_cmf_automation_cron_trigger_cmf_locked_atÚ/ix_cmf_automation_cron_trigger_cmf_locked_by_idÚ.ix_cmf_automation_cron_trigger_cmf_modified_atÚ1ix_cmf_automation_cron_trigger_cmf_modified_by_idÚ5ix_cmf_automation_cron_trigger_cmf_owner_assistant_idÚ+ix_cmf_automation_cron_trigger_cmf_owner_idÚ*ix_cmf_automation_cron_trigger_cmf_versionÚ,ix_cmf_automation_cron_trigger_cmf_viewed_atÚ#ix_cmf_automation_cron_trigger_codeÚ#ix_cmf_automation_cron_trigger_nameÚ&ix_cmf_automation_cron_trigger_ordernoÚ(ix_cmf_automation_cron_trigger_parent_idÚ*ix_cmf_automation_cron_trigger_perm_acl_idÚ-ix_cmf_automation_cron_trigger_perm_parent_idÚ-ix_cmf_automation_cron_trigger_tree_parent_idÚcmf_automation_crud_triggerÚcmf_model_nameé    Úcrud_actionÚ	eval_typeÚactivity_idÚscheme_wf_idÚcall_trigger_idzcmf_activity.idzcmf_automation_crud_trigger.idzcmf_scheme_wf.idÚ*ix_cmf_automation_crud_trigger_activity_idÚ.ix_cmf_automation_crud_trigger_call_trigger_idÚ,ix_cmf_automation_crud_trigger_cmf_author_idÚ-ix_cmf_automation_crud_trigger_cmf_created_atÚ*ix_cmf_automation_crud_trigger_cmf_deletedÚ,ix_cmf_automation_crud_trigger_cmf_import_idÚ,ix_cmf_automation_crud_trigger_cmf_locked_atÚ/ix_cmf_automation_crud_trigger_cmf_locked_by_idÚ.ix_cmf_automation_crud_trigger_cmf_modified_atÚ1ix_cmf_automation_crud_trigger_cmf_modified_by_idÚ5ix_cmf_automation_crud_trigger_cmf_owner_assistant_idÚ+ix_cmf_automation_crud_trigger_cmf_owner_idÚ*ix_cmf_automation_crud_trigger_cmf_versionÚ,ix_cmf_automation_crud_trigger_cmf_viewed_atÚ#ix_cmf_automation_crud_trigger_codeÚ#ix_cmf_automation_crud_trigger_nameÚ&ix_cmf_automation_crud_trigger_ordernoÚ(ix_cmf_automation_crud_trigger_parent_idÚ*ix_cmf_automation_crud_trigger_perm_acl_idÚ-ix_cmf_automation_crud_trigger_perm_parent_idÚ+ix_cmf_automation_crud_trigger_scheme_wf_idÚ-ix_cmf_automation_crud_trigger_tree_parent_idÚ*cmf_automation_crud_trigger_cmf_logic_typeé€   Úroot_idÚdescriptioni   Úleft_idÚright_idÚleft_name_cacheÚright_name_cachezcmf_logic_type.idÚ5ix_cmf_automation_crud_trigger_cmf_logic_type_left_idÚ7ix_cmf_automation_crud_trigger_cmf_logic_type_parent_idÚ6ix_cmf_automation_crud_trigger_cmf_logic_type_right_idÚ5ix_cmf_automation_crud_trigger_cmf_logic_type_root_idÚ'cmf_automation_crud_trigger_cmf_projectzcmf_project.idÚ2ix_cmf_automation_crud_trigger_cmf_project_left_idÚ4ix_cmf_automation_crud_trigger_cmf_project_parent_idÚ3ix_cmf_automation_crud_trigger_cmf_project_right_idÚ2ix_cmf_automation_crud_trigger_cmf_project_root_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚf© r~   r~   ú@/opt/eva-app/alembic/versions/d0fb3f178c44_automation_trigger.pyÚupgrade   sN   Ø*Ð2õõr€   c                   C   s   t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t  d¡ t jt  d¡dd t jt  d	¡dd t jt  d
¡dd t jt  d¡dd t  d¡ t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d ¡dd t jt  d!¡dd t jt  d"¡dd t  d¡ t jt  d#¡d$d t jt  d%¡d$d t jt  d&¡d$d t jt  d'¡d$d t jt  d(¡d$d t jt  d)¡d$d t jt  d*¡d$d t jt  d+¡d$d t jt  d,¡d$d t jt  d-¡d$d t jt  d.¡d$d t jt  d/¡d$d t jt  d0¡d$d t jt  d1¡d$d t jt  d2¡d$d t jt  d3¡d$d t jt  d4¡d$d t jt  d5¡d$d t jt  d6¡d$d t  d$¡ d S )7Nrp   rl   )Ú
table_namero   rn   rm   rk   r`   rj   ri   rh   r_   rB   r^   r]   r\   r[   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rA   r   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r3   r2   r1   r0   r.   )r   Ú
drop_indexr}   Ú
drop_tabler~   r~   r~   r   Ú	downgrade¿   sj    


r„   )Ú__doc__Úalembicr   Ú
sqlalchemyrr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr€   r„   r~   r~   r~   r   Ú<module>   s    -