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()
