
    whI                         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 d dlmZmZmZmZ d dlmZ  G d de      Z G d	 d
e      Zy)    )Literal)	BaseModelField)VARCHAR
ForeignKeyIntegerEnum)Base)Mappedmapped_columnrelationshipSession)ENUMc                   "   e Zd ZU dZ 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)CarpentryBasetbl_carpentryN)defaultcarpentry_idformate_typestore_format_typenumber_of_unitscost_per_unittotalremarkgroup_id)__name__
__module____qualname____tablename__r   r   int__annotations__r   strr   r   r   r   r   r        @/var/www/html/retail-simulation-api/app/models/main/carpentry.pyr   r      s    !M %d 3L3:3 %d 3L3:3 &+4%8d
8#(#6OcDj6!&t!4MC$J4t,EC$J,-FS4Z-!$/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            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d      Zee   e	d<    ee ed      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)TblCarpentryr   r   T)primary_keyautoincrementr      N)nullableserver_defaultr   zStore Format AzStore Format Br   r   r   r   ztbl_group.group_idF)r+   r   TblGroup	carpentry)back_populatesdatadbreturnc                 x    |j                         } | di |}|j                  |       |j                          |S )Nr#   )
model_dumpaddflush)clsr0   r1   	data_dictnew_datas        r%   createzTblCarpentry.create.   s5    OO%	##
x

r$   c                 |    |j                  |       j                  | j                  |k(        j                         }|S N)queryfilterr   all)r7   r   r1   get_datas       r%   get_by_carpentryzTblCarpentry.get_by_carpentry6   s1    88C=''(@AEEGr$   carpentry_update_idc                 ,   |j                  |       j                  | j                  |k(        j                         }|j	                         }|j                         D ]  \  }}|	t        |||        |j                          |j                  |       y r<   )	r=   r>   r   firstr4   itemssetattrcommitrefresh)r7   rB   r0   r1   update_datar8   keyvalues           r%   update_carpentryzTblCarpentry.update_carpentry;   sy    hhsm**3+;+;?R+RSYY[OO%	#//+JC S%0 , 			


;r$   c                     |j                  |       j                  | j                  |k(        j                         }|sy|j	                  |       |j                          |S )NF)r=   r>   r   rD   deleterG   )r7   r   r1   delete_datas       r%   delete_carpentryzTblCarpentry.delete_carpentryE   sO    hhsm**3+;+;|+KLRRT
		+
		r$   )r   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:   rA   rL   rP   r#   r$   r%   r'   r'      s   !M!.~wTXhl!mL6#;m!.~ws|VZko!pL6#;p '44GN^_oIp&qsq$12CWW[lp$qOfSkq"/SWhl"mMF3Km'4X\]EF3K](73<$_cdFVC[d)':>R3S^cdHfSkdK@E - W      N    3  m  QX  \j     3 7 n  r$   r'   N)typingr   pydanticr   r   
sqlalchemyr   r   r   r	   app.models.base_classr
   sqlalchemy.ormr   r   r   r   sqlalchemy.dialects.mysqlr   r   r'   r#   r$   r%   <module>rY      s5     % 8 8 & D D *0I 0 44 4r$   