X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FVariant.js;h=85abf5aeb831d9b417b21a0d7b1feebbebdb5a21;hb=0234201fb338fc239d6f613c677fa932c7c3697c;hp=ae417932c31d0dfe9f10de5af57cb4bf0ebfed8f;hpb=98db2082fd31e7a7bc0348e31ce119f39dbc31b3;p=vchess.git diff --git a/server/models/Variant.js b/server/models/Variant.js index ae417932..85abf5ae 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,17 @@ 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 = { + getAll: function(callback) { + db.serialize(function() { + const query = + "SELECT * " + + "FROM Variants"; + db.all(query, callback); + }); + }, - 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); - }); - }, - - //create, update, delete: directly in DB + //create, update, delete: directly in DB } module.exports = VariantModel;