X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FVariant.js;h=f439e192f2930bc93ead353cdadc2af8fcb19b49;hb=7a0c1b7e33a346195caebfdfa6489e7c6d0457e6;hp=233d938bfc4b2892ba9242d2b0701d32d831b087;hpb=bebcc8d45532e67902175f69084a08040f06855f;p=vchess.git diff --git a/server/models/Variant.js b/server/models/Variant.js index 233d938b..f439e192 100644 --- a/server/models/Variant.js +++ b/server/models/Variant.js @@ -1,36 +1,28 @@ -var db = require("../utils/database"); +const db = require("../utils/database"); /* * Structure: * id: integer * name: varchar + * display: varchar + * groupe: integer * description: varchar + * noProblems: boolean */ -const VariantModel = -{ - getByName: function(name, callback) - { - db.serialize(function() { - const query = - "SELECT * " + - "FROM Variants " + - "WHERE name='" + name + "'"; - db.get(query, callback); - }); - }, +const VariantModel = { - getAll: function(callback) - { - db.serialize(function() { - const query = - "SELECT * " + - "FROM Variants"; - db.all(query, 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;