-
Notifications
You must be signed in to change notification settings - Fork 2
/
mysqlConfig.js
64 lines (55 loc) · 1.89 KB
/
mysqlConfig.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
var _mysql = require('mysql');
var login = require('./login');
var mysql;
exports.MYSQL_USER = login.user;
exports.MYSQL_PASS = login.pw;
exports.DATABASE = 'todo';
exports.TABLE = 'toDoList';
exports.currentDate = "CURDATE()";
exports.mySqlStart = function(){
mysql = _mysql.createClient({
user: exports.MYSQL_USER,
password: exports.MYSQL_PASS,
});
mysql.query('use ' + exports.DATABASE);
return mysql;
}
exports.insertData = function (createDate, dueDate, task, complete){
var query = "INSERT INTO " + exports.TABLE + " (creationDate, dueDate, task, complete)";
query += " VALUES (" + createDate + ", " + dueDate + ", " + task + ", " + complete +")";
mysql.query(query,
function(err, result, fields) {
if (err)
console.log(err);
else
console.log('Inserted into DB using the following statement:\n\t "' + query + '"');
});
}
exports.updateData = function(createDate, dueDate, task, complete, set)
{
var query = "UPDATE " + exports.TABLE + " SET " + set + " WHERE task = '" + task + "'";
query += " AND creationDate = '" + createDate + "'";
query += " AND dueDate = '" + dueDate + "'";
query += " AND complete = '" + complete +"'";
mysql.query(query,
function(err, result, fields) {
if (err)
console.log(err);
else
console.log('Updated DB using the following statement:\n\t "' + query + '"');
});
}
exports.deleteData = function(createDate, dueDate, task, complete)
{
var query = "DELETE FROM " + exports.TABLE + " WHERE task = '" + task + "'";
query += " AND creationDate = '" + createDate + "'";
query += " AND dueDate = '" + dueDate + "'";
query += " AND complete = '" + complete +"'";
mysql.query(query,
function(err, result, fields) {
if (err)
console.log(err);
else
console.log('Deleted from DB using the following statement:\n\t "' + query + '"');
});
}