Index page almost OK. Now work on variant page (main hall...)

[vchess.git] / routes / all.js

diff --git a/routes/all.js b/routes/all.js
index 79f7c3d..7c2a6da 100644 (file)
--- a/routes/all.js
+++ b/routes/all.js
@@ -1,138 +1,8 @@
-let express = require('express');
-let router = express.Router();
-const createError = require('http-errors');
-const sqlite3 = require('sqlite3');//.verbose();
-const DbPath = __dirname.replace("/routes", "/db/vchess.sqlite");
-const db = new sqlite3.Database(DbPath);
-const sanitizeHtml = require('sanitize-html');
-const MaxNbProblems = 20;
+var router = require("express").Router();
 
-const supportedLang = ["en","es","fr"];
-function selectLanguage(req, res)
-{
-       // If preferred language already set:
-       if (!!req.cookies["lang"])
-               return req.cookies["lang"];
-
-       // Else: search and set it
-       const langString = req.headers["accept-language"];
-       let langArray = langString
-               .replace(/;q=[0-9.]+/g, "") //priority
-               .replace(/-[A-Z]+/g, "") //region (skipped for now...)
-               .split(",") //may have some duplicates, but removal is too costly
-       let bestLang = "en"; //default: English
-       for (let lang of langArray)
-       {
-               if (supportedLang.includes(lang))
-               {
-                       bestLang = lang;
-                       break;
-               }
-       }
-       // Cookie expires in 183 days (expressed in milliseconds)
-       res.cookie('lang', bestLang, { maxAge: 183*24*3600*1000 });
-       return bestLang;
-}
-
-// Home
-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),
-                               languages: supportedLang,
-                       });
-               });
-       });
-});
-
-// Variant
-router.get("/:variant([a-zA-Z0-9]+)", (req,res,next) => {
-       const vname = req.params["variant"];
-       db.serialize(function() {
-               db.all("SELECT * FROM Variants WHERE name='" + vname + "'", (err,variant) => {
-                       if (!!err)
-                               return next(err);
-                       if (!variant || variant.length==0)
-                               return next(createError(404));
-                       // Get only N most recent problems
-                       const query2 = "SELECT * FROM Problems " +
-                               "WHERE variant='" + vname + "' " +
-                               "ORDER BY added DESC " +
-                               "LIMIT " + MaxNbProblems;
-                       db.all(query2, (err2,problems) => {
-                               if (!!err2)
-                                       return next(err2);
-                               res.render('variant', {
-                                       title: vname + ' Variant',
-                                       variant: vname,
-                                       problemArray: problems,
-                                       lang: selectLanguage(req, res),
-                                       languages: supportedLang,
-                               });
-                       });
-               });
-       });
-});
-
-// Load a rules page (AJAX)
-router.get("/rules/:variant([a-zA-Z0-9]+)", (req,res) => {
-       if (!req.xhr)
-               return res.json({errmsg: "Unauthorized access"});
-       const lang = selectLanguage(req, res);
-       res.render("rules/" + req.params["variant"] + "/" + lang);
-});
-
-// Fetch N previous or next problems (AJAX)
-router.get("/problems/:variant([a-zA-Z0-9]+)", (req,res) => {
-       if (!req.xhr)
-               return res.json({errmsg: "Unauthorized access"});
-       const vname = req.params["variant"];
-       const directionStr = (req.query.direction == "forward" ? ">" : "<");
-       const lastDt = req.query.last_dt;
-       if (!lastDt.match(/[0-9]+/))
-               return res.json({errmsg: "Bad timestamp"});
-       db.serialize(function() {
-               const query = "SELECT * FROM Problems " +
-                       "WHERE variant='" + vname + "' " +
-                       "  AND added " + directionStr + " " + lastDt + " " +
-                       "ORDER BY added " + (directionStr=="<" ? "DESC " : "") +
-                       "LIMIT " + MaxNbProblems;
-               db.all(query, (err,problems) => {
-                       if (!!err)
-                               return res.json(err);
-                       return res.json({problems: problems});
-               });
-       });
-});
-
-// Upload a problem (AJAX)
-router.post("/problems/:variant([a-zA-Z0-9]+)", (req,res) => {
-       if (!req.xhr)
-               return res.json({errmsg: "Unauthorized access"});
-       const vname = req.params["variant"];
-       const timestamp = Date.now();
-       // Sanitize them
-       const fen = req.body["fen"];
-       if (!fen.match(/^[a-zA-Z0-9, /-]*$/))
-               return res.json({errmsg: "Bad characters in FEN string"});
-       const instructions = sanitizeHtml(req.body["instructions"]).trim();
-       const solution = sanitizeHtml(req.body["solution"]).trim();
-       if (instructions.length == 0)
-               return res.json({errmsg: "Empty instructions"});
-       if (solution.length == 0)
-               return res.json({errmsg: "Empty solution"});
-       db.serialize(function() {
-               let stmt = db.prepare("INSERT INTO Problems " +
-                       "(added,variant,fen,instructions,solution) VALUES (?,?,?,?,?)");
-               stmt.run(timestamp, vname, fen, instructions, solution);
-               stmt.finalize();
-       });
-  res.json({});
-});
+router.use("/", require("./index"));
+router.use("/", require("./variant"));
+router.use("/", require("./problems"));
+router.use("/", require("./messages"));
 
 module.exports = router;