config.py
import datetime
DEBUG = True #开启Debug模式
JSON_AS_ASCII = False #修改配置，json返回中文不会乱码
SQLALCHEMY_COMMIT_ON_TEARDOWN = True
SQLALCHEMY_TRACK_MODIFICATIONS = False
SECRET_KEY = 'x&xQ#RC!bB6P^N*k@'
PERMANENT_SESSION_LIFETIME = datetime.timedelta(days=365) # 设置session过期时间
#MYSQL数据库配置
HOST = '127.0.0.1'
PORT = 4306
USER = 'dbusername'
PASSWORD = 'pwpwpw'
DB = 'dbname'
run.py
import pymysql
# 数据库连接池/sql改造如关闭cursor和dbconn
pool = PooledDB(pymysql, 5, host=config.HOST, user=config.USER, passwd=config.PASSWORD, db=config.DB, port=config.PORT) # 5为连接池里的最少连接数
# db = pool.connection()
# cursor = db.cursor()
def func1():
db = pool.connection()
cursor = db.cursor()
#查询待提现的任务
sql= "select * from table1 where id = 1"
cursor.execute(sql)
res = cursor.fetchall()
print('res',res)
