Refactor models (merge Players in Games), add cursor to correspondance games. Finishe...

[vchess.git] / server / models / Variant.js

diff --git a/server/models/Variant.js b/server/models/Variant.js
index ae41793..85abf5a 100644 (file)
--- 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;