
    wh[
                     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)
ForeignKeyIntegerVARCHAR)Base)Mappedmapped_columnrelationshipSessionc                       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<   y)ConsumerPreferencesResearchBaseN)defaultconsumer_idresearch_methodologyshopping_behaviorothesr_remarkgroup_id)__name__
__module____qualname__r   r   int__annotations__r   strr   r   r        T/var/www/html/retail-simulation-api/app/models/main/consumer_preferences_research.pyr   r      sc    $T2K#*2(-d(;3:;%*4%8d
8!&t!4MC$J4!$/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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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)TblConsumerPreferencesResearch!tbl_consumer_preferences_researchr   T)primary_keyautoincrementr      N)nullableserver_defaultr   others_remarkr   r   ztbl_group.group_iddatadbreturnc                 x    |j                         } | di |}|j                  |       |j                          |S )Nr   )
model_dumpaddflush)clsr'   r(   	data_dictnew_datas        r   createz%TblConsumerPreferencesResearch.create   s5    OO%	##
x

r   consumer_get_idc                 |    |j                  |       j                  | j                  |k(        j                         }|S N)queryfilterr   first)r.   r2   r(   get_datas       r   !get_consumer_preferences_researchz@TblConsumerPreferencesResearch.get_consumer_preferences_research!   s1    88C=''?(JKQQSr   consumer_update_idc                 ,   |j                  |       j                  | j                  |k(        j                         }|j	                         }|j                         D ]  \  }}|	t        |||        |j                          |j                  |       y r4   )	r5   r6   r   r7   r+   itemssetattrcommitrefresh)r.   r:   r'   r(   update_datar/   keyvalues           r   $update_consumer_preferences_researchzCTblConsumerPreferencesResearch.update_consumer_preferences_research&   sw    hhsm**3??>P+PQWWYOO%	#//+JC S%0 , 			


;r   c                     |j                  |       j                  | j                  |k(        j                         }|sy|j	                  |       |j                          y)NFT)r5   r6   r   r7   deleter>   )r.   r   r(   delete_datas       r   $delete_consumer_preferences_researchzCTblConsumerPreferencesResearch.delete_consumer_preferences_research0   sJ    hhsm**3??k+IJPPR
		+
		r   )r   r   r   __tablename__r
   r   r   r	   r   r   r   r   r   r   r   r   r   classmethodr   r   r1   r9   rC   rG   r   r   r   r   r      s^   7M -mWRVfj kK&+k)67MwWZ|fj{  *A6#;  A&34GQT`duy&zsz"/X\mq"rMF3Kr*:w
K_@`aHvc{a 8 W Hh   s w Rr    S  On  sz    _     c g Qq  r   r   N)pydanticr   r   
sqlalchemyr   r   r   app.models.base_classr   sqlalchemy.ormr	   r
   r   r   r   r   r   r   r   <module>rN      s/    % 2 2 & D D0i 0)T )r   