projects
/
vchess.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Remove unused move.color, format moves corr --> live after retrieval
[vchess.git]
/
server
/
models
/
Game.js
diff --git
a/server/models/Game.js
b/server/models/Game.js
index
ced5611
..
786f1e7
100644
(file)
--- a/
server/models/Game.js
+++ b/
server/models/Game.js
@@
-20,7
+20,6
@@
var db = require("../utils/database");
* message: text
* played: datetime
* idx: integer
* message: text
* played: datetime
* idx: integer
- * color: character
*/
const GameModel =
*/
const GameModel =
@@
-71,7
+70,7
@@
const GameModel =
if (!!err2)
return cb(err2);
query =
if (!!err2)
return cb(err2);
query =
- "SELECT squares, message, played, idx
, color
" +
+ "SELECT squares, message, played, idx " +
"FROM Moves " +
"WHERE gid = " + id;
db.all(query, (err3,moves) => {
"FROM Moves " +
"WHERE gid = " + id;
db.all(query, (err3,moves) => {
@@
-132,31
+131,24
@@
const GameModel =
// obj can have fields move, fen and/or score
update: function(id, obj)
{
// obj can have fields move, fen and/or score
update: function(id, obj)
{
-
-
-
-console.log(id);
- console.log(obj);
-
-
db.parallelize(function() {
let query =
"UPDATE Games " +
"SET ";
if (!!obj.fen)
db.parallelize(function() {
let query =
"UPDATE Games " +
"SET ";
if (!!obj.fen)
- query += "fen =
" + obj.fen + "
,";
+ query += "fen =
'" + obj.fen + "'
,";
if (!!obj.score)
if (!!obj.score)
- query += "score =
" + obj.score + "
,";
+ query += "score =
'" + obj.score + "'
,";
query = query.slice(0,-1); //remove last comma
query = query.slice(0,-1); //remove last comma
- query += " WHERE
gameI
d = " + id;
+ query += " WHERE
i
d = " + id;
db.run(query);
if (!!obj.move)
{
db.run(query);
if (!!obj.move)
{
- const m
=
obj.move;
+ const m
=
obj.move;
query =
query =
- "INSERT INTO Moves (gid,
squares,message,played,idx,color
) VALUES " +
+ "INSERT INTO Moves (gid,
squares, message, played, idx
) VALUES " +
"(" + id + ",'" + JSON.stringify(m.squares) + "','" + m.message +
"(" + id + ",'" + JSON.stringify(m.squares) + "','" + m.message +
- "'
" + m.played + "," + m.idx + ",'" + m.color + "'
)";
+ "'
," + m.played + "," + m.idx + "
)";
db.run(query);
}
});
db.run(query);
}
});