def insert_coordinates_to_our_db(osoite, postinumero, postitoimipaikka, latitude, longitude, api_result_confidence): command = ("INSERT INTO [ANTERO].[sa].[sa_koordinaatit] (osoite, postinumero, postitoimipaikka, latitude, longitude, confidence) VALUES ('" + osoite + "', '" + postinumero + "', '" + postitoimipaikka + "', '" + str(latitude) + "', '" + str(longitude) + "', '" + \ str(api_result_confidence) + "')").encode('utf-8', 'ignore') dbcommand.load(command, "", False)
def check_if_coordinates_in_our_db(osoite, postinumero, postitoimipaikka): command = ("SELECT * FROM [ANTERO].[sa].[sa_koordinaatit] WHERE osoite='" + osoite + "' AND postinumero='" + postinumero + "' AND postitoimipaikka='" + postitoimipaikka + "'") \ .encode('utf-8', 'ignore') # unknown characters will be lost (ignored) result = dbcommand.load(command, "*", False) if len(result) > 0: # the coordinates are found latitude = result[0]["latitude"] longitude = result[0]["longitude"] confidence = result[0]["confidence"] else: return { "coordinates_found": False, "latitude": None, "longitude": None, "confidence": None } return { "coordinates_found": True, "latitude": latitude, "longitude": longitude, "confidence": confidence }
def check_if_coordinates_in_our_db(osoite, postinumero, postitoimipaikka): command = ("SELECT * FROM [ANTERO].[sa].[sa_koordinaatit] WHERE osoite='" + osoite + "' AND postinumero='" + postinumero + "' AND postitoimipaikka='" + postitoimipaikka + "'") \ .encode('utf-8', 'ignore') # unknown characters will be lost (ignored) result = dbcommand.load(command, "*", False) if len(result) > 0: # the coordinates are found latitude = result[0]["latitude"] longitude = result[0]["longitude"] confidence = result[0]["confidence"] else: return {"coordinates_found": False, "latitude": None, "longitude": None, "confidence": None} return {"coordinates_found": True, "latitude": latitude, "longitude": longitude, "confidence": confidence}