=MgH :ddlmZmZddlmZdZdZdZdZdS))requestjsonify)get_db_connectioncz t}|d}|d|}||t |S#t $r*}t dt|idfcYd}~Sd}~wwxYw)NT) dictionaryz$SELECT * FROM tasks ORDER BY id DESCerror)rcursorexecutefetchallcloser Exceptionstr)connr taskses 2/var/www/wisegym.app/api/functions/task_service.py get_all_tasksrs / ""--=>>>!!  u~~ ///Q())3......./sBB B:B5/B:5B:c tj}|d}|stddidfSt }|}|d|f|||tddiS#t$r*}tdt|idfcYd}~Sd}~wwxYw) NidrzMissing task IDzDELETE FROM tasks WHERE id = %sstatusz Task deletedr rjsongetrrr r commitr rr)datatask_idrr rs r delete_taskrs/|((4.. >G%6788#= = ""87*EEE   .1222 ///Q())3......./s#5B>BB>> C2C-'C2-C2cN tj}|d}|d}|d}|r|r|stddidfSt }|}|d|||f|||tdd id fS#t$r*}tdt|id fcYd}~Sd}~wwxYw) Ntitletypepriorityrz Missing title, type, or priorityrz=INSERT INTO tasks (title, type, priority) VALUES (%s, %s, %s)rz Task createdr r)rr! task_typer#rr rs r create_taskr&!s5/|!!HHV$$ 88J'' OI OX OG%GHII3N N ""VY^`iksXtuuu   .122C77 ///Q())3......./s%A#C0&B C00 D$:DD$D$c~ tj}|d}|d}|d}|r|r|tddidfS|dvrtddidfSt }|}|d |d ||f|||td d iS#t$r*}tdt|id fcYd}~Sd}~wwxYw)NrfieldvaluerzMissing id, field, or valuer)r!r"r#z Invalid fieldzUPDATE tasks SET z = %s WHERE id = %srz Task updatedr r)rrr(r)rr rs rupdate_task_fieldr*5sT/|((4..!!!! Je Ju}G%BCDDcI I 5 5 5G_566; ; ""E5EEEwGWXXX   .1222 ///Q())3......./s+A#D&D=B D D<D71D<7D<N) flaskrr db_configrrrr&r*rr/su""""""""'''''' / / ////"///(/////r.