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