
    	,h                     x    d dl mZmZ d dlmZmZmZ d dlmZ d dl	m
Z
mZmZmZ  G d de      Z G d de      Zy	)
    )	BaseModelField)VARCHAR
ForeignKeyInteger)Base)mapped_columnMappedrelationshipSessionc                   b   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	<    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)CompetitorCategoryAnalysesBaseN)defaultcompetitor_category_idreference_competitornumber_of_categories_stockedkey_categories_stockedstocking_observationscompetitor_others_remarkresearch_methodologyshopping_behaviorconsumer_others_remarkgroup_id)__name__
__module____qualname__r   r   int__annotations__r   strr   r   r   r   r   r   r   r        G/var/www/html/RetailAPI/app/models/main/competitor_category_analyses.pyr   r      s    */*=S4Z=(-d(;3:;05d0C 3:C*/*=S4Z=).t)<C$J<,1$,?sTz?(-d(;3:;%*4%8d
8*/*=S4Z=!$/HsTz/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      Zee   e	d<    eded      Zee   e	d<    ed	 e
d      d      Zee   e	d	<    ed
 e
d      d      Zee   e	d
<    ed e
d      d      Zee   e	d<    ed e
d      d      Zee   e	d<    ed e
d      d      Zee   e	d<    ed e
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) TblCompetitorCategoryAnalyses tbl_competitor_category_analysesr   T)primary_keyautoincrementr      )nullabler   r   r   other_remarksr   r   r   others_remarkr   r   ztbl_group.group_idTblGroupcompetitor_category_analyses)back_populatesdatadbreturnc                 x    |j                         } | di |}|j                  |       |j                          |S )Nr    )
model_dumpaddflush)clsr/   r0   	data_dictnew_datas        r"   createz$TblCompetitorCategoryAnalyses.create#   s5    OO%	##
x

r!   c                 |    |j                  |       j                  | j                  |k(        j                         }|S N)queryfilterr   first)r6   r   r0   get_datas       r"    get_competitor_category_analysesz>TblCompetitorCategoryAnalyses.get_competitor_category_analyses+   s4    88C=''(B(BF\(\]ccer!   competitor_category_update_idc                 ,   |j                  |       j                  | j                  |k(        j                         }|j	                         }|j                         D ]  \  }}|	t        |||        |j                          |j                  |       y r;   )	r<   r=   r   r>   r3   itemssetattrcommitrefresh)r6   rA   r/   r0   update_datar7   keyvalues           r"   #update_competitor_category_analyseszATblCompetitorCategoryAnalyses.update_competitor_category_analyses0   sy    hhsm**3+E+EIf+fgmmoOO%	#//+JC S%0 , 			


;r!   competitor_category_delete_idc                     |j                  |       j                  | j                  |k(        j                         }|sy|j	                  |       |j                          y)NFT)r<   r=   r   r>   deleterE   )r6   rK   r0   delete_datas       r"   #delete_competitor_category_analyseszATblCompetitorCategoryAnalyses.delete_competitor_category_analyses:   sM    hhsm**3+E+EIf+fgmmo
		+
		r!   N)r   r   r   __tablename__r	   r   r   r
   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   groupclassmethodr   r   r9   r@   rJ   rO   r    r!   r"   r$   r$      s   6M+89QSZhl  }A  ,BVC[  B)67MwWZ|fj)k6#;k1>?]_fqu1v 6#;v+89QSZ[^S_jn+oVC[o*78OQXY\Q]hl*mF3Km-:?GTWLcg-hvc{h)67MwWZ|fj)k6#;k&34GQT`d&ese+8'RU,ae+fVC[f*:w
K_@`aHvc{a4RSE7 G Gf   S W Xw    s  Yw    }D    Hg     s W^   cB  r!   r$   N)pydanticr   r   
sqlalchemyr   r   r   app.models.base_classr   sqlalchemy.ormr	   r
   r   r   r   r$   r    r!   r"   <module>rW      s/    % 3 3 & D D0Y 0.D .r!   