# scripts/delete_all_questions.py
# *coding: utf-8*

from backoffice.models import Place
import requests
import urllib
import time
import logging
logger = logging.getLogger('django')

def run():
    # Fetch all places
    allPlaces = Place.objects.filter(valid=True)
    for place in allPlaces:
        if place.googlePlaceId is None:
            adresseToCheck = (u''+place.name+" "+u''+place.full_address).encode("utf8")
            print("Adresse %s" % adresseToCheck)
            if adresseToCheck:
                url="https://maps.googleapis.com/maps/api/place/findplacefromtext/json?inputtype=textquery&key=AIzaSyC2StTKAdCeCl2zUwzNhLxR8kWWyqOQjYQ&input="+ urllib.quote_plus(adresseToCheck)
                try:
                    print("On doit checker " + url)
                    response = requests.get(url)
                    #{u'status': u'OK', u'candidates': [{u'place_id': u'ChIJL1ZjScxRqEcRxn13lbhc60s'}]}
                    data = response.json()
                    if data["status"]=="OK":
                        if len(data["candidates"])==1:
                            placeId = data["candidates"][0]["place_id"]
                            place.googlePlaceId = placeId
                            place.save()
                            print("On a place Id "+placeId)
                        else:
                            logger.info("Place %s name %s data %s" %(place.id,place.name,data))

                    time.sleep(1)
                except Exception as e:
                    print(e)