!+idZddlmZmZmZmZmZmZmZm Z m Z ddl m Z ddl mZGddeZGddeZGd d eZy ) uu Modelos para análise de inteligência competitiva. Rastreamento de métricas, eventos e impactos de concorrentes. ) ColumnStringIntegerNumericBooleanDateTimeText TIMESTAMP ForeignKey)func)BaseceZdZdZdZeeddZeedddZ eedddZ ee de jdZeed d ZeeZeeZeed d ZeeZeeZeeZeeZeed d ZeeZeed Zeed d ZeeZeeZeed d ZeeZ dZ!y)CompetitorMetricsHistoryu Histórico completo de métricas de concorrentes. Armazena snapshots periódicos de todas as métricas disponíveis do concorrente, junto com nossas métricas no mesmo momento para permitir análise comparativa. competitor_metrics_historyT primary_key autoincrement2Fnullableindex)rdefaultr c<d|jd|jdS)Nz) competitor_id timestampselfs P/var/www/hypershopcomercio.com.br/hyper-ai/app/models/competitor_intelligence.py__repr__z!CompetitorMetricsHistory.__repr__1s#$T%7%7$8DNN;K1MMN)"__name__ __module__ __qualname____doc__ __tablename__rridrr! our_ad_idrr nowr"rpricevisitssalesconversion_ratesearch_positionrhas_free_shipping has_promotionstock_availablerating reviews_countseller_reputation our_price our_visits our_salesour_conversion_rateour_search_positionr&r'r%rr s 1M T >B6":TBMvbzE>Ix%4PI 72q> "E G_F 7OEWQ]+OWoOw7OMWoO GAqM "F7OMvbz* wr1~&IJwI A/ /Nr'rceZdZdZdZeeddZeedddZ eedddZ eedddZ ee de jZee de jZeedZeed d Zeed d Zeed d ZeeZeeZeed d Zeed d ZeeZeeZeeZeed d Zeed d ZeedZeeZ ee!Z"ee!Z#ee$dZ%eedZ&ee Z'dZ(y)CompetitorImpactEventu Eventos de impacto competitivo detectados. Registra mudanças significativas do concorrente e o impacto medido em nossas métricas. Usado para análise de correlação e diagnósticos automáticos. competitor_impact_eventsTrrFrrrrrrrr)rcVd|jd|jd|jdS)Nz B6":TBMvbzE>Ir U$?JXxtxxzJOE8488:FK $F2J/%gb!n5$WR^4wq!}- gWoO"71a=1!'!Q-0wg "'?#GBN3wq!}-fRj)'?Lt ID\N'51L$Kh'cr'rBc4eZdZdZdZeeddZeedddZ eedddZ ee de jZeeZeeZeeZeeZeeZeeZeed ZeeZd Zy ) CompetitorThreatScoreu Score de ameaça competitiva agregado (atualizado diariamente). Combina múltiplos fatores para gerar um score único de ameaça por concorrente. Permite priorização rápida de monitoramento. competitor_threat_scoresTrrFrrDrc<d|jd|jdS)Nz )r!total_threat_scorer#s r%r&zCompetitorThreatScore.__repr__s%t112"T5L5L4MUSSr'N)r(r)r*r+r,rrr-rr!r.rr r/ calculated_atprice_advantage_scoreconversion_advantage_scorevisits_advantage_scoreposition_advantage_scorereputation_advantage_scorerb threat_levelr summaryr&r@r'r%r_r_ks /M T >B6":TBMvbzE>I8eXTXXZHM #7O!'#G_%g!'  &*%LTlGTr'r_N)r+ sqlalchemyrrrrrrr r r sqlalchemy.sqlr app.models.baser rrBr_r@r'r%rnsH hgg 'Nt'NT3cD3cl!TD!Tr'