def accm(db):
# try logging in
session = canLogin(db, 'd4nny', 'password')
assert session
assert session.addMasterAccount('thomas', '(780) 111-1111', 'industrial',
'2018-02-25', '2018-03-25')
assert not session.createServiceAgreement(
'1', 'McDonalds', 'mixed waste', 'everyday', '(780) 111-1111', 250,
350)
assert not session.createServiceAgreement(
'1', 'Burger King', 'paper', 'everyday', '(780) 111-1111', 250, 237)
assert session.createServiceAgreement('142', 'McDonalds', 'mixed waste',
'everyday', '(780) 111-1111', 250,
350)
assert session.createServiceAgreement('142', 'Burger King', 'paper',
'everyday', '(780) 111-1111', 250,
237)
assert not session.getServiceAgreements('1')
assert session.getServiceAgreements('142')
summary = session.getSummaryReport('142')
assert summary
print(tuple(summary))
print("All test cases passed for account managers!")
def dispatcher(db):
session = canLogin(db, 'lol', 'password')
assert session.getPublicTrucks()
assert session.getTruckDriver('100')
assert session.getAvailableAgreements()
print('All test cases passed for dispatcher!')
def admin(db):
db.cursor.execute("SELECT role, login FROM users")
displayQuery(db, db.cursor.fetchall())
# try logging in
session = canLogin(db, 'owner', 'password')
assert session
assert session.role == 'admin'
assert session.addUser('user1', 'pass1', '12', 'supervisor')
assert not session.addUser('user1', 'pass1', '13', 'driver')
assert not session.addUser('user1', 'pass1', '14', 'account manager')
assert session.deleteUser('user1')
print("Test case for admin passed!")
def supervisor(db):
# try logging in
session = canLogin(db, 'thomas', 'password')
assert session.getSupervisedAccounts()
assert session.getSupervisedManagers()
assert session.isSupervising('6969') == False
assert session.addMasterAccount('6969', 'fail', '(780) 111-1111',
'industrial', '2018-02-25',
'2018-03-25') == None
assert session.addMasterAccount('111111', 'pass', '(780) 111-1111',
'industrial', '2018-02-25', '2018-03-25')
assert session.getSummaryReport('142')
assert session.getSummaryReport('1')
assert session.getManagerSummaryReport()
print('All test cases passed for supervisors!')
def driver(db):
session = canLogin(db, 'test', 'password')
assert len(session.getTours('2010-03-10', '2018-03-12')) == 2
print('All test cases passed for driver!')