gI :ddlmZmZddlmZdZdZdZdZdS))requestjsonify)get_db_connectioncz t}|d}|d|}||t |S#t $r*}t dt|idfcYd}~Sd}~wwxYw)NT dictionaryzSELECT * FROM requestserror)rcursorexecutefetchallcloser Exceptionstr)connr requestses 5/var/www/wisegym.app/api/functions/request_service.pyget_all_requestsrs / ""--/000??$$  x   ///Q())3......./sBB B:B5/B:5B:c tj}|d}|d}|d}|dd}|dd}|r|r|stdd id fSt }|}|d kr|d |||||fn3|dkr|d |||fntddid fS|||tddidfS#t$r*}tdt|idfcYd}~Sd}~wwxYw)N request_typenameuser_idmuscles equipmentNoner zMissing fieldsexercisezbINSERT INTO requests (request_type, name, muscles, equipment, user_id) VALUES (%s, %s, %s, %s, %s)zFINSERT INTO requests (request_type, name, user_id) VALUES (%s, %s, %s)zInvalid request_typestatuszRequest submittedr rjsongetrrr r commitrrr) datarrrrrrr rs rsubmit_requestr's!/|xx// xx((9%%((9b))HH[&11  =4 =w =G%5677< < "" : % % NNttWiA    [ ( ( NNXtW-     G%;<==sB B   "5677<< ///Q())3......./s,BEA6E AE F "FF F c$ tj}|d}|stddidfSt }|d}|d|f|}|s;||tddid fS|d }|d }|d |fd }d|d}|d|||f| ||tddidfS#t$r*} tdt| idfcYd} ~ Sd} ~ wwxYw)N request_idr Missing request_idrTrz$SELECT * FROM requests WHERE id = %szRequest not foundirr"DELETE FROM requests WHERE id = %szRequest AcceptedzYour request 'z' has been accepted !zjINSERT INTO notifications (user_id, title, message, created_at, is_read) VALUES (%s, %s, %s, NOW(), false)r z"Request accepted and user notifiedr ) rr#r$rrr r fetchonerr%rr) r&r)rr reqrr notif_title notif_msgrs raccept_requestr16s$/|XXl++  AG%9:;;S@ @ ""--= }MMMoo @ LLNNN JJLLLG%89::C? ?i.6{;j]KKK( @T@@@  x k9 -     "FGHH#MM ///Q())3......./s*5EB EBE F%F F Fc tj}|d}|stddidfSt }|}|d|f|||tddidfS#t$r*}tdt|id fcYd}~Sd}~wwxYw) Nr)r r*rr+r zRequest rejected (deleted)r,r r")r&r)rr rs rreject_requestr3^s/|XXl++  AG%9:;;S@ @ "";j]KKK   ">?@@#EE ///Q())3......./s#5CBC C4 C/)C4/C4N) flaskrr db_configrrr'r1r3rr8sw""""""""'''''' / / /"/"/"/J%/%/%/P/////r7