Save current state (unmerged, broken, not working...)

[vchess.git] / routes / index.js

diff --git a/routes/index.js b/routes/index.js
index ab44cf5..0ed5b07 100644 (file)
--- 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),
                });
        });
 });