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)
