const Dao = require("./dao.js");
module.exports = class PersonDao extends Dao {
getAll(callback) {
super.query("select navn, alder, adresse from person", [], callback);
}
getOne(id, callback) {
super.query(
"select navn, alder, adresse from person where id=?",
[id],
callback
);
}
createOne(json, callback) {
var val = [json.navn, json.adresse, json.alder];
super.query(
"insert into person (navn,adresse,alder) values (?,?,?)",
val,
callback
);
}
deleteOne(json, callback){
let values = [json.id];
super.query(
"DELETE from person WHERE id=?",
values,
callback
);
}
updateOne(json,callback){
let values= [json.navn,json.alder,json.adresse,json.id];
super.query(
"UPDATE person SET navn=?, alder=?, adresse=? WHERE id=?",
values,
callback
);
}
};
|