diff options
Diffstat (limited to 'csci4131/hw7/dbio.js')
| -rw-r--r-- | csci4131/hw7/dbio.js | 38 |
1 files changed, 26 insertions, 12 deletions
diff --git a/csci4131/hw7/dbio.js b/csci4131/hw7/dbio.js index 302334b..dcc7386 100644 --- a/csci4131/hw7/dbio.js +++ b/csci4131/hw7/dbio.js @@ -1,21 +1,35 @@ var mysql = require("mysql"); var bcrypt = require("bcrypt"); +var fs = require("fs"); +var xml2js = require("xml2js"); +var parser = new xml2js.Parser(); +var conInfo; +var connection; -var connection = mysql.createConnection({ - host: "cse-mysql-classes-01.cse.umn.edu", - user: "C4131S21U83", - password: "6919", - database: "C4131S21U83", - port: 3306 -}); +fs.readFile(__dirname + '/dbconfig.xml', function (err, data) { + if (err) throw err; + parser.parseString(data, function (err, result) { + if (err) throw err; + conInfo = result; + }); + connection = mysql.createConnection({ + host: conInfo.dbconfig.host[0], + user: conInfo.dbconfig.user[0], + password: conInfo.dbconfig.password[0], + database: conInfo.dbconfig.database[0], + port: conInfo.dbconfig.port[0] + }); -connection.connect(function(err) { - if (err) { - throw err; - }; - console.log("Connected to MYSQL database!"); + connection.connect(function (err) { + if (err) { + throw err; + }; + console.log("Connected to MYSQL database!"); + }); }); + + function passcheck(user,pass) { return new Promise(function(resolve, reject) { connection.query('SELECT * FROM tbl_accounts', function(err, rows, fields) { |