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 | 2x 2x | const sql = require("./db.js");
class FlightCrew {
constructor(flightCrew) {
this.FullName = flightCrew.FullName;
this.PilotID = flightCrew.PilotID;
}
static create(newFlightCrew, result) {
sql.query("INSERT INTO FlightCrews SET ?", newFlightCrew, (err, res) => {
if (err) {
console.log("error: ", err);
result(err, null);
return;
}
console.log("crated flightCrew: ", { ID: res.insertId, ...newFlightCrew });
const apiResponse = {
ops: "FlightCrewAdd",
status: "success",
message: "Flight Crew created with name " + newFlightCrew.FullName,
payload: { ID: res.insertId, ...newFlightCrew },
affectedRows: 1
};
result(null, apiResponse);
});
}
static getByPilotID(pilotID, result) {
console.log(pilotID);
var query = `SELECT * FROM FlightCrews WHERE PilotID = '${pilotID}'`;
sql.query(query, (err, res) => {
if (err) {
console.log("error: ", err);
result(err, null);
return;
}
else {
console.log("found flight crew count", res.length);
const apiResponse = {
ops: "FlightCrewGetByPilotID",
status: "success",
message: "Flight Crew search, pilot ID: " + pilotID,
payload: res,
affectedRows: res.length
};
result(null, apiResponse);
return;
}
});
}
static sync(pilotID, version, result) {
var query = `SELECT * FROM FlightCrews
WHERE PilotID = ? and Version > ?`;
sql.query(query, [pilotID, version], (err, res) => {
if (err) {
console.log("error: ", err);
result(err, null);
return;
}
const apiResponse = {
ops: "sync",
status: "success",
message: "Sync Flight Crews",
payload: res,
affectedRows: res.length
};
// console.log("apiResponse:", apiResponse);
result(null, apiResponse);
});
}
}
module.exports = FlightCrew; |