index.js

const express = require('express');
const helmet = require('helmet');

const knex = require('knex');
const knexConfig = require('./knexfile.js');
const db = knex(knexConfig.development);

const cors = require('cors');
const corsOptions = {
    origin: '*',
    optionsSuccessStatus: 200 // some legacy browsers (IE11, various SmartTVs) choke on 204
}

const server = express();

server.use(express.json());
server.use(helmet());
server.use(cors(corsOptions));

const port = 8000;
server.listen(port, () => console.log(`API running on port ${port}`));

// sanity check
server.get('/', (request, response) => {
    response.send('Server initialized.');
});

// POST request
server.post('/api/notes', (request, response) => {
    const title = request.body.title;
    const content = request.body.content;
    const newNote = { title, content };

    db
        .insert(newNote)
        .into('notes')
        .then(ids => {
            return response
                .status(201)
                .json(ids[0]);
        })
        .catch(() => {
            return response
                .status(500)
                .json({ Error: "There was an error while saving the note" })
        });
});

server.get('/api/notes', (request, response) => {
    db('notes')
        .then(notes => {
            return response
                .status(200)
                .json(notes);
        })
        .catch(() => {
            return response
                .status(500)
                .json({ Error: "Could not find list of notes." })
        });
});

server.get('/api/notes/:id', (request, response) => {
    const id = request.params.id;

    db('notes')
        .where({ id })
        .then(note => {
            return response
                .status(200)
                .json(note);
        })
        .catch(() => {
            return response
                .status(500)
                .json({ Error: "Note info could not be retrieved." })
        });
});

server.put('/api/notes/:id', (request, response) => {
    const id = request.params.id;
    const title = request.body.title;
    const content = request.body.content;
    const updatedNote = { title, content };

    db('notes')
        .where('id', '=', id)
        .update(updatedNote)
        .then(note => {
            return response
                .status(200)
                .json(note);
        })
        .catch(() => {
            return response
                .status(500)
                .json({ Error: "The note info could not be modified" })
        });
});

server.delete('/api/notes/:id', (request, response) => {
    const id = request.params.id;

    db('notes')
        .where({ id })
        .del()
        .then(removedNote => {
            return response
                .status(200)
                .json(removedNote);
        })
        .catch(() => {
            return response
                .status(500)
                .json({ Error: "The note could not be removed" })
        });
});