def test_single_query3(self): """test query with multiple tables""" query = "find dataset.name, algo.name, primds.name" mquery, keylist = query_parser(self.app.mapper, query) query = self.app.build_query(query) print query query = "find dataset.name, algo.name, primds.name where file.name = 123 and \ (dataset.name = 456 or dataset.name = 789)" mquery, keylist = query_parser(self.app.mapper, query) query = self.app.build_query(query) print query
def test_single_query(self): """ test single query without constaints """ query = "find dataset.createdate, dataset.name" mquery, keylist = query_parser(self.app.mapper, query) query = self.app.build_query(query) print query
def test_single_query2(self): """ test single query with constraints """ query = "find dataset.name where file.name = 123 and \ (dataset.name = 456 or dataset.name = 789)" mquery, keylist = query_parser(self.app.mapper, query) query = self.app.build_query(query) print query
def test_query_parser(self): """ test clause generation """ query = "find dataset.createdate, dataset.name where file.name = 123" mquery, keylist = query_parser(self.app.mapper, query) mquery2 = {'keywords':[['ProcessedDataset.CreateDate'], ['Files.Path']], 'constraints': [{'value': '123', 'keyword': ['Files.Name', 'file.name'], 'sign': '='}]} keylist2 = {'mkeywords': [['ProcessedDataset.CreateDate'],['Files.Path']], 'constraints':['file.name'], 'keywords':['dataset.createdate', 'dataset.name']} self.assertEqual(mquery['keywords'], mquery2['keywords']) self.assertEqual(mquery['constraints'],mquery2['constraints']) self.assertEqual(keylist['keywords'], keylist2['keywords']) self.assertEqual(keylist['constraints'], keylist2['constraints'])