def test_mappings_vp_0(self):
sat1 = create_example_satellite("1")
hub1 = create_example_hub("1")
sat2 = create_example_satellite("1", "1")
vp_1_1 = create_example_version_pointer("1", "1")
_ = Schema('dv', [sat1, hub1, sat2, vp_1_1])
# print(schema.referred_tables)
table_mappings = TableMappings([
t._asdict() for t in [
TableMapping("dv", "example1_s", "", "dv", "example_1_1_vp"),
TableMapping("dv", "example11_s", "", "dv", "example_1_1_vp")
]
])
column_mappings = ColumnMappings([
c._asdict() for c in [
ColumnMapping("dv", "example1_s", "example1_key", "", "dv",
"example_1_1_vp", "example1_m_key"),
ColumnMapping("dv", "example11_s", "example1_key", "", "dv",
"example_1_1_vp", "example1_c_key"),
ColumnMapping("dv", "example11_s", "load_dts", "", "dv",
"example_1_1_vp", "example1_c_load_dts"),
ColumnMapping("dv", "example1_s", "load_dts", "", "dv",
"example_1_1_vp", "load_dts"),
]
])
mappings = Mappings(table_mappings, column_mappings,
[vp_1_1] + column_mappings.source_tables())
mappings.check(vp_1_1)
path = mappings.path(vp_1_1)
self.assertEqual([c.full_name for c in path], [
'dv.example1_s.example1_key', 'dv.example1_h.example1_key',
'dv.example11_s.example1_key'
])
def test_mappings_vp_2(self):
sat1 = create_example_satellite("1")
hub1 = create_example_hub("1")
link_1_2 = create_example_link("1", "2")
hub2 = create_example_hub("2")
link_2_3 = create_example_link("2", "3")
lsat_2_3 = create_example_link_satellite("2", "3")
hub3 = create_example_hub("3")
sat3 = create_example_satellite("3")
vp_1_3 = create_example_version_pointer("1", "3")
schema = Schema('dv', [
sat1, hub1, link_1_2, hub2, link_2_3, lsat_2_3, hub3, sat3, vp_1_3
])
# print(schema.referred_tables)
table_mappings = TableMappings([
t._asdict() for t in [
TableMapping("dv", "example1_s", "", "dv", "example_1_3_vp"),
TableMapping("dv", "example1_h", "", "dv", "example_1_3_vp"),
TableMapping("dv", "example_1_2_l", "", "dv",
"example_1_3_vp"),
TableMapping("dv", "example2_h", "", "dv", "example_1_3_vp"),
TableMapping("dv", "example_2_3_l", "", "dv",
"example_1_3_vp"),
TableMapping("dv", "example3_h", "", "dv", "example_1_3_vp"),
TableMapping("dv", "example3_s", "", "dv", "example_1_3_vp")
]
])
column_mappings = ColumnMappings([
c._asdict() for c in [
ColumnMapping("dv", "example1_s", "example1_key", "", "dv",
"example_1_3_vp", "example1_m_key"),
ColumnMapping("dv", "example3_s", "example3_key", "", "dv",
"example_1_3_vp", "example3_c_key"),
ColumnMapping("dv", "example3_s", "load_dts", "", "dv",
"example_1_3_vp", "example3_c_load_dts"),
ColumnMapping("dv", "example1_s", "load_dts", "", "dv",
"example_1_3_vp", "load_dts"),
]
])
mappings = Mappings(
table_mappings, column_mappings,
list(schema.tables.values()) + column_mappings.source_tables())
mappings.check(vp_1_3)
path = mappings.path(vp_1_3)
self.assertEqual([c.full_name for c in path], [
'dv.example1_s.example1_key', 'dv.example1_h.example1_key',
'dv.example_1_2_l.example1_key', 'dv.example_1_2_l.example2_key',
'dv.example2_h.example2_key', 'dv.example_2_3_l.example2_key',
'dv.example_2_3_l.example3_key', 'dv.example3_h.example3_key',
'dv.example3_s.example3_key'
])