aboutsummaryrefslogtreecommitdiffstats
path: root/csci4131/hw6/strap012_hw6/insert_into_accounts_table.js
diff options
context:
space:
mode:
Diffstat (limited to 'csci4131/hw6/strap012_hw6/insert_into_accounts_table.js')
-rw-r--r--csci4131/hw6/strap012_hw6/insert_into_accounts_table.js45
1 files changed, 0 insertions, 45 deletions
diff --git a/csci4131/hw6/strap012_hw6/insert_into_accounts_table.js b/csci4131/hw6/strap012_hw6/insert_into_accounts_table.js
deleted file mode 100644
index 3157ce3..0000000
--- a/csci4131/hw6/strap012_hw6/insert_into_accounts_table.js
+++ /dev/null
@@ -1,45 +0,0 @@
-/*
-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();
-});