aboutsummaryrefslogtreecommitdiffstats
path: root/csci4131/hw7/insert_into_accounts_table.js
diff options
context:
space:
mode:
authorRossTheRoss <mstrapp@protonmail.com>2021-05-16 21:38:59 -0500
committerRossTheRoss <mstrapp@protonmail.com>2021-05-16 21:38:59 -0500
commit9148fa6e2fad9d54e3451a4478e03f55f0a9fa3c (patch)
tree9e739b11361f5fd122b31cfce107947502b69809 /csci4131/hw7/insert_into_accounts_table.js
parentAdd trash (diff)
downloadhomework-9148fa6e2fad9d54e3451a4478e03f55f0a9fa3c.tar
homework-9148fa6e2fad9d54e3451a4478e03f55f0a9fa3c.tar.gz
homework-9148fa6e2fad9d54e3451a4478e03f55f0a9fa3c.tar.bz2
homework-9148fa6e2fad9d54e3451a4478e03f55f0a9fa3c.tar.lz
homework-9148fa6e2fad9d54e3451a4478e03f55f0a9fa3c.tar.xz
homework-9148fa6e2fad9d54e3451a4478e03f55f0a9fa3c.tar.zst
homework-9148fa6e2fad9d54e3451a4478e03f55f0a9fa3c.zip
Rearrange files
Diffstat (limited to 'csci4131/hw7/insert_into_accounts_table.js')
-rw-r--r--csci4131/hw7/insert_into_accounts_table.js45
1 files changed, 0 insertions, 45 deletions
diff --git a/csci4131/hw7/insert_into_accounts_table.js b/csci4131/hw7/insert_into_accounts_table.js
deleted file mode 100644
index 0be14ce..0000000
--- a/csci4131/hw7/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 = 'admin%'; // replace with password chosen by you OR retain the same value
- const passwordHash = bcrypt.hashSync(myPlaintextPassword, saltRounds);
-
- const rowToBeInserted = {
- acc_name: 'admin$', // replace with acc_name chosen by you OR retain the same value
- acc_login: 'admin$', // 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();
-});