
    NRi
                         d dl mZmZ d dl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  G d de      Z G d de      Zy	)
    )	BaseModelField)Base)Mappedmapped_columnrelationshipSession)
ForeignKeyIntegerVARCHARFloatTextc                       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)ShrinkageAreasReasonsBaseNdefaultshrinkage_id	shrinkageshrinkage_do_you_envisionshrinkage_in_your_storesgroup_id)__name__
__module____qualname__r   r   int__annotations__r   floatr   strr   r        N/var/www/html/retail-simulation-api/app/models/main/shrinkage_areas_reasons.pyr   r      sc     %d 3L3:3$T2I2-24-@d
@,1$,?sTz?!$/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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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)TblShrinkageAreasReasonstbl_shrinkage_areas_reasonsr   T)primary_keyautoincrementr   N)nullableserver_defaultr   0shrinkage_in_your_storesshrinkage_in_your_storesr   
is_deletedr   r   r   ztbl_group.group_idTblGroupshrinkage_areas_reasons)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_shrinkage_areas_reasonsz7TblShrinkageAreasReasons.create_shrinkage_areas_reasons   s5    OO%	##
x

r    c                 |    |j                  |       j                  | j                  |k(        j                         }|S N)queryfilterr   all)r5   r   r/   get_datas       r!   get_shrinkage_areas_reasonsz4TblShrinkageAreasReasons.get_shrinkage_areas_reasons!   s1    88C=''(@AEEGr    shrinkage_update_idc                 .   |j                  |       j                  | j                  |k(        j                         }|j	                         }|j                         D ]  \  }}|	t        |||        |j                          |j                  |       |S r:   )	r;   r<   r   firstr2   itemssetattrcommitrefresh)r5   r@   r.   r/   update_datar6   keyvalues           r!   update_shrinkage_areas_reasonsz7TblShrinkageAreasReasons.update_shrinkage_areas_reasons&   s    hhsm**3+;+;?R+RSYY[OO%	#//+JC S%0 , 			


;r    c                     |j                  |       j                  | j                  |k(        j                         }|syd|_        |j                          y)NF   T)r;   r<   r   rB   r*   rE   )r5   r   r/   delete_datas       r!   delete_shrinkage_areas_reasonsz7TblShrinkageAreasReasons.delete_shrinkage_areas_reasons1   sH    hhsm**3+;+;|+KLRRT!"
		r    )r   r   r   __tablename__r   r   r   r   r   r   r   r   r   r   r   r   r   r*   r
   r   r   groupclassmethodr   r	   r8   r?   rJ   rN   r   r    r!   r#   r#      s   1M!.~wTXhl!mL6#;m -k54`d eIue.;<WY]hl  ~B  /Cs  C-:;mos  C  TX  .Yvc{  Y,\7ANJN*:zBV7WXHvc{X4MNE1J w Zt   # ' E_    Jc ho   tN     Lf  r    r#   N)pydanticr   r   app.models.base_classr   sqlalchemy.ormr   r   r   r	   
sqlalchemyr
   r   r   r   r   r   r#   r   r    r!   <module>rV      s/    % & D D @ @0	 0+t +r    