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

 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=TabError,autoincrement=True)
12     username=db.Column(db.String(20),nullable=False)
13     password=db.Column(db.String(20),nullable=False)
14 '''
15 # 数据删除
16 user = User.query.filter(User.username=='hh').first()
17 db.session.delete(user)
18 db.session.commit()
19 
20 # 数据更改
21 user = User.query.filter(User.username=='hh').first()
22 user.password='0000'
23 db.session.commit()
24 
25 # 数据添加
26 user=User(username='hh',password='gg')
27 db.session.add(user)
28 db.session.commit()
29 db.create_all()
30 
31 # 数据查询
32 user = User.query.filter(User.username=='hh').first()
33 print(user.username,user.password)
34 '''
35 
36 
37 @app.route('/')
38 def hello_world():
39     return 'hello World'
40 
41 
42 if __name__ == '__main__':
43       app.run()

 

转载于:https://www.cnblogs.com/honghui/p/7839307.html