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))