X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fmodels%2FChallenge.js;h=f82f9e817938c4bf51f80a2150a6564d53a8e499;hp=3f713203f1adeaacbd59ae4af7dfb0434e02b5db;hb=8c564f462f5406fcd311d4733f851daf6ada665d;hpb=b1aa927be964db4fa6a3eb7cf6c04640951d7dbb diff --git a/server/models/Challenge.js b/server/models/Challenge.js index 3f713203..f82f9e81 100644 --- a/server/models/Challenge.js +++ b/server/models/Challenge.js @@ -15,28 +15,27 @@ 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 " + "(" + Date.now() + "," + c.uid + "," + (!!c.to ? c.to + "," : "") + c.vid + ",'" + c.fen + "','" + c.timeControl + "')"; - db.run(query, err => { - return cb(err); + db.run(query, function(err) { + return cb(err, {cid: this.lastID}); }); }); }, @@ -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,34 @@ 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) + { + db.serialize(function() { + const query = + "DELETE FROM Challenges " + + "WHERE id = " + id; + db.run(query); + }); + }, + + safeRemove: function(id, uid, cb) { db.serialize(function() { - let query = + const 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"}); - query = - "DELETE FROM Challenges " + - "WHERE id = " + id; - db.run(query); + db.get(query, (err,chall) => { + if (!chall) + return cb({errmsg: "Not your challenge"}); + ChallengeModel.remove(id); + cb(null); }); }); },