通过用户模型，对数据库进行增删改查操作。

 

 

增加：
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

 

 



 




 




 






            

            
posted @ 
2017-11-15 15:49 
029郭媚婷 
阅读(127) 
评论(0) 
 
收藏 
举报