详解Flask数据库的连接与使用
目录
- 数据库连接配置
- 创建实体类
- 配置打印sql语句
- 或、与、非和排序
数据库连接配置
HOST = "XXXXXXXXXXXXX"
PORT = 3310
USERNAME = "root"
PASSWord = "@XXXXXXXXXXX"
DATABASE = "mydb"
SQLALCHEMY_DATABASE_URI = f"Mysql+pymysql://{USERNAME}:{quote(PASSWORD)}@{HOST}:{PORT}/{DATABASE}?"
SQLALCHEMY_TRACK_MODIFICATioNS = False
SQLALCHEMY_ECHO = True
