Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 | 2x 2x | const sql = require("./db.js");
class Airport {
constructor(airport) {
this.ID = airport.ID;
this.Name = airport.Name;
this.ICAO_Code = airport.ICAO_Code;
this.IATA_Code = airport.IATA_Code;
this.City = airport.City;
this.Country = airport.Country;
this.Elevation = airport.Elevation;
this.Coordinates = airport.Coordinates;
}
static get(result) {
var query = `SELECT * FROM Airports`;
sql.query(query, (err, res) => {
if (err) {
console.log("error: ", err);
result(err, null);
return;
}
else {
console.log("airport count", res.length);
const apiResponse = {
ops: "getAllAirports",
status: "success",
message: "Airport list",
payload: res ,
affectedRows: res.length
};
result(null, apiResponse);
return;
}
});
}
static getByID(airportID, result) {
var query = `SELECT * FROM Airports where ID = '${airportID}'`;
sql.query(query, (err, res) => {
if (err) {
console.log("error: ", err);
result(err, null);
return;
}
else {
console.log("airport count", res.length);
const apiResponse = {
ops: "getAirportByID",
status: "success",
message: "Airport",
payload: res[0] ,
affectedRows: res.length
};
result(null, apiResponse);
return;
}
});
}
static search(term, result) {
console.log(term);
var query = `SELECT * FROM Airports WHERE ICAO_CODE LIKE '%${term}%' or IATA_CODE LIKE '%${term}%' or Name LIKE '%${term}%' or City LIKE '%${term}%'`;
sql.query(query, (err, res) => {
if (err) {
console.log("error: ", err);
result(err, null);
return;
}
else {
console.log("found airport count", res.length);
const apiResponse = {
ops: "search",
status: "success",
message: "Airport search",
payload: res ,
affectedRows: res.length
};
result(null, apiResponse);
return;
}
});
}
}
module.exports = Airport; |