-
Notifications
You must be signed in to change notification settings - Fork 0
/
user.js
80 lines (75 loc) · 1.95 KB
/
user.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
const crypto = require("crypto");
function registerUser(secret,data){
return new Promise(function(resolve, reject) {
global.db.query("INSERT INTO users (secret,data) VALUES (?,?);",[secret,data], function(err, result, fields) {
resolve(result.insertId);
});
});
}
function checkUserSecret(id,secret){
return new Promise(function(resolve, reject) {
global.db.query("SELECT secret FROM users WHERE id=? LIMIT 1;",[id],function(err, result, fields) {
if(err){
reject(err);
}else{
if(result.length < 1){
resolve(false);
}else{
resolve(result[0]["secret"] == secret);
}
}
});
});
}
function updateUserData(userId,data){
return new Promise(function(resolve, reject) {
let json = JSON.stringify(data);
global.db.query("UPDATE users SET data=? WHERE id=? LIMIT 1;",[json,userId],function(err){
if(err){
reject(err);
}else{
resolve(true);
}
});
});
}
function setArrayProperty(array,path,value){
var property = array;
for(let i=0; i<path.length; i++){
if(i == path.length-1){
property[path[i]] = value;
}else{
property = property[path[i]];
}
}
return array;
}
function updateUserDataProperty(userId,propertyPath,newValue){
return new Promise(function(resolve, reject) {
getUserData(userId).then(function(data){
data = setArrayProperty(data,propertyPath,newValue);
updateUserData(userId,data);
resolve(true);
});
});
}
function getUserData(id){
return new Promise(function(resolve, reject) {
global.db.query("SELECT * FROM users WHERE id=? LIMIT 1;",[id],function(err, result, fields) {
if(err){
reject(err);
}else{
result = result[0];
result = JSON.parse(result["data"]);
resolve(result);
}
});
});
}
module.exports = {
registerUser,
updateUserData,
updateUserDataProperty,
getUserData,
checkUserSecret
};