o
    *h                     @   sn   d dl mZ d dlmZ d dlmZ e ZG dd deejZG dd dejZG dd	 d	ejZ	d
d Z
dS )    )
SQLAlchemy)	UserMixin)datetimec                   @   s~   e Zd ZdZejejddZejeddddZ	ejedddZ
ejejdd	ZejejddZejed
ddZdS )UseruserTprimary_keyP   Funiquenullable   r   default   N)__name__
__module____qualname____tablename__dbColumnIntegeridStringusernamepasswordBooleanZis_admin
gallery_idrole r    r    ,/var/www/html/figdemos/bartoux_crm/models.pyr      s    r   c                   @   sj   e Zd ZdZejejddZejeddddZ	ejej
ddZejej
ddZejedddZd	S )
ArtistartistTr   d   Fr
   r   r   N)r   r   r   r   r   r   r   r   r   nameTextdescriptiondescription_en
image_pathr    r    r    r!   r"      s    r"   c                   @   s   e Zd ZdZejejddZejeddddZ	ejedddZ
ejed	ddZejedddZeed
Zeed
ZeejZeejZeejZeejZejeddddZejejddZejejejdZdS )ArtworkartworkTr   r$   Fr
      r   r   2   r   pendingr   r   r   N)r   r   r   r   r   r   r   r   r   cegidtitler)   artist_nametypeprice_range	height_cmwidth_cmdepth_cmr&   
commentarystatusr   is_availableDateTimer   utcnow
created_atr    r    r    r!   r*      s     r*   c                 C   s  d|  }t |tjfi dd|  ddtjtjdddtjtjtd	dd
dtjtddd
dtjtddd
dttddttddttddtjtdddddttddttddttjdtjtjdddttj	dtjtjddd tjtdd!dd"tjtj
dd
tjtdd#dtjtjtjdtjtjtjtjd$d%S )&z2Dynamically create a client table for each galleryZGalleryClient_r   galleryZ_clientsr   Tr   commercial_idzuser.idr   
first_namer$   F	last_nameemailx   phone_number   commercial_namer9   r   ZProspectr/   nationalityr-   languagefavorite_artists
newsletterr   r8   potential_hautrelance_statusu   À relancerrelance_datezEn cours)r   onupdate)negotiation_statusr=   
updated_at)r3   r   Modelr   r   
ForeignKeyr   JSONr   r&   Dater;   r   r<   )r   
class_namer    r    r!   create_gallery_client_table)   sP   
	

rV   N)Zflask_sqlalchemyr   flask_loginr   r   r   rQ   r   r"   r*   rV   r    r    r    r!   <module>   s    	