gistfile1.txt

var db = require('../db').db
db.run("CREATE TABLE IF NOT EXISTS dorns (id INTEGER PRIMARY KEY AUTOINCREMENT, dorn TEXT, facultee TEXT, places INTEGER)");

var newJob = function(data){
  db.run("INSERT INTO dorns (dorn, facultee, places) VALUES ('"+ data.company + "', '" + data.job + "', " + data.salary + ")");
}

var allJobs = function(c){
  db.all("SELECT rowid AS id, * FROM dorns", function(err, rows) {
    c(rows);
  });
}

var sortByJob = function(c){
  db.all("SELECT dorn, MAX(places) AS avg FROM dorns GROUP BY facultee", function(err, rows) {
      c(rows);
  });
}

var sortByCompany = function(c){
  db.all("SELECT dorn, MAX(places) AS avg FROM dorns GROUP BY facultee", function(err, rows) {
      c(rows);
  });
}

module.exports.new = newJob;
module.exports.all = allJobs;
module.exports.sortJob = sortByJob;
module.exports.sortCompany = sortByCompany;