aboutsummaryrefslogtreecommitdiffstats
path: root/csci4131/hw6/strap012_hw6/dbio.js
diff options
context:
space:
mode:
Diffstat (limited to 'csci4131/hw6/strap012_hw6/dbio.js')
-rw-r--r--csci4131/hw6/strap012_hw6/dbio.js79
1 files changed, 41 insertions, 38 deletions
diff --git a/csci4131/hw6/strap012_hw6/dbio.js b/csci4131/hw6/strap012_hw6/dbio.js
index ab3ec42..302334b 100644
--- a/csci4131/hw6/strap012_hw6/dbio.js
+++ b/csci4131/hw6/strap012_hw6/dbio.js
@@ -16,56 +16,59 @@ connection.connect(function(err) {
console.log("Connected to MYSQL database!");
});
-async function passcheck(user,pass) {
- let ret = '';
- connection.query('SELECT * FROM tbl_accounts', function(err,rows,fields) {
- if (err) throw err;
- if (rows.length == 0) {
- console.log("There are no entries in the accounts field!");
- } else {
- for (var i = 0 ; i < rows.length; i++) {
+function passcheck(user,pass) {
+ return new Promise(function(resolve, reject) {
+ connection.query('SELECT * FROM tbl_accounts', function(err, rows, fields) {
+ let ret = [];
+ if (err) {
+ return reject(err);
+ }
+ for (var i = 0; i < rows.length; i++) {
if (rows[i].acc_login.localeCompare(user) === 0) {
if (bcrypt.compareSync(pass, rows[i].acc_password)) {
- ret += rows[i];
+ ret += rows[i];
}
}
}
- }
- return ret;
+ resolve(ret);
+ });
});
-
}
function getContacts() {
- let conTab = []
- connection.query('SELECT * FROM tbl_contacts', function(err,rows,fields) {
- for (let i=0; i<rows.length; i++) {
- conTab[i] = rows[i];
- }
+ return new Promise (function(resolve, reject) {
+ let conTab = []
+ connection.query('SELECT * FROM tbl_contacts', function (err, rows, fields) {
+ if (err) {
+ return reject(err);
+ }
+ resolve(rows);
+ });
});
- return conTab;
}
-// Parameterized Insert
-var rowToBeInserted = {
- Title: 'A Book', // Dummy Book Name
- Category: 'General', // Dummy Category Type
- ISBN : '0000001234'// Dummy
- };
+function addContacts(contact) {
+ let newCon = {
+ name: contact.name,
+ category: contact.category,
+ location: contact.location,
+ contact_info: contact.contact,
+ email: contact.email,
+ website_url: contact.website_name,
+ }
+ return new Promise(function(resolve, reject) {
+ connection.query('INSERT tbl_contacts SET ?', newCon, function (err, result) { //Parameterized insert
+ if (err) throw err;
+ console.log("Values inserted");
+ resolve();
+ });
+ });
+
+}
-//connection.query('INSERT books SET ?', rowToBeInserted, function(err, result) { //Parameterized insert
-// if(err) throw err;
-// console.log("Values inserted");
-// });
-
-var Title = 'Another Book';
-var Cat = 'Fiction';
-var ISBN = '0000002345';
-
-//var sql = 'INSERT INTO books (Title,Category,ISBN) VALUES (' + '"' + Title + '"' + ',' + '"' + Cat + '"' + ',' + '"' + ISBN + '"' + ')';
-//connection.query(sql,function(err,result) {
-// if (err) throw err;
-// console.log ("Version 2 values inserted");
-// });
+
+
+exports.addContact = addContacts;
exports.query = passcheck;
+exports.getContacts = getContacts;