Technology used
- javascript
- node.js
- inquirer
- mysql
- mysql2 node package
This application takes input from the user, and allows them to do basic employee managment. Open starting the application the user may view all departments, view all roles, view all employees, add a department, add a role, add an employee, or update an employee role. It leverages javascript, inquirer and mysql2 package to create a functioning application to access mysql database tables.
The biggest challenge for me in making this app was the need to be precise with mysql queries. Javascript tends to be a lot more flexible in it's structure compared to mysql. While mysql follows a well thought out and developed logic, it is exacting in nature. By studying the language, and the documnetation I was able to overcome this challenge.
To install-
- Clone the repository
- install npm dependencies with npm -i
- run the index.js file with node index.js
To use the application, after installation run it in terminal with node index.js. From there follow the on screen prompts.
A video the the application demonstration can be found here
github.com/andrewn822/
andrewn822@gmail.com