+ getPlayers: function(id, cb)
+ {
+ db.serialize(function() {
+ const query =
+ "SELECT id " +
+ "FROM Players " +
+ "WHERE gid = " + id;
+ db.all(query, (err,players) => {
+ return cb(err, players);
+ });
+ });
+ },
+
+ // obj can have fields move, fen and/or score
+ update: function(id, obj, cb)
+ {
+ db.serialize(function() {
+ let query =
+ "UPDATE Games " +
+ "SET ";
+ if (!!obj.move)
+ {
+ move.played = Date.now();
+ query += "move = " + obj.move + ","; //TODO: already stringified?!
+ }
+ if (!!obj.fen)
+ query += "fen = " + obj.fen + ",";
+ if (!!obj.score)
+ query += "score = " + obj.score + ",";
+ query = query.slice(0,-1); //remove last comma
+ query += " WHERE gameId = " + id;
+ db.run(query, (err) => {
+ cb(err);
+ });
+ });
+ },
+