Ë
    	,¹hÆ  ã                   óx   — d dl mZmZ d dlmZmZmZmZ d dlm	Z	m
Z
mZ d dlmZ  G d„ de«      Z G d„ de«      Zy	)
é    )Ú	BaseModelÚField)ÚMappedÚmapped_columnÚSessionÚrelationship)Ú
ForeignKeyÚIntegerÚVARCHAR)ÚBasec                   óü   — e Zd ZU  ed¬«      Zedz  ed<    ed¬«      Zedz  ed<    ed¬«      Z	edz  ed<    ed¬«      Z
edz  ed<    ed¬«      Zedz  ed<    ed¬«      Zedz  ed<    ed¬«      Zedz  ed	<   y)
ÚCompetitorPricingAnalysisBaseN)ÚdefaultÚcompetitor_idÚreference_competitorÚpricing_strategyÚ6which_category_generates_the_most_income_for_the_storeÚ+key_observation_around_pricing_in_the_storeÚother_remarksÚgroup_id)Ú__name__Ú
__module__Ú__qualname__r   r   ÚintÚ__annotations__r   Ústrr   r   r   r   r   © ó    úF/var/www/html/RetailAPI/app/models/main/competitor_pricing_analysis.pyr   r      sŒ   … á!&¨tÔ!4€MC˜$‘JÓ4Ù(-°dÔ(;Ð˜3 ™:Ó;Ù$)°$Ô$7Ðs˜T‘zÓ7ÙJOÐX\ÔJ]Ð:¸SÀ4¹ZÓ]Ù?DÈTÔ?RÐ/°#¸±*ÓRÙ!&¨tÔ!4€MC˜$‘JÓ4Ù!¨$Ô/€HˆsT‰zÔ/r   r   c            	       óþ  — e Zd ZU dZ ededd¬«      Zee   e	d<    ed e
d«      dd¬«      Zee   e	d<    ed	 e
d«      dd¬«      Zee   e	d	<    ed
 e
d«      dd¬«      Zee   e	d
<    ed e
d«      dd¬«      Zee   e	d<    ed e
d«      dd¬«      Zee   e	d<    ede ed«      «      Zee   e	d<    edd¬«      Zedededd fd„«       Zedededd fd„«       Zededededd fd„«       Zedededd fd„«       Zy)ÚTblCompetitorPricingAnalysisÚtbl_competitor_pricing_analysisr   T)Úprimary_keyÚautoincrementr   éÿ   N)ÚnullableÚserver_defaultr   r   r   r   r   ztbl_group.group_idÚTblGroupÚcompetitor_pricing_analysis)Úback_populatesÚdataÚdbÚreturnc                 óx   — |j                  «       } | di |¤Ž}|j                  |«       |j                  «        |S )Nr   )Ú
model_dumpÚaddÚflush)Úclsr+   r,   Ú	data_dictÚnew_datas        r   Ú"create_competitor_pricing_analysisz?TblCompetitorPricingAnalysis.create_competitor_pricing_analysis   s5   € à—O‘OÓ%ˆ	ÙÑ#˜Ñ#ˆØ
‰ˆxÔØ
‰Œ
Øˆr   Úcompetitor_get_idc                 ó|   — |j                  | «      j                  | j                  |k(  «      j                  «       }|S ©N)ÚqueryÚfilterr   Úfirst)r2   r6   r,   Úget_datas       r   Úget_competitor_pricing_analysisz<TblCompetitorPricingAnalysis.get_competitor_pricing_analysis%   s4   € à—8‘8˜C“=×'Ñ'¨×(9Ñ(9Ð=NÑ(NÓO×UÑUÓWˆØˆr   Úcompetitor_update_idc                 ó.  — |j                  | «      j                  | j                  |k(  «      j                  «       }|j	                  «       }|j                  «       D ]  \  }}|€Œ	t        |||«       Œ |j                  «        |j                  |«       |S r8   )	r9   r:   r   r;   r/   ÚitemsÚsetattrÚcommitÚrefresh)r2   r>   r+   r,   Úupdate_datar3   ÚkeyÚvalues           r   Ú"update_competitor_pricing_analysisz?TblCompetitorPricingAnalysis.update_competitor_pricing_analysis*   s   € à—h‘h˜s“m×*Ñ*¨3×+<Ñ+<Ð@TÑ+TÓU×[Ñ[Ó]ˆØ—O‘OÓ%ˆ	Ø#Ÿ/™/Ö+‰JˆCØÑ Ü˜ S¨%Õ0ð ,ð 		‰	ŒØ

‰
;ÔØÐr   c                 óÐ   — |j                  | «      j                  | j                  |k(  «      j                  «       }|sy|D ]#  }|j	                  |«       |j                  «        Œ% y)NFT)r9   r:   r   ÚallÚdeleterB   )r2   r   r,   Údelete_datarJ   s        r   Ú"delete_competitor_pricing_analysisz?TblCompetitorPricingAnalysis.delete_competitor_pricing_analysis5   sV   € à—h‘h˜s“m×*Ñ*¨3¯<©<¸8Ñ+CÓD×HÑHÓJˆÙØÛ!ˆFØI‰IfÔØI‰IKð "ð r   )r   r   r   Ú__tablename__r   r
   r   r   r   r   r   r   r   r   r   r   r   r	   r   r   ÚgroupÚclassmethodr   r   r5   r=   rG   rL   r   r   r   r!   r!      sé  … Ø5€Má"/°ÀÐVZÐjnÔ"o€MF˜3‘KÓoÙ)6Ð7MÉgÐVYËlÐeiÐz~Ô)Ð˜6 #™;ÓÙ%2Ð3EÁwÈsÃ|Ð^bÐswÔ%xÐv˜c‘{ÓxÙKXð  ZRñ  T[ð  \_ó  T`ð  koð  @Dô  LEÐ:¸VÀC¹[ó  EÙ@MÐN{ñ  ~Eð  FIó  ~Jð  UYð  jnô  AoÐ/°&¸±+ó  oÙ"/°ÁÈÃÐX\ÐmqÔ"r€MF˜3‘KÓrÙ*¨:°wÁ
ÐK_Ó@`Óa€Hˆvc‰{Óaá˜Ð4QÔR€EàðÐ5Rð ÐW^ð ð  cAò ó ðð ð¸sð Àwð ÐRpò ó ðð ðÀSð ÐOlð Ðqxð ð  }[ò ó ðð ð¸ð Àð ÐLjò ó ñr   r!   N)Úpydanticr   r   Úsqlalchemy.ormr   r   r   r   Ú
sqlalchemyr	   r
   r   Úapp.models.base_classr   r   r!   r   r   r   ú<module>rT      s/   ðß %ß DÓ Dß 3Ñ 3Ý &ô0 Iô 0ô- 4õ -r   