-
Notifications
You must be signed in to change notification settings - Fork 0
/
lotsofitems.py
67 lines (46 loc) · 1.9 KB
/
lotsofitems.py
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Catalog, Base, Item, User
engine = create_engine('sqlite:///catalog.db')
# Bind the engine to the metadata of the Base class so that the
# declaratives can be accessed through a DBSession instance
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
# A DBSession() instance establishes all conversations with the database
# and represents a "staging zone" for all the objects loaded into the
# database session object. Any change made against the objects in the
# session won't be persisted into the database until you call
# session.commit(). If you're not happy about the changes, you can
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()
# Create dummy user
User1 = User(name="El Bundy", email="[email protected]",
picture='http://vignette1.wikia.nocookie.net/marriedwithchildren/images/b/b8/Al_Bundy.jpg/revision/latest?cb=20141207170838')
session.add(User1)
session.commit()
# Catalog-ID Soccer
catalog1 = Catalog(user_id=1, name="Soccer")
session.add(catalog1)
session.commit()
item2 = Item(user_id=1, name="Shoes", description="To hit the ball perfect.",
catalog=catalog1)
session.add(item2)
session.commit()
item1 = Item(user_id=1, name="Ball", description="The most important part.",
catalog=catalog1)
session.add(item1)
session.commit()
# Catalog-ID Snowboard
catalog2 = Catalog(user_id=1, name="Snowboarding")
session.add(catalog2)
session.commit()
item2 = Item(user_id=1, name="Goggles", description="To see it better.",
catalog=catalog2)
session.add(item2)
session.commit()
item1 = Item(user_id=1, name="Snowboard", description="The board to rule them all.",
catalog=catalog2)
session.add(item1)
session.commit()
print "added catalog items!"