/
prefill.py
86 lines (63 loc) · 2.16 KB
/
prefill.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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Category, Item, User
engine = create_engine('sqlite:///itemcatalog.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# Users
user1 = User(name="Hamilcar Barca", email="hamilcar.barca275@gmail.com")
session.add(user1)
session.commit()
user2 = User(name="Pyrrhus", email="pyrrhustheepyrian319@gmail.com")
session.add(user2)
session.commit()
# Category soccer
category1 = Category(name="Soccer")
session.add(category1)
session.commit()
item1 = Item(name="Football", description="very round and slippery",
category=category1, user=user1)
session.add(item1)
session.commit()
# Category Snowboarding
category2 = Category(name="Snowboarding")
session.add(category2)
session.commit()
item1 = Item(name="Goggles", description="very cool", category=category2,
user=user2)
session.add(item1)
session.commit()
item2 = Item(name="Snowboard", description="long and smooth",
category=category2, user=user2)
session.add(item2)
session.commit()
# Category Frisbee - empty category
category3 = Category(name="Frisbee")
session.add(category3)
session.commit()
# Category Baseball
category4 = Category(name="Baseball")
session.add(category4)
session.commit()
item1 = Item(name="Shoes",
description="Lorem ipsum dolor sit amet, felis vitae magna,",
category=category4,
user=user1)
session.add(item1)
session.commit()
item2 = Item(name="Bat",
description="molestie etiam eu eget erat, ipsum amet," +
"aenean omnis lacinia viverra arcu ut a" +
". Est aenean vel sagittis elit duis, vulputate " +
"praesent maecenas mauris vehicula tristique, " +
"dictumst feugiat elementum nec sem, bibendum ",
category=category4, user=user2)
session.add(item2)
session.commit()
item3 = Item(name="Ball",
description="non ligula placerat. Maecenas quisque",
category=category4, user=user2)
session.add(item3)
session.commit()
print "added items!"