MySQL-Employee-Tracker
Employee Tracker
URL: https://darnocer.github.io/MySQL-Employee-Tracker/
Description
CMS for employee management utilizing node and MySQL.
Table of Contents
Installation
fork repo
run schema in MySQL
run seeds in MySQL
node server.js
Usage
After installation, select which action you’d like to take from the prompt. You can select fro the following actions:
View Employees: See all of the employees with their ID, first and last name, role, department, salary and manager.
View Employees By Department: Select a department from the list and see all employees within that department.
View Employees by Role: Select a role from the list and see all employees within that role.
View Employees by Manager: Select a manager from the list and see all employees under the specified manager.
Add Employee: Specify the employee’s first name, last name, role, and manager
Add Role: Specify new role
Add Department: Specify new department
Remove Employee: Specify which employee to remove from the list
Remove Role: Specify which role to remove from the list
Remove Department: Specify which role to remove from the list
Update Employee Role: Select an employee from the list and select the employee’s new role from the list
Update Employee Manager: Select an employee from the list and select the employee’s new manager from the list
Credits
-
My tutor who helped me understand how to write asynchrounous functions!
Future Enhancements
- Show Department Name instead of only ID in the table after adding a new role
- Update informational logs (eg. “Viewing Employees for {selected department}”)
- Refactor to use classes/constructors
- Refactor for asynchronous consistency (convert .then chains to async/await)
- If a selected table is blank, display a message rather than a blank table
- Add confirmations for deletions/additions/updates
- Add validation to free text prompts
Tests
Coming Soon
Questions?
Contact me at darian.nocera26@gmail.com
or
Copyright © 2020 Darian Nocera