Skip to content
Snippets Groups Projects

WIP: Master

Open Juni Leirvik Larsen requested to merge junill/DatabaseTest:master into master
Files
4
+ 24
4
const Dao = require("./dao.js");
module.exports = class PersonDao extends Dao {
module.exports = class PersonDao extends Dao {
getAll(callback) {
super.query("select navn, alder, adresse from person", [], callback);
super.query("SELECT navn, alder, adresse FROM person", [], callback);
}
getOne(id, callback) {
super.query(
"select navn, alder, adresse from person where id=?",
"SELECT navn, alder, adresse FROM person WHERE id=?",
[id],
callback
);
@@ -16,9 +16,29 @@ module.exports = class PersonDao extends Dao {
createOne(json, callback) {
var val = [json.navn, json.adresse, json.alder];
super.query(
"insert into person (navn,adresse,alder) values (?,?,?)",
"INSERT INTO person (navn,adresse,alder) VALUES (?,?,?)",
val,
callback
);
}
editOne(id, json, callback){
var val = [json.navn, json.adresse, json.alder, id];
super.query(
"UPDATE person SET navn = ?, adresse = ?, alder = ? WHERE id = ?",
val,
callback
);
}
deleteOne(id, callback){
super.query(
"DELETE FROM person WHERE id = ?",
[id],
callback
);
}
};
Loading