X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=routes%2Findex.js;h=0ed5b07ac573be6d89c51cd19a7acd37ab04d682;hp=ab44cf5e769eba633f2c7ebd282aac40b8a92a4a;hb=8d7e2786f5a67a1b9a77c742d7951e0efbe8747d;hpb=7192f4711467ae73a0f813189f8a4d8cca252bf1

diff --git a/routes/index.js b/routes/index.js
index ab44cf5e..0ed5b07a 100644
--- a/routes/index.js
+++ b/routes/index.js
@@ -1,19 +1,15 @@
 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),
 		});
 	});
 });