§
    ¶‰=j-  ã                   óÖ   — d Z ddlZddlZej                             dej                             e¦  «        ¦  «         ddlmZm	Z	 ddl
mZ ddlmZ dZd„ Zedk    r e¦   «          dS dS )	zAAjoute les colonnes de suppression logique aux tables existantes.é    N)ÚinspectÚtext)Ú
create_app)Údb)ÚcoproprietesÚ	personnesÚlotsÚ	compteursÚrelevesc            	      ó¤  — t          ¦   «         } |                      ¦   «         5  t          t          j        ¦  «        }t
          D ]Æ}||                     ¦   «         vrŒd„ |                     |¦  «        D ¦   «         }d|vrCt          j         	                    t          d|› d�¦  «        ¦  «         t          d|› d�¦  «         d|vrCt          j         	                    t          d|› d�¦  «        ¦  «         t          d|› d	�¦  «         ŒÇt          j                             ¦   «          t          d
¦  «         d d d ¦  «         d S # 1 swxY w Y   d S )Nc                 ó   — h | ]
}|d          ’ŒS )Úname© )Ú.0Úcs     ú//var/www/stessy.org/papa/migrate_soft_delete.pyú	<setcomp>zmigrate.<locals>.<setcomp>   s   € ÐGÐGÐG Q�q˜”yÐGÐGÐGó    ÚstatutzALTER TABLE z7 ADD COLUMN statut VARCHAR(20) NOT NULL DEFAULT 'actif'z  + z.statutÚdate_suppressionz% ADD COLUMN date_suppression DATETIMEz.date_suppressionu(   Migration suppression logique terminÃ©e.)r   Úapp_contextr   r   ÚengineÚTABLESÚget_table_namesÚget_columnsÚsessionÚexecuter   ÚprintÚcommit)ÚappÚ	inspectorÚtableÚcolumnss       r   Úmigrater$      s¼  € Ý
‰,Œ,€CØ	�ŠÑ	Ô	ð :ð :Ý�BœIÑ&Ô&ˆ	Ýð 	7ð 	7ˆEØ˜I×5Ò5Ñ7Ô7Ð7Ð7ØØGÐG¨)×*?Ò*?ÀÑ*FÔ*FÐGÑGÔGˆGØ˜wÐ&Ð&Ý”
×"Ò"ÝðQ uð Qð Qð Qñô ñô ð õ Ð+˜UÐ+Ð+Ð+Ñ,Ô,Ð,Ø!¨Ð0Ð0Ý”
×"Ò"ÝÐT¨ÐTÐTÐTÑUÔUñô ð õ Ð5˜UÐ5Ð5Ð5Ñ6Ô6Ð6øÝ
Œ
×ÒÑÔÐÝÐ8Ñ9Ô9Ð9ð):ð :ð :ñ :ô :ð :ð :ð :ð :ð :ð :ð :øøøð :ð :ð :ð :ð :ð :s   £DEÅE	ÅE	Ú__main__)Ú__doc__ÚosÚsysÚpathÚinsertÚdirnameÚ__file__Ú
sqlalchemyr   r   r    r   Ú
app.modelsr   r   r$   Ú__name__r   r   r   ú<module>r0      sµ   ðØ GÐ GØ 	€	€	€	Ø 
€
€
€
à „‡‚��2”7—?’? 8Ñ,Ô,Ñ -Ô -Ð -à $Ð $Ð $Ð $Ð $Ð $Ð $Ð $à Ð Ð Ð Ð Ð Ø Ð Ð Ð Ð Ð à	F€ð:ð :ð :ð2 ˆzÒÐØ€G�I„I€I€I€Ið Ðr   