- const query =
- "SELECT DISTINCT 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);
+ let query =
+ "SELECT id, vid, cadence, created, score, white, black " +
+ "FROM Games ";
+ if (uid > 0) query +=
+ "WHERE " +
+ " created < " + cursor + " AND " +
+ " white <> " + uid + " AND " +
+ " black <> " + uid + " ";
+ query +=
+ "ORDER BY created DESC " +
+ "LIMIT 20"; //TODO: 20 hard-coded...
+ db.all(query, (err, games) => {
+ // Query players names
+ let pids = {};
+ games.forEach(g => {
+ if (!pids[g.white]) pids[g.white] = true;
+ if (!pids[g.black]) pids[g.black] = true;
+ });
+ UserModel.getByIds(Object.keys(pids), (err2, users) => {
+ let names = {};
+ users.forEach(u => { names[u.id] = u.name; });
+ cb(
+ err,
+ games.map(
+ g => {
+ return {
+ id: g.id,
+ vid: g.vid,
+ cadence: g.cadence,
+ created: g.created,
+ score: g.score,
+ players: [
+ { id: g.white, name: names[g.white] },
+ { id: g.black, name: names[g.black] }
+ ]
+ };
+ }
+ )
+ );
+ });
+ });
+ });
+ },
+
+ // For display on MyGames: registered user only
+ getRunning: function(uid, cb) {
+ db.serialize(function() {
+ let query =
+ "SELECT g.id, g.cadence, g.created, " +
+ "g.white, g.black, v.name AS vname " +
+ "FROM Games g " +
+ "JOIN Variants v " +
+ " ON g.vid = v.id " +
+ "WHERE score = '*' AND (white = " + uid + " OR black = " + uid + ")";
+ db.all(query, (err, games) => {
+ // Get movesCount (could be done in // with next query)
+ query =
+ "SELECT gid, COUNT(*) AS nbMoves " +
+ "FROM Moves " +
+ "WHERE gid IN " + "(" + games.map(g => g.id).join(",") + ") " +
+ "GROUP BY gid";
+ db.all(query, (err, mstats) => {
+ let movesCounts = {};
+ mstats.forEach(ms => { movesCounts[ms.gid] = ms.nbMoves; });
+ // Query player names
+ let pids = {};
+ games.forEach(g => {
+ if (!pids[g.white]) pids[g.white] = true;
+ if (!pids[g.black]) pids[g.black] = true;