werewolf-weed

• OVERVIEW
  • user story
  • acceptance criteria
  • the hairy list
• INSTALLATION
• USAGE
  • screenshot
  • demo
• TESTING
• SOURCES
• LICENSE
• LINKS
• CONNECT

The WEREWOLF WEED Employee Database is a command-line application that manages WEREWOLF WEED’S employee database by using Node.js, Inquirer, and MySQL.

• MySQL2 package to connect to WEREWOLF WEED'S MySQL database and perform queries.
• Inquirer package to interact with the user via the command-line.

The application is invoked using the following commands:

Clone the repository in your local development enviorment.

git clone https://github.com/christiecamp/werewolf-weed.git

Update .env with your information

Navigate to the command line and input:

npm i :: inquirer@8.2.4, --save mysql2, dotenv --save, --save sequelize, -g nodemon --save-dev, console-table-printer

mysql -u root -p

SOURCE lib/db/schema.sql;
SOURCE lib/db/seeds.sql;
quit

node server

INSTRUCTIONS:

1. Open the Integrated Terminal and input - node server.

2. Interact with WEREWOLF WEED’s database by selecting the below prompts:

   • view departments
   • view roles
   • view employees
   • add department
   • add role
   • update employee role
   • view employee by manager
   • update employee manager
   • delete department
   • delete role
   • delete employee
   • view total utilized budget by department

Here’s a list of technologies used:

1. Node.js - is an open-source, cross-platform JavaScript runtime environment.

2. Inquirer - the NPM package that provides an easy way to capture user input in your Node. js command line interface applications.

3. MySQL2 - MySQL is a relational database management system based on SQL – Structured Query Language.

4. Dotenv - a zero-dependency module that loads environment variables from a .env file into process.env.

5. Sequelize - a Node.js based Object Relational Mapper that makes it easy to work with MySQL databases. An Object Relational Mapper performs functions like handling database records by representing the data as objects.

6. Nodemon - a Node.js tool that helps develop applications by automatically restarting the node application when file changes in the directory are detected.

7. Chalk - a Node.js tool that helps develop applications by automatically restarting the node application when file changes in the directory are detected.

8. Console Table Printer - a Node.js tool that prints simple tables.

MIT License

GitHub Repository

Video Demo

This site is open source. Improve this page.