All files / mylog-api/models manufacturer.model.js

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
2x
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
2x
const sql = require("./db.js");
class Manufacturer {
	constructor(manufacturer) {
		this.ID = manufacturer.ID;
		this.Name = manufacturer.Name;
	}
 
	static get(result) {
		var query = `SELECT * FROM Manufacturers order by Name asc`;
		sql.query(query, (err, res) => {
			if (err) {
				console.log("error: ", err);
				result(err, null);
				return;
			}
			else {
				console.log("found aircraft manufacturers count", res.length);
				const apiResponse = {
					ops: "getManufacturers",
					status: "success",
					message: "get manufacturers list",
					payload: res,
					affectedRows: res.length
				};
				result(null, apiResponse);
				return;
			}
		});
	}
}
 
module.exports = Manufacturer;