/employee-manager

This content management systems (CMS) is a command-line application to manage a company's employee database, using Node.js, Inquirer, and MySQL.

Primary LanguageJavaScriptMIT LicenseMIT

EMPLOYEE MANAGER

License: MIT Node.js Badge Express Badge mysql

Description

This content management systems (CMS) is a command-line application to manage a company's employee database, using Node.js, Inquirer, and MySQL.

Application

The following video shows the application's appearance and functionality:

Screen.Recording.2023-05-30.at.4.04.17.PM.mov

Technologies Used

MySQL
Javascript
NODE JS
Express.js

Installation

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).

Usage

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.

Credits

https://nodejs.org/en
https://www.w3schools.com
https://www.w3schools.com/mysql/mysql_join.asp

License

MIT License. For more information on the license, please refer to the LICENSE file in the repo