a
    ×æ.i¦  ã                   @   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 )zpaverage displacements

Revision ID: 0f8096f0867a
Revises: 50e8b4193a62
Create Date: 2025-09-24 10:26:38.942001

é    )ÚopN)Ú
postgresqlZ0f8096f0867aÚ50e8b4193a62c               	   C   s~   t  dtjdt ¡ dd¡ t  dtjdt ¡ dd¡ dD ]$} t  | tjdt tj¡dd¡ q<t  ¡ }| 	t 
d¡¡ d S )	NÚframesÚ	start_binT)ÚnullableÚend_bin©Ú
points_ascÚpoints_descÚaverage_dispsa  
            CREATE OR REPLACE FUNCTION unnest_by_one_dimension(a_nd ANYARRAY, OUT a_1d ANYARRAY)
                RETURNS SETOF ANYARRAY
                LANGUAGE plpgsql IMMUTABLE PARALLEL SAFE STRICT AS
            $func$
            BEGIN
                FOREACH a_1d SLICE 1 IN ARRAY a_nd LOOP
                    RETURN NEXT;
                END LOOP;
            END
            $func$;
        )r   Ú
add_columnÚsaÚColumnÚIntegerr   ÚARRAYÚREALÚget_bindÚexecuteÚtext©ÚtableÚ
connection© r   ú\/var/www/staging/api/app_home/migrations/insar/alembic/versions/027_average_displacements.pyÚupgrade   s    "ÿr   c                  C   sJ   t  dd¡ t  dd¡ dD ]} t  | d¡ qt  ¡ }| t d¡¡ d S )Nr   r   r   r	   r   z0DROP FUNCTION IF EXISTS unnest_by_one_dimension;)r   Údrop_columnr   r   r   r   r   r   r   r   Ú	downgrade/   s    r   )Ú__doc__Úalembicr   Ú
sqlalchemyr   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr   r   r   r   r   r   Ú<module>   s   