Employee Manager

Table of Contents

• Description
• Installation
• Screenshots
• Credits
• License

Description

Use this application to manage your company's employees, roles, and departments. Employee Manager uses a series of CLI prompts that will kick off queries to the MySQL database "employee_db" based on the user's input.

Prompts

1. • View all employees.
2. • View all roles.
3. • View all departments.
4. • Add an employee.
5. • Add a role.
6. • Add a department.
7. • Update an employee's role.
8. • Update an employee's reporting manager.
9. • View employees by manager.

See Screenshots for examples.

Installation

Technologies Used

• JavaScript
• MySQL & MySQL Workbench
• Node and npm
• Visual Studio Code
• cmder

Steps

1. • Start by entering the following in your terminal: Git clone https://github.com/whackingMUFN/Employee_Manager.git
2. • Change directory to Employee_Manager and enter npm install into your terminal. This will install all package dependencies.
3. • Add node_modules to .gitignore.
4. • Create a config.js file based on the template here.
   • If file config.js is created in another location other than the parent folder, remember to update server.js const credentials = require('./config') with the new relative path.
   • Replace <ID> in the user and password fields in config.js with the credential information for the database.
5. • Copy Database and Table setup from ./db/scehma.sql
     • Paste into MySQL Workbench and execute.
6. • Copy table data from ./db/employeeSeed.sql
     • Paste into MySQL and execute only the INSERT INTO ... VALUES (...) information code blocks for each table. This can be done by selecting/highlighting the desired code blocks and clicking the lightning bolt.

• Start the application by running npm start

Screenshots

Employee Manager Tour - View All Employees/Roles/Departments

Add Employee

Add Role

Add Department

Update Employee Role

Update Employee Manager

Credits

This assignment was provided by Trilogy Education Services. Code was developed based on in class activities and lectures, MDN Reference Documents for JavaScript syntax, JSHint for JavaScript validation, mysqltutorial for reference documentation and examples, and various other online resources.

License

License MIT © 2020 Calvin Freese