通过用户模型,对数据库进行增删改查操作。
增加:
db.session.add(user)
db.session.commit()
查询:
User.query.filter(User.username == 'mis1114').first()
修改:
user.password = '111111'
db.session.commit()
删除:
db.session.delete(user)
db.session.commit()
1 from flask import Flask 2 from flask_sqlalchemy import SQLAlchemy 3 import config 4 5 app = Flask(__name__) 6 app.config.from_object(config) 7 db = SQLAlchemy(app) 8 9 class User(db.Model): 10 __tablename__ = 'user' 11 id = db.Column(db.Integer,primary_key=True,autoincrement=True) 12 username = db.Column(db.String(20),nullable=False) 13 password = db.Column(db.String(20),nullable=False) 14 nickname = db.column(db.String(50)) 15 16 17 # db.create_all() 18 19 user = User.query.filter(User.username=='mis1555').first() 20 db.session.delete(user) 21 db.session.commit() 22 23 ''' 24 user = User(username = 'mis1555',password = 'mis1555') 25 db.session.add(user) 26 db.session.commit() 27 28 user = User.query.filter(User.username=='mis1555').first() 29 user.password = '111111' 30 print(user.username,user.password) 31 db.session.commit() 32 ''' 33 34 @app.route('/') 35 def hello_world(): 36 return 'Hello World!' 37 38 39 if __name__ == '__main__': 40 app.run()
1 SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:@127.0.0.1:3306/mis_db?charset=utf8' 2 SQLALCHEMY_TRACK_MODIFICATIONS = False