def membersubmit(self): params = self.request.params import transaction session = DBSession() ourvalues = {} try: userid = params.get('userid') groupid = params.get('groupid') player = session.query(Player).filter(Player.id==userid).one() group = session.query(Group).filter(Group.id==groupid).one() if 'removefromgroup' in params: membership = session.query(GroupMembership) \ .filter( and_(GroupMembership.groupid==groupid, GroupMembership.userid==userid)) \ .first() session.delete(membership) ourvalues['message'] = 'Succesfully removed %s from %s ' % (player.name, group.name) transaction.commit() if 'addtogroup' in params: membership = GroupMembership(userid, groupid) session.add(membership) ourvalues['message'] = 'Succesfully added %s to %s ' % (player.name, group.name) transaction.commit() except: pass returnvalue = self.grouplist() returnvalue.update(ourvalues) return returnvalue
def submit(self): params = self.request.params import transaction session = DBSession() ourvalues = {} try: groupid = params.get('groupid') group = session.query(Group).filter(Group.id==groupid).one() if 'deletegroup' in params: ourvalues['message'] = 'Succesfully removed %s ' % group.name if 'addgroup' in params: groupname = params.get('groupname') guildid = params.get('guildid') group = Group(groupname, guildid) session.add(group) ourvalues['message'] = 'Succesfully added %s ' % groupname except: pass returnvalue = self.grouplist() returnvalue.update(ourvalues) return returnvalue