micheqn3 / employee-tracker Goto Github PK

This repository contains a content management system interface that utilizes MySQL in order to view and interact with data stored in the database. This application is run through the command line and allows the user to:

• Add departments, roles, and employees
• View departments, roles, and employees
• Update employee roles
• Remove employees and departments

1. Make sure you have Node.js to run the application
2. Clone this repo

HTTPS: https://github.com/micheqn3/employee-tracker.git
SSH: [email protected]:micheqn3/employee-tracker.git

3. Install the NPM packages

npm install

4. Create the database in MySQL using the schema found in sql/ schema.sql
5. Provide your MySQL credentials in the index.js file and make sure your server is running
6. Run the application in command line

node index.js

• index.js - This file connects to the MySQL database and contains an Application class, which will control the flow of the application.
• sql/ schema.sql - This file contains the tables that will store the data.
• sql/ seeds.sql - This file contains the data that will prepopulate the database.
• src/ inquirer.js - This file contains all the prompts for the user and is utilized in index.js.

• JavaScript
• Node.js
• Inquirer
• MySQL
• Chalk
• Console.table
• Dotenv

MIT