Save current state (unmerged, broken, not working...)

[vchess.git] / models / Variant.js

diff --git a/models/Variant.js b/models/Variant.js
new file mode 100644 (file)
index 0000000..9a19f18
--- /dev/null
+++ b/models/Variant.js
@@ -0,0 +1,27 @@
+var db = require("../utils/database");
+
+/*
+ * Structure:
+ *   _id: integer
+ *   name: varchar
+ *   description: varchar
+ */
+
+exports.getByName = function(name, callback)
+{
+       db.serialize(function() {
+               db.get(
+                       "SELECT * FROM Variants " +
+                       "WHERE name='" + name + "'",
+                       callback);
+       });
+}
+
+exports.getAll = function(callback)
+{
+       db.serialize(function() {
+               db.all("SELECT * FROM Variants", callback);
+       });
+}
+
+//create, update, delete: directly in DB