Flask通过数据库填充select标签
最近要用Flask做一个省市二级联动的Select选择,数据从数据库里面读出,详细代码如下:@auth.route('/register', methods=['GET', 'POST'])
def register():
form = RegistrationForm()
name = '用户注册'
ch_region = CH_REGION.query.filter_by(REGION_TYPE=1).all()
if form.validate_on_submit():
user = User(email=form.email.data,
username=form.username.data,
password=form.password.data)
db.session.add(user)
token = user.generate_confirmation_token()
send_email(user.email, 'Confirm Your Account', 'auth/email/confirm', user=user, token=token)
flash('You can now login.')
return redirect(url_for('auth.login'))
return render_template('auth/register.html', form=form, name=name, ch_region=ch_region)
之后前端绑定,代码如下:Country请选择身份{% foroinch_region%}
{{ o.REGION_NAME}}{% endfor%}