A CLI solution for managing employees. Allows the user to add, remove, update and view employees by department or manager. Requires node, npm.
-
Clone this repo.
-
Create a local database called
employee_manager_db
by running theschema.sql
file. This will also seed the database with some example data. -
Create a
.env
file with the following variables:
DB_HOST=localhost
DB_USER=[your SQL username]
DB_PW=[your SQL password]
- Install dependencies by running
npm i
-
Run
node index
to start the program. -
Follow the onscreen prompts.