o
    _<i­
  ã                   @   s`   d dl mZmZ d dlZdededB dedB dedB dedB f
dd	„Zded
edB fdd„ZdS )é    )ÚA_DB_CONFIGÚloggerNÚ
session_idÚeligibilityÚskills_and_experienceÚwelcome_personalityÚkey_informationc              
   C   sè   z^t jjdi t¤Ž}| ¡ }|pd|pd|pd|pd| f}d}| ||¡ |jdkrHd}	| |	| |p3d|p6d|p9d|p<df¡ t d| › ¡ nt d| › ¡ | 	¡  | 
¡  | 
¡  W dS  tys }
 z	t d|
› ¡ ‚ d}
~
ww )	uê   
    ê°™ì€ session_idë©´ ê¸°ì¡´ í–‰ ì—…ë°ì´íŠ¸, ì—†ìœ¼ë©´ INSERT.
    eligibility: å¿œå‹Ÿæ¡ä»¶, skills_and_experience: æ´»ã‹ã›ã‚‹çµŒé¨“ã¨èƒ½åŠ›,
    welcome_personality: æ­“è¿Žã™ã‚‹äººç‰©åƒ, key_information: é‡è¦äº‹é …
    NzÌ
            UPDATE company_info
            SET eligibility = %s, skills_and_experience = %s, welcome_personality = %s, key_information = %s, updated_at = NOW()
            WHERE session_id = %s
        r   zÉ
                INSERT INTO company_info
                (session_id, eligibility, skills_and_experience, welcome_personality, key_information)
                VALUES (%s, %s, %s, %s, %s)
            z#Company info inserted for session: z"Company info updated for session: zCompany info save error: © )ÚmysqlÚ	connectorÚconnectr   ÚcursorÚexecuteÚrowcountr   ÚinfoÚcommitÚcloseÚ	ExceptionÚerror)r   r   r   r   r   Úconnr   ÚargsÚ
update_sqlÚ
insert_sqlÚer	   r	   ú@/home/air/goalskill_sales/back/app/models/company_info_module.pyÚsave_company_info   s@   û
ûþ
€þr   Úreturnc              
   C   sz   z't jjdi t¤Ž}|jdd}d}| || f¡ | ¡ }| ¡  | ¡  |W S  ty< } z	t	 
d|› ¡ ‚ d}~ww )uB   session_idë¡œ ì €ìž¥ëœ íšŒì‚¬ ì •ë³´ 1ê±´ ì¡°íšŒ. ì—†ìœ¼ë©´ None.T)Ú
dictionaryzö
            SELECT eligibility, skills_and_experience, welcome_personality, key_information, created_at, updated_at
            FROM company_info
            WHERE session_id = %s
            ORDER BY updated_at DESC
            LIMIT 1
        zCompany info get error: Nr	   )r
   r   r   r   r   r   Úfetchoner   r   r   r   )r   r   r   ÚsqlÚrowr   r	   r	   r   Úget_company_info<   s   €þr!   )	Úapp.core.configr   r   Úmysql.connectorr
   Ústrr   Údictr!   r	   r	   r	   r   Ú<module>   s    ÿþýü
û7