
    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)DOUBLEVARCHAR
ForeignKeyInteger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<    ed      Zedz  ed<   y)	VisualMerchStrategyBaseN)default	visual_idinternal_display_remarkexternal_display_remarkFrequency_change_per_year Frequency_change_per_year_remarkgroup_id)__name__
__module____qualname__r   r   int__annotations__r   strr   r   r   r        T/var/www/html/retail-simulation-api/app/models/main/visual_merchandising_strategy.pyr   r      sx    "40Id
0+0+>cDj>+0+>cDj>-24-@d
@49$4G$sTzG!$/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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)TblVisualMerchStrategytbl_visual_merch_strategyr   T)primary_keyautoincrementr   N)nullableserver_defaultr   r   r   groupztbl_group.group_idr   TblGroupvisual_merchandising_strategy)back_populatesdatadbreturnc                 t     | di |j                         }|j                  |       |j                          |S )Nr   )
model_dumpaddflush)clsr,   r-   new_datas       r    createzTblVisualMerchStrategy.create   s0    +*+
x

r   c                 |    |j                  |       j                  | j                  |k(        j                         }|S N)queryfilterr   all)r3   r   r-   get_datas       r    getzTblVisualMerchStrategy.get#   s1    88C=''(@AEEGr   c                 .   |j                  |       j                  | j                  |k(        j                         }|j	                         }|j                         D ]  \  }}|	t        |||        |j                          |j                  |       |S r7   )	r8   r9   r   firstr0   itemssetattrcommitrefresh)r3   r   r,   r-   update_data	data_dictkeyvalues           r    updatezTblVisualMerchStrategy.update(   s|    hhsm**3==I+EFLLNOO%	#//+JC S%0 , 			


;r   c                     |j                  |       j                  | j                  |k(        j                         }|sy|j	                  |       |j                          y)NFT)r8   r9   r   r>   deleterA   )r3   r   r-   delete_datas       r    rI   zTblVisualMerchStrategy.delete3   sJ    hhsm**3==I+EFLLN
		+
		r   )r   r   r   __tablename__r   r   r   r   r   r   r   r   r   r   r
   r   r   r   r   r   r(   classmethodr   r	   r5   r<   rG   rI   r   r   r    r"   r"      s   /M+KdbfgIsg,9:SUYdhy},~fSk~,9:SUYdhy},~fSk~.;<WY_jn  @D  /Es  E5BCegkvz  LP  6Q$vc{  Q*7J?S4TUHvc{U4STE0 W @X   # ' -E   c (? G Og   c g 1I  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>rQ      s/    % & D D @ @0i 0+T +r   