Ë
    ïjjë  ã                   ó¬   — U d Z ddlmZmZ ddlmZ ddlZdZe	e
d<   dZee	ee	   df   e
d<   dZee	ee	   df   e
d	<   dZee	ee	   df   e
d
<   dd„Zdd„Zy)zmadd_alfresco_models

Revision ID: d1e2f3a4b5c6
Revises: 0f5a1b2c3d4e
Create Date: 2026-07-28 20:00:00.000000
é    )ÚSequenceÚUnion)ÚopNÚd1e2f3a4b5c6ÚrevisionÚ0f5a1b2c3d4eÚdown_revisionÚbranch_labelsÚ
depends_onc                  ó  — t        j                  dt        j                  dt        j                  «       dd¬«      t        j                  dt        j                  «       d¬«      t        j                  dt        j
                  d	«      d¬«      t        j                  d
t        j
                  d«      d¬«      t        j                  dt        j
                  d«      d¬«      t        j                  dt        j
                  d	«      d¬«      t        j                  dt        j                  «       dd¬«      t        j                  dt        j                  «       t        j                  j                  «       d¬«      t        j                  dt        j                  «       t        j                  j                  «       d¬«      t        j                  d«      «       t        j                  d«       t        j                  d«       y )NÚalfresco_modelsÚidTF)ÚautoincrementÚnullableÚconnection_id)r   Ú
model_nameéÿ   Úmodel_titlei   Úmodel_descriptioni   Ú	namespaceÚ	tipologiaÚfalse)Úserver_defaultr   Ú
created_atÚ
updated_atu_  
        INSERT INTO permissions (code, name, module, created_at)
        VALUES
            ('tipologias.view', 'Ver TipologÃ­as', 'TipologÃ­as', now()),
            ('tipologias.sync', 'Sincronizar Modelos', 'TipologÃ­as', now()),
            ('tipologias.edit', 'Editar TipologÃ­as', 'TipologÃ­as', now())
        ON CONFLICT (code) DO NOTHING
    a  
        INSERT INTO role_permissions (role_id, permission_id)
        SELECT r.id, p.id FROM roles r, permissions p
        WHERE r.name = 'admin' AND p.code IN ('tipologias.view', 'tipologias.sync', 'tipologias.edit')
        ON CONFLICT (role_id, permission_id) DO NOTHING
    )r   Úcreate_tableÚsaÚColumnÚIntegerÚStringÚBooleanÚDateTimeÚfuncÚnowÚPrimaryKeyConstraintÚexecute© ó    úQ/var/www/html/metafoliadorv2/alembic/versions/d1e2f3a4b5c6_add_alfresco_models.pyÚupgrader*      s2  € Ü‡O�OØÜ
�	‰	�$œŸ
™
›°DÀ5ÔIÜ
�	‰	�/¤2§:¡:£<¸%Ô@Ü
�	‰	�,¤§	¡	¨#£¸Ô?Ü
�	‰	�-¤§¡¨3£¸$Ô?Ü
�	‰	Ð%¤r§y¡y°£ÀÔFÜ
�	‰	�+œrŸy™y¨›~¸Ô=Ü
�	‰	�+œrŸz™z›|¸GÈeÔTÜ
�	‰	�,¤§¡£¼b¿g¹g¿k¹k»mÐV[Ô\Ü
�	‰	�,¤§¡£¼b¿g¹g¿k¹k»mÐV[Ô\Ü
×Ñ Ó%ôô ‡J�Jð ô 	ô ‡J�Jð õ 	r(   c                  ó‚   — t        j                  d«       t        j                  d«       t        j                  d«       y )Nz¼
        DELETE FROM role_permissions WHERE permission_id IN (
            SELECT id FROM permissions WHERE code IN ('tipologias.view', 'tipologias.sync', 'tipologias.edit')
        )
    zm
        DELETE FROM permissions WHERE code IN ('tipologias.view', 'tipologias.sync', 'tipologias.edit')
    r   )r   r&   Ú
drop_tabler'   r(   r)   Ú	downgrader-   1   s5   € Ü‡J�Jð ô 	ô
 ‡J�Jð ô 	ô ‡M�MÐ#Õ$r(   )ÚreturnN)Ú__doc__Útypingr   r   Úalembicr   Ú
sqlalchemyr   r   ÚstrÚ__annotations__r	   r
   r   r*   r-   r'   r(   r)   ú<module>r5      sx   ðò÷ #Ý Û à€ˆ#Ó Ø1?€ˆu�S˜( 3™-¨Ð-Ñ.Ó ?Ø15€ˆu�S˜( 3™-¨Ð-Ñ.Ó 5Ø.2€
ˆE�#�x ‘} dÐ*Ñ+Ó 2ó	ô@	%r(   