X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=routes%2Fall.js;h=b9665327dab08dd76a24bfbcb5d0e38cfa586484;hb=b5fb8e693dc82037eec2617a7dc49d838a9a8441;hp=ca09be5325002353af5ea244e9594e3742840e7f;hpb=982d5b66524487243b5fc8eb02f3115e4f957085;p=vchess.git

diff --git a/routes/all.js b/routes/all.js
index ca09be53..b9665327 100644
--- a/routes/all.js
+++ b/routes/all.js
@@ -1,28 +1,84 @@
-var express = require('express');
-var router = express.Router();
-
-const Variants = require("../variants");
+let express = require('express');
+let router = express.Router();
+const createError = require('http-errors');
+const sqlite3 = require('sqlite3');//.verbose();
+const db = new sqlite3.Database('db/vchess.sqlite');
+const sanitizeHtml = require('sanitize-html');
 
 // Home
 router.get('/', function(req, res, next) {
-  res.render('index', {
-		title: 'club',
-		variantArray: Variants, //JSON.stringify(Variants)
+	db.serialize(function() {
+		db.all("SELECT * FROM Variants", (err,variants) => {
+			if (!!err)
+				return next(err);
+			res.render('index', {
+				title: 'club',
+				variantArray: variants, //JSON.stringify(variants)
+			});
+		});
 	});
 });
 
 // Variant
-router.get("/:vname([a-zA-Z0-9]+)", (req,res) => {
+router.get("/:vname([a-zA-Z0-9]+)", (req,res,next) => {
 	const vname = req.params["vname"];
-	res.render('variant', {
-		title: vname + ' Variant',
-		variant: vname,
+	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));
+			// TODO (later...) get only n=100(?) most recent problems
+			db.all("SELECT * FROM Problems WHERE variant='" + vname + "'",
+				(err2,problems) => {
+					if (!!err2)
+						return next(err2);
+					res.render('variant', {
+						title: vname + ' Variant',
+						variant: vname,
+						problemArray: problems,
+					});
+				}
+			);
+		});
 	});
 });
 
 // Load a rules page (AJAX)
 router.get("/rules/:variant([a-zA-Z0-9]+)", (req,res) => {
-  res.render("rules/" + req.params["variant"]);
+	if (!req.xhr)
+		return res.json({errmsg: "Unauthorized access"});
+	res.render("rules/" + req.params["variant"]);
+});
+
+// Fetch 10 previous or next problems (AJAX)
+router.get("/problems/:variant([a-zA-Z0-9]+)", (req,res) => {
+	if (!req.xhr)
+		return res.json({errmsg: "Unauthorized access"});
+	// TODO: next or previous: in params + timedate (of current oldest or newest)
+	db.serialize(function() {
+		//TODO
+	});
+});
+
+// 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"]);
+	const solution = sanitizeHtml(req.body["solution"]);
+	db.serialize(function() {
+		let stmt = db.prepare("INSERT INTO Problems VALUES (?,?,?,?,?)");
+		stmt.run(timestamp, vname, fen, instructions, solution);
+		stmt.finalize();
+	});
+  res.json({});
 });
 
 module.exports = router;