import_airport_codes.js

// Imported from http://www.nationsonline.org/oneworld/IATA_Codes/airport_code_list.htm
// Use the "jQuerify" extension for Google Chrome and run the following script on the JavaScript Console
var airports = [];
$.each($('tr[bgcolor=#EEEEEE]'), function(idx, el) {
    airports.push('INSERT INTO `ean_airports` (`city`, `country`) VALUES ("'+$('td', el)[0].textContent.trim()+' ('+$('td', el)[2].textContent.trim()+')", "'+$('td', el)[1].textContent.trim()+'");');
});
airports.sort();
airports.join('\n');