
    4u(iBd                         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	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)zqdummy data + snapshots

Revision ID: 694082d3ab93
Revises: c43c088686d5
Create Date: 2025-11-27 15:58:44.703216

    )SequenceUnion)opN694082d3ab93revisionc43c088686d5down_revisionbranch_labels
depends_onc                  FJ   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      d      t        j                  dt        j                  d      t        j                  d      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      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      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j
                  d
      d      t        j                  dt        j                  d      t        j                  d      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                  d      d      t        j                  dt        j                  d      t        j                  d      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                  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)d*d+d,d-d./      d      t        j                  d0t        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgd1g      t        j                  d(gd2g      t        j                  d             t        j                  t        j                  d3      d&dgd       t        j                  t        j                  d4      d&dgd       t        j                  t        j                  d5      d&d(gd       t        j                  t        j                  d6      d&d'gd       t        j                  d7t        j                  dt        j                         dd      t        j                  dt        j                         d      t        j                  d(t        j                         d      t        j                  d8t        j                  d      d      t        j                  d9t        j
                  d
      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgd1g      t        j                  d(gd2g      t        j                  d             t        j                  t        j                  d:      d7dgd       t        j                  t        j                  d;      d7dgd       t        j                  t        j                  d<      d7d(g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      d      t        j                  d@t        j                         d      t        j                  dAt        j                         d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgd1g      t        j                  d(gd2g      t        j                  d>gdBg      t        j                  d             t        j                  t        j                  dC      d=dgd       t        j                  t        j                  dD      d=dgd       t        j                  t        j                  dE      d=d(gd       t        j                  t        j                  dF      d=d>gd       t        j                  t        j                  dG      d=d?gd       t        j                  dHt        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                  dIt        j
                  d
      d      t        j                  dJt        j                         d      t        j                  dKt        j                  d      d      t        j                  dLt        j                  d      d      t        j                  dt        j                  dMdNdOdPdQdR/      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgd1g      t        j                  d(gd2g      t        j                  d>gdBg      t        j                  d             t        j                  t        j                  dS      dHdIgd       t        j                  t        j                  dT      dHdgd       t        j                  t        j                  dU      dHdgd       t        j                  t        j                  dV      dHd(gd       t        j                  t        j                  dW      dHd>gd       t        j                  dXt        j                  dt        j                         dd      t        j                  dt        j                         d      t        j                  dYt        j                         d      t        j                  d>t        j                         d      t        j                  d(t        j                         d      t        j                  dZt        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
      d      t        j                  d`t        j
                  d
      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgd1g      t        j                  d(gd2g      t        j                  d>gdBg      t        j                  d             t        j                  t        j                  da      dXdgd       t        j                  t        j                  db      dXdgd       t        j                  t        j                  dc      dXd(gd       t        j                  t        j                  dd      dXd>gd       t        j                  t        j                  de      dXdYgd       t        j                  dft        j                  dt        j                         dd      t        j                  dt        j                         d      t        j                  dgt        j                         d      t        j                  d>t        j                         d      t        j                  dht        j                         d      t        j                  dit        j                         d      t        j                  djt        j                         d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgd1g      t        j                  d>gdBg      t        j                  dggdkg      t        j                  d             t        j                  t        j                  dl      dfdgd       t        j                  t        j                  dm      dfdgd       t        j                  t        j                  dn      dfd>gd       t        j                  dot        j                  dt        j                         dd      t        j                  dt        j                         d      t        j                  dpt        j                         d      t        j                  d>t        j                         d      t        j                  dqt        j                         d      t        j                  drt        j                         d      t        j                  dst        j                         d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgd1g      t        j                  d>gdBg      t        j                  dpgdtg      t        j                  d             t        j                  t        j                  du      dodgd       t        j                  t        j                  dv      dodgd       t        j                  t        j                  dw      dod>gd       t        j                  dxt        j                  dt        j                         d      t        j                  dyt        j                          d      t        j                  dt        j                         d      t        j                  d(t        j                         d      t        j                  d>t        j                         d      t        j                  dzt        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      d      t        j                  dgd1g      t        j                  d(gd2g      t        j                  d>gdBg      t        j                  d             t        j                  t        j                  d~      dxdgd       t        j                  t        j                  d      dxdygd       t        j                  t        j                  d      dxdgd       t        j                  t        j                  d      dxd(gd       t        j                  t        j                  d      dxd>gd       t        j                  ddxg dd       t        j                  dt        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                  dyt        j                          d      t        j                  d|t        j                         d      t        j                  dt        j
                  d	
      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgd1g      t        j                  d(gd2g      t        j                  d>gdBg      t        j                  d             t        j                  ddg dd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddygd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd(gd       t        j                  t        j                  d      dd>gd       t        j                  dt        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                  dt        j                         d      t        j                  dt        j                  dddddd/      d      t        j                  dt        j                         d      t        j                  dt        j
                  d
      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgdg      t        j                  dgd1g      t        j                  d(gd2g      t        j                  d>gdBg      t        j                  d             t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd(gd       t        j                  t        j                  d      dd>gd       t        j"                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd       t        j$                  d dddgdg       t        j"                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd       t        j$                  d dddgdg       t        j"                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd       t        j$                  d dddgdg       t        j"                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd       t        j$                  d dddgdg       t        j"                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd       t        j$                  d dddgdg       t        j&                  ddZ       t        j&                  dd\       t        j&                  ddY       t        j&                  dd]       t        j&                  dd[       t        j"                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd       t        j$                  d dddgdg       y )N	companiesidTFautoincrementnullable
company_id)r   company_name   )length
created_at)timezoneznow())server_defaultr   
updated_atix_companies_company_id)uniqueix_companies_idcron_job_logs	task_typed   task_idstatus2   processed_countinserted_countupdated_countrows_insertedtarget_date
started_atcompleted_atduration_secondserror_messagetask_resultix_cron_job_logs_idix_cron_job_logs_task_idix_cron_job_logs_task_typepurchase_orderssupplier_idlocation_idDRAFTPENDING_APPROVALSENTRECEIVEDCLOSEDpurchaseorderstatus)nameexpected_delivery_datezcompanies.company_idzlocations.location_idix_purchase_orders_company_idix_purchase_orders_idix_purchase_orders_location_idix_purchase_orders_supplier_idsales_orderssold_atchannelix_sales_orders_company_idix_sales_orders_idix_sales_orders_location_iddaily_sales
product_id	sale_datequantity_soldtotal_amountzproducts.product_idix_daily_sales_company_idix_daily_sales_idix_daily_sales_location_idix_daily_sales_product_idix_daily_sales_sale_dateinventory_batches	batch_refquantity_on_handexpiry_datereceived_dateACTIVESOLD_OUTEXPIREDDISPOSEDDONATEDinventorybatchstatusix_inventory_batches_batch_refix_inventory_batches_company_idix_inventory_batches_id ix_inventory_batches_location_idix_inventory_batches_product_idproduct_pricesproduct_price_idcost_price_per_unitmarkup_valuemargin_valueretail_price_excl_taxcompare_at_pricemarkup_type_namemargin_type_nameix_product_prices_company_idix_product_prices_idix_product_prices_location_idix_product_prices_product_id"ix_product_prices_product_price_idpurchase_order_linespurchase_order_idordered_qtyreceived_qty	unit_costzpurchase_orders.id"ix_purchase_order_lines_company_idix_purchase_order_lines_id"ix_purchase_order_lines_product_idsales_order_linessales_order_idquantity
unit_pricepromotion_idzsales_orders.idix_sales_order_lines_company_idix_sales_order_lines_idix_sales_order_lines_product_idservice_level_dailydate
demand_qtyfulfilled_qtylost_sales_qtyservice_level!ix_service_level_daily_company_idix_service_level_daily_dateix_service_level_daily_id"ix_service_level_daily_location_id!ix_service_level_daily_product_id#ix_servicelvl_company_loc_prod_date)r~   r   r2   rF   stockout_eventsreason!ix_stockout_company_loc_prod_date)r   r2   rF   r~   ix_stockout_events_company_idix_stockout_events_dateix_stockout_events_idix_stockout_events_location_idix_stockout_events_product_idinventory_movementsbatch_idmovement_typeSALERECEIPT
ADJUSTMENTTRANSFER_INTRANSFER_OUTmovementtypequantity_delta	referencezinventory_batches.id!ix_inventory_movements_company_idix_inventory_movements_id"ix_inventory_movements_location_id!ix_inventory_movements_product_id
categoriesix_categories_company_id	locationsix_locations_company_idproduct_locationsix_product_locations_company_idproduct_vendorsix_product_vendors_company_idproductsix_products_company_idvendorsix_vendors_company_id)r   create_tablesaColumnIntegerStringDateTimetextPrimaryKeyConstraintcreate_indexfTextJSONEnumForeignKeyConstraintFloatDate
add_columncreate_foreign_keydrop_column     Q/var/www/html/hubwallet-dev/alembic/versions/694082d3ab93_dummy_data_snapshots.pyupgrader      s`   OOKIIdBJJLuEIIlBJJL59IInbiis3eDIIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfgD! OOBDD23[<.Y]^OOBDD*+[4&OOOOIIdBJJL51IIk299C05AIIi#.>IIh		,u=II=II

t<IIorzz|d;IIorzz|d;IImRYYb1DAIIlBKK6rwwwGWbghIInbkk484HII "**,>IIorwwy48IImRWWY6IIlBKK6rwwwGWbghIIlBKK6rwwwGWbghD!#& OOBDD./4&QVWOOBDD34o	{[`aOOBDD56+_deOO%IIdBJJLuEIIlBJJL59IImRZZ\E:IImRZZ\E:IIh);VZQY`uv  BG  HII&T(BTRIIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfg\N-C,DG]O.E-FID! OOBDD89;L|nejkOOBDD013DtfUZ[OOBDD9:<MP]glmOOBDD9:<MP]glmOONIIdBJJLuEIIlBJJL59IImRZZ\E:IIid3eDIIi"->IIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfg\N-C,DG]O.E-FID! OOBDD56_deOOBDD-.uUOOBDD67-afgOOMIIdBJJLuEIIlBJJL59IIlBJJL59IImRZZ\E:IIk2;;5FIIorzz|e<IInbhhj59IIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfg\N-C,DG]O.E-FI\N-B,CFD! OOBDD45}|n]bcOOBDD,-}tfUSOOBDD56_deOOBDD45}|n]bcOOBDD34mk][`aOO'IIdBJJLuEIIlBJJL59IIlBJJL59IImRZZ\E:IIk299C05AII "**,?IImR[[$7$GIIor{{D9EJIIh*iY]st  @E  FIIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfg\N-C,DG]O.E-FI\N-B,CFD!" OOBDD9:<OR]Q^gklOOBDD:;=PS_R`inoOOBDD235H4&Y^_OOBDD;<>QTaSbkpqOOBDD:;=PS_R`inoOO$IIdBJJLuEIIlBJJL59II "**,?IIlBJJL59IImRZZ\E:II#RXXZ$?IInbhhj48IInbhhj48II%rxxzDAII "((*t<II "))2"6FII "))2"6FIIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfg\N-C,DG]O.E-FI\N-B,CFD!%( OOBDD78:J\NchiOOBDD/02BTFSXYOOBDD89;Km_ejkOOBDD78:J\NchiOOBDD=>@PSeRfostOO*IIdBJJLuEIIlBJJL59II!2::<%@IIlBJJL59IImRZZ\E:IInbjjlU;IIk288:6IIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfg\N-C,DG\N-B,CF014H3ILD! OOBDD=>@VYeXfotuOOBDD568NQUPV_deOOBDD=>@VYeXfotuOO'IIdBJJLuEIIlBJJL59II

u=IIlBJJL59IIj"**,7IIlBHHJ7IInbjjlT:IIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfg\N-C,DG\N-B,CF-.1B0CFD! OOBDD:;=PS_R`inoOOBDD235H4&Y^_OOBDD:;=PS_R`inoOO)IIdBJJL51IIfbggi%0IIlBJJL59IImRZZ\E:IIlBJJL59IIlBHHJ7IIorxxzE:II
U;IIorxxzE:IIlBKK6rwwwGWbfg\N-C,DG]O.E-FI\N-B,CFD!  OOBDD<=?TWcVdmrsOOBDD679NQWPXafgOOBDD457Ltf]bcOOBDD=>@UXeWfotuOOBDD<=?TWcVdmrsOO9;P  SF  OS  TOO%IIdBJJL51IIlBJJL59IImRZZ\E:IIlBJJL59IIfbggi%0II
U;IIh		-=IIlBKK6rwwwGWbfg\N-C,DG]O.E-FI\N-B,CFD! OO79JL  IN  OOOBDD89;L|nejkOOBDD235FY^_OOBDD013DtfUZ[OOBDD9:<MP]glmOOBDD89;L|nejkOO)IIdBJJLuEIIlBJJL59IIlBJJL59IImRZZ\E:IIj"**,6IIorwwvy,Welz{  GL  MII

u=IIk299C04@IIlBKK6rwwwGWbfgZL+A*BE\N-C,DG]O.E-FI\N-B,CFD!  OOBDD<=?TWcVdmrsOOBDD457Ltf]bcOOBDD=>@UXeWfotuOOBDD<=?TWcVdmrsMM,		,

u UVOOBDD34l\N[`a$kL>L>ZMM+ryyrzz|eTUOOBDD23[<.Y^_$[<.<.YMM%ryyrzz|V['\]OOBDD:;=PS_R`ino$ 3[<.S_R`aMM#RYY|RZZ\TY%Z[OOBDD89;L|nejk$ 1;Q]P^_MM*biibjjlUSTOOBDD12JW\]$
K,,XNN:45NN:~.NN:12NN:67NN:~.MM)RYY|RZZ\ERSOOBDD019|nUZ[$	;Wr   c            	      j   t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j
                  dt        j                  dt        j                  d	
      dd             t        j
                  dt        j                  dt        j                  d	
      dd             t        j
                  dt        j                  dt        j                         dd             t        j
                  dt        j                  dt        j                  d	
      dd             t        j
                  dt        j                  dt        j                  d	
      dd             t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  d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       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                  t        j                  d%      d!       t        j                  d&d!       t        j                  d!       t        j                  d'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                  t        j                  d-      d(       t        j                  d(       t        j                  t        j                  d.      d/       t        j                  t        j                  d0      d/       t        j                  t        j                  d1      d/       t        j                  d/       t        j                  t        j                  d2      d3       t        j                  t        j                  d4      d3       t        j                  t        j                  d5      d3       t        j                  d3       t        j                  t        j                  d6      d7       t        j                  t        j                  d8      d7       t        j                  t        j                  d9      d7       t        j                  t        j                  d:      d7       t        j                  t        j                  d;      d7       t        j                  d7       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                  t        j                  dA      d=       t        j                  d=       t        j                  t        j                  dB      dC       t        j                  t        j                  dD      dC       t        j                  t        j                  dE      dC       t        j                  t        j                  dF      dC       t        j                  t        j                  dG      dC       t        j                  dC       t        j                  t        j                  dH      dI       t        j                  t        j                  dJ      dI       t        j                  t        j                  dK      dI       t        j                  dI       t        j                  t        j                  dL      dM       t        j                  t        j                  dN      dM       t        j                  t        j                  dO      dM       t        j                  t        j                  dP      dM       t        j                  dM       t        j                  t        j                  dQ      dR       t        j                  t        j                  dS      dR       t        j                  t        j                  dT      dR       t        j                  dR       t        j                  t        j                  dU      dV       t        j                  t        j                  dW      dV       t        j                  dV       y )XNr   
foreignkey)type_r   )
table_namer   r   rb   5   )	precisionFTr   rd   r`   rc   ra   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r}   r   r   r   r   r   r|   ru   r{   rz   rt   rm   rs   rr   rl   r_   rk   rj   ri   rh   r^   rO   r]   r\   r[   rZ   rN   rE   rM   rL   rK   rJ   rD   r?   rC   rB   r>   r0   r=   r<   r;   r/   r   r.   r-   r   r   r   )r   drop_constraint
drop_indexr   r   r   r   r   DOUBLE_PRECISIONINTEGER
drop_tabler   r   r   	downgrader     s   tYl;MM"$$./IFNN9l+MM*bii8K8KVX8Yiny}~MM*bii(?ATAT_aAbrw  CG  H  IMM*bii(:BJJLX]hlmnMM*bii8K8KVX8Yiny}~MM*bii(=r?R?R]_?`pu  AE  F  GtZ|<MM"$$/0ZHNN:|,t.lCMM"$$67DUVNN$l3t0EMM"$$89FYZNN&5t[=MM"$$01kJNN;-t\>MM"$$12|LNN<.MM"$$:;H]^MM"$$;<I^_MM"$$23@UVMM"$$:;H]^MM'(MM"$$67DUVMM"$$78EVWMM"$$./<MNMM"$$01>OPMM"$$67DUVMM5BSTMM#$MM7DYZMM"$$:;H]^MM"$$;<I^_MM"$$23@UVMM"$$45BWXMM"$$:;H]^MM'(MM"$$89FYZMM"$$01>QRMM"$$89FYZMM%&MM"$$;<I_`MM"$$34AWXMM"$$;<I_`MM()MM"$$;<IYZMM"$$56CSTMM"$$67DTUMM"$$-.;KLMM"$$56CSTMM"#MM"$$89FYZMM"$$9:GZ[MM"$$01>QRMM"$$89FYZMM"$$78EXYMM%&MM"$$12}MMM"$$23NMM"$$34OMM"$$*+FMM"$$23NMM- MM"$$45.QMM"$$+,HMM"$$34PMM.!MM"$$78EVWMM"$$78EVWMM"$$./<MNMM"$$67DUVMM#$MM"$$34QMM"$$12OMM"$$,-/JMM/"MM"$$()kBMM"$$01kJMM+r   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr   r   str__annotations__r	   r
   r   r   r   r   r   r   <module>r      sv    #   # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2}XBUr   