/Employee-Tracker

A CLI application for tracking employees, roles, departments and more with the use of MySQL and Node

Primary LanguageJavaScriptMIT LicenseMIT

Employee Tracker

This is a CLI application for tracking employees in database using Node and MySQL.

Instructions

  • Download/clone the repo
  • Run employee_db.js in the terminal and run "npm i" to install the dependencies
  • Copy the schema in employee_db.sql and run it in MySQL/Sequel Pro to create the database with the seed content
  • Once the db is created enter your MySQL username and password in the available locations; lines 13 and 16 of the employee_db.js file
  • Run the employee_db.js file in the terminal using node; "node employee_db.js"
  • Follow the prompts to do any of the following:
    • Add departments, roles, employees
    • View departments, roles, employees
    • Update employee roles
    • Delete departments, roles, and employees
  • When you are finished navigate to the EXIT option to quit the application

Built With

  • Node.js
  • MySQL
  • Inquirer.js

License

This project is licensed under the MIT License - see the LICENSE.md file for details