
    ph                         U d Z ddlmZmZ ddlmZ ddlZddlm	Z	 dZ
eed<   dZ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)zsAdd Crawl property Table

Revision ID: 425ed29584d5
Revises: f652e94c3a0f
Create Date: 2025-07-18 19:19:02.554621

    )SequenceUnion)opN)
postgresql425ed29584d5revisionf652e94c3a0fdown_revisionbranch_labels
depends_onc                  |   t        j                  dt        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  dt        j
                         d      t        j                  dt        j
                         d      t        j                  d	t        j                         d      t        j                  d
t        j
                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  d             t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd
gd       t        j                  t        j                  d      ddgd       t        j                  dt        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  dt        j
                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  d t        j                         d      t        j                  d!t        j                         d      t        j                  d"t        j                         d      t        j                  d#t        j                         d      t        j                  d
t        j
                         d      t        j                  d$t        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  d             t        j                  t        j                  d%      ddgd       t        j                  t        j                  d&      ddgd       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      t        j                  d-t        j                         d      t        j                  d.t        j                         d      t        j                  d/t        j                         d      t        j                  d0t        j                         d      t        j                  d      
       t        j                  t        j                  d1      d'd)gd       t        j                  d2t        j                  dt        j                         d      t        j                  d3t        j                         d      t        j                  d4t        j
                         d      t        j                  d5t        j
                         d      t        j                  d6t        j                         d      t        j                  d7t        j                         d      t        j                  d8t        j
                         d      t        j                  d3gd9g      t        j                  d      
       t        j                  d:d;t        j                          d<       t        j                  d=d
t#        j$                  d>d?d@A      t        j
                         dB       t        j                  dCdDt        j                          d<       yE)FzUpgrade schema.job_logsidF)nullableliteralTcodenameurlstatustotal_recordstotal_prices
date_startdate_endmessagetotal_validationvalidation_passedvalidation_warnvalidation_failedvalidation_statusvalidation_messagedate_createdlast_updatedjob_dateix_job_logs_code)uniqueix_job_logs_idix_job_logs_statusix_job_logs_validation_statusmatched_logsprocess_keywordhistory_matchedkeyword_matchedambiguous_matchedunknown_wines
crawl_dateix_matched_logs_codeix_matched_logs_idwine_matches)autoincrementr   uuid   )lengthdescription
is_deleted
deleted_at
created_at
updated_atix_wine_matches_uuidcrawl_propertiesweb_crawler_idwine_propertycustom_labelproperty_indexdata_output	selectorszweb_crawlers.idproducer_keywordsproducer_idexisting_typer   wine_dbACTIVEDELETEDwinedbstatusr   rG   type_existing_nullablewine_keywords
wine_db_idN)r   create_tablesaColumnIntegerStringTextDECIMALDateTimePrimaryKeyConstraintcreate_indexfBooleanUUIDForeignKeyConstraintalter_columnINTEGERr   ENUM     s/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/425ed29584d5_add_crawl_property_table.pyupgraderf      sH    OOJIIdBJJL51IIit4IIfbiikD1IIfbiikD1IIeRWWY.IIh		d3IIorzz|d;IInbjjlT:IIlBKKMD9IIj"++-$7IIiT2II "**,>II!2::<$?II=II!2::<$?II!299;>II"BGGI=IInbkkmd;IInbkkmd;IIj"++-$7D!+. OOBDD+,j6(5QOOBDD)*JuMOOBDD-.
XJuUOOBDD89:H[G\ejkOONIIdBJJL51IIit4IIfbiikD1II=IIorzz|d;II=II=II!2::<$?IIorzz|d;IIh		d3IIlBKKMD9IIlBKKMD9IIj"++-$7IIiT2IInbkkmd;IInbkkmd;D!#& OOBDD/0.6(SXYOOBDD-.uUOONIIdBJJLuEIIfbggi%0IIfbiis+e<IImRWWY6IIlBJJL59IIlBKKMD9IIlBKKMD9IIlBKKMD9D!
 OOBDD/0.6(SWXOO&IIdBJJL51II

u=IIoryy{U;IInbiikD9II

u=IImRZZ\D9IIk299;6-.1B0CFD!
 OO'ZZ\ OOIx'__Xy~VYY[!%' OOO\ZZ\rd   c            
      (   t        j                  ddt        j                         d       t        j                  ddt        j                         t        j                  ddd	
      d       t        j                  ddt        j                         d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       y)zDowngrade schema.rP   rQ   TrF   rH   r   rI   rJ   rK   rL   rM   rD   rE   r=   r<   r2   )
table_namer1   r)   r0   r(   r   r'   r&   r$   N)
r   r`   rS   ra   rV   r   rb   
drop_table
drop_indexr\   rc   rd   re   	downgraderk   l   sH    OOO\ZZ\ OOIxYY[__Xy~N!%' OO'ZZ\ MM$%MM"$$-.>JMM.!MM"$$+,HMM"$$-.>JMM.!MM"$$67JOMM"$$+,DMM"$$'(Z@MM"$$)*zBMM*rd   )returnN)__doc__typingr   r   alembicr   
sqlalchemyrS   sqlalchemy.dialectsr   r   str__annotations__r
   r   r   rf   rk   rc   rd   re   <module>rt      sw    #   * # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2Snrd   