def test_get_address_from_postcode_single(self): address = Address() address.uprn = "123456" address.address_line_1 = "Dataland Village Main Street" address.postcode = "AA111ZZ" address.point = Point(float("-1.83356713993623"), float("55.4168769443259"), srid=4326) address.save() found_address = get_address_from_postcode('AA111ZZ') self.assertIsNotNone(found_address) self.assertEqual(found_address[0].uprn, '123456')
def process_row(self, row): print(row) try: address = Address.objects.get(uprn=row[0]) except Address.DoesNotExist: address = Address() address.uprn = row[0] address.address_line_1 = row[2] address.address_line_2 = row[3] address.address_line_3 = row[4] address.city = row[5] address.county = row[6] address.postcode = row[7].strip().replace(' ', '').upper() address.country_code = row[8] address.point = Point(float(row[10]), float(row[9]), srid=4326) try: address.save() except Exception as e: print('Could not add: {0}'.format(row))