X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FVariant.js;h=d01d2a27c8c9820653c7595f31c9ab6ec39b7f51;hb=9f9e9a0588d4b28a1825a56ae53553d89bf0c65f;hp=ae417932c31d0dfe9f10de5af57cb4bf0ebfed8f;hpb=98db2082fd31e7a7bc0348e31ce119f39dbc31b3;p=vchess.git diff --git a/server/models/Variant.js b/server/models/Variant.js index ae417932..d01d2a27 100644 --- a/server/models/Variant.js +++ b/server/models/Variant.js @@ -1,4 +1,4 @@ -var db = require("../utils/database"); +const db = require("../utils/database"); /* * Structure: @@ -7,53 +7,19 @@ var db = require("../utils/database"); * description: varchar */ -const VariantModel = -{ - // This is duplicated in client. TODO: really required here? - NbPlayers: - { - "Alice": [2,3,4], - "Antiking": [2,3,4], - "Atomic": [2,3,4], - "Baroque": [2,3,4], - "Berolina": [2,4], - "Checkered": [2,3,4], - "Chess960": [2,3,4], - "Crazyhouse": [2,3,4], - "Dark": [2,3,4], - "Extinction": [2,3,4], - "Grand": [2], - "Losers": [2,3,4], - "Magnetic": [2], - "Marseille": [2], - "Switching": [2,3,4], - "Upsidedown": [2], - "Wildebeest": [2], - "Zen": [2,3,4], - }, +const VariantModel = { - getByName: function(name, callback) - { - db.serialize(function() { - const query = - "SELECT * " + - "FROM Variants " + - "WHERE name='" + name + "'"; - db.get(query, callback); - }); - }, + 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;