X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=models%2FUser.js;h=d0b105dc85cf417d67caf17424a95d63169afcd5;hb=HEAD;hp=6e91458eb310e3e798e6cb5483d005d5c1382ac8;hpb=8a477a7e1b781babc74d7935b80ac0b18ec04f86;p=vchess.git

diff --git a/models/User.js b/models/User.js
deleted file mode 100644
index 6e91458e..00000000
--- a/models/User.js
+++ /dev/null
@@ -1,90 +0,0 @@
-var db = require("../utils/database");
-var maild = require("../utils/mailer.js");
-var TokenGen = require("../utils/tokenGenerator");
-
-/*
- * 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)
-{
-	db.serialize(function() {
-		const query =
-			"INSERT INTO Users " +
-			"(name, email, notify) VALUES " +
-			"('" + name + "', '" + email + "', " + notify + ")";
-		db.run(query, callback); //TODO: need to get the inserted user (how ?)
-	});
-}
-
-// Find one user (by id, name, email, or token)
-exports.getOne = function(by, value, cb)
-{
-	const delimiter = (typeof value === "string" ? "'" : "");
-	db.serialize(function() {
-		const query =
-			"SELECT * FROM Users " +
-			"WHERE " + by + " = " + delimiter + value + delimiter;
-		db.get(query, cb);
-	});
-}
-
-/////////
-// MODIFY
-
-exports.setLoginToken = function(token, uid, cb)
-{
-	db.serialize(function() {
-		const query =
-			"UPDATE Users " +
-			"SET loginToken = " + token + " AND loginTime = " + Date.now() + " " +
-			"WHERE id = " + uid;
-		db.run(query, cb);
-	});
-}
-
-// Set session token only if empty (first login)
-// TODO: weaker security (but avoid to re-login everywhere after each logout)
-exports.trySetSessionToken = function(uid, cb)
-{
-	// Also empty the login token to invalidate future attempts
-	db.serialize(function() {
-		const querySessionTOken =
-			"SELECT sessionToken " +
-			"FROM Users " +
-			"WHERE id = " + uid;
-		db.get(querySessionToken, (err,token) => {
-			if (!!err)
-				return cb(err);
-			const newToken = token || TokenGen.generate(params.token.length);
-			const queryUpdate =
-				"UPDATE Users " +
-				"SET loginToken = NULL " +
-				(!token ? "AND sessionToken = " + newToken + " " : "") +
-				"WHERE id = " + uid;
-			db.run(queryUpdate);
-				cb(null, newToken);
-		});
-	});
-}
-
-exports.updateSettings = function(user, cb)
-{
-	db.serialize(function() {
-		const query =
-			"UPDATE Users " +
-			"SET name = " + user.name +
-			" AND email = " + user.email +
-			" AND notify = " + user.notify + " " +
-			"WHERE id = " + user._id;
-		db.run(query, cb);
-	});
-}