['Scanner', '654321', '654321'],
['Sys block', '1324356', '1324356']
]
users = [
['Serg', 'Porokh'],
['Vasyl', 'Chereda'],
['Musiy', 'Storoguk']
]
departments = ['jur', 'it']
d = Department(departments[0])
u1 = User(users[0][0],users[0][1])
u2 = User(users[1][0],users[1][1])
d.set_user(u1)
d.set_user(u2)
eq1 = Equipment(equipment[0][0], equipment[0][1], equipment[0][2])
eq2 = Equipment(equipment[1][0], equipment[1][1], equipment[1][2])
u1.set_equipment(eq1)
u1.set_equipment(eq2)
eq3 = Equipment(equipment[2][0], equipment[2][1], equipment[2][2])
u2.set_equipment(eq3)
db.add(eq1)
db.add(eq2)
db.add(eq3)
db.add(u1)
db.add(u2)
db.add(d)
db.commit()
dep_us = {
u'ІТ': [
(u'Порох', u'Сергій'),
(u'Копайбіда', u'Олег'),
(u'Череда', u'Василь')
],
u'Юридичний': [
(u'Порошенко', u'Петро'),
(u'Копач', u'Світлана')
],
u'Бухгалтерія': [
(u'Калюжна', u'Ірина')
]
}
for dep in dep_us.keys():
d = Department(dep)
for us in dep_us[dep]:
u = User(us[0], us[1])
for eq in us_quip[us]:
e = Equipment(eq[0], eq[1], eq[2])
u.set_equipment(e)
db.add(e)
d.set_user(u)
db.add(u)
db.add(d)
db.commit()
