-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.js
93 lines (89 loc) · 2.79 KB
/
index.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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
// adds required
const express = require("express");
const mysql = require("mysql2");
const inquirer = require("inquirer");
const app = express();
const cTable = require("console.table");
// includes external modules
const topLevelPrompts = require("./utils/topLevelPrompts");
const addDepartment = require("./utils/addDepartment");
const addEmployee = require("./utils/addEmployee");
const addRole = require("./utils/addRole");
const updateRole = require("./utils/updateRole");
const db = require("./db/server");
const {
insertDepartment,
insertRole,
insertEmployee,
viewDepartment,
viewRole,
viewEmployee,
changeEmployee,
} = require("./utils/dbQueries");
console.log(`
╔═╗╔╦╗╔═╗╦ ╔═╗╦ ╦╔═╗╔═╗ ╔╦╗╔═╗╔╗╔╔═╗╔═╗╔═╗╦═╗
║╣ ║║║╠═╝║ ║ ║╚╦╝║╣ ║╣ ║║║╠═╣║║║╠═╣║ ╦║╣ ╠╦╝
╚═╝╩ ╩╩ ╩═╝╚═╝ ╩ ╚═╝╚═╝ ╩ ╩╩ ╩╝╚╝╩ ╩╚═╝╚═╝╩╚═
`);
// begin prompts
const promptLoad = () => {
topLevelPrompts().then((answer) => {
switch (answer.main) {
case "View All Employees":
viewEmployee()
.then((employees) => {
console.table(employees);
})
.then(promptLoad);
break;
case "Add A New Employee":
viewRole().then((roles) => {
viewEmployee().then((employees) => {
addEmployee(roles, employees).then((employee) => {
insertEmployee(employee).then(promptLoad);
});
});
});
break;
case "View All Roles":
viewRole()
.then((roles) => {
console.table(roles);
})
.then(promptLoad);
break;
case "Add A Role":
viewDepartment().then((departments) => {
addRole(departments).then((role) => {
insertRole(role).then(promptLoad);
});
});
break;
case "View All Departments":
viewDepartment()
.then((departments) => {
console.table(departments);
})
.then(promptLoad);
break;
case "Add A Department":
addDepartment().then((department) => {
insertDepartment(department.department2).then(promptLoad);
});
break;
case "Update An Employee Role":
viewEmployee().then((employees) => {
viewRole().then((roles) => {
updateRole(employees, roles).then((newEmployeeRole) => {
changeEmployee(newEmployeeRole).then(promptLoad);
});
});
});
break;
case "Exit":
console.log("Let's go make some money! Press CTRL-C to Exit.");
break;
}
});
};
promptLoad();