- getByUser: function(uid, excluded, cb)
- {
- db.serialize(function() {
- // Next query is fine because a player appear at most once in a game
- const query =
- "SELECT gid " +
- "FROM Players " +
- "WHERE uid " + (excluded ? "<>" : "=") + " " + uid;
- db.all(query, (err,gameIds) => {
- if (!!err)
- return cb(err);
- gameIds = gameIds || []; //might be empty
- let gameArray = [];
- for (let i=0; i<gameIds.length; i++)
- {
- GameModel.getOne(gameIds[i]["gid"], (err2,game) => {
- if (!!err2)
- return cb(err2);
- gameArray.push(game);
- // Call callback function only when gameArray is complete:
- if (i == gameIds.length - 1)
- return cb(null, gameArray);
- });
- }
- });
- });
- },
+ // These games could be deleted on some side. movesCount not required
+ getCompleted: function(uid, cursor, cb) {
+ db.serialize(function() {
+ let query =
+ "SELECT g.id, g.cadence, g.created, g.score, g.scoreMsg, " +
+ "g.white, g.black, g.deletedByWhite, g.deletedByBlack, " +
+ "v.name AS vname " +
+ "FROM Games g " +
+ "JOIN Variants v " +
+ " ON g.vid = v.id " +
+ "WHERE " +
+ " created < " + cursor + " AND " +
+ " (" +
+ " (" + uid + " = white AND NOT deletedByWhite) OR " +
+ " (" + uid + " = black AND NOT deletedByBlack)" +
+ " ) ";
+ query +=
+ "ORDER BY created DESC " +
+ "LIMIT 20";
+ db.all(query, (err, games) => {
+ // Query player names
+ let pids = {};
+ games.forEach(g => {
+ if (!pids[g.white]) pids[g.white] = true;
+ if (!pids[g.black]) pids[g.black] = true;
+ });
+ UserModel.getByIds(pids, (err2, users) => {
+ let names = {};
+ users.forEach(u => { names[u.id] = u.name; });
+ cb(
+ games.map(
+ g => {
+ return {
+ id: g.id,
+ cadence: g.cadence,
+ vname: g.vname,
+ created: g.created,
+ score: g.score,
+ scoreMsg: g.scoreMsg,
+ white: names[g.white],
+ black: names[g.black],
+ deletedByWhite: g.deletedByWhite,
+ deletedByBlack: g.deletedByBlack
+ };
+ }
+ )
+ );
+ });
+ });
+ });
+ },