The motivation for this project was to create a command line application that can store, access, and update employee information. I built this to practice using node and mysql to connect to a local database. It solves the problem of storing and accessing important information on employees and being able to see the information in a structured table on the command line. I learned a lot about how to add and view data using only node and mysql.
To install application open the command line and run npm i to install all dependencies.
To use application open command line and run node server.js. A welcome message will appear and you can use the up and down arrows to make a selection. Hit enter to choose your selection and the data will appear on a formatted table. If you select to add or update a department, role, or employee, you need to input the text and press enter and a prompt will appear to let you know you were successful. To quit application select quit or close out command line.
You can view a video walk-through at https://drive.google.com/file/d/16yzxQCT4h67Supo9k_2Xi1TVXJwkA1Ix/view?usp=sharing
Utilized node, mysql, inquirer, dotenv, and console.table
N/A