
    di                         d dl mZ d dlmZ 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mZmZ d dlmZ  G d de      Z G d	 d
e      Zy)    )Enum)List)	BaseModelField)Mappedmapped_columnSessionrelationship)Integerr   
ForeignKeyVARCHARText)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<   y)	CategoryPricingStrategisBaseN)defaultcategory_idcategorypricing_strategisrationalspecify_other_strategygroup_id)__name__
__module____qualname__r   r   int__annotations__r   strr   r   r   r        Q/var/www/html/retail-simulation-api/app/models/main/category_pricing_strategis.pyr   r   	   sv    $T2K#*2!$/HsTz/%*4%8d
8!$/HsTz/*/*=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d      Zee   e	d<    ed	 e
d      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)TblCategoryPricingStrategistbl_category_pricing_strategisr   T)primary_keyautoincrementr      N)nullableserver_defaultr   r   r   r   ztbl_group.group_idTblGroupcategory_pricing_strategis)back_populatesdatadbreturnc                 t     | di |j                         }|j                  |       |j                          |S )Nr   )
model_dumpaddflush)clsr-   r.   	data_dicts       r!   !create_category_pricing_strategisz=TblCategoryPricingStrategis.create_category_pricing_strategis$   s1    ,$//+,	
y

r    c                 |    |j                  |       j                  | j                  |k(        j                         }|S N)queryfilterr   all)r4   r   r.   get_datas       r!   get_category_pricing_strategisz:TblCategoryPricingStrategis.get_category_pricing_strategis+   s1    88C=''(@AEEGr    	update_idc                 .   |j                  |       j                  | j                  |k(        j                         }|j	                         }|j                         D ]  \  }}|	t        |||        |j                          |j                  |       |S r8   )	r9   r:   r   firstr1   itemssetattrcommitrefresh)r4   r>   r-   r.   update_datar5   keyvalues           r!   !update_category_pricing_strategisz=TblCategoryPricingStrategis.update_category_pricing_strategis0   s|    hhsm**3??i+GHNNPOO%	#//+JC S%0 , 			


;r    c                     |j                  |       j                  | j                  |k(        j                         }|sy|j	                  |       |j                          y)NFT)r9   r:   r   r@   deleterC   )r4   r   r.   delete_datas       r!   !delete_category_pricing_strategisz=TblCategoryPricingStrategis.delete_category_pricing_strategis;   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   r   r   r
   groupclassmethodr   r	   r6   r=   rH   rL   r   r    r!   r#   r#      sy   4M -mWRVfj kK&+k*:ws|dcghHvc{h&34GPS_ctx&ysy*:td[_`Hvc{`+89QSWbfw{+|VC[|*:w
K_@`aHvc{a4PQE4P U\ `}   S W He    C_ dk   pM   3 7 Nk  r    r#   N)enumr   PyEnumtypingr   pydanticr   r   sqlalchemy.ormr   r   r	   r
   
sqlalchemyr   r   r   r   app.models.base_classr   r   r#   r   r    r!   <module>rW      s5      % G G ? ? &09 0*$ *r    