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_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)
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)
