barebonesExam

This is just code requested by an exam. It is basically an example of a working CRUD app.

Restrictions are as follows:

• Library to use is only Mysql, EJS, and Express.

• Create a RESTful API that can return JSON or consume API call.

• Must be uploaded in Github with iterative commits.

Miscellaneous details (that are possibly important to reconstruct the app) from the developer of this app as follows:

• This was created in Arch Linux, running mysql57 from the AUR

• mysqld and other installation files from the package are untouched. Everything is installed in their default locations.

• Dummy mysql account is root@localhost with password "1234567890" (no quotes)

• IDE is Atom with several packages installed

• Most code/lines are borrowed or based on the references below.

Sources

• https://medium.com/@bhanushali.mahesh3/creating-a-simple-website-with-node-js-express-and-ejs-view-engine-856382a4578f

• https://www.youtube.com/watch?v=EN6Dx22cPRI

• https://stackoverflow.com/questions/8829102/check-if-table-exists-without-using-select-from

• https://chartio.com/learn/databases/using-information-schema-views-to-check-to-see-if-table-exists-in-sql-server/

• https://stackoverflow.com/questions/51126022/displaying-mysql-query-results-as-html-with-ejs

Note: The code remains unfinished due to time constraints. Commits will continue over the days if requested.