diff options
author | Matthew Strapp <msattr@gmail.com> | 2021-04-29 12:08:29 -0500 |
---|---|---|
committer | Matthew Strapp <msattr@gmail.com> | 2021-04-29 12:08:29 -0500 |
commit | cb0d7de098f482ba667029f266dd286eab1795b6 (patch) | |
tree | d267c42f6ce9bb9461a53104185c5e32043f548d /csci4131/hw7/insert_into_accounts_table.js | |
parent | Fix styling (diff) | |
download | homework-cb0d7de098f482ba667029f266dd286eab1795b6.tar homework-cb0d7de098f482ba667029f266dd286eab1795b6.tar.gz homework-cb0d7de098f482ba667029f266dd286eab1795b6.tar.bz2 homework-cb0d7de098f482ba667029f266dd286eab1795b6.tar.lz homework-cb0d7de098f482ba667029f266dd286eab1795b6.tar.xz homework-cb0d7de098f482ba667029f266dd286eab1795b6.tar.zst homework-cb0d7de098f482ba667029f266dd286eab1795b6.zip |
Add HW6 files
Diffstat (limited to '')
-rw-r--r-- | csci4131/hw7/insert_into_accounts_table.js | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/csci4131/hw7/insert_into_accounts_table.js b/csci4131/hw7/insert_into_accounts_table.js new file mode 100644 index 0000000..3157ce3 --- /dev/null +++ b/csci4131/hw7/insert_into_accounts_table.js @@ -0,0 +1,45 @@ +/* +TO DO: +----- +READ ALL COMMENTS AND REPLACE VALUES ACCORDINGLY +*/ + +const mysql = require("mysql"); +const bcrypt = require('bcrypt'); + +const dbCon = mysql.createConnection({ + host: "cse-mysql-classes-01.cse.umn.edu", + user: "C4131S21U83", // replace with the database user provided to you + password: "6919", // replace with the database password provided to you + database: "C4131S21U83", // replace with the database user provided to you + port: 3306 +}); + +console.log("Attempting database connection"); +dbCon.connect(function (err) { + if (err) { + throw err; + } + + console.log("Connected to database!"); + + const saltRounds = 10; + const myPlaintextPassword = 'tango'; // replace with password chosen by you OR retain the same value + const passwordHash = bcrypt.hashSync(myPlaintextPassword, saltRounds); + + const rowToBeInserted = { + acc_name: 'charlie', // replace with acc_name chosen by you OR retain the same value + acc_login: 'charlie', // replace with acc_login chosen by you OR retain the same value + acc_password: passwordHash + }; + + console.log("Attempting to insert record into tbl_accounts"); + dbCon.query('INSERT tbl_accounts SET ?', rowToBeInserted, function (err, result) { + if (err) { + throw err; + } + console.log("Table record inserted!"); + }); + + dbCon.end(); +}); |