models/Variant.js

   1 var db = require("../utils/database");
   2
   3 /*
   4  * Structure:
   5  *   _id: integer
   6  *   name: varchar
   7  *   description: varchar
   8  */
   9
  10 exports.getByName = function(name, callback)
  11 {
  12     db.serialize(function() {
  13         const query =
  14             "SELECT * FROM Variants " +
  15             "WHERE name='" + name + "'";
  16         db.get(query, callback);
  17     });
  18 }
  19
  20 exports.getAll = function(callback)
  21 {
  22     db.serialize(function() {
  23         const query = "SELECT * FROM Variants";
  24         db.all(query, callback);
  25     });
  26 }
  27
  28 //create, update, delete: directly in DB