import mysql.connector

cnx = mysql.connector.connect(user='rt_bot', password='mp.work.',
                                  host='tripnomicsdb.cloudapp.net',
                                  database='meta')

cnx.autocommit = True
cursor = cnx.cursor()

cursor.execute("SELECT * FROM Masters.Airports")

rows = cursor.fetchall()
airportCity = dict()
for row in rows:
    airportCity[str(row[0])] = str(row[2])

cursor.execute("SELECT DISTINCT(Destination) FROM meta.segmentDetails")

rows = cursor.fetchall()

for row in rows:
    try:
        airport = str(row[0])
        citycode = airportCity[airport]
        if airport != citycode:
            print "UPDATE meta.segmentDetails SET Destination='"+citycode+"' WHERE Destination='"+airport+"';"
    except:
        pass

cursor.close()
cnx.close()