/Staff_Organizer

Primary LanguageJavaScriptMIT LicenseMIT

Staff Organizer

Description

In this application you will be interacting with the terminal to view, add or update data that is stored in a database.

When the commands have been made in the terminal (See Installation on more information on how to install), the

main menu will apprear. Once a selection has been made the application will either view, add or update the

database, depending on the selection. Use this application to manipulate the database and keep track of

employees, managers and their roles.


Demo

User Demonstration

Staff.Organizer.mp4

Installation

(MUST have MySQL installed before using this application)

  1. Clone Staff Organizer repository

Staff Organizer

  1. Navigate to 'index.js' located in the 'Main' folder, then open the file.

Staff Organizer

  1. On lines 12 & 15 enter your mysql login information

Staff Organizer

  1. Right click 'index.js', then 'Open in Intergrated Terminal'

Staff Organizer

  1. Run 'mysql -u root -p' then enter a password if needed

Staff Organizer

  1. While in mysql run the commands 'source db/schema.sql' followed by 'source db/seeds.sql'

Staff Organizer Staff Organizer

  1. Enter 'Quit' to exit mysql.

Staff Organizer

  1. Run the command 'node index.js'

Staff Organizer

Tools Used

  • Node.js
  • NPM
  • MySQL2
  • Inquirer
  • Console.table

Contact Information

Matthew Castoreno

Email: matthew.castoreno@yahoo.com