flask sqlalchemy 连接数据库

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import text

app = Flask(__name__)


HOSTNAME = '127.0.0.1'

PORT = 3306

USERNAME = "root"

PASSWORD = "root"

DATABASE = "database_learn"

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

db = SQLAlchemy(app)


# 测试链接成功代码
# with app.app_context():
#     with db.engine.connect() as conn:
#         rs = conn.execute(text("select 1"))
#         print(rs.fetchone())

class User(db.Model):
    __tablename__ = 'user'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)

    username = db.Column(db.String(100), nullable=False)
    password = db.Column(db.String(100), nullable=False)

with app.app_context():
    db.create_all()

@app.route('/')
def hello_world():
    return 'hello world!'

@app.route('/user/add')
def add_user():
    user = User(username='法外狂徒', password='123123')

    db.session.add(user)

    db.session.commit()

    return '用户添加成功！'

@app.route('/user/query')
def query_user():
    # user = User.query.get(1)
    # print(f'{user.username}, {user.password}')

    users = User.query.filter_by(username='法外狂徒')
    print(type(users))
    for i in users:
        print(i.username)
    return '数据查找成功！'

@app.route('/user/update')
def update_user():
    user = User.query.filter_by(username='法外狂徒').first()
    user.password = '321321'
    db.session.commit()

    return '数据修改成功！'

@app.route('/user/delete')
def delete_user():
    user = User.query.get(1)
    db.session.delete(user)
    db.session.commit()
    return '数据删除成功！'


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