def removeFriendRequest(self, username, otherUsername):
     oldFriendRequests = self.getFriendRequestsForUser(username)
     if (oldFriendRequests == [(None,)]):
         newFriendRequestList = ""
     else:
         csv = oldFriendRequests[0][0].split(",")
         csv.remove(otherUsername)
         newFriendRequestList = listToCsvString(csv)
     return self.writeQuery("""update users set friend_requests = '{friend_requests}'""".format(friend_requests = newFriendRequestList))
 def removeFriendRequest(self, username, otherUsername):
     oldFriendRequests = self.getFriendRequestsForUser(username)
     if (oldFriendRequests == [(None, )]):
         newFriendRequestList = ""
     else:
         csv = oldFriendRequests[0][0].split(",")
         csv.remove(otherUsername)
         newFriendRequestList = listToCsvString(csv)
     return self.writeQuery(
         """update users set friend_requests = '{friend_requests}'""".
         format(friend_requests=newFriendRequestList))
 def removeFriend(self,username,friend):
     oldFriendsCsv = self.getFriendsForUser(username)
     if (oldFriendsCsv == [(None,)] or oldFriendsCsv == [("",)]):
         oldFriends = []
     else:
         oldFriends = oldFriendsCsv[0][0].split(",")
     if (friend in oldFriends):
         oldFriends.remove(friend)
     else:
         print("~" + username + "~ is not friends with ~" + friend + "~")
         return None
     newFriends = listToCsvString(oldFriends)
     return self.writeQuery("""update users set friends = '{friends}' where username = '******'""".format(friends = newFriends, username = username))
 def removeFriend(self, username, friend):
     oldFriendsCsv = self.getFriendsForUser(username)
     if (oldFriendsCsv == [(None, )] or oldFriendsCsv == [("", )]):
         oldFriends = []
     else:
         oldFriends = oldFriendsCsv[0][0].split(",")
     if (friend in oldFriends):
         oldFriends.remove(friend)
     else:
         print("~" + username + "~ is not friends with ~" + friend + "~")
         return None
     newFriends = listToCsvString(oldFriends)
     return self.writeQuery(
         """update users set friends = '{friends}' where username = '******'"""
         .format(friends=newFriends, username=username))