U
    z]f‰q  ă                   @   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 )zcasset v2

Revision ID: 4eeaf4305980
Revises: 04e5270f74a3
Create Date: 2024-02-27 21:58:52.116097

é    )ÚopN)Ú
postgresqlÚ4eeaf4305980Ú04e5270f74a3c                	   C   sV  t  dtjdtjddŤddŤˇ t  dtjdtjddŤddŤˇ t  dtjd	t ˇ d
ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ d
ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdtjddŤddŤˇ t  dtjdtjddŤddŤˇ t  dtjdtjddŤddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdt ˇ ddŤˇ t  dtjdtjddŤddŤˇ t  dtjd tjddŤddŤˇ t  dtjd!tjddŤddŤˇ t  dtjd"tjddŤddŤˇ t jt  	d#ˇddgd
d$Ť t jt  	d%ˇddgdd$Ť t jt  	d&ˇddgd
d$Ť t jt  	d'ˇddgd
d$Ť t jt  	d(ˇdd!gd
d$Ť t jt  	d)ˇdd"gd
d$Ť t jt  	d*ˇdd gd
d$Ť t  
d dd+d!gd,gˇ t  
d dd-dgd,gˇ t  d.tjdtjddŤddŤˇ t  d.tjdtjddŤddŤˇ t  d.tjd	t ˇ d
ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ d
ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdtjddŤddŤˇ t  d.tjdtjddŤddŤˇ t  d.tjdtjddŤddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdt ˇ ddŤˇ t  d.tjdtjddŤddŤˇ t  d.tjd/tjddŤddŤˇ t  d.tjd tjddŤddŤˇ t  d.tjd!tjddŤddŤˇ t  d.tjd"tjddŤddŤˇ t jt  	d0ˇd.dgd
d$Ť t jt  	d1ˇd.dgdd$Ť t jt  	d2ˇd.dgd
d$Ť t jt  	d3ˇd.dgd
d$Ť t jt  	d4ˇd.d!gd
d$Ť t jt  	d5ˇd.d"gd
d$Ť t jt  	d6ˇd.d gd
d$Ť t jt  	d7ˇd.d/gd
d$Ť t  
d d.d-dgd,gˇ t  
d d.d+d!gd,gˇ t  d8tjdtjddŤddŤˇ t  d8tjdtjddŤddŤˇ t  d8tjd	t ˇ d
ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ d
ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdtjddŤddŤˇ t  d8tjdtjddŤddŤˇ t  d8tjdtjddŤddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdt ˇ ddŤˇ t  d8tjdtjddŤddŤˇ t  d8tjd/tjddŤddŤˇ t  d8tjd tjddŤddŤˇ t  d8tjd!tjddŤddŤˇ t  d8tjd"tjddŤddŤˇ t jt  	d9ˇd8dgd
d$Ť t jt  	d:ˇd8dgdd$Ť t jt  	d;ˇd8dgd
d$Ť t jt  	d<ˇd8dgd
d$Ť t jt  	d=ˇd8d!gd
d$Ť t jt  	d>ˇd8d"gd
d$Ť t jt  	d?ˇd8d gd
d$Ť t jt  	d@ˇd8d/gd
d$Ť t  
d d8d+d!gd,gˇ t  
d d8d-dgd,gˇ t  dAtjdtjddŤddŤˇ t  dAtjdtjddŤddŤˇ t  dAtjd	t ˇ d
ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ d
ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdtjddŤddŤˇ t  dAtjdtjddŤddŤˇ t  dAtjdtjddŤddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdt ˇ ddŤˇ t  dAtjdtjddŤddŤˇ t  dAtjd tjddŤddŤˇ t  dAtjd!tjddŤddŤˇ t  dAtjd"tjddŤddŤˇ t jt  	dBˇdAdgd
d$Ť t jt  	dCˇdAdgdd$Ť t jt  	dDˇdAdgd
d$Ť t jt  	dEˇdAdgd
d$Ť t jt  	dFˇdAd!gd
d$Ť t jt  	dGˇdAd"gd
d$Ť t jt  	dHˇdAd gd
d$Ť t  
d dAd+d!gd,gˇ t  
d dAd-dgd,gˇ t  dItjdtjddŤddŤˇ t  dItjd	t ˇ d
ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ d
ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdtjddŤddŤˇ t  dItjdtjddŤddŤˇ t  dItjdtjddŤddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdt ˇ ddŤˇ t  dItjdtjddŤddŤˇ t  dItjd/tjddŤddŤˇ t  dItjd tjddŤddŤˇ t  dItjd!tjddŤddŤˇ t  dItjd"tjddŤddŤˇ t jt  	dJˇdIdgd
d$Ť t jt  	dKˇdIdgdd$Ť t jt  	dLˇdIdgd
d$Ť t jt  	dMˇdId!gd
d$Ť t jt  	dNˇdId"gd
d$Ť t jt  	dOˇdId gd
d$Ť t jt  	dPˇdId/gd
d$Ť t  
d dId-dgd,gˇ t  
d dId+d!gd,gˇ d S )QNÚcmf_asset_catÚnameé   )ÚlengthT)ÚnullableÚcodeé@   ÚsystemFÚfalse)r
   Úserver_defaultÚtextÚimport_originalÚimport_raw_jsonÚext_idÚcmf_archivedÚ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_security_level_allowed_ids_cacheÚperm_encryptÚcmf_import_idÚroot_parent_idÚperm_acl_idÚperm_parent_idÚix_cmf_asset_cat_cmf_import_id)ÚuniqueÚix_cmf_asset_cat_codeÚix_cmf_asset_cat_nameÚix_cmf_asset_cat_ordernoÚix_cmf_asset_cat_perm_acl_idÚix_cmf_asset_cat_perm_parent_idÚix_cmf_asset_cat_root_parent_idÚcmf_access_listÚidÚ
cmf_importÚcmf_asset_schemeÚtree_parent_idÚ!ix_cmf_asset_scheme_cmf_import_idÚix_cmf_asset_scheme_codeÚix_cmf_asset_scheme_nameÚix_cmf_asset_scheme_ordernoÚix_cmf_asset_scheme_perm_acl_idÚ"ix_cmf_asset_scheme_perm_parent_idÚ"ix_cmf_asset_scheme_root_parent_idÚ"ix_cmf_asset_scheme_tree_parent_idÚcmf_asset_typeÚix_cmf_asset_type_cmf_import_idÚix_cmf_asset_type_codeÚix_cmf_asset_type_nameÚix_cmf_asset_type_ordernoÚix_cmf_asset_type_perm_acl_idÚ ix_cmf_asset_type_perm_parent_idÚ ix_cmf_asset_type_root_parent_idÚ ix_cmf_asset_type_tree_parent_idÚcmf_asset_type_catÚ#ix_cmf_asset_type_cat_cmf_import_idÚix_cmf_asset_type_cat_codeÚix_cmf_asset_type_cat_nameÚix_cmf_asset_type_cat_ordernoÚ!ix_cmf_asset_type_cat_perm_acl_idÚ$ix_cmf_asset_type_cat_perm_parent_idÚ$ix_cmf_asset_type_cat_root_parent_idÚcmf_locationÚix_cmf_location_cmf_import_idÚix_cmf_location_codeÚix_cmf_location_ordernoÚix_cmf_location_perm_acl_idÚix_cmf_location_perm_parent_idÚix_cmf_location_root_parent_idÚix_cmf_location_tree_parent_id)r   Ú
add_columnÚsaÚColumnÚStringÚBooleanÚTEXTÚIntegerÚcreate_indexÚfÚcreate_foreign_key© r^   r^   ú6/opt/eva-app/alembic/versions/4eeaf4305980_asset_v2.pyÚupgrade   s\                                                  r`   c                   C   s|	  t jddddŤ t jd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dˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  ddˇ t  dd ˇ t  dd!ˇ t  dd"ˇ t  dd#ˇ t  dd$ˇ t  dd%ˇ t  dd&ˇ t jd'd(ddŤ t jd)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  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(dˇ t  d(d ˇ t  d(d!ˇ t  d(d"ˇ t  d(d#ˇ t  d(d$ˇ t  d(d%ˇ t  d(d&ˇ t  d(d1ˇ t jd2d3ddŤ t jd4d3ddŤ t jt  d5ˇd3dŤ t jt  d6ˇd3dŤ t jt  d7ˇd3dŤ t jt  d8ˇd3dŤ t jt  d9ˇd3dŤ t jt  d:ˇd3dŤ t jt  d;ˇd3dŤ t jt  d<ˇd3dŤ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3dˇ t  d3d ˇ t  d3d!ˇ t  d3d"ˇ t  d3d#ˇ t  d3d$ˇ t  d3d%ˇ t  d3d&ˇ t  d3d1ˇ t jd=d>ddŤ t jd?d>ddŤ t jt  d@ˇd>dŤ t jt  dAˇd>dŤ t jt  dBˇd>dŤ t jt  dCˇd>dŤ t jt  dDˇd>dŤ t jt  dEˇd>dŤ t jt  dFˇd>dŤ t jt  dGˇd>dŤ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>dˇ t  d>d ˇ t  d>d!ˇ t  d>d"ˇ t  d>d#ˇ t  d>d$ˇ t  d>d%ˇ t  d>d&ˇ t  d>d1ˇ t jdHdIddŤ t jdJdIddŤ t jt  dKˇdIdŤ t jt  dLˇdIdŤ t jt  dMˇdIdŤ t jt  dNˇdIdŤ t jt  dOˇdIdŤ t jt  dPˇdIdŤ t jt  dQˇdIdŤ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dIdˇ t  dId ˇ t  dId!ˇ t  dId"ˇ t  dId#ˇ t  dId$ˇ t  dId%ˇ t  dId&ˇ t  dId1ˇ d S )RNZcmf_location_cmf_import_id_fkeyrL   Ú
foreignkey)Útype_Zcmf_location_perm_acl_id_fkeyrS   )Ú
table_namerR   rQ   rP   rO   rN   rM   r%   r$   r#   r2   r"   r!   r    r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   Z%cmf_asset_type_cat_cmf_import_id_fkeyrD   Z#cmf_asset_type_cat_perm_acl_id_fkeyrK   rJ   rI   rH   rG   rF   rE   r   Z!cmf_asset_type_cmf_import_id_fkeyr;   Zcmf_asset_type_perm_acl_id_fkeyrC   rB   rA   r@   r?   r>   r=   r<   Z#cmf_asset_scheme_cmf_import_id_fkeyr1   Z!cmf_asset_scheme_perm_acl_id_fkeyr:   r9   r8   r7   r6   r5   r4   r3   Z cmf_asset_cat_cmf_import_id_fkeyr   Zcmf_asset_cat_perm_acl_id_fkeyr-   r,   r+   r*   r)   r(   r&   )r   Údrop_constraintÚ
drop_indexr\   Údrop_columnr^   r^   r^   r_   Ú	downgradeĆ   s\   rg   )Ú__doc__Úalembicr   Ú
sqlalchemyrU   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr`   rg   r^   r^   r^   r_   Ú<module>   s    4