create操作
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
HOSTNAME="127.0.0.1"
PORT="3306"
USERNAME="root"
PASSWORD='123456'
DATABASE='demo'
app.config['SQLALCHEMY_DATABASE_URI'] = f'mysql+pymysql://{USERNAME}:{PASSWORD}@{HOSTNAME}:{PORT}/{DATABASE}?charset=utf8mb4'
db=SQLAlchemy(app)
class User(db.Model):
__tablename__ = "user"
id = db.Column(db.Integer,primary_key=True,autoincrement=True)
# varchar,null=0
username = db.Column(db.String(100),nullable=False)
password = db.Column(db.String(100),nullable=False)
@app.route('/')
def hello_world():
return 'Hello world!'
@app.route('/user/add')
def add_user():
user=User(username="Allen",password="123456")
db.session.add(user)
db.session.commit()
return '添加用户成功'
if __name__ == '__main__':
app.run(debug=True)
read操作
@app.route("/user/query")
def query_user():
# 方法一 get查找主键
# user=User.query.get(1)
# 方法二 filter_by
users=User.query.filter_by(username="Allen")
for user in users:
print(f'{user.id}:{user.username}-{user.password}')
return '数据查找成功!'
update操作
@app.route("/user/update")
def update_user():
user=User.query.filter_by(username='Allen').first()
user.password='222222'
db.session.commit()
return '数据修改成功!'
delete操作
@app.route('/user/delete')
def delete_user():
user=User.query.filter_by(username='Allen').first()
db.session.delete(user)
db.session.commit()
return '数据删除成功!'