o
    լit                     @   s"   d dl Zd dlmZ dddZdS )    N)D_DB_CONFIGc              
   C   sz  d}zzt 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   9/home/air/goalskill_t/back/app/models/interview_module.pyinsert_evaluation   s\   











r    )NN)mysql.connectorr   app.core.configr   r    r   r   r   r   <module>   s   