o
    $Ɖi                     @   s2   d dl Zd dlmZ d	ddZdd Zdd ZdS )
    N)INPUT_DB_CONFIGc              
   C   s  d }zzt jjdi t}| }d}	||	| f | }
|
r|
d }g }g }|d ur6|d || |d urD|d || |d urR|d || |d ur`|d || |d urn|d || |d ur||d || |rd	d
| d}|| ||t	| |
  |W W |r|  S S d}||| ||||||f |
  |jW W |r|  S S  ty } z	td|  |d }~ww |r|  w w )NzQSELECT id FROM selfpr_logs WHERE session_id = %s ORDER BY created_at DESC LIMIT 1r   zuser_name=%szuser_age=%szcompany_name=%szphoto_path=%szselected_items=%szsite_url=%szUPDATE selfpr_logs SET z, z WHERE id = %sz
                INSERT INTO selfpr_logs 
                (session_id, user_name, user_age, company_name, photo_path, selected_items, site_url) 
                VALUES (%s, %s, %s, %s, %s, %s, %s)
            z[SelfPR DB Error]  )mysql	connectorconnectr   cursorexecutefetchoneappendjointuplecommitclose	lastrowid	Exceptionprint)
session_id	user_nameuser_agecompany_name
photo_pathselected_itemssite_urlconnr   	check_sqlrowlog_idupdate_fieldsparamssqler   r   :/home/air/goalskill_sales/back/app/models/selfpr_module.pyinsert_selfpr_log   sj   















r"   c              
   C   s   d }zKz't jjdi t}|jdd}d}||| f | }|W W |r*|  S S  tyM } zt	d|  W Y d }~W |rG|  d S d S d }~ww |rU|  w w )NT
dictionaryz
            SELECT user_name, user_age, company_name, photo_path, selected_items, site_url, created_at
            FROM selfpr_logs 
            WHERE session_id = %s 
            ORDER BY created_at DESC 
            LIMIT 1
        z[SelfPR DB Load Error] r   )
r   r   r   r   r   r   r	   r   r   r   )r   r   r   r   r   r    r   r   r!   get_selfpr_logB   s,   

r%   c              
   C   s   d }zezAddl m} tjjd
i |}|jdd}d}||| f | }|r9|d r9|d W W |r8|  S S W W |rC|  dS dS  t	yg } zt
d|  W Y d }~W |ra|  d	S d	S d }~ww |ro|  w w )Nr   )A_DB_CONFIGTr#   z?SELECT username FROM user_profile_summary WHERE session_id = %susernamezUnknown Userz[SelfPR Profile Load Error] Guestr   )app.core.configr&   r   r   r   r   r   r	   r   r   r   )r   r   r&   r   r   r   r    r   r   r!   get_username_from_profile\   s8   


r*   )NNNNNN)mysql.connectorr   r)   r   r"   r%   r*   r   r   r   r!   <module>   s
    
>