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