Flask

from flask import Flask
from flask_sqlalchemy import SQLAlchemy



app = Flask(__name__)

# 在app.config中设置好链接数据库的信息
# 然后使用SQLAlchemy(app)创建一个dp对象
# SQLAchemy会自动读取aoo,config中连接数据库的信息

# MySQL所在主机名
HOSTNAME = '127.0.0.1'
# MySQL监听的端口号，默认3306
PORT = 3306
# 连接MySQL的用户名，读者自己设置
USERNAME = "root"
# 连接MySQL的密码，自己设置
PASSWORD = "lzj200452"
# MySQL上创建的数据库名称
DATABASE = 'database_learn'

app.config['SQLALCHEMY_DATABASE_URI'] = f"mysql+pymysql://{USERNAME}:{PASSWORD}@{HOSTNAME}:{PORT}/{DATABASE}?charset=utf8"

db = SQLAlchemy(app)

# 测试是否连接成功
with db.engine.connect() as conn:
    rs = conn.execute( "select 1" )
    print(rs.fetchone())

if(__name__ == '__main__'):
    app.run(debug=True)