
    Ui                     .    d dl Zd dlmZ ddZd Zd ZdS )    N)D_DB_CONFIGc           
         d }	 t          j        j        di t          }|                                }d}	|                    |	| f           |                                }
|
r|
d         }g }g }|*|                    d           |                    |           |*|                    d           |                    |           |*|                    d           |                    |           |*|                    d           |                    |           |*|                    d           |                    |           |*|                    d           |                    |           |red	d
                    |           d}|                    |           |                    |t          |                     |
                                 ||r|                                 S S d}|                    || ||||||f           |
                                 |j        |r|                                 S S # t          $ r}t          d|            |d }~ww xY w# |r|                                 w w xY 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es                    /app/app/models/selfpr_module.pyinsert_selfpr_logr$      s   D:&5555 h	y:-000oo )	$VFMF$$$^444i(((#$$]333h''''$$%6777l+++%$$_555j))))$$%8999n---#$$]333h''' X		-0H0HXXXf%%%sE&MM222   	JJLLLL	C
 NN3Y,PZ\jlt uvvvKKMMM#  	JJLLLL		    &1&&'''  	JJLLLL	s*   GI 79I 
I+I&&I++I. .Jc                    d }	 t          j        j        di t          }|                    d          }d}|                    || f           |                                }||r|                                 S S # t          $ r5}t          d|            Y d }~|r|                                 d S d S d }~ww xY w# |r|                                 w w xY 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"   s         r#   get_selfpr_logr(   B   s   D&5555-- 	sZM***oo  	JJLLLL		    +++,,,ttt 	JJLLLLL	 		  	JJLLLL	s*   AA; ;
B:B5B= 5B::B= =Cc                 
   d }	 ddl m} t          j        j        d
i |}|                    d          }d}|                    || f           |                                }|r'|d         r|d         |r|                                 S S 	 |r|                                 dS dS # t          $ r5}t          d|            Y d }~|r|                                 d	S d	S d }~ww xY w# |r|                                 w w xY 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"   s          r#   get_username_from_profiler.   \   s^   D//////&5555-- PsZM***oo 	#3z? 	#z?  	JJLLLL	   	JJLLLLL	 		    0Q00111www 	JJLLLLL	 		  	JJLLLL	s*   A0B' '
C&1C!C) !C&&C) )D)NNNNNN)mysql.connectorr   r-   r   r$   r(   r.   r       r#   <module>r1      s`        ' ' ' ' ' '< < < <|  4    r0   