X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=models%2FVariant.js;h=233d938bfc4b2892ba9242d2b0701d32d831b087;hb=b955c65b942d09d24b5c3bed0d755d4f2f8f71f1;hp=9a19f18cc7f495b4fca89751c4d1d0045a8f1dab;hpb=8d7e2786f5a67a1b9a77c742d7951e0efbe8747d;p=vchess.git diff --git a/models/Variant.js b/models/Variant.js index 9a19f18c..233d938b 100644 --- a/models/Variant.js +++ b/models/Variant.js @@ -2,26 +2,35 @@ var db = require("../utils/database"); /* * Structure: - * _id: integer + * id: integer * name: varchar * description: varchar */ -exports.getByName = function(name, callback) +const VariantModel = { - db.serialize(function() { - db.get( - "SELECT * FROM Variants " + - "WHERE name='" + name + "'", - callback); - }); -} + getByName: function(name, callback) + { + db.serialize(function() { + const query = + "SELECT * " + + "FROM Variants " + + "WHERE name='" + name + "'"; + db.get(query, callback); + }); + }, -exports.getAll = function(callback) -{ - db.serialize(function() { - db.all("SELECT * FROM Variants", callback); - }); + getAll: function(callback) + { + db.serialize(function() { + const query = + "SELECT * " + + "FROM Variants"; + db.all(query, callback); + }); + }, + + //create, update, delete: directly in DB } -//create, update, delete: directly in DB +module.exports = VariantModel;