/i ddlZddlmZddlmZddlmZddlmZddlm Z ddl m Z ddl m Zddlm Zddlm Zddlm ZddlmZdd lmZdd lmZdd lmZdd lmZmZm Z m!Z!m"Z"m#Z#ejHejJd dD]-Z&ejNe&jQejJ/defdZ)e)Z*y)N)FastAPI)CORSMiddleware)delete)text)SQLAlchemyError)router)Base)engine)utcnow)PasswordResetToken)User RefreshTokenVendor ViolationProductScrapingResultz4%(asctime)s - %(name)s - %(levelname)s - %(message)s)levelformat)appz app.serviceszapp.apireturnctd}|jtdgdddgdg|jddd }|j t d d g |j t d g|j tddg |j tddg |j tddg |S)NzMARCO Scraping)titlez#https://marco-fe.testyourapp.onlinez,^https?:\/\/(localhost|127\.0\.0\.1)(:\d+)?$T*) allow_originsallow_origin_regexallow_credentials allow_methods allow_headersstartupc K tj4d{}|jtjj d{|j tdd{|j ttjtjtktjjdzd{|j tdd{|j tdd{|j tdd{|j tdd{|j tdd{|j tdd{|j tdd{|j td d{|j td d{|j td d{|j td d{|j td d{|j tdd{|j tdd{|j tdd{dddd{y7777777777c7D7%777777f7F78#1d{7swYyxYw#t$r}t!d|d}~wwxYww)NzQALTER TABLE users ADD COLUMN IF NOT EXISTS tokens_invalid_before TIMESTAMPTZ NULLzLALTER TABLE violations ADD COLUMN IF NOT EXISTS barcode_number VARCHAR(255);zJALTER TABLE violations ADD COLUMN IF NOT EXISTS reference_id VARCHAR(255);zUALTER TABLE violations ADD COLUMN IF NOT EXISTS confirmation_count INTEGER DEFAULT 1;z]ALTER TABLE violations ADD COLUMN IF NOT EXISTS source_type VARCHAR(50) DEFAULT 'registered';zUALTER TABLE violations ADD COLUMN IF NOT EXISTS last_confirmed_date TIMESTAMPTZ NULL;zVALTER TABLE violations ADD COLUMN IF NOT EXISTS notification_sent_at TIMESTAMPTZ NULL;zIALTER TABLE violations ADD COLUMN IF NOT EXISTS vendor_name VARCHAR(512);zIALTER TABLE violations ADD COLUMN IF NOT EXISTS marketplace VARCHAR(255);z._create_tables6sW ||~Q Q mmDMM$<$<===llZ ll-.44+66&(B-55< s ( )C-G%%  \\)XXt{7&B}I;7~oZLQ(1B,X'k]K J)+loggingfastapirfastapi.middleware.corsr sqlalchemyrrsqlalchemy.excrapp.api.routes.productsrr;app.api.routes.authr9app.api.routes.vendorsr:app.api.routes.violationsr<app.api.routes.dashboardr= app.db.baser app.db.sessionr app.core.securityr app.models.password_reset_tokenr app.modelsr rrrrr basicConfigINFO logger_name getLoggersetLevelr>rr?r-rUs2*<5:A?!$>UU ,, A 6:KGk"++GLL9: vGvrlr?