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

diff --git a/routes/index.js b/routes/index.js
index ab44cf5e..547ae6d1 100644
--- a/routes/index.js
+++ b/routes/index.js
@@ -1,19 +1,16 @@
+// 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', {
+			variantArray: variants,
+			lang: selectLanguage(req, res),
 		});
 	});
 });