-
Notifications
You must be signed in to change notification settings - Fork 0
/
utils.js
51 lines (42 loc) · 1.63 KB
/
utils.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
module.exports = {
selectFromDB(connection, callback, table, row, query) {
if (row && query) query = " WHERE " + row + "='" + query + "'";
else query = "";
try {
connection.query("SELECT * FROM " + table + query, function(err, resp, fields) {
if (err || resp[0] === undefined) {
callback(false, "This value doesn't exist");
return;
}
callback(true, resp);
});
} catch (err) {
callback(false, err);
return;
}
},
existsInTable(connection, table, row, query, callback) {
connection.query("SELECT EXISTS(SELECT * FROM " + table + " WHERE " + row + "='" + query + "')", function(err, resp, field) {
if (err) {
callback(false, err);
return;
}
if (resp[0][Object.keys(resp[0])[0]] == 0) callback(false);
else callback(true);
});
},
insertToDB(connection, table, row, value, callback) {
if (row != "") {
if (Array.isArray(row)) row = " (" + row.join(", ") + ")";
else row = " (" + row + ")";
}
if (Array.isArray(value)) value = "('" + value.join("', '") + "')";
else value = "('" + value + "')";
connection.query("INSERT INTO " + table + row + " VALUES " + value + ";");
callback();
},
updateRow(connection, table, row, value, anchor, callback) {
connection.query("UPDATE " + table + " SET " + row + "=" + value + " WHERE " + anchor[0] + "=" + anchor[1] + ";");
callback();
}
};