
    di                         d dl mZmZ d dlmZmZ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TextDOUBLE)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        S/var/www/html/retail-simulation-api/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            	       6   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      Zee   e	d	<    ed
ed      Zee   e	d
<    eded      Zee   e	d<    eded      Zee   e	d<    eded      Zee   e	d<    ede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)clsr1   r2   	data_dictnew_datas        r$   createz$TblCompetitorCategoryAnalyses.create#   s5    OO%	##
x

r#   c                 |    |j                  |       j                  | j                  |k(        j                         }|S N)queryfilterr   first)r8   r   r2   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@   r5   itemssetattrcommitrefresh)r8   rC   r1   r2   update_datar9   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@   deleterG   )r8   rM   r2   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   r   r   groupclassmethodr   r   r;   rB   rL   rQ   r"   r#   r$   r&   r&      s   6M+89QSZhl  }A  ,BVC[  B)67MwWZ|fj)k6#;k1>?]_ept1u 6#;u+89QSWbf+gVC[g*78OQU`d*eF3Ke-:?D[_-`vc{`)67Mt^b)c6#;c&34GX\&]s]+8$Y]+^VC[^*: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   r   r	   app.models.base_classr
   sqlalchemy.ormr   r   r   r   r   r&   r"   r#   r$   <module>rY      s/    % A A & D D0Y 0.D .r#   