X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=routes%2Findex.js;h=d510068ea8c3d139e02d6ab9398d00bf43db09e5;hb=582df3497b0f91dd4b645386a059eac9e98da1bb;hp=ab44cf5e769eba633f2c7ebd282aac40b8a92a4a;hpb=298c42e63ae321526693e9ce418c4113af36e025;p=vchess.git

diff --git a/routes/index.js b/routes/index.js
index ab44cf5e..d510068e 100644
--- a/routes/index.js
+++ b/routes/index.js
@@ -1,19 +1,17 @@
+// Main index page
+
 let router = require("express").Router();
-const sqlite3 = require('sqlite3');//.verbose();
-const DbPath = __dirname.replace("/routes", "/db/vchess.sqlite");
-const db = new sqlite3.Database(DbPath);
-const selectLanguage = require(__dirname.replace("/routes", "/utils/language.js"));
+const VariantModel = require("../models/Variant");
+const selectLanguage = require("../utils/language.js");
 
 router.get('/', function(req, res, next) {
-	db.serialize(function() {
-		db.all("SELECT * FROM Variants", (err,variants) => {
-			if (!!err)
-				return next(err);
-			res.render('index', {
-				title: 'club',
-				variantArray: variants,
-				lang: selectLanguage(req, res),
-			});
+	VariantModel.getAll((err,variants) => {
+		if (!!err)
+			return next(err);
+		res.render('index', {
+			title: 'club',
+			variantArray: variants,
+			lang: selectLanguage(req, res),
 		});
 	});
 });