def registerattendee(groupId): if not groupId is None: group = Groups.get_or_none((Groups.group_id == groupId)) if group is None: # group-id not in database -> abort abort(404) else: event = Event.get_or_none(Event.event_id == group.event_id) if event is None: # event_id in group is not registered abort(500) else: instance = Instance.get_or_none( Instance.name == event.instance_id) if instance is None: abort(500) else: abort(400) # PLSS WHY DIDN'T I CHOOSE A JOIN registersuccess = request.args.get('registersuccess') if registersuccess is None: registersuccess = False username = request.args.get('username') return dict(group=group, event=event, instance=instance, registersuccess=registersuccess, username=username)
def instance_details(instance_id): managers = defaultdict(list) i = Instance.get_or_none(Instance.name == instance_id) if i is None: return abort(404) # todo 404 handler event_list = list( Event.select(Event, EventManagerRelation.manager).join( EventManagerRelation, on=EventManagerRelation.event == Event.event_id, join_type=JOIN.LEFT_OUTER).where( Event.instance == instance_id).group_by( Event.event_id).namedtuples()) for ev in event_list: managers[ev.event_id].append(ev.manager) return dict(events=event_list, managers=managers, name=instance_id, hostname=i.hostname, api_key=i.api_key)