Emp. Manager is a CLI application to view and manage the departments, roles, and employees
Emp. Manager is a CLI application to view and manage the departments, roles, and employees.
- This is around 12 minutes of end to end demo. Please watch till end for all the operations.
To install dependencies, run the following command:
npm install
To run the application use node app command
- You need to have the same DB Schema as used in the application.
- For convinience schema file is provided with the project. The file path is /db/schema.sql
This project is licensed under the MIT license
- boxen
- cfonts
- chalk"
- console.table
- dotenv
- inquirer
- mysql"
emp.manager uses modular architecture. The app's entry point is app.js. App.js presents operations menu to the user and on userselection routes to appropriate enitity. The entity JS for example department.js in make use of entity specific ORM to perform the operations. There are 4 ORM code files in this project
- deptorm - Department Table ORM
- roleorm - Role Table ORM
- emporm - Employee Table ORM
The orm tables in turn make use of Database class defined in database.js to perform Database CRUD operations DMLs and DDL
The architecture diagram below shows the interactions.
If you have any questions you can contact me direct at bhagat.abhijeet@gmail.com.
Reach out to me at GitHub : bhagatabhijeet
