from algoliasearch.search_client import SearchClient
from dotenv import load_dotenv
import os

INDEX_NAME = 'pubfinder'   

client = SearchClient.create(os.getenv('ALG_APPLICATION_ID'), os.getenv('ALG_API_KEY'))
index = client.init_index(INDEX_NAME)

for record in index.browse_objects({"filters": "borough:'City of London'"}):
    _geoloc = {
        "lat": record["lat"],
        "lng": record["lng"]
    }
    record["_geoloc"] = _geoloc
    del record["lat"]
    del record["lng"]
    index.save_object(record)