- getSeatCount: function(id, cb)
- {
- db.serialize(function() {
- let query =
- "SELECT COUNT(*) AS scount " +
- "FROM WillPlay " +
- "WHERE cid = " + id;
- db.get(query, (err,scRow) => {
- if (!!err)
- return cb(err);
- query =
- "SELECT nbPlayers " +
- "FROM Challenges " +
- "WHERE id = " + id;
- db.get(query, (err2,chRow) => {
- if (!!err2)
- return cb(err2);
- cb(chRow["nbPlayers"] - scRow["scount"]);
- });
- });
- });
- },
-
- setSeat: function(id, uid)
- {
- // TODO: remove extra "db.serialize" (parallelize by default)
- //db.serialize(function() {
- const query =
- "INSERT OR REPLACE INTO WillPlay " +
- "VALUES (true," + id + "," + uid +")";
- db.run(query);
- //});
- },
-