a
    ;]rii	                     @   s   d Z ddlZddlmZmZ ddlZddlmZ ddl	m
Z
 ddlmZ ddlmZ ddlmZ d	Zd
ZdZdZdd Zdd ZdS )zmdrop satbots table

Revision ID: f1a4ec5e34e5
Revises: fed7415a80da
Create Date: 2026-01-16 10:29:24.933061

    N)opcontext)CONFIG)EnumSqlalchemyType)SatbotPriority)SatbotState)
SatbotTypeZf1a4ec5e34e5fed7415a80dac               	   C   s\   t  jjjj} tt	dt
d d  d|  d tdd tdd	 td d S )
NzCOPY satbots TO 'satbotsbackups_directory/_satbots.csv' (FORMAT CSV)alerts_satbot_id_fkeyalertsorders_satbot_id_fkeyorders)r   get_context
connectionengineurldatabaser   executesatextr   drop_constraint
drop_tabler    r   Y/var/www/staging/api/app_home/migrations/users/alembic/versions/039_drop_satbots_table.pyupgrade   s
    &r   c                  C   s  t dtjdt dddtjdttddtjdttddtjd	t ddtjd
t ddtjdttddtjdt	t
 ddtjdt t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d t jjjj} tjtjtd d |  drVt tdtd d  d|  d t ddddgdg t ddddgdg d S )Nr
   idFT)nullableautoincrementtype)r!   stateprogresspidprioritylog
created_atz"TIMEZONE('utc', CURRENT_TIMESTAMP))server_defaultr!   created_by_id
started_atfinished_at
parametersr   z_satbots.csvzCOPY satbots FROM 'r   r   r   r   	satbot_idr   r   )r   create_tabler   ColumnIntegerr   r   r   r   ARRAYString	TIMESTAMPr   JSONPrimaryKeyConstraintr   r   r   r   r   r   ospathexistsjoinr   r   create_foreign_keyr   r   r   r   	downgrade"   s(    &&r=   )__doc__r8   alembicr   r   
sqlalchemyr   setupr   Z%main.services.custom_sqlalchemy_typesr   Z%main.services.satbots.satbot_priorityr   Z"main.services.satbots.satbot_stater   Z!main.services.satbots.satbot_typer   revisiondown_revisionbranch_labels
depends_onr   r=   r   r   r   r   <module>   s   