Manage employee data using this command line Content Management System (CMS) built with Node.js, Inquirer, and MySQL. Options include: view all departments, view all roles, view all employees, add a department, add a role, add an employee, and update an employee role.
Watch a video demonstration of the basic functionaity using mock data:
employee-tracker.mov
- Check if you have Node.js installed by typing "node -v" in your command line. If node is not installed, visit the Node.js website to install.
- Next, clone this project repository to your computer.
- Use the command "npm install" to install dependecies.
- Create a file in the root directory titled ".env" and type "PASSWORD='[YOUR PASSWORD HERE]'"
- Type "mysql -u root -p" in the terminal and enter your personal MySQL password. Next, type "source schema.sql" and "source seeds.sql" (These commands will create the employee_db database and seed the database with mock data.).
- Open terminal in "index.js" and run the command "npm start".
- Select a desired task and follow the Inquirer prompts.
- Choose another task or exit the application.
- To exit application, choose "EXIT" from task prompt list.
- Reference the video demonstration above as needed.
This project was created as a challenge assignment for the Austin UT Full Stack Boot Camp. Table structures provided in 'assets' folder was provided by Austin UT Boot Camps. Please contact me with any ideas, questions, or requests.
- Email elizabetholsavsky@gmail.com
- LinkedIn https://www.linkedin.com/in/elizabetholsavsky/
- Portfolio https://elizabetholsavsky.com/
- Hashnode Blog https://blog.elizabetholsavsky.com/
- Twitter @elizavsky