
    ph=                     |    d dl mZmZmZmZmZmZmZmZm	Z	 d dl
mZ d dlmZ d dlmZmZ  e       Z G d de      Zy)    )	ColumnInteger
BigIntegerFloatStringDateTimeBooleanText
ForeignKey)relationship)declarative_base)datetimetimezonec                      e Zd ZdZdZ eedd      Z eedd      Z eedd      Z	 ee
d      Z ee
d      Z ee
d      Z ee
d      Z eed      Z eed	      Z eed	      Z eed	      Z eed	      Z eed	      Z eed      Z eed      Z eed
 	      Z eed d       Z eed	      Zd Zy)StorePerformanceScorez8Model for storing monthly performance scores for stores.store_performance_scoresT)primary_keyautoincrementF)nullableindex)r   r   )defaultc                  H    t        j                  t        j                        S Nr   nowr   utc     B/var/www/html/hubwallet-dev/src/marketing/apps/Analytics/models.py<lambda>zStorePerformanceScore.<lambda>%       (,,x||2L r   c                  H    t        j                  t        j                        S r   r   r   r   r   r    zStorePerformanceScore.<lambda>&   r!   r   c                  H    t        j                  t        j                        S r   r   r   r   r   r    zStorePerformanceScore.<lambda>&   s    _g_k_kltlxlx_y r   )r   onupdatec           	      p    d| j                    d| j                   d| j                   d| j                   d	S )Nz <StorePerformanceScore(store_id=z, score=z, month=/z)>)store_idoverall_scorescore_month
score_year)selfs    r   __repr__zStorePerformanceScore.__repr__)   sW    1$--I[I[H\\deieueudvvwx|  yH  yH  xI  IK  L  	Lr   N)__name__
__module____qualname____doc____tablename__r   r   idr'   	branch_idr   r(   engagement_ratereach_efficiencyposting_consistencyr
   platform_scoresr   total_poststotal_engagementtotal_impressionstotal_followersconnected_accounts_countr)   r*   r   
created_at
updated_atr	   	is_activer,   r   r   r   r   r      s   B.M	
D	ABj5=HzD=I 551MUU3Oee4 7 TD1O !,Kj!4z15Z3O%gq9 51K%0J *LMJ*LWyzJw-ILr   r   N)
sqlalchemyr   r   r   r   r   r   r	   r
   r   sqlalchemy.ormr   sqlalchemy.ext.declarativer   r   r   Baser   r   r   r   <module>rD      s-    f f f ' 7 '"LD "Lr   