Finished User management implementation
[vchess.git] / models / Variant.js
index ce5329c..8d7eba2 100644 (file)
@@ -2,7 +2,7 @@ var db = require("../utils/database");
 
 /*
  * Structure:
- *   _id: integer
+ *   id: integer
  *   name: varchar
  *   description: varchar
  */
@@ -11,7 +11,8 @@ exports.getByName = function(name, callback)
 {
        db.serialize(function() {
                const query =
-                       "SELECT * FROM Variants " +
+                       "SELECT * " +
+                       "FROM Variants " +
                        "WHERE name='" + name + "'";
                db.get(query, callback);
        });
@@ -20,7 +21,9 @@ exports.getByName = function(name, callback)
 exports.getAll = function(callback)
 {
        db.serialize(function() {
-               const query = "SELECT * FROM Variants";
+               const query =
+                       "SELECT * " +
+                       "FROM Variants";
                db.all(query, callback);
        });
 }