-
Notifications
You must be signed in to change notification settings - Fork 0
/
addEmp.js
58 lines (51 loc) · 1.43 KB
/
addEmp.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
const mysql = require('mysql2');
const inquirer = require('inquirer');
const cTable = require('console.table');
const questions = [
{
type: 'input',
message:'Enter first name of new employee',
name:'first_name'
},
{
type: 'input',
message:'Enter last name of new employee',
name:'last_name'
},
{
type: 'input',
message:'Enter role id number of new employee',
name:'role_id'
},
{
type: 'input',
message:"Enter id number of new employee's manager",
name:'manager_id'
}
];
const db = mysql.createConnection(
{
host: 'localhost',
user:'root',
password:'root',
database:'employee_db'
})
function addEmp(callback){
inquirer.prompt(questions)
.then(response=>{
db.query(`INSERT INTO employee_table (first_name, last_name, role_id, manager_id) VALUES ('${response.first_name}','${response.last_name}','${response.role_id}','${response.manager_id}')`, (err, result)=>{
if (err) {
console.log(err);
}
else{
db.query('SELECT * FROM employee_table;', (err, result)=> {
if (err) {
console.log(err);
}
console.table(result)
callback()
});
}
})
})}
module.exports = addEmp;