def signup(): form = SignUpForm() if request.method == 'POST' and form.validate_on_submit(): signup = SignUp("", "", "", "", False, False, True) signup.name = form.name.data signup.email = form.email.data signup.school = form.school.data signup.experience = form.experience.data db.session.add(signup) db.session.commit() mail_body = render_template('mails/signup_thankyou.txt') send_email("Graffathon - Ilmoittautuminen rekisteröity", [form.email.data], mail_body, "") return redirect(url_for('signup_thank_you')) # 66 = maximum visitors we take MAX_VISITORS = 66 places = {'min': MAX_VISITORS - SignUp.query.filter_by(visible=True, confirmed=True).count(), 'max': MAX_VISITORS - SignUp.query.filter_by(visible=True, paid=True).count()} return render_template('signup.html', form=form, places=places)