Fosclass Notes Api

Simple CRUD notes app with MySQL Database Fosclass Programming Final Submission.

Content

Instruction
Setup
Project Structure
Request and Responses
Testing
Depedencies

Instruction

Open file src/controllers/notes.js then replace commented /* @todo comments */ with your own code to have output like Request and Responses section.

// const Note = require('../models/note')
const responses = require('../constants/responses')
const apiResponse = require('../helpers/response-helper')

const getNotes = async (req, res) => {
  try {
    /**
     * @todo Write your code here
     */
  } catch (error) {
    return apiResponse(res, responses.error.code, 'Error retrieving notes')
  }
}

const getNote = async (req, res) => {
  try {
    /**
     * @todo Write your code here
     */
  } catch (error) {
    return apiResponse(res, responses.error.code, 'Error retrieving note')
  }
}

const createNote = async (req, res) => {
  try {
    /**
     * @todo Write your code here
     */
  } catch (error) {
    return apiResponse(res, responses.error.code, 'Error creating note')
  }
}

const updateNote = async (req, res) => {
  try {
    /**
     * @todo Write your code here
     */
  } catch (error) {
    return apiResponse(res, responses.error.code, 'Error updating note')
  }
}

const deleteNote = async (req, res) => {
  try {
    /**
     * @todo Write your code here
     */
  } catch (error) {
    return apiResponse(res, responses.error.code, 'Error deleting note')
  }
}

module.exports = {
  getNotes,
  getNote,
  createNote,
  updateNote,
  deleteNote
}

To make sure your output code as expected, you can test api with Postman with importing environment and collections json files on Testing section.

If you want to change database configuration, open file src/config/database.js like below.

module.exports = {
  development: {
    username: 'root',
    password: null,
    database: 'notes_db',
    host: '127.0.0.1',
    dialect: 'mysql'
  },
  test: {
    username: 'root',
    password: null,
    database: 'notes_db',
    host: '127.0.0.1',
    dialect: 'mysql'
  },
  production: {
    username: 'root',
    password: null,
    database: 'notes_db',
    host: '127.0.0.1',
    dialect: 'mysql'
  }
}

To get know what the request method from the API, you can start by opening file routes/api.js.

const { Router } = require('express')
const {
  getNotes,
  getNote,
  createNote,
  updateNote,
  deleteNote
} = require('../controllers/notes')

const router = Router()
router.get('/notes', getNotes)
router.get('/notes/:id', getNote)
router.post('/notes', createNote)
router.put('/notes/:id', updateNote)
router.delete('/notes/:id', deleteNote)

module.exports = router

To complete this submission you can use Sequelize Model that include on this project at directory src/models to Retrieve, Insert, Update, and Delete data from MySQL table.

You can use apiResponse() helper function from directory src/helpers/response-helper.js to construct JSON response from Model retrieved data.

const apiResponse = (response, statusCode, message, data) => {
  return response.status(statusCode).json({
    status: statusCode,
    message,
    data
  })
}

module.exports = apiResponse

If you cannot complete this submission by using MySQL and Sequelize, you can make your own Model to store notes data temporary on variable that presistent while this Node JS API running.

Setup

Install all depedencies by running npm command
```
npm install
```
Create MySQL database with name notes_db
```
CREATE DATABASE notes_db;
```
Run database migration using command below
```
npm run migrate
```

Project Structure

fosclass-notesapi
├── .eslintrc.json
├── .gitignore
├── .sequelizerc
├── index.js
├── package-lock.json
├── package.json
├── postman
│   ├── Fosclass Notes Api.postman_collection.json
│   └── Fosclass Notes Api.postman_environment.json
└── src
    ├── config
    │   └── database.js
    ├── constants
    │   └── responses.js
    ├── controllers
    │   └── notes.js
    ├── database
    │   └── sequelize.js
    ├── helpers
    │   └── response-helper.js
    ├── migrations
    │   └── 20231128075856-create_notes_table.js
    ├── models
    │   └── note.js
    ├── routes
        └── api.js

Start Application

Starting on development mode
```
npm run dev
```
Starting on production mode
```
npm start
```

Request and Responses

[GET] /api/notes
Request :

curl http://localhost:3000/api/notes

Response :

{
  "status": 200,
  "message": "Notes retrieved successfully",
  "data": [
      {
          "id": "e171b52a-2e95-409c-8635-a2da42ef92ff",
          "title": "My Note",
          "content": "This is my first note",
          "createdAt": "2023-11-28T09:59:31.000Z",
          "updatedAt": "2023-11-28T09:59:31.000Z"
      }
  ]
}

[GET] /api/notes/:id
Request :

curl http://localhost:3000/api/notes/e171b52a-2e95-409c-8635-a2da42ef92ff

Response :

{
  "status": 200,
  "message": "Note retrieved successfully",
  "data": {
      "id": "e171b52a-2e95-409c-8635-a2da42ef92ff",
      "title": "My Note",
      "content": "This is my first note",
      "createdAt": "2023-11-28T09:59:31.000Z",
      "updatedAt": "2023-11-28T09:59:31.000Z"
  }
}

[POST] /api/notes
Request :

curl -H "Content-Type: application/json" \
  -X POST http://localhost:3000/api/notes \
  -d '{"title": "My Note", "content": "This is my first note"}'

Response :

{
  "status": 201,
  "message": "Note created successfully",
  "data": {
      "id": "42362a8e-1141-464b-8a27-f993dcdde5d5",
      "title": "My Note",
      "content": "This is my first note",
      "createdAt": "2023-11-28T10:07:04.274Z",
      "updatedAt": "2023-11-28T10:07:04.274Z"
  }
}

[PUT] /api/notes/:id
Request :

curl -H "Content-Type: application/json" \
  -X PUT http://localhost:3000/api/notes/42362a8e-1141-464b-8a27-f993dcdde5d5 \
  -d '{"title": "Updated note title", "content": "This is updated note content"}'

Response :

{
  "status": 200,
  "message": "Note updated successfully",
  "data": {
      "id": "42362a8e-1141-464b-8a27-f993dcdde5d5",
      "title": "Updated note title",
      "content": "This is updated note content",
      "createdAt": "2023-11-28T10:07:04.274Z",
      "updatedAt": "2023-11-28T10:08:00.000Z"
  }
}

[DELETE] /api/notes/:id
Request :

curl -H "Content-Type: application/json" \
  -X DELETE http://localhost:3000/api/notes/42362a8e-1141-464b-8a27-f993dcdde5d5

Response :

{
  "status": 200,
  "message": "Note deleted successfully",
  "data": {
      "id": "42362a8e-1141-464b-8a27-f993dcdde5d5"
  }
}

Testing

Import Postman environment and collection then run the test, below is the files location:

"postman/Fosclass Notes Api.postman_collection.json"
"postman/Fosclass Notes Api.postman_environment.json"

mfl4 / fosclass-notes-api Goto Github PK