def test_obj_query(self): schema = self.schemas['schema1'] dao = ORM_DAO(session=self.session, schema=schema) q = { 'ID': 'obj_q', 'SELECT': ['__TestClass1'], } results = dao.execute_queries(query_defs=[q]) self.assertIsNotNone(results)
def test_combined_query(self): schema = self.schemas['schema1'] dao = ORM_DAO(session=self.session, schema=schema) q = { 'ID': 'obj_q', 'SELECT': [ {'ID': 'foo', 'EXPRESSION': '__TestClass1'}, '__TestClass1__id'], } results = dao.execute_queries(query_defs=[q]) self.assertIsNotNone(results)
def test_join_query(self): schema = self.schemas['schema1'] dao = ORM_DAO(session=self.session, schema=schema) simple_q = { 'ID': 'simple_q', 'SELECT': ['__TestClass1'], 'FROM': [ { 'SOURCE': 'TestClass1', 'JOINS': [ [ 'TestClass2', [ {'TYPE': 'ENTITY', 'EXPRESSION': '__TestClass1__id'}, '==', {'TYPE': 'ENTITY', 'EXPRESSION': '__TestClass2__id'} ] ] ] } ], } results = dao.execute_queries(query_defs=[simple_q]) self.assertIsNotNone(results)