/
categorydbinit.py
58 lines (45 loc) · 1.36 KB
/
categorydbinit.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
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Category
print '[+] Connecting to database...'
engine = create_engine('sqlite:///catalog.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
print '[+] Creating Categories...'
aud = Category(name="Audio", id=1)
session.add(aud)
session.commit()
print '[+] Created Category: Audio.'
browser = Category(name="Browsers", id=2)
session.add(browser)
session.commit()
print '[+] Created Category: Browsers.'
db = Category(name="Database", id=3)
session.add(db)
session.commit()
print '[+] Created Category: Database.'
dt = Category(name="Developer Tools", id=4)
session.add(dt)
session.commit()
print '[+] Created Category: Developer Tools.'
gaming = Category(name="Gaming", id=5)
session.add(gaming)
session.commit()
print '[+] Created Category: Gaming.'
os = Category(name="Operating Systems", id=6)
session.add(os)
session.commit()
print '[+] Created Category: Operating Systems.'
rt = Category(name="Theming/Ricing", id=7)
session.add(rt)
session.commit()
print '[+] Created Category: Theming/Ricing.'
sys = Category(name="System", id=8)
session.add(sys)
session.commit()
print '[+] Created Category: System.'
util = Category(name="Utilities", id=9)
session.add(util)
session.commit()
print '[+] Created Category: Utilities.'