Implement cleaning methods (CRON tasks)

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

diff --git a/server/models/User.js b/server/models/User.js
index a36ab68..ee4b056 100644 (file)
--- a/server/models/User.js
+++ b/server/models/User.js
@@ -1,7 +1,7 @@
 var db = require("../utils/database");
-var maild = require("../utils/mailer.js");
 var genToken = require("../utils/tokenGenerator");
 var params = require("../config/parameters");
+var sendEmail = require('../utils/mailer');
 
 /*
  * Structure:
@@ -12,18 +12,37 @@ var params = require("../config/parameters");
  *   loginTime: datetime (validity)
  *   sessionToken: token in cookies for authentication
  *   notify: boolean (send email notifications for corr games)
+ *   created: datetime
  */
 
 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)
        {
                db.serialize(function() {
                        const insertQuery =
                                "INSERT INTO Users " +
-                               "(name, email, notify) VALUES " +
-                               "('" + name + "', '" + email + "', " + notify + ")";
+                               "(name, email, notify, created) VALUES " +
+                               "('" + name + "', '" + email + "', " + notify + "," + Date.now() + ")";
                        db.run(insertQuery, err => {
                                if (!!err)
                                        return callback(err);
@@ -45,6 +64,16 @@ const UserModel =
                });
        },
 
+  getByIds: function(ids, cb) {
+    db.serialize(function() {
+      const query =
+        "SELECT id, name " +
+        "FROM Users " +
+        "WHERE id IN (" + ids + ")";
+      db.all(query, cb);
+    });
+  },
+
        /////////
        // MODIFY
 
@@ -96,6 +125,44 @@ const UserModel =
                        db.run(query, cb);
                });
        },
+
+  /////////////////
+  // NOTIFICATIONS
+
+  tryNotify: function(oppId, message)
+  {
+               UserModel.getOne("id", oppId, (err,opp) => {
+      if (!err || !opp.notify)
+        return; //error is ignored here (TODO: should be logged)
+      const subject = "vchess.club - notification";
+      const body = "Hello " + opp.name + "!\n" + message;
+      sendEmail(params.mail.noreply, opp.email, subject, body, err => {
+        res.json(err || {});
+      });
+    });
+  },
+
+  ////////////
+  // CLEANING
+
+  cleanUsersDb: function()
+  {
+    const tsNow = Date.now();
+    // 86400000 = 24 hours in milliseconds
+    const day = 86400000;
+    db.serialize(function() {
+      const query =
+        "SELECT id, sessionToken, created " +
+        "FROM Users";
+      db.all(query, (err, users) => {
+        users.forEach(u => {
+          // Remove unlogged users for >1 day
+          if (!u.sessionToken && tsNow - u.created > day)
+            db.run("DELETE FROM Users WHERE id = " + u.id);
+        });
+      });
+    });
+  },
 }
 
 module.exports = UserModel;