def test_no_more_matches(self):
"""Test to make sure that similar fields have different targets"""
raw_data = [
'address line 1',
'address line 2',
'address line 3',
'address line 4',
'address line 5',
'address line 6',
'address line 7',
'address line 8',
]
map_data = [
('PropertyState', 'address_line_1'),
('PropertyState', 'address_line_2'),
('TaxLotState', 'address_line_1'),
('TaxLotState', 'address_line_2'),
]
mc = mapping_columns.MappingColumns(raw_data, map_data)
expected = {
'address line 1': ['PropertyState', 'address_line_1', 100],
'address line 2': ['PropertyState', 'address_line_2', 100],
'address line 3': ['TaxLotState', 'address_line_1', 97],
'address line 4': ['TaxLotState', 'address_line_2', 97],
'address line 5': ['PropertyState', 'address line 5', 100],
'address line 6': ['PropertyState', 'address line 6', 100],
'address line 7': ['PropertyState', 'address line 7', 100],
'address line 8': ['PropertyState', 'address line 8', 100]
}
self.assertDictEqual(mc.final_mappings, expected)
def test_add_mappings(self):
mc = mapping_columns.MappingColumns(self.raw_columns,
self.md.keys_with_table_names)
result = mc.add_mappings('new', [('a', 'b', 100)])
self.assertTrue(result)
result = mc.add_mappings('new', [('a', 'b', 100)])
self.assertFalse(result)
def test_first_suggested_mapping(self):
mc = mapping_columns.MappingColumns(self.raw_columns,
self.md.keys_with_table_names)
expected = ('PropertyState', 'city', 100)
result = mc.first_suggested_mapping('City')
self.assertTupleEqual(result, expected)
with self.assertRaises(KeyError):
mc.first_suggested_mapping('bad-key')
def test_duplicate_fields_across_models(self):
"""Test to make sure that similar fields have different targets"""
raw_data = ['city 2015', 'city 2016', 'city 2017']
expected = {
'city 2015': ['PropertyState', 'city', 88],
'city 2016': ['TaxLotState', 'city', 88],
'city 2017': ['PropertyState', 'custom_id_1', 60],
}
mc = mapping_columns.MappingColumns(raw_data,
self.md.keys_with_table_names)
self.assertDictEqual(mc.final_mappings, expected)
def test_excluded_fields(self):
"""Test to make sure excluded fields are not mapped to"""
raw_data = [
'UBI',
'Data State',
'GBA',
'BLDGS',
'Address',
'Owner',
'City',
'State',
'Zip',
'Property Type',
'AYB_YearBuilt',
'extra_data_1',
'extra_data_2',
]
expected = {
'AYB_YearBuilt': ['PropertyState', 'year_built', 82],
'Address': ['PropertyState', 'address_line_1', 90],
'BLDGS': ['PropertyState', 'building_count', 69],
'City': ['PropertyState', 'city', 100],
'Data State': ['PropertyState', 'recent_sale_date', 66],
'GBA': ['PropertyState', 'gross_floor_area', 100],
'Owner': ['PropertyState', 'owner', 100],
'Property Type': ['PropertyState', 'property_type', 100],
'State': ['PropertyState', 'state', 100],
'UBI': ['PropertyState', 'building_certification', 60],
'Zip': ['PropertyState', 'postal_code', 100],
'extra_data_1': ['PropertyState', 'generation_date', 69],
'extra_data_2': ['PropertyState', 'release_date', 67]
}
mc = mapping_columns.MappingColumns(raw_data,
self.md.keys_with_table_names)
# _log.debug(json.dumps(mc.final_mappings, indent=4))
self.assertDictEqual(mc.final_mappings, expected)
def test_mapping_columns(self):
mc = mapping_columns.MappingColumns(self.raw_columns,
self.md.keys_with_table_names)
self.assertDictEqual(mc.final_mappings, self.expected)
def test_mapping_columns_with_threshold(self):
expected = {
'City': ['PropertyState', 'city', 100],
'Zip': ['PropertyState', 'postal_code', 100],
'GBA': ['PropertyState', 'gross_floor_area', 100],
'BLDGS': ['PropertyState', 'building_count', 69],
'AYB_YearBuilt': ['PropertyState', 'year_built', 82],
'State': ['PropertyState', 'state', 100],
'Address': ['PropertyState', 'address_line_1', 90],
'Owner': ['PropertyState', 'owner', 100],
'extra_data_1': ['PropertyState', 'generation_date', 69],
'extra_data_2': ['PropertyState', 'extra_data_2', 100],
'Property Type': ['PropertyState', 'property_type', 100],
'UBI': ['PropertyState', 'UBI', 100],
'UBI_BBL': ['PropertyState', 'UBI_BBL', 100],
}
mc = mapping_columns.MappingColumns(self.raw_columns,
self.md.keys_with_table_names,
threshold=69)
self.assertDictEqual(mc.final_mappings, expected)
expected = {
'City': ['PropertyState', 'city', 100],
'Zip': ['PropertyState', 'postal_code', 100],
'GBA': ['PropertyState', 'gross_floor_area', 100],
'BLDGS': ['PropertyState', 'BLDGS', 100],
'AYB_YearBuilt': ['PropertyState', 'year_built', 82],
'State': ['PropertyState', 'state', 100],
'Address': ['PropertyState', 'address_line_1', 90],
'Owner': ['PropertyState', 'owner', 100],
'extra_data_1': ['PropertyState', 'extra_data_1', 100],
'extra_data_2': ['PropertyState', 'extra_data_2', 100],
'Property Type': ['PropertyState', 'property_type', 100],
'UBI': ['PropertyState', 'UBI', 100],
'UBI_BBL': ['PropertyState', 'UBI_BBL', 100],
}
mc = mapping_columns.MappingColumns(self.raw_columns,
self.md.keys_with_table_names,
threshold=80)
self.assertDictEqual(mc.final_mappings, expected)
expected = {
'City': ['PropertyState', 'city', 100],
'Zip': ['PropertyState', 'postal_code', 100],
'GBA': ['PropertyState', 'gross_floor_area', 100],
'BLDGS': ['PropertyState', 'BLDGS', 100],
'AYB_YearBuilt': ['PropertyState', 'AYB_YearBuilt', 100],
'State': ['PropertyState', 'state', 100],
'Address': ['PropertyState', 'Address', 100],
'Owner': ['PropertyState', 'owner', 100],
'extra_data_1': ['PropertyState', 'extra_data_1', 100],
'extra_data_2': ['PropertyState', 'extra_data_2', 100],
'Property Type': ['PropertyState', 'property_type', 100],
'UBI': ['PropertyState', 'UBI', 100],
'UBI_BBL': ['PropertyState', 'UBI_BBL', 100],
}
mc = mapping_columns.MappingColumns(self.raw_columns,
self.md.keys_with_table_names,
threshold=100)
self.assertDictEqual(mc.final_mappings, expected)
