1 var db
= require("../utils/database");
4 * Structure table Challenges:
8 * vid: variant id (int)
11 * Structure table WillPlay:
12 * cid: ref challenge id
16 exports
.create = function(uid
, vid
, nbPlayers
, cb
)
20 "INSERT INTO Challenges (added, uid, vid, nbPlayers) " +
21 "VALUES (" + Date
.now() + "," + uid
+ "," + vid
+ "," + nbPlayers
+ ")";
22 db
.run(insertQuery
, err
=> {
25 db
.get("SELECT last_insert_rowid() AS rowid", (err2
,lastId
) => {
27 "INSERT INTO WillPlay VALUES " +
28 "(" + lastId
["rowid"] + "," + uid
+ ")";
36 exports
.getOne = function(id
, cb
)
38 db
.serialize(function() {
41 "FROM Challenges c " +
45 db
.get(query
, (err
,challengeInfo
) => {
49 "SELECT w.uid AS id, u.name " +
53 "WHERE w.cid = " + id
;
54 db
.run(query
, (err2
,players
) => {
59 vname: challengeInfo
.name
,
60 added: challengeInfo
.added
,
61 nbPlayers: challengeInfo
.nbPlayers
,
62 players: players
, //currently in
64 return cb(null, challenge
);
70 exports
.remove = function(id
)
72 db
.parallelize(function() {
74 "DELETE FROM Challenges " +
78 "DELETE FROM WillPlay " +