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!')