a
    ;]riÿ  ã                   @   sh   d Z ddlmZ ddlZddl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 )zpcustom geometry admin

Revision ID: be7a44d96984
Revises: 8350e5a3e24c
Create Date: 2026-01-15 15:27:11.159411

é    )ÚopN)ÚCONFIG)ÚEnumSqlalchemyType)ÚMetricsTypeZbe7a44d96984Ú8350e5a3e24cc                
   C   s¤  t  dtjdt ¡ ddtjdt ¡ ddt dgdg¡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t	t
d d d ƒd¡ t  dtjdt ¡ d	d¡ t  dtjdt ¡ dt	t
d d d ƒd¡ t  dtjdt ¡ d	d¡ t jddd dd t jddd dd t jddt d¡d t jddt d¡d t jddd	d t jdd
d	d d t  dtjdttƒd	d¡ d S )NÚcustom_group_usersÚcustom_group_idF©ÚnullableÚuser_idzcustom_groups.idÚcustom_pointsÚ
created_atTÚ
updated_atÚcustom_polygonsÚcreated_by_idÚsatbotsZupdate_grids_script)r
   Úserver_defaultÚupdated_by_id)r   r
   ú"TIMEZONE('utc', CURRENT_TIMESTAMP)©r   Úcustom_groupsÚmetrics_type)r   Úcreate_tableÚsaÚColumnÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚ
add_columnÚ	TIMESTAMPÚstrr   Úalter_columnÚtextr   r   © r#   r#   ú\/var/www/staging/api/app_home/migrations/insar/alembic/versions/031_custom_geometry_admin.pyÚupgrade   s&    
ü..r%   c                   C   s¢   t  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t d¡d
 t  d¡ t jdddd d S )Nr   r   r   r   r   r   r   r   r   r   r   zcUPDATE custom_polygons SET updated_at = TIMEZONE('utc', CURRENT_TIMESTAMP) WHERE updated_at is NULLFr	   )r   Ú
drop_tableÚdrop_columnr!   r   r"   Úexecuter#   r#   r#   r$   Ú	downgrade5   s    

r)   )Ú__doc__Úalembicr   Ú
sqlalchemyr   Úgeoalchemy2Úsetupr   Z%main.services.custom_sqlalchemy_typesr   Úmain.models.insar.custom_groupr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr%   r)   r#   r#   r#   r$   Ú<module>   s   