projects
/
vchess.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
UserBio: a few fixes, but still doesn't work as expected
[vchess.git]
/
server
/
models
/
User.js
diff --git
a/server/models/User.js
b/server/models/User.js
index
edb3c06
..
37df4e6
100644
(file)
--- a/
server/models/User.js
+++ b/
server/models/User.js
@@
-13,7
+13,7
@@
const sendEmail = require('../utils/mailer');
* sessionToken: token in cookies for authentication
* notify: boolean (send email notifications for corr games)
* created: datetime
* sessionToken: token in cookies for authentication
* notify: boolean (send email notifications for corr games)
* created: datetime
- *
newsRead: datetime
+ *
bio: text
*/
const UserModel = {
*/
const UserModel = {
@@
-58,6
+58,16
@@
const UserModel = {
});
},
});
},
+ getBio: function(id, cb) {
+ db.serialize(function() {
+ const query =
+ "SELECT bio " +
+ "FROM Users " +
+ "WHERE id = " + id;
+ db.get(query, cb);
+ });
+ },
+
/////////
// MODIFY
/////////
// MODIFY
@@
-71,13
+81,13
@@
const UserModel = {
});
},
});
},
- set
NewsRead: function(id
) {
+ set
Bio: function(id, bio
) {
db.serialize(function() {
const query =
"UPDATE Users " +
db.serialize(function() {
const query =
"UPDATE Users " +
- "SET
newsRead = " + Date.now() + "
" +
+ "SET
bio = ?
" +
"WHERE id = " + id;
"WHERE id = " + id;
- db.run(query);
+ db.run(query
, bio
);
});
},
});
},