Draft Game and Challenge models

[vchess.git] / models / Variant.js

diff --git a/models/Variant.js b/models/Variant.js
index 9a19f18..8d7eba2 100644 (file)
--- a/models/Variant.js
+++ b/models/Variant.js
@@ -2,7 +2,7 @@ var db = require("../utils/database");
 
 /*
  * Structure:
- *   _id: integer
+ *   id: integer
  *   name: varchar
  *   description: varchar
  */
@@ -10,17 +10,21 @@ var db = require("../utils/database");
 exports.getByName = function(name, callback)
 {
        db.serialize(function() {
-               db.get(
-                       "SELECT * FROM Variants " +
-                       "WHERE name='" + name + "'",
-                       callback);
+               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);
+               const query =
+                       "SELECT * " +
+                       "FROM Variants";
+               db.all(query, callback);
        });
 }