o i@sddlmZddlmZddlmZddlmZddlm Z ddl m Z ddl m Z mZddlmZdd lZdd lmZmZdd lmZd d ZddZd S))jsonify)connect_to_database)closing)get_possible_causes_by_visit)get_diagnostics_by_visit)get_medications_by_visit)get_dietPlan_by_visitget_weekly_dietPlan)get_doctor_timingsN)datedatetime)ResponsecCsNt|trdd|DSt|trdd|DSt|ttfr%|S|S)zZRecursively convert all non-serializable types (e.g., dates) to JSON-serializable formats.cSsi|] \}}|t|qSmake_json_serializable).0kvrrI/Users/harjaapdhillon/Desktop/newidea/medvista_backend/Services/Report.py sz*make_json_serializable..cSsg|]}t|qSrr)rirrr sz*make_json_serializable..) isinstancedictitemslistr r isoformat)datarrrr s  rc Csft}|stddddfSzz^t|jddJ}z)|d|f|}|sDtd|d dd fWWdWW|SWn+typ}ztd |ddd fWYd}~WdWW|Sd}~wwz(|d |df|}|stdd dd fWWdWW|SWn+ty}ztd|ddd fWYd}~WdWW|Sd}~wwz(|d|df|}|stdd dd fWWdWW|SWn,ty}ztd|ddd fWYd}~WdWW|Sd}~wwzt|d\}}|dkr.| dng} Wn,ty]}ztd|ddd fWYd}~WdWW|Sd}~wwWdn 1siwYWn$ty}ztd|ddd fWYd}~W|Sd}~wwW|n|wzt |\} } | dkr| dng} Wnty}ztd|ddd fWYd}~Sd}~wwzt |\} }|dkr| dng}Wnty}ztd|ddd fWYd}~Sd}~wwzt |\}}|dkr| dng}Wnty=}ztd|ddd fWYd}~Sd}~wwzt |\}}|dkrP| dng}Wntyr}ztd|ddd fWYd}~Sd}~ww|||| |||| d}t|}ztj|d ddd }t|d!d"WSty}ztd#|ddd fWYd}~Sd}~ww)$NzMissing visit_idtrue)messageerroriT) dictionaryz"SELECT * FROM visits WHERE id = %szNo visit found for visit_id falseizError fetching visit data: iz$SELECT * FROM patients WHERE id = %s fk_patientszNo patient data foundzError fetching patient data: z!SELECT * FROM users WHERE id = %s fk_doctorzNo doctor data foundzError fetching doctor data: rzError fetching doctor timings: zInternal server error: z Error fetching possible causes: zError fetching diagnostics: zError fetching medications: zError fetching diet plan: )visits patient_info doctor_infopossible_cause diagnosticsZ medicationdietPlandoctor_timings)rr F) sort_keyszapplication/json)mimetypez#Non-serializable data encountered: )rrrcursorexecutefetchoneclose Exceptionr get_jsonrrrr rjsondumpsr TypeError)visit_id connectionr/r&er'r(Zdoctor_timings_responseZdoctor_timings_statusr,Zpossible_causes_responseZpossible_causes_statusZpossible_causesZdiagnostics_responseZdiagnostics_statusr*Zmedications_responseZmedications_status medicationsZdietPlan_responseZdietPlan_statusr+Z response_dataZserializable_response_dataZ response_jsonrrr get_reportss, ," ,  ," , ," , " ,($  $ $ $  $ $r<)flaskrconfr contextlibrServices.PossibleCausesrServices.DiagnosticsrServices.MedicationsrServices.DietPlanrr Services.Doctorr r5r r r rr<rrrrs