def test_02_check_passwords(self): y = SQLResolver() y.loadConfig(self.parameters) # SHA256 of "dunno" # 772cb52221f19104310cd2f549f5131fbfd34e0f4de7590c87b1d73175812607 result = y.checkPass(3, "dunno") print result assert result is True """ SHA1 base64 encoded of "dunno" Lg8DuLoXOwvPkMABDprnaTp0JOA= """ result = y.checkPass(2, "dunno") assert result is True result = y.checkPass(1, "dunno") assert result is True result = y.checkPass(4, "dunno") assert result is True result = y.checkPass(5, "dunno") assert result is True """ >>> PH = PasswordHash() >>> PH.hash_password("testpassword") '$P$Bz4R6lzp6VWCL0SCeTozqKHNV8DM.Q/' """ result = y.checkPass(6, "testpassword") self.assertTrue(result)
def test_02_check_passwords(self): y = SQLResolver() y.loadConfig(self.parameters) # SHA256 of "dunno" # 772cb52221f19104310cd2f549f5131fbfd34e0f4de7590c87b1d73175812607 result = y.checkPass(3, "dunno") print(result) assert result is True ''' SHA1 base64 encoded of "dunno" Lg8DuLoXOwvPkMABDprnaTp0JOA= ''' result = y.checkPass(2, "dunno") assert result is True result = y.checkPass(1, "dunno") assert result is True result = y.checkPass(4, "dunno") assert result is True result = y.checkPass(5, "dunno") assert result is True ''' >>> PH = PasswordHash() >>> PH.hash_password("testpassword") '$P$Bz4R6lzp6VWCL0SCeTozqKHNV8DM.Q/' ''' result = y.checkPass(6, "testpassword") self.assertTrue(result)
def test_00_delete_users(self): # If the test failed and some users are still in the database (from # add_user) we delete them here. y = SQLResolver() y.loadConfig(self.parameters) for username in self.usernames: uid = y.getUserId(username) y.delete_user(uid)
def test_00_delete_achmeds(self): # If the test failed and some achmeds are still in the database (from # add_user) we delete them here. y = SQLResolver() y.loadConfig(self.parameters) for username in ["achmed", "achmed2", "corneliusReg"]: uid = True while uid: uid = y.getUserId(username) y.delete_user(uid)
def test_00_delete_achmeds(self): # If the test failed and some achmeds are still in the database (from # add_user) we delete them here. y = SQLResolver() y.loadConfig(self.parameters) for username in ["achmed", "achmed2"]: uid = True while uid: uid = y.getUserId(username) y.delete_user(uid)
def test_01_sqlite_resolver(self): y = SQLResolver() y.loadConfig(self.parameters) userlist = y.getUserList() self.assertTrue(len(userlist) == 6, len(userlist)) user = "******" user_id = y.getUserId(user) self.assertTrue(user_id == 3, user_id) rid = y.getResolverId() self.assertTrue(rid == "sql.testuser.sqlite", rid) rtype = y.getResolverType() self.assertTrue(rtype == "sqlresolver", rtype) rdesc = y.getResolverClassDescriptor() rdesc = y.getResolverDescriptor() self.assertTrue("sqlresolver" in rdesc, rdesc) self.assertTrue("config" in rdesc.get("sqlresolver"), rdesc) self.assertTrue("clazz" in rdesc.get("sqlresolver"), rdesc) uinfo = y.getUserInfo(user_id) self.assertTrue(uinfo.get("username") == "cornelius", uinfo) ret = y.getUserList({"username": "******"}) self.assertTrue(len(ret) == 1, ret) username = y.getUsername(user_id) self.assertTrue(username == "cornelius", username)
def test_99_testconnection_fail(self): y = SQLResolver() self.parameters['Database'] = "does_not_exist" result = y.testconnection(self.parameters) self.assertTrue(result[0] == -1, result) self.assertTrue("failed to retrieve" in result[1], result)
def test_05_add_user_update_delete(self): y = SQLResolver() y.loadConfig(self.parameters) uid = y.add_user({ "username": "******", "email": "*****@*****.**", "mobile": "12345" }) self.assertTrue(uid > 6) uid = y.getUserId("achmed") self.assertTrue(uid > 6) r = y.update_user(uid, {"username": "******", "password": "******"}) uname = y.getUsername(uid) self.assertEqual(uname, "achmed2") r = y.checkPass(uid, "test") self.assertTrue(r) # Now we delete the user y.delete_user(uid) # Now there should be no achmed anymore uid = y.getUserId("achmed2") self.assertFalse(uid) uid = y.getUserId("achmed") self.assertFalse(uid)
def test_03_testconnection(self): y = SQLResolver() result = y.testconnection(self.parameters) self.assertEqual(result[0], 6) self.assertTrue('Found 6 users.' in result[1])
def test_01_where_tests(self): y = SQLResolver() y.loadConfig( dict(self.parameters.items() + {"Where": "givenname == " "hans"}.items())) userlist = y.getUserList() self.assertTrue(len(userlist) == 1, userlist) y = SQLResolver() y.loadConfig( dict(self.parameters.items() + {"Where": "givenname like " "hans"}.items())) userlist = y.getUserList() self.assertTrue(len(userlist) == 1, userlist) y = SQLResolver() y.loadConfig( dict(self.parameters.items() + {"Where": "id > 2"}.items())) userlist = y.getUserList() self.assertTrue(len(userlist) == 4, userlist) y = SQLResolver() y.loadConfig( dict(self.parameters.items() + {"Where": "id < " "5"}.items())) userlist = y.getUserList() self.assertTrue(len(userlist) == 4, userlist)
def test_99_testconnection_fail(self): y = SQLResolver() self.parameters["Database"] = "does_not_exist" result = y.testconnection(self.parameters) self.assertTrue(result[0] == -1, result) self.assertTrue("failed to retrieve" in result[1], result)
def test_05_add_user_update_delete(self): y = SQLResolver() y.loadConfig(self.parameters) uid = y.add_user({"username": "******", "email": "*****@*****.**", "mobile": "12345"}) self.assertTrue(uid > 6) uid = y.getUserId("achmed") self.assertTrue(uid > 6) r = y.update_user(uid, {"username": "******", "password": "******"}) uname = y.getUsername(uid) self.assertEqual(uname, "achmed2") r = y.checkPass(uid, "test") self.assertTrue(r) # Now we delete the user y.delete_user(uid) # Now there should be no achmed anymore uid = y.getUserId("achmed2") self.assertFalse(uid) uid = y.getUserId("achmed") self.assertFalse(uid)
def test_03_testconnection(self): y = SQLResolver() result = y.testconnection(self.parameters) self.assertTrue(result[0] == 6, result) self.assertTrue("Found 6 users." in result[1])
def test_01_where_tests(self): y = SQLResolver() y.loadConfig(dict(self.parameters.items() + {"Where": "givenname == " "hans"}.items())) userlist = y.getUserList() self.assertTrue(len(userlist) == 1, userlist) y = SQLResolver() y.loadConfig(dict(self.parameters.items() + {"Where": "givenname like " "hans"}.items())) userlist = y.getUserList() self.assertTrue(len(userlist) == 1, userlist) y = SQLResolver() y.loadConfig(dict(self.parameters.items() + {"Where": "id > 2"}.items())) userlist = y.getUserList() self.assertTrue(len(userlist) == 4, userlist) y = SQLResolver() y.loadConfig(dict(self.parameters.items() + {"Where": "id < " "5"}.items())) userlist = y.getUserList() self.assertTrue(len(userlist) == 4, userlist)