g4ddlmZmZddlmZdZdZdZdS))requestjsonify)get_db_connectionc t}|d}|d|f|}|||st ddidfS|dpd|d<t |S#t $r*}t dt|id fcYd}~Sd}~wwxYw) NT dictionaryzs SELECT name, display_name, common_name, description FROM muscles WHERE name = %s errorzMuscle not foundi descriptionzNo description available)rcursorexecutefetchonecloser Exceptionstr) muscle_nameconnr resultes 4/var/www/wisegym.app/api/functions/muscle_service.pyget_muscle_by_namers/ ""-- ^   ""   ?G%78993> > &} 5 S9S}v ///Q())3......./s$B B*B** C4CCCcz t}|d}|d|}||t |S#t $r*}t dt|idfcYd}~Sd}~wwxYw)NTrzSELECT * FROM musclesr r )rr r fetchallrrrr)rr musclesrs rget_all_musclesrs / ""--./////##  w ///Q())3......./sBB B:B5/B:5B:cP tj}|d}|d}|d}|r|stddidfSt }|}|d|d||f|||td d id fS#t$r*}tdt|id fcYd}~Sd}~wwxYw) N muscleNamefieldvaluer zMissing muscleName or fieldizUPDATE muscles SET z = %s WHERE name = %sstatussuccessr ) rjsongetrrr r commitrrr)datanamerrrr rs rupdate_muscle_fieldr(%s3/|xx %%!!!! J5 JG%BCDDcI I ""IUIIIESW=YYY   ),--s22 ///Q())3......./s%A!C1$B C11 D%;D D% D%N)flaskrr db_configrrrr(rr-sf""""""""''''''///* / / //////r,