g:ddlmZmZddlmZdZdZdZdZdS))requestjsonify)get_db_connectionctjd}|stddidfS t }|d}|d|f|}||t|S#t$r*}tdt|idfcYd}~Sd}~wwxYw) Nuser_iderrorMissing user_idT) dictionaryz SELECT m.name AS muscle_name, COALESCE(mc.score, 50) AS score FROM muscles m LEFT JOIN muscle_cards mc ON mc.muscle_id = m.id AND mc.user_id = %s ) rargsgetrrcursorexecutefetchallclose Exceptionstr)rconnrresultses 9/var/www/wisegym.app/api/functions/muscle_card_service.pyget_muscle_cards_for_userrsly))G :!2344c99 / ""-- Z     //##  w ///Q())3......./sBB<< C0C+%C0+C0ctjd}tjd}|r|stddidfS t }|}|d|f|}|stddidfS|d }|d ||f|}||t||r|d nd d S#t$r*}tdt|id fcYd}~Sd}~wwxYw)Nr muscle_namerzMissing user_id or muscle namer &SELECT id FROM muscles WHERE name = %sMuscle not foundrzDSELECT score FROM muscle_cards WHERE user_id = %s AND muscle_id = %s2)musclescorer ) rr rrrrrfetchonerrr)rrrrresult muscle_idr!rs rget_muscle_scorer%sly))G,""=11K I+I!ABCCSHH/ ""?+PPP"" ?G%78993> >1I ]`gir_sttt!!  !!&.U1XXB      ///Q())3......./s&A!D19A7D11 E%;E E% E%ctjd}tjd}tjd}|r|r|tddidfS t |}d|cxkrdksntdd idfSn##t $rtdd idfcYSwxYw t }|}|d |f| }|stdd id fS|d}|d|||f| | | tdd|d|iS#t$r*}tdt|idfcYd}~Sd}~wwxYw)Nrr r!rz Missing user_id, muscle or scorer dzScore must be between 1 and 100zScore must be an integerrrrrz INSERT INTO muscle_cards (user_id, muscle_id, score) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE score = VALUES(score) messagez Score for 'z ' updated to r )rjsonrrint ValueErrorrrrr"commitrrr)rrr!rrr#r$rs rset_muscle_scorer./s(ly))G,""8,,K L  W % %E K+K!CDEEsJJCE U!!!!c!!!!G%FGHH#M M" CCC!;<==sBBBBC/ ""?+PPP"" ?G%78993> >1I  y% (  * * *    #R#R#R5#R#RSTTT ///Q())3......./s880B**C  C A!F$0A3F$$ G.G GGcHtjd}|stddidfS t }|}|d|}|D]\}|d||f|| | tddiS#t$r*}tdt|id fcYd}~Sd}~wwxYw) Nrrr r zSELECT id FROM musclesz INSERT INTO muscle_cards (user_id, muscle_id, score) VALUES (%s, %s, 50) ON DUPLICATE KEY UPDATE score = 50 r)zAll muscle scores reset to 50r ) rr*rrrrrrr-rrr)rrrmusclesr$rs rreset_muscle_scoresr1Us=ly))G :!2344c99/ "" /000//### ' 'LY NN9%  ' ' ' '    #BCDDD ///Q())3......./sB6C-- D!7DD!D!N) flaskrr db_configrrr%r.r1rr6sv""""""""''''''///&///0$/$/$/L/////r5