-
Notifications
You must be signed in to change notification settings - Fork 0
/
usersManager.js
82 lines (80 loc) · 2.84 KB
/
usersManager.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
81
82
const mysql = require('mysql');
const connection = mysql.createConnection({
host: '',
user: 'admin',
password: '',
database: 'users'
});
module.exports = {
getUserByID: (id) => {
return new Promise((resolve, reject) => {
connection.query(`SELECT * from drill where id=${id}`, function (error, results, fields) {
if (error) reject(error);
resolve(results[0]);
});
})
},
addUser: async ({
first_name,
last_name,
id,
password
}) => {
return new Promise((resolve, reject) => {
connection.query(`INSERT INTO drill (first_name, last_name, id, password)
VALUES ('${first_name}', '${last_name}', '${id}', '${password}');`, function (error, results, fiels) {
if (error) reject(error);
resolve({
data: `${first_name} added succesefully`,
error: null
});
});
})
},
login: async ({
id,
password
}) => {
return new Promise((resolve, reject) => {
connection.query(`SELECT * from drill where id='${id}' AND password='${password}'`, function (error, results, fiels) {
if (error) reject(error);
resolve(results[0]);
})
})
},
changeDetails: async ({
id,
change,
changeTo
}) => {
return new Promise((resolve, reject) => {
connection.query(`UPDATE drill SET ${change} = '${changeTo}' WHERE id='${id}'`, function (error, results, fields) {
// if (results) resolve(results[0])
// else reject(error);
if (error) reject(error);
else resolve(results[0]);
})
});
},
deleteRecord: async (id) => {
return new Promise((resolve, reject) => {
connection.query(`SELECT * from drill WHERE id='${id}'`, function (error, results, fields) {
if (error) return reject(error);
let message;
if (results[0]) {
let deleted_date = results[0].delete_date;
if (deleted_date)
message = `User deleted on ${deleted_date}`;
}
else message = 'User not found';
if(message) return reject(message);
let d = new Date();
d = d.toISOString();
connection.query(`UPDATE drill SET delete_date = '${d}' WHERE id='${id}'`, function (error, results, fields) {
if (error) return reject(error);
resolve(results[0]);
})
});
})
}
}