def admin(): form = AdminForm() if form.is_submitted(): if form.stats1.data: stats1() return redirect(url_for("admin")) if form.stats2.data: stats2() return redirect(url_for("admin")) if form.notify.data: notify() return redirect(url_for("admin")) return redirect(url_for("addevent")) oracle_connection_string = 'oracle+cx_oracle://{username}:{password}@{host}:{port}/{sid}' engine = create_engine(oracle_connection_string.format( username="******", password="******", sid="XE", host="localhost", port="1521", database="XE", ), echo=True) with engine.connect() as conn: events_count = conn.execute("SELECT COUNT(event_name) FROM EVENTS").fetchone() event_names = conn.execute("SELECT EVENT_NAME FROM EVENTS") tickets_left = conn.execute("SELECT QUANTITY_TIC FROM EVENTS") event_times = conn.execute("SELECT EVENT_TIME FROM EVENTS") prices = conn.execute("SELECT PRICE FROM EVENTS") dict_event_names = TupleToDictionary(event_names) dict_tickets_left = TupleToDictionary(tickets_left) dict_event_times = TupleToDictionary(event_times) dict_prices = TupleToDictionary(prices) event_forms = [] for i in range(0, events_count[0]): event = EventForm() event.name.data = dict_event_names[i] event.tickets_left.data = dict_tickets_left[i] event.time.data = dict_event_times[i] event.price.data = dict_prices[i] event_forms.append(event) form.events = event_forms return render_template("admin.html", form=form)