X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=models%2FVariant.js;fp=models%2FVariant.js;h=9a19f18cc7f495b4fca89751c4d1d0045a8f1dab;hb=8d7e2786f5a67a1b9a77c742d7951e0efbe8747d;hp=0000000000000000000000000000000000000000;hpb=7192f4711467ae73a0f813189f8a4d8cca252bf1;p=vchess.git

diff --git a/models/Variant.js b/models/Variant.js
new file mode 100644
index 00000000..9a19f18c
--- /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