Easily view, change, and then view the changes for all individuals in your workplace in this handy bird's eye built for businesses
This is a back-end application that allows a user to view or update a workplace's list of departments, all roles/job titles, and all existing employees. The app runs in node and is powered by inquirer, mysql2, dotenv, process, and console.table npm packages.
This challenge does not include a deployed application. Instead, a screen-recorded video is submitted alongside the github repo link.
Video link: https://drive.google.com/file/d/1i9vDdDTLYLmDfU2recQM0PSODGzLyGBb/view
- Separate js files into a better file structure. I tried to separate them at first, but the functions I exported/required across files were not functioning properly. It was happier all together in one file in the end.
- Use constructor functions or a class to better organize the SQL queries, as the assignment suggested, because I absolutely got lost in my own code.
- Change the printed console tables to show department, role, and manager names instead of just their corresponding ids.
- Change the printed console tables to show more column information, sometimes combined with other tables.
- Make the department, role and employee lists dynamic within inquirer so that once one is added, the list next presented is the most recent list with the new additions.
- Remove the (index) column from the printed data tables with console.table just to make it prettier.
- Add the bonus features like more updates, deleting data, and sorting the column views.
Below is a screenshot of Bird's Eye for Business.
List of resources used:
https://www.educative.io/blog/what-is-database-query-sql-nosql
https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench
https://www.sqlshack.com/learn-mysql-add-data-in-tables-using-the-insert-statement/
https://www.npmjs.com/package/process
https://www.npmjs.com/package/mysql2
https://www.npmjs.com/package/dotenv
https://www.npmjs.com/package/console.table
https://en.rakko.tools/tools/36/
https://kinsta.com/knowledgebase/content-management-system/
No licenses (default copyright laws apply).