-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathuser.py
More file actions
27 lines (23 loc) · 706 Bytes
/
user.py
File metadata and controls
27 lines (23 loc) · 706 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
from database import db
class User(db.Model):
id = db.Column(db.Integer,primary_key=True)
username = db.Column(db.String(255), unique=True)
age = db.Column(db.Integer)
def __init__(self,username,age):
self.username = username
self.age = age
def __repr__(self):
return '<User %r>' % self.username
if __name__ == '__main__':
db.drop_all()
db.create_all()
user1 = User('ologist', 10)
user2 = User('josh', 20)
db.session.add(user1)
db.session.add(user2)
db.session.commit()
# user = User.query.filter_by(username='josh').first()
user = User.query.get(1)
print user.username
print user.age
print User.query.all()