[vchess.git] / routes / index.js

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"));

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),
			});
		});
	});
});

module.exports = router;
Commit	Line	Data
298c42e6 BA	1	let router = require("express").Router();
	2	const sqlite3 = require('sqlite3');//.verbose();
	3	const DbPath = __dirname.replace("/routes", "/db/vchess.sqlite");
	4	const db = new sqlite3.Database(DbPath);
	5	const selectLanguage = require(__dirname.replace("/routes", "/utils/language.js"));
	6
	7	router.get('/', function(req, res, next) {
	8	db.serialize(function() {
	9	db.all("SELECT * FROM Variants", (err,variants) => {
	10	if (!!err)
	11	return next(err);
	12	res.render('index', {
	13	title: 'club',
	14	variantArray: variants,
	15	lang: selectLanguage(req, res),
	16	});
	17	});
	18	});
	19	});
	20
	21	module.exports = router;