Vi!<ddlZddlZddlZddlmZddlmZmZmZm Z m Z ddl m Z ddl mZmZddlmZddlmZmZmZmZmZmZeZer eendZd ed ed ed ed ZeedddZeZeZdedededeefdZ e!dedededededededede de de de dedede dfdededededeedeedeed eed!eed"eed#eed$eed%ed&ed'eefd(Z"dS))N)Optional) APIRouterForm UploadFileFile HTTPException)CORSMiddleware) create_enginetext) quote_plus)DB_HOSTDB_USER DB_PASSWORD IMG_Q_PATH IMG_EXP_PATH Q_DB_NAMEzmysql+pymysql://:@/z?charset=utf8mb4 i) pool_size max_overflow pool_recyclefile base_pathsection_folderreturnc|sdStj||}tj|d|j}d|vr|ddnd}t jd|}tj||}t|d5}tj |j |dddn #1swxYwY|S)u.이미지 저장 함수 (기존 로직 동일)NT)exist_ok.pngwb) ospathjoinmakedirsfilenamesplituuiduuid4openshutil copyfileobjr) rrr target_dirr*file_ext new_filename target_pathbuffers /app/app/routers/quiz_router.py save_imager7s ti88JK T****}H*-//x~~c""2&&uHjll//X//L',,z<88K k4 .F49f---............... s+CCCz/save_question.chapterquestion_numberq_text choice_typechoice_one_textchoice_two_textchoice_three_textchoice_four_textchoice_one_imgchoice_two_imgchoice_three_imgchoice_four_imganswerexplanation_textexplanation_filec K d|}d|}d\}}}}|dkr |}|}|}|}n`|rt|t|}| rt| t|}| rt| t|}| rt| t|}d}|rt|t|}t5}t d|d}||||dt d|d }|||||||d t d |d }|||| d t d|d}|||| |ddddn #1swxYwYdd|ddS#t$r5}td|tdt|d}~wwxYw)Nsection_section)rrrrr zINSERT INTO Q_DB.z& (question_number, Q) VALUES (:qn, :q))qnqz( INSERT INTO Example_DB.zy (question_number, one, two, three, four) VALUES (:qn, :v1, :v2, :v3, :v4) )rJv1v2v3v4zINSERT INTO Correct_Answer_DB.z( (question_number, A) VALUES (:qn, :ans))rJanszINSERT INTO Solution_DB.z6 (question_number, text, img) VALUES (:qn, :txt, :img))rJtxtimgsuccessz Question z saved successfully.)statusmessagezError occurred: i) status_codedetail) r7BASE_IMG_Q_PATHBASE_IMG_EXP_PATHenginebeginr execute Exceptionprintrstr)r8r9r:r;r<r=r>r?r@rArBrCrDrErF table_suffix folder_suffixval_oneval_two val_threeval_four sol_img_pathconnsql_qsql_exsql_anssql_soles r6 save_questionrm3s&8<+'++ +'++ 1?-)X & %G%G)I'HH cNOUb)c)cw cNOUb)c)cw iZ8H/[h-i-i f:oXe+f+f  Z%&68I=YYL\\^^ ita\aaabbE LLV D D E E E(4F LL%WIX""    rLrrrssG LL"H"H I I Izlzzz{{G LLAQZf"g"g h h h1 i i i i i i i i i i i i i i i4$0aO0a0a0abbb <<< $$$%%%CFF;;;; rzs3 DDDDDDDDDDDDDD222222********######^^^^^^^^^^^^^^^^ '2 9::k " " "r VG V Vh V V V V9 V V V       ZCRU( 499499$s))tCyy%)T$ZZ%)T$ZZ'+tDzz&*d4jj+/4::+/4::-1T$ZZ,0DJJ$s)) DII-1T$ZZ!J<J< J<J<  J<  J< c] J<c]J< }J<smJ<Z(J<Z(J<z*J<j)J< J<J< z*!J<J<J<J<J<J