U
    1Eg                     @   sD   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
d ZdS )zlarchived_quickfix

Revision ID: 6b5b0854d342
Revises: 5b28afa694a0
Create Date: 2024-09-23 09:38:54.911404

    )opNZ6b5b0854d342Z5b28afa694a0c                 C   s(   t  }|d|  d| d d k	S )NzG
        SELECT 1 
        FROM pg_indexes 
        WHERE indexname = 'z' 
        AND tablename = 'z
'
        )r   get_bindexecutescalar)
index_name
table_nameconn r	   ?/opt/eva-app/alembic/versions/6b5b0854d342_archived_quickfix.pyindex_exists   s    r   c                	   C   s   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d	rrt jdd	d
 tdd	rt jdd	d
 tdd	st jdd	dgddd tdd	st jdd	dgddddid d S )Ncmf_asset_cathas_children_archivedFfalse)nullableserver_defaultcmf_asset_schemecmf_asset_type_cat-ix_cmf_full_search_custom_fields_tsvector_gincmf_full_searchr   -ix_cmf_full_search_obj_custom_fields_gin_trgm,ix_cmf_full_search_addon_fields_tsvector_ginaddon_fields_tsvectorgin)uniquepostgresql_using,ix_cmf_full_search_obj_addon_fields_gin_trgmobj_addon_fieldsgin_trgm_ops)r   r   postgresql_ops)r   
add_columnsaColumnBooleanr   
drop_indexcreate_indexr	   r	   r	   r
   upgrade   s,    


  
  r&   c                   C   s   t ddrtjddd t ddr0tjddd t ddsNtjdddgdd t d	dsltjd	dd
gdd tdd tdd tdd d S )Nr   r   r   r   r   r   F)r   r   r   r   r   r   r   )r   r   r$   r%   drop_columnr	   r	   r	   r
   	downgrade6   s.    


 
 r(   )__doc__alembicr   
sqlalchemyr!   revisiondown_revisionbranch_labels
depends_onr   r&   r(   r	   r	   r	   r
   <module>   s   