X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FVariant.js;fp=server%2Fmodels%2FVariant.js;h=233d938bfc4b2892ba9242d2b0701d32d831b087;hb=625022fdcf750f0aff8fcd699f7e9b89730e1d10;hp=0000000000000000000000000000000000000000;hpb=b955c65b942d09d24b5c3bed0d755d4f2f8f71f1;p=vchess.git

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