def index(): instance_list = list( Instance.select(Instance.hostname, Instance.name).namedtuples()) manager_list = list( EventManager.select(EventManager.username, EventManager.email, EventManager.site_admin).namedtuples()) return dict(instances=instance_list, managers=manager_list)
def groupsyncstate(event_id): req = json.loads(request.data) group_id = req['group_id'] try: state = not req['state'] == "True" except: return redirect(url_for(".admin", event_id=event_id)) hostname, api_key = list( Instance.select(Instance.hostname, Instance.api_key).join( Event, on=Event.instance_id == Instance.name).join( Groups, on=Groups.event_id == Event.event_id).where( Event.event_id == event_id).namedtuples())[0] with RdyApi(hostname, api_key) as api: api.set_sync_npcs(group_id, state) print(state) print(group_id) Groups.update(has_synced_npcs=state).where( group_id == group_id).execute() return redirect(url_for(".admin", event_id=event_id))
def add_event_group(event_id): instance = list( Instance.select(Instance).join( Event, on=(Event.instance_id == Instance.name)).where( Event.event_id == event_id).namedtuples()) groupname = request.form.get('groupname') register_event_group(instance[0].hostname, instance[0].api_key, event_id, groupname, False) return redirect(url_for(".admin", event_id=event_id))
def add_event_attendee(event_id): username = request.form.get('username') groupID = request.form.get('group-id') email = request.form.get('email') if username is None: flash("please enter a username") return redirect(url_for('.admin', event_id=event_id)) if groupID is None: flash("please choose a Group") return redirect(url_for('.admin', event_id=event_id)) instance = list( Instance.select(Instance).join( Event, on=(Event.instance_id == Instance.name)).where( Event.event_id == event_id).namedtuples()) if email is None: flash("please enter a email for sending user credentials") return redirect(url_for('.admin', event_id=event_id)) # emails = list(Event.select() # .join(EventManagerRelation, on=Event.event_id == EventManagerRelation.event_id) # .join(EventManager, on=EventManager.username == EventManagerRelation.manager_id) # .namedtuples()) register_event_attendee(instance[0].hostname, instance[0].api_key, event_id, username, pw_gen(8), groupID, sendmail=True, email=email) return redirect(url_for(".admin", event_id=event_id))