def leaveGroup(self, groupName): group_id = Group.getGroupId(groupName) sql = "DELETE FROM `user-groups` WHERE `user_id` = %s AND `group_id` = %s " User.cursor.execute(sql, (self.id,group_id))
def joinGroup(self,groupName): group_id = Group.getGroupId(groupName) sql = "INSERT INTO `user-groups` SET `user_id` = %s ,`group_id` = %s " User.cursor.execute(sql, (self.id,group_id))