VjPdZddlmZddlmZmZddlmZdZe dk(reyy)zApply the explicit MySQL schema for the Venda Local module. Run once from the project root: .\.venv\Scripts\python.exe app/scripts/apply_local_sales_schema.py )Path)inspecttext)engineczttjdz dz }|jd}g}g}|j D]3}|j j dr#|j|5dj|jdD]&}|j }|s|j|(tj5}|D]}|jt|t|}d|jvrs|j!dDchc]}|d  } }d | vr4|jtd |jtd |jtd dddt#dt%|dycc}w#1swY'xYw)Nsqlzlocal_sales_tables.sqlzutf-8)encodingz-- ;salesname channel_keyzUALTER TABLE sales ADD COLUMN channel_key VARCHAR(50) NOT NULL DEFAULT 'mercado_livre'z9CREATE INDEX idx_sales_channel_key ON sales (channel_key)z\UPDATE sales SET channel_key = 'mercado_livre' WHERE channel_key IS NULL OR channel_key = ''z Venda Local: u$ instruções aplicadas com sucesso.)r__file__parent read_text splitlinesstrip startswithappendjoinsplitrbeginexecuterrget_table_names get_columnsprintlen) schema_pathcontents statementscurrentline statement connection inspectorcolumncolumnss R/var/www/hypershopcomercio.com.br/hyper-ai/app/scripts/apply_local_sales_schema.pymainr)sx.''%/2JJK$$g$6HJG##% ::< " "4 ( tYYw'--c2) OO%    i () :# 0I   tI / 0 J' i//1 14=4I4I'4RS&vf~SGSG+""4k$""4(c#de   tn  " M#j/**N OPTs AF1+ F,7AF1,F11F:__main__N) __doc__pathlibr sqlalchemyrrapp.core.databaserr)__name__r(r2s0 $$QD zFr1