Pg @ddlmZmZddlmZdZdZdZdZdZ dS) )requestjsonify)get_db_connectioncptjd}tjdd}|stddidfS t }|d}d }||||g}|d vr|d z }||||||}| | t|S#t$r*}tdt|id fcYd}~Sd}~wwxYw) Nuser_idfilterallerrorzMissing user_idT) dictionarya@ SELECT f.id, f.user_id_1, f.user_id_2, f.status, CASE WHEN f.user_id_1 = %s THEN u2.username ELSE u1.username END AS friend_username, CASE WHEN f.user_id_1 = %s THEN u2.display_name ELSE u1.display_name END AS friend_display FROM friendships f JOIN users u1 ON u1.id = f.user_id_1 JOIN users u2 ON u2.id = f.user_id_2 WHERE (f.user_id_1 = %s OR f.user_id_2 = %s) )acceptedpendingblockedz AND f.status = %s) rargsgetrrcursorappendexecutefetchallclose Exceptionstr)r filter_byconnrqueryvaluesresultses 8/var/www/wisegym.app/api/functions/friendship_service.py get_friendsr!sIly))G   511I :!2344c99"/ ""--  7GW5 : : : ) )E MM) $ $ $uf%%%//##  w ///Q())3......./sB*D D5 D0*D50D5cRtj}|d}|d}|r|stddidfS t }|}|dt||t||f| | | tddiS#t$r*}tdt|id fcYd}~Sd}~wwxYw) Nr friend_idr Missing user_id or friend_idr z INSERT INTO friendships (user_id_1, user_id_2, status) VALUES (%s, %s, 'pending') ON DUPLICATE KEY UPDATE status = 'pending' messagezFriend request sentr rjsonrrrrrminmaxcommitrrrdatarr#rrrs r send_friend_requestr-.s7 '> ?  A A A    #89::: ///Q())3......./B"C22 D&<D!D&!D&ctj}|d}|d}|r|stddidfS t }|}|d||||f|||tddiS#t$r*}tdt|id fcYd}~Sd}~wwxYw) Nrr#r r$r z UPDATE friendships SET status = 'accepted' WHERE user_id_1 = %s AND user_id_2 = %s OR user_id_1 = %s AND user_id_2 = %s r%zFriend request acceptedr rr'rrrrrr*rrrr+s r accept_friend_requestr1Ds$ >> ///Q())3......./BC D "DD D cRtj}|d}|d}|r|stddidfS t }|}|dt||t||f| | | tddiS#t$r*}tdt|id fcYd}~Sd}~wwxYw) Nrr#r r$r z INSERT INTO friendships (user_id_1, user_id_2, status) VALUES (%s, %s, 'blocked') ON DUPLICATE KEY UPDATE status = 'blocked' r%z User blockedrr&r+s r block_friendr4Zs6 '> ?  A A A    >2333 ///Q())3......./r.ctj}|d}|d}|r|stddidfS t }|}|d||||f|||tddiS#t$r*}tdt|id fcYd}~Sd}~wwxYw) Nrr#r r$r z DELETE FROM friendships WHERE (user_id_1 = %s AND user_id_2 = %s) OR (user_id_1 = %s AND user_id_2 = %s) r%zFriendship removedrr0r+s r remove_friendr6ps$ r;s""""""""''''''(/(/(/T///,///,///,/////r: