This is part of Academy's technical curriculum for The Mark. All parts of that curriculum, including this project, are licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

This is starting code for a very simple guestbook API, inspired by a similar one in the http conventions project, but simpler.

It is not currently working - you must fix it by adding code to execute queries read from and write to the database, using the node-postgres ('pg') library.

• Create a database called guestbook

sudo -u postgres createdb guestbook

• In that new database, run the commands in db/create_tables.sql, to create a table.
• Run yarn to install the project dependencies!
• Run with yarn start:dev

• When the API user sends a signature it should contain two strings:

  • name (a mandatory string, such as 'Grace Hopper')
  • message (an optional string, such as 'Hello World')

• When the API returns signatures from the database, the signatures will also contain:

  • id: an integer
  • time: a timestamp describing when this signature was added to the guestbook.

Find all the lines of code that have the comment //FIXME-TASK

At each of these locations, write code to execute SQL commands to read from, insert, update, or delete table rows in the database, as appropriate.

Test your server manually with Postman.

There is a Postman collection file in this repo, here. Optionally, this can be imported into Postman to quickly give you some requests to use in testing. Or you can just create Postman requests as normal.