背景:在数据库取值时,可能会存在只有程序第一次运行是取一次值,后期修改数据库数据,静态字段将不会重新到数据库中重新取值更新
背景题:在数据库中取值,将获取的值在前端做成下拉列表显示
部分代码展示
帮助我们处理sql语句的.py文件
import pymysql from DBUtils.PooledDB import PooledDB, SharedDBConnection import pymysql POOL = PooledDB( creator=pymysql, # 使用链接数据库的模块 maxconnections=6, # 连接池允许的最大连接数,0和None表示不限制连接数 mincached=2, # 初始化时,链接池中至少创建的空闲的链接,0表示不创建 maxcached=5, # 链接池中最多闲置的链接,0和None不限制 maxshared=3, # 链接池中最多共享的链接数量,0和None表示全部共享。PS: 无用,因为pymysql和MySQLdb等模块的 threadsafety都为1,所有值无论设置为多少,_maxcached永远为0,所以永远是所有链接都共享。 blocking=True, # 连接池中如果没有可用连接后,是否阻塞等待。True,等待;False,不等待然后报错 maxusage=None, # 一个链接最多被重复使用的次数,None表示无限制 setsession=[], # 开始会话前执行的命令列表。如:["set datestyle to ...", "set time zone ..."] ping=0, # ping MySQL服务端,检查是否服务可用。# 如:0 = None = never, 1 = default = whenever it is requested, 2 = when a cursor is created, 4 = when a query is executed, 7 = always host='127.0.0.1', port=3306, user='root', password='123456', database='s9day119', charset='utf8' ) def connect(type): conn = POOL.connection() cursor = conn.cursor(cursor=type) return conn,cursor def connect_close(conn,cursor): cursor.close() conn.close() def fetch_all(sql,args,type=pymysql.cursors.DictCursor): conn,cursor = connect(type) cursor.execute(sql, args) record_list = cursor.fetchall() connect_close(conn,cursor) return record_list def fetch_one(sql, args): conn, cursor = connect() cursor.execute(sql, args) result = cursor.fetchone() connect_close(conn, cursor) return result def insert(sql, args): conn, cursor = connect() row = cursor.execute(sql, args) conn.commit() connect_close(conn, cursor) return row
使用了wtforms组件构建了input下拉框数据从数据库中取
from wtforms.fields import simple from wtforms.fields import core from wtforms import Form import helper class UserForm(Form): city = core.SelectField( label='城市', choices=helper.fetch_all('select id,name from tb1', [], type=None), coerce=int # 使值保持为int类型 ) name = simple.StringField(label='姓名') @app.route('/user') def user(): if request.method == "GET": # form = UserForm(data={'name':'alex','city':3}) form = UserForm() return render_template('user.html', form=form) if __name__ == '__main__': app.run()
前端模板
<!DOCTYPE html> <html lang="zh-CN"> <head> <meta charset="UTF-8"> <title>Title</title> <meta name="viewport" content="width=device-width, initial-scale=1"> </head> <body> <form method="post"> {% for field in form %} <p>{{field.label}}: {{field}} {{field.errors[0]}}</p> {% endfor %} <input type="submit" value="提交"> </form> </body> </html>
解决办法【自定义构造方法__init__】
from wtforms.fields import simple from wtforms.fields import core from wtforms import Form import helper class UserForm(Form): city = core.SelectField( label='城市', choices=(), coerce=int # 使值保持为int类型 ) name = simple.StringField(label='姓名') def __init__(self, *args, **kwargs): # 实时同步更新数据库数据【意思为每次发请求的时候都重新在数据库中查询】 super(UserForm, self).__init__(*args, **kwargs) self.city.choices = helper.fetch_all('select id,name from tb1', [], type=None) @app.route('/user') def user(): if request.method == "GET": # form = UserForm(data={'name':'alex','city':3}) form = UserForm() return render_template('user.html', form=form) if __name__ == '__main__': app.run()