import requests

postals = []
latitudes = []
longitudes = []
def string_to_html(string):
    string.replace(" ", "+")
    return string


def append_to_file(string):
    with open("postal.csv", "a") as text_file:
        print(string, file=text_file)


for i in range(len(resale_data)):
    sys.stdout.write('\r')
    # the exact output you're looking for:
    sys.stdout.write(f"{i}/{len(resale_data)}")
    sys.stdout.flush()
    address = f'{resale_data["street_name"][i]} {resale_data["block"][i]}'
    url = f'https://developers.onemap.sg/commonapi/search?searchVal={string_to_html(address)}&returnGeom=Y&getAddrDetails=Y&pageNum=1'

    x = requests.get(url).json()
    if len(x["results"]) == 0:
        postals.append(None)
        latitudes.append(None)
        longitudes.append(None)
        append_to_file("None,None,None")
        continue
    postals.append(x["results"][0]["POSTAL"])
    latitudes.append(x["results"][0]["LATITUDE"])
    longitudes.append(x["results"][0]["LONGITUDE"])
    append_to_file(f'{x["results"][0]["POSTAL"]},{x["results"][0]["LATITUDE"]},{x["results"][0]["LONGITUDE"]}')
resale_data["postal"] = postals
resale_data["latitude"] = latitudes
resale_data["longitude"] = longitudes

def string_to_html_mrt(string):
    string.replace(" ", "+")
    return string+"+MRT+STATION"
mrt_stations_name = []
mrt_stations_postal = []
mrt_stations_long = []
mrt_stations_lat = []
mrt_stations = pd.read_csv("mrt_stations.csv",header=None)

def append_to_file_mrt(string):
    with open("mrt_info.csv", "a") as text_file:
        print(string, file=text_file)
print(mrt_stations)

for i in mrt_stations[0]:
    url = f'https://developers.onemap.sg/commonapi/search?searchVal={string_to_html_mrt(i)}&returnGeom=Y&getAddrDetails=Y&pageNum=1'
    x = requests.get(url).json()
#     print(x["results"][])
    for j in x["results"]:
        print(j["SEARCHVAL"])
        if "MRT STATION" in j["SEARCHVAL"]:
            mrt_stations_name.append(j["SEARCHVAL"])
            mrt_stations_postal.append(j["POSTAL"])
            mrt_stations_long.append(j["LONGITUDE"])
            mrt_stations_lat.append(j["LATITUDE"])
            append_to_file_mrt(f'{j["SEARCHVAL"]},{j["POSTAL"]},{j["LONGITUDE"]},{j["LATITUDE"]}')
            break