persondao.js

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
    );
  }

  updateOne(json, callback){
      var val= [json.navn,json.alder,json.adresse,json.id];
      super.query(
          "UPDATE person SET navn=?,alder=?,adresse=? WHERE id=? ",
          val,
          callback
      );
  }

  deleteOne(json,callback){
      var val=[json.id];
      super.query(
          "DELETE from person WHERE id=?",
          val,
          callback
      );
  }

};