Command line application which prompts user questions about a company's employees, roles, and departments using the inquirer package. Responses are then used to build and interact with data in a MySQL database.
Users are prompted to select an initial action, presented with further questions depending on their selection, and either presented with a data table to view or a message confirming the change they've made to the database. The initial question is re-prompted and users loop through this process until choosing to quit.
Users can currently view the data tables in the console, as well as add, update, and delete records.
- Question validation to reject empty fields or incorrect entry types
- Action validation to control database interactions, such as when a user attempts to delete an employee when none exist in the database
- Colorized console messages to quickly indicate to a user the status of their requests
- Node.js
- MySQL
- inquirer, mysql2, console.table, and colors packages
Run the following script to install the application:
git clone https://github.com/kayleriegerpatton/employee-tracker.git
cd employee-tracker
npm install
Before starting the application, seed data with the following script:
npm run seed
Run the following script to use the application:
npm run start
To contribute to or ask a question about this project, please email me.
MIT License
Click to view a demo video.