def test_fact_table_struct(self):
join_struct = ntd.generate_join_struct_for_fact_table("f_detail", self.metadata, "d_", "_id",
overrides={"lab_procedure_class_id": "procedure_class_id"},
filter_table=None)
self.assertTrue(len(join_struct))
self.assertEquals(3, len(join_struct))
select_join_sql = ntd.join_tables_together(join_struct)
print(select_join_sql)
self.assertTrue(len(select_join_sql))
self.connection.execute(select_join_sql)
def test_join_tables_togehther(self):
join_struct = [{"table_name": "main_table", "alias": "mt", "fields": ["a", "b", "c"], "field_aliases": {}},
{"table_name": "join_table", "alias": "jt", "fields": ["a", "x", "z"], "field_aliases": {"a": "a1"},
"join_criteria": {"join_table": "main_table", "join_table_field": "a", "join_to_table_field": "a"}
}
]
join_sql = ntd.join_tables_together(join_struct)
self.assertIsNotNone(join_sql)
c = self.connection.execute(join_sql)
result_set = list(c)
print(result_set)
self.assertEquals(2, len(result_set))