CSBC1010 Assigment 3 Server App - Notes

This is the Application Tier for a simple Notes app. Built in Node.js and Express.js. You are required to:

1. Setup a connection to a SQL database.
2. Upon connection success, create the relavent table(s) if it does not exist.
3. Fetch all notes
4. Create a new note
5. Update an existing note
6. Delete an existing note
7. Search notes by content
8. Bulk delete all existing notes

Steps to setup:

1. Fork this repo and clone your forked repo

2. On your local machine, go to the folder and install dependencies

npm i

3. Run the app

npm start

4. Now server is listening on http://localhost:3001

• If you go to http://localhost:3001 on your browser, you should see: CSBC1010 Assignment 3 - My Notes
• If you go to http://localhost:3001/health on your browser, you should see: API is working properly
• If the above two links do not work as expected, please contact me.

Dependencies

• Node v14+
• npm v6+

Related Project

• CSBC1010 Assigment 3 Client App - Notes