This is a
- GIVEN a command-line application that accepts user input
- WHEN I start the application
- THEN a I am presented with the following options: view all departments, view all roles, view all employees, add a department, add a role, add an employee, and update an employee role
- WHEN I choose to view all departments
- THEN I am presented with a formatted table showing department names and department ids
- WHEN I choose to view all roles
- THEN I am presented with the job title, role id, the department that role belongs to, and the salary for that role
- WHEN I choose to view all employees
- THEN I am presented with a formatted table showing employee data, including employee ids, first names, last names, job titles, departments, salaries, and managers that the employees report to
- WHEN I choose to add a department
- THEN I am prompted to enter the name of the department and that department is added to the database
- WHEN I choose to add a role
- THEN I am prompted to enter the name, salary, and department for the role and that role is added to the database
- WHEN I choose to add an employee
- THEN I am prompted to enter the employee’s first name, last name, role, and manager and that employee is added to the database
- WHEN I choose to update an employee role
- THEN I am prompted to select an employee to update and their new role and this information is updated in the database
-
Download it through Github
-
Ensure npm packages are installed
-
Ensure mySQL is installed
-
Open terminal
-
Now, in the read-me-generator "cd" into the develop folder
-
Run & Test by typing "node index.js"
-
Answer the prompts that follow
-
On success a README.md will be generated.
Javascript
mySQL2
npm packages installed -
npm init -y
npm i console.table
npm i mysql2
https://drive.google.com/file/d/1XsJXpi8bwNel1nLO6y0vbIPjEJ6Tr8mz/view
For questions about this project, please see
My GitHub at: arand013
Reach out by email at: alexanderaranda@ymail.com