Some adjustments, next: fix time control handling + finish corr play

[vchess.git] / server / models / User.js

diff --git a/server/models/User.js b/server/models/User.js
index a36ab68..7a0f70a 100644 (file)
--- a/server/models/User.js
+++ b/server/models/User.js
@@ -16,6 +16,24 @@ var params = require("../config/parameters");
 
 const UserModel =
 {
+       checkNameEmail: function(o)
+       {
+               if (typeof o.name === "string")
+               {
+                       if (o.name.length == 0)
+                               return "Empty name";
+                       if (!o.name.match(/^[\w]+$/))
+                               return "Bad characters in name";
+               }
+               if (typeof o.email === "string")
+               {
+                       if (o.email.length == 0)
+                               return "Empty email";
+                       if (!o.email.match(/^[\w.+-]+@[\w.+-]+$/))
+                               return "Bad characters in email";
+               }
+       },
+
        // NOTE: parameters are already cleaned (in controller), thus no sanitization here
        create: function(name, email, notify, callback)
        {
@@ -45,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
 
@@ -96,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;