def get_event_logs(): conn = engine.connect() event_logs = conn.execute(select([eventlog])) event_logs = rows_to_dict(event_logs.keys(), event_logs.fetchall()) if len(event_logs) == 0: abort(404) return jsonify(event_logs=event_logs), 200
def get_events(): params = request.args.to_dict() conn = engine.connect() query = build_select() if 'event_id' in params: query = query.where(event.c.id == params['event_id']) if 'startDate' in params: query = query.where(event.c.date >= datetime.strptime(params['startDate'], '%Y-%m-%d')) if 'endDate' in params: query = query.where(event.c.date <= datetime.strptime(params['endDate'], '%Y-%m-%d')) if 'createdDateStart' in params: query = query.where(event.c.created >= datetime.strptime(params['createdDateStart'], '%Y-%m-%d')) if 'createdDateEnd' in params: query = query.where(event.c.created <= datetime.strptime(params['createdDateEnd'], '%Y-%m-%d')) if 'city' in params: query = query.where(event.c.city == params['city']) events = conn.execute(query) events = rows_to_dict(events.keys(), events.fetchall()) if len(events) == 0: abort(404) events = pretty_events(events) return jsonify(events=events), 200