X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FChallenge.js;fp=server%2Fmodels%2FChallenge.js;h=82b252fd281bf6b59cb3b8aa19bcb4606dc0719e;hb=bebcc8d45532e67902175f69084a08040f06855f;hp=3f713203f1adeaacbd59ae4af7dfb0434e02b5db;hpb=6e3a7e26d57f60480b08abed7441963674a79b18;p=vchess.git diff --git a/server/models/Challenge.js b/server/models/Challenge.js index 3f713203..82b252fd 100644 --- a/server/models/Challenge.js +++ b/server/models/Challenge.js @@ -15,21 +15,20 @@ const ChallengeModel = { checkChallenge: function(c) { - if (!c.vid.match(/^[0-9]+$/)) + if (!c.vid.toString().match(/^[0-9]+$/)) return "Wrong variant ID"; - if (!c.timeControl.match(/^[0-9dhms +]+$/)) return "Wrong characters in time control"; - - if (!c.fen.match(/^[a-zA-Z0-9, /-]+$/)) + if (!c.fen.match(/^[a-zA-Z0-9, /-]*$/)) return "Bad FEN string"; + return ""; }, // fen cannot be undefined create: function(c, cb) { db.serialize(function() { - let query = + const query = "INSERT INTO Challenges " + "(added, uid, " + (!!c.to ? "target, " : "") + "vid, fen, timeControl) VALUES " + @@ -44,7 +43,7 @@ const ChallengeModel = getOne: function(id, cb) { db.serialize(function() { - let query = + const query = "SELECT * " + "FROM Challenges " + "WHERE id = " + id; @@ -62,26 +61,27 @@ const ChallengeModel = "SELECT * " + "FROM Challenges " + "WHERE target IS NULL OR target = " + uid; - db.run(query, (err,challenges) => { + db.all(query, (err,challenges) => { return cb(err, challenges); }); }); }, - remove: function(id, uid) + remove: function(id, uid, cb) { db.serialize(function() { let query = "SELECT 1 " + "FROM Challenges " + "WHERE id = " + id + " AND uid = " + uid; - db.run(query, (err,rows) => { - if (rows.length == 0) - return res.json({errmsg: "Not your challenge"}); + db.get(query, (err,chall) => { + if (!chall) + return cb({errmsg: "Not your challenge"}); query = "DELETE FROM Challenges " + "WHERE id = " + id; db.run(query); + cb(null); }); }); },