o
    e^i½  ã                   @   s"   d dl Zd dlmZ ddd„ZdS )é    N)ÚINPUT_DB_CONFIGc              
   C   sz  d}z²zœt jjdi t¤Ž}| ¡ }d}| || f¡ | ¡ }|rƒ|d }	g }
g }|
 d¡ | |¡ |dur@|
 d¡ | |¡ |durN|
 d¡ | |¡ |dur\|
 d¡ | |¡ |
rxd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 )zP
    Inserts or Updates an interview evaluation record based on session_id.
    Nz9SELECT id FROM interview_evaluation WHERE session_id = %sr   z	rating=%sz	advice=%szinterviewer_name=%szinterview_type=%sz UPDATE interview_evaluation SET z, z WHERE id = %sz»
                INSERT INTO interview_evaluation 
                (session_id, rating, advice, interviewer_name, interview_type) 
                VALUES (%s, %s, %s, %s, %s)
            z[Interview Eval DB Error] © )ÚmysqlÚ	connectorÚconnectr   ÚcursorÚexecuteÚfetchoneÚappendÚjoinÚtupleÚcommitÚcloseÚ	lastrowidÚ	ExceptionÚprint)Ú
session_idÚratingÚadviceÚinterviewer_nameÚinterview_typeÚconnr   Ú	check_sqlÚrowÚlog_idÚupdate_fieldsÚparamsÚsqlÚer   r   ú=/home/air/goalskill_sales/back/app/models/interview_module.pyÚinsert_evaluation   s\   









ÿò
ÿü€þ
ÿr    )NN)Úmysql.connectorr   Úapp.core.configr   r    r   r   r   r   Ú<module>   s   