X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FUser.js;h=7a0f70a78ca30cdd00af2d6eb4654d703532d704;hb=5d04793e1bce0d448b4ffc532f1e8eb47a72e972;hp=cf4c5293178a72707cbaa7f15e5bdd4b624e38d7;hpb=98db2082fd31e7a7bc0348e31ce119f39dbc31b3;p=vchess.git diff --git a/server/models/User.js b/server/models/User.js index cf4c5293..7a0f70a7 100644 --- a/server/models/User.js +++ b/server/models/User.js @@ -63,6 +63,16 @@ const UserModel = }); }, + getByName: function(names, cb) { + db.serialize(function() { + const query = + "SELECT id " + + "FROM Users " + + "WHERE name IN ('" + names.join("','") + "')"; + db.all(query, cb); + }); + }, + ///////// // MODIFY @@ -114,6 +124,15 @@ const UserModel = db.run(query, cb); }); }, + + ///////////////// + // NOTIFICATIONS + + tryNotify: function(oppId, gid, vname, message) + { + // TODO: send email to oppId (request...) with title + // "vchess.club - vname" and content "message" + } } module.exports = UserModel;