-
Notifications
You must be signed in to change notification settings - Fork 28
Expand file tree
/
Copy pathSqlalchemyORM.py
More file actions
executable file
·47 lines (40 loc) · 1.05 KB
/
SqlalchemyORM.py
File metadata and controls
executable file
·47 lines (40 loc) · 1.05 KB
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
#!/usr/bin/python
from sqlalchemy import *
from sqlalchemy.orm import *
from sqlalchemy.ext.declarative import *
from User import *
db=create_engine("sqlite:///tutorial.db")
metadata = MetaData(db)
users_table = Table('users',metadata,
Column('id',Integer,primary_key=True),
Column('name',String(20)),
Column('fullname',String(20)),
Column('password',String(20)))
metadata.create_all(db)
Session = sessionmaker(bind = db)
session = Session()
user1 = User('name1','fullname','ps')
user2 = User('name2','fullname','ps')
user3 = User('name3','fullname','ps')
session.add(user1)
session.add(user2)
session.add(user3)
#session.flush()
session.commit()
# query by name
userlist = session.query(User).filter_by(name='name1')
for user in userlist:
print user
# query all
userlist = session.query(User)
for user in userlist:
print user
# update
userlist = session.query(User).filter_by(name='name1')
for user in userlist:
user.name='user55'
user.password='new'
session.commit()
userlist=session.query(User).filter_by(name='user55')
for user in userlist:
print user