server/models/User.js

   1 var db = require("../utils/database");
   2 var maild = require("../utils/mailer.js");
   3 var genToken = require("../utils/tokenGenerator");
   4 var params = require("../config/parameters");
   5
   6 /*
   7  * Structure:
   8  *   _id: integer
   9  *   name: varchar
  10  *   email: varchar
  11  *   loginToken: token on server only
  12  *   loginTime: datetime (validity)
  13  *   sessionToken: token in cookies for authentication
  14  *   notify: boolean (send email notifications for corr games)
  15  */
  16
  17 const UserModel =
  18 {
  19     checkNameEmail: function(o)
  20     {
  21         if (typeof o.name === "string")
  22         {
  23             if (o.name.length == 0)
  24                 return "Empty name";
  25             if (!o.name.match(/^[\w]+$/))
  26                 return "Bad characters in name";
  27         }
  28         if (typeof o.email === "string")
  29         {
  30             if (o.email.length == 0)
  31                 return "Empty email";
  32             if (!o.email.match(/^[\w.+-]+@[\w.+-]+$/))
  33                 return "Bad characters in email";
  34         }
  35     },
  36
  37     // NOTE: parameters are already cleaned (in controller), thus no sanitization here
  38     create: function(name, email, notify, callback)
  39     {
  40         db.serialize(function() {
  41             const insertQuery =
  42                 "INSERT INTO Users " +
  43                 "(name, email, notify) VALUES " +
  44                 "('" + name + "', '" + email + "', " + notify + ")";
  45             db.run(insertQuery, err => {
  46                 if (!!err)
  47                     return callback(err);
  48                 db.get("SELECT last_insert_rowid() AS rowid", callback);
  49             });
  50         });
  51     },
  52
  53     // Find one user (by id, name, email, or token)
  54     getOne: function(by, value, cb)
  55     {
  56         const delimiter = (typeof value === "string" ? "'" : "");
  57         db.serialize(function() {
  58             const query =
  59                 "SELECT * " +
  60                 "FROM Users " +
  61                 "WHERE " + by + " = " + delimiter + value + delimiter;
  62             db.get(query, cb);
  63         });
  64     },
  65
  66   getByName: function(names, cb) {
  67         db.serialize(function() {
  68             const query =
  69                 "SELECT id
  70         "FROM Users " +
  71                 "WHERE name IN ('" + names.join("','") + "')";;
  72             db.all(query, cb);
  73         });
  74   },
  75
  76     /////////
  77     // MODIFY
  78
  79     setLoginToken: function(token, uid, cb)
  80     {
  81         db.serialize(function() {
  82             const query =
  83                 "UPDATE Users " +
  84                 "SET loginToken = '" + token + "', loginTime = " + Date.now() + " " +
  85                 "WHERE id = " + uid;
  86             db.run(query, cb);
  87         });
  88     },
  89
  90     // Set session token only if empty (first login)
  91     // TODO: weaker security (but avoid to re-login everywhere after each logout)
  92     trySetSessionToken: function(uid, cb)
  93     {
  94         // Also empty the login token to invalidate future attempts
  95         db.serialize(function() {
  96             const querySessionToken =
  97                 "SELECT sessionToken " +
  98                 "FROM Users " +
  99                 "WHERE id = " + uid;
 100             db.get(querySessionToken, (err,ret) => {
 101                 if (!!err)
 102                     return cb(err);
 103                 const token = ret.sessionToken || genToken(params.token.length);
 104                 const queryUpdate =
 105                     "UPDATE Users " +
 106                     "SET loginToken = NULL" +
 107                     (!ret.sessionToken ? (", sessionToken = '" + token + "'") : "") + " " +
 108                     "WHERE id = " + uid;
 109                 db.run(queryUpdate);
 110                 cb(null, token);
 111             });
 112         });
 113     },
 114
 115     updateSettings: function(user, cb)
 116     {
 117         db.serialize(function() {
 118             const query =
 119                 "UPDATE Users " +
 120                 "SET name = '" + user.name + "'" +
 121                 ", email = '" + user.email + "'" +
 122                 ", notify = " + user.notify + " " +
 123                 "WHERE id = " + user.id;
 124             db.run(query, cb);
 125         });
 126     },
 127 }
 128
 129 module.exports = UserModel;