X-Git-Url: https://git.auder.net/rpsls.js?a=blobdiff_plain;f=models%2FUser.js;h=655012d8cd8dce669c7ee566e5c9edbb514895af;hb=HEAD;hp=66b1bf549b738d0acf6be27e1c4ee2244901b17e;hpb=8d7e2786f5a67a1b9a77c742d7951e0efbe8747d;p=vchess.git diff --git a/models/User.js b/models/User.js deleted file mode 100644 index 66b1bf54..00000000 --- a/models/User.js +++ /dev/null @@ -1,74 +0,0 @@ -var db = require("../utils/database"); -var maild = require("../utils/mailer.js"); - -/* - * Structure: - * _id: integer - * name: varchar - * email: varchar - * loginToken: token on server only - * loginTime: datetime (validity) - * sessionToken: token in cookies for authentication - * notify: boolean (send email notifications for corr games) - */ - -// User creation -exports.create = function(name, email, notify, callback) -{ - if (!notify) - notify = false; //default - db.serialize(function() { - db.run( - "INSERT INTO Users " + - "(name, email, notify) VALUES " + - "(" + name + "," + email + "," + notify + ")"); - }); -} - -// Find one user (by id, name, email, or token) -exports.getOne = function(by, value, cb) -{ - const delimiter = (typeof value === "string" ? "'" : ""); - db.serialize(function() { - db.get( - "SELECT * FROM Users " + - "WHERE " + by " = " + delimiter + value + delimiter, - callback); - }); -} - -///////// -// MODIFY - -exports.setLoginToken = function(token, uid, cb) -{ - db.serialize(function() { - db.run( - "UPDATE Users " + - "SET loginToken = " + token + " AND loginTime = " + Date.now() + " " + - "WHERE id = " + uid); - }); -} - -exports.setSessionToken = function(token, uid, cb) -{ - // Also empty the login token to invalidate future attempts - db.serialize(function() { - db.run( - "UPDATE Users " + - "SET loginToken = NULL AND sessionToken = " + token + " " + - "WHERE id = " + uid); - }); -} - -exports.updateSettings = function(name, email, notify, cb) -{ - db.serialize(function() { - db.run( - "UPDATE Users " + - "SET name = " + name + - " AND email = " + email + - " AND notify = " + notify + " " + - "WHERE id = " + uid); - }); -}