Step toward a one-page application

[vchess.git] / models / Variant.js

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