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 | 2x 2x | const sql = require("./db.js");
class AircraftType {
constructor(aircraftType) {
this.ID = aircraftType.ID;
this.ICAO_Code = aircraftType.ICAO_Code;
this.IATA_Code = aircraftType.IATA_Code;
this.Description = aircraftType.Description;
}
static get(result) {
var query = `SELECT * FROM AircraftTypes order by Description asc`;
sql.query(query, (err, res) => {
if (err) {
console.log("error: ", err);
result(err, null);
return;
}
else {
console.log("found aircraft types count", res.length);
const apiResponse = {
ops: "getAircraftTypes",
status: "success",
message: "get aircraft type list",
payload: res,
affectedRows: res.length
};
result(null, apiResponse);
return;
}
});
}
static getByManufacturer(manufacturer, result) {
var query = `SELECT * FROM AircraftTypes where Description LIKE '%${manufacturer}%'`;
sql.query(query, (err, res) => {
if (err) {
console.log("error: ", err);
result(err, null);
return;
}
else {
console.log("found aircraft types for manufacturer " + manufacturer + " count", res.length);
const apiResponse = {
ops: "getByManufacturer",
status: "success",
message: "get aircraft type list for manufacturer " + manufacturer,
payload: res,
affectedRows: res.length
};
result(null, apiResponse);
return;
}
});
}
static sync(version, result) {
var query = `SELECT * FROM AircraftTypes
where Version > ? `;
sql.query(query, [version], (err, res) => {
if (err) {
console.log("error: ", err);
result(err, null);
return;
}
const apiResponse = {
ops: "sync",
status: "success",
message: "Sync Aircraft Types",
payload: res,
affectedRows: res.length
};
result(null, apiResponse);
});
}
}
module.exports = AircraftType; |