server/models/Variant.js

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