+ let query =
+ "SELECT g.id, g.vid, g.cadence, g.created, " +
+ " g.score, g.white, g.black " +
+ "FROM Games g ";
+ 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(
+ games.map(
+ g => {
+ return {
+ id: g.id,
+ cadence: g.cadence,
+ vname: g.vname,
+ created: g.created,
+ score: g.score,
+ white: names[g.white],
+ black: 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.score, " +
+ "g.white, g.black, v.name AS vname " +
+ "FROM Games g " +
+ "JOIN Variants v " +
+ " ON g.vid = v.id " +
+ "WHERE white = " + uid + " OR black = " + uid;
+ db.all(query, (err, games) => {
+ // Get movesCount (could be done in // with next query)