Ui hddlmZmZddlZdededzdedzdedzdedzf dZded edzfd ZdS) ) A_DB_CONFIGloggerN session_id eligibilityskills_and_experiencewelcome_personalitykey_informationc> tjjdit}|}|pd|pd|pd|pd|f}d}||||jdkr=d} || ||pd|pd|pd|pdftjd|ntjd|| | | dS#t$r} tj d| d} ~ wwxYw) 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 rz 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: zCompany info save error: ) mysql connectorconnectrcursorexecuterowcountrinfocommitclose Exceptionerror) rrrrr connrargs update_sql insert_sqles &/app/app/models/company_info_module.pysave_company_inforsg(&5555  4 ! )T  '4  #t    z4((( ?a  J NN'4)1T'/4#+t     KJjJJ K K K K KIZII J J J    444555 sC1C55 D?DDreturnch tjjdit}|d}d}|||f|}|||S#t$r}tj d|d}~wwxYw)uBsession_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 zCompany info get error: Nr ) r r rrrrfetchonerrrr)rrrsqlrowrs rget_company_infor$<s&5555--  sZM***oo    333444 sBB B1B,,B1) app.core.configrrmysql.connectorr strrdictr$r rr*s////////44t4:4t 4 4Z 4444nr)