def test_administrators(self): self.user = um_utils.user(self.admin, 'quantel@') result = um_utils.login(self.user) if (result == 0 or result == 1): self.user.loggedin = True self.assertTrue((result == 0 or result == 1), 'Test Failed: User could not log in.') # Delete all existing licenses db_utils.deleteAllLicenses(self.connection, self.cur) for x in range(0, 7): # Check user every minute to see if still logged in print 'Sleeping for 60 secs.................' time.sleep(60) # Check that user is still logged in if (db_utils.isUserLoggedIn(self.connection, self.cur, self.user)): print 'User still logged in after %d minutes' % (x + 1) self.assertTrue((db_utils.isUserLoggedIn(self.connection, self.cur, self.user)), 'Test Failed: User has been logged out') print 'Sleeping for 2 secs.................' time.sleep(2)
def setUpClass(inst): print 'Start of test: test_license_invalid_version' # List of editors i.e. users that do not have admin rights inst.editors = [ 'chloe.anderson', 'chloe.garcia', 'chloe.jackson', 'chloe.johnson', 'chloe.jones', 'chloe.lee' ] # List of managers i.e. users with manager rights inst.managers = [ 'maria.a', 'maria.b', 'maria.c', 'maria.d', 'maria.e', 'maria.f', 'maria.g' ] # List of administrators i.e. users with administrator rights inst.admins = [ 'avaa.johnsona', 'avaa.whitea', 'avac.whitec', 'avad.johnsond', 'avaf.whitef', 'avag.johnsong', 'avag.wilsong' ] # Set up connection to database inst.connection = db_utils.connectToDb() inst.cur = inst.connection.cursor() # Delete all existing licenses db_utils.deleteAllLicenses(inst.connection, inst.cur) # Install license with an invalid version number inst.maxUsers = db_utils.addUserLicenseInvalidVersion( inst.connection, inst.cur) print 'License installed with an invalid version'
def setUpClass(inst): print 'Start of test: test_remove_license_table' # List of editors i.e. users that do not have admin rights inst.editors = [ 'chloe.anderson', 'chloe.garcia', 'chloe.jackson', 'chloe.johnson', 'chloe.jones', 'chloe.lee' ] # List of managers i.e. users with manager rights inst.managers = [ 'maria.a', 'maria.b', 'maria.c', 'maria.d', 'maria.e', 'maria.f', 'maria.g' ] # List of administrators i.e. users with administrator rights inst.admins = [ 'avaa.johnsona', 'avaa.whitea', 'avac.whitec', 'avad.johnsond', 'avaf.whitef', 'avag.johnsong', 'avag.wilsong' ] # Set up connection to database inst.connection = db_utils.connectToDb() inst.cur = inst.connection.cursor() # Delete all existing licenses db_utils.deleteAllLicenses(inst.connection, inst.cur) # Delete the license table from the database db_utils.deleteLicencesTable(inst.connection, inst.cur) inst.maxUsers = 0 print 'All licenses deleted and license tabble removed from db'
def setUpClass(inst): print 'Start of test: test_valid_license' # List of editors i.e. users that do not have admin rights inst.editors = [ 'chloe.anderson', 'chloe.garcia', 'chloe.jackson', 'chloe.johnson', 'chloe.jones', 'chloe.lee' ] # List of managers i.e. users with manager rights inst.managers = [ 'maria.a', 'maria.b', 'maria.c', 'maria.d', 'maria.e', 'maria.f', 'maria.g', 'maria.h', 'maria.i', 'maria.j', 'maria.k', 'maria.l' ] # List of administrators i.e. users with administrator rights inst.admins = [ 'avaa.johnsona', 'avaa.whitea', 'avac.whitec', 'avad.johnsond', 'avaf.whitef', 'avag.johnsong', 'avag.wilsong', 'avai.robinsoni', 'aval.wilsonl', 'avag.whiteg', 'avah.wilsonh', 'avam.robinsonm' ] # Set up connection to database inst.connection = db_utils.connectToDb() inst.cur = inst.connection.cursor() # Delete all existing licenses db_utils.deleteAllLicenses(inst.connection, inst.cur) # Install license for five users and set the value of maxManagers inst.maxUsers = db_utils.addFiveUserLicense(inst.connection, inst.cur) print 'License installed for %d users' % inst.maxUsers
def tearDownClass(inst): # Delete license and reinstall license for twenty-five users db_utils.deleteAllLicenses(inst.connection, inst.cur) maxUsers = db_utils.addTwentyFiveUserLicense(inst.connection, inst.cur) print 'License installed for %d users' % maxUsers # Close connection to database db_utils.closeConnection(inst.connection, inst.cur)
def setUpClass(inst): print 'Start of test: test_login' # Username to be used for this test username = '******' inst.user = um_utils.user(username, 'quantel@') # Set up connection to database inst.connection = db_utils.connectToDb() inst.cur = inst.connection.cursor() # Delete all existing licenses and install license for five users db_utils.deleteAllLicenses(inst.connection, inst.cur) inst.maxUsers = db_utils.addFiveUserLicense(inst.connection, inst.cur) print 'License installed for %d users' % inst.maxUsers
def setUpClass(inst): print 'Start of test: test_remove_license' # Name of administrator to be used for this test inst.admin = 'avaa.johnsona' # Name of editor to be used for this test inst.editor = 'chloe.anderson' # Name of manager to be used for this test inst.manager = 'maria.a' # Set up connection to database inst.connection = db_utils.connectToDb() inst.cur = inst.connection.cursor() # Delete all existing licenses db_utils.deleteAllLicenses(inst.connection, inst.cur)
def test_editors(self): self.user = um_utils.user(self.editor, 'quantel@') result = um_utils.login(self.user) print 'Result = %d' % result if (result == 0 or result == 1): self.user.loggedin = True self.assertTrue((result == 0 or result == 1), 'Test Failed: User could not log in.') # Delete all existing licenses db_utils.deleteAllLicenses(self.connection, self.cur) for x in range(0, 5): # Check user every minute to see if still logged in print 'Sleeping for 60 secs.................' time.sleep(60) # Check that user is still logged in if (db_utils.isUserLoggedIn(self.connection, self.cur, self.user)): print 'User still logged in after %d minutes' % (x + 1) self.assertTrue( (db_utils.isUserLoggedIn(self.connection, self.cur, self.user)), 'Test Failed: User has been logged out after %d minutes' % (x + 1)) # If still logged in after five minutes, wait another 120 seconds and check that user has been logged out print 'Sleeping for 120 secs.................' time.sleep(120) if (db_utils.isUserLoggedIn(self.connection, self.cur, self.user) == False): print 'User has been successfully logged out' self.assertFalse( db_utils.isUserLoggedIn(self.connection, self.cur, self.user), 'Test Failed: User has not been logged out after seven minutes') print 'Sleeping for 2 secs.................' time.sleep(2)
def setUp(inst): # Delete all existing licenses at the start of each test db_utils.deleteAllLicenses(inst.connection, inst.cur)