BOh8 ddlmZddlmZddlZddlZddlmZddlm Z ddl m Z m Z m Z eZejedgdgdgd Zd Zej%d d Zej)d defdZy))FastAPI)CORSMiddlewareN)DiagnoseRequest)run_rule_engine)train_model_from_dbanswers_to_featurespredict_ml_model*) allow_origins allow_methods allow_headersc6tjdddddS)Nz103.216.116.241rootz Tung_2002@ copd_tb_dbi3)hostuserpassworddatabaseport)pymysqlconnect*/var/www/html/diagnosisapp-backend/main.pyget_dbr s ?? 1`lrw xxrctd|D}td|D}g}|dk\r|jd|dk\r|jd|S)Nc3ZK|]#}|jdks|js d%yw)Nquestionnaire_idanswer.0as r z"threshold_logic..s#O!!*<*<*AahhAO + ++c3ZK|]#}|jdk\s|js d%yw)rNr r#s rr&z"threshold_logic..s#P11+=+=+BqxxQPr'laocopd)sumappend)answers lao_count copd_countresults rthreshold_logicr4sROwOOIPPPJ FA~ eQ f Mrz /questionsct}|j5}|jd|j}ddd|j Dcgc] }|d|ddc}S#1swY2xYwcc}w)Nz"SELECT id, question FROM questionsrr)idquestion)rcursorexecutefetchallclose)conncurr3rows r get_questionsr?so 8D  # 89  JJL:@ A33q6s1v . AA    Bs"A.A:.A7z /diagnosereqc vt|j}t|j}t|j}t }|j 5}|j d|jj|jj|jjtj|df|j|j d|j}ddd|jDcgc] }|d|dd}}g} |rh t!|t#|} | j%dD cgc]7} | j's| j'dk7s(| j'9} } t)||z| z} | sd } d }d}nd } d }d j+t-| }t }|j 5}|j d||jj|jjf|jddd|jt-t)|t-t)|t-t)| t-| | |dS#1swYxYwcc}wcc} w#g} YxYw#1swYxYw)NzWINSERT INTO results (name, age, gender, answers, diagnosis) VALUES (%s, %s, %s, %s, %s) _pending_zESELECT answers, diagnosis FROM results WHERE diagnosis != '_pending_'rr)r0 diagnosis,uKhông đủ dữ liệu MLuDKhông đủ dấu hiệu rõ ràng để nghi ngờ Lao hoặc COPDuuBạn nên theo dõi thêm và thực hiện lại khảo sát sau một thời gian nếu có triệu chứng mới.uPhân tích hoàn tấtuXBạn nên thực hiện xét nghiệm chẩn đoán chuyên sâu với cơ sở y tế.z, zZUPDATE results SET diagnosis = %s WHERE diagnosis = '_pending_' AND name = %s AND age = %s) rule_basedlogic_threshold ml_predictionfinal_diagnosisstatus suggestion)rr0r4rrr8r9rnameagegenderjsondumpscommitr:r;rr splitstripsetjoinsorted)r@rEthreshold_basedfeaturesr<r=r3r> result_dicts ml_result predictionsfinalrIrJ final_results rdiagnoser^%sB -J%ckk2O"3;;/H 8D  # mXX]]CHHLL#((//4::hCWYde g  [\   JJLHNOASV<OLOI   -)(3J,6,<,rhs2 #(OO i>#se\_[`ay BB+5/55r