Live coding practice interview question

Overview

This is a FullStack Todo Application, the client is based on Todo MVC

• Stack:
  • Client: Basic jQuery selectors, event-handlers, DOM manipulation and AJAX
  • Web Server: Node and Express with PostgreSQL
  • Database: Locally hosted PostgreSQL
  • Tests: Supertest, Chai

The Rules

As in previous interviews, you may consult official docs and reference-style resources during this coding challenge. You are encouraged to work through as much of it on your own as you can.

Setup

• Clone this repository to your local machine
  • git clone https://github.com/Thinkful-Ed/todo-router.git
• Install the dependencies for the project
  • npm install
• Ensure your PostgreSQL server is running
  • pg_ctl start
• Create a User for this exercise
  • createuser --interactive owner
  • createuser = command
  • ineractive
    • Shall the new role be a superuser? (y/n) n
    • Shall the new role be allowed to create databases? (y/n) y
    • Shall the new role be allowed to create more new roles? (y/n) n
  • owner = username
• Create a database for the exercise with your user as the owner
  • createdb --owner=owner todo
• Rename the example.env file to .env and update the following fields with your database credentials:

   MIGRATION_DB_NAME=
   MIGRATION_DB_USER=
   MIGRATION_DB_PASS=
   DB_URL="postgresql://USERNAME@localhost/DATABASE_NAME"
  

• Run the command npm run migrate -- 1 to create the database tables
• run the command npm t
• You should see output from 10 integration tests, all will be passing.

Exercise

• Todo Router
  • Create a new file name todo-router.js in the todo directory
  • Move all the endpoints from app.js to todo-router.js
  • Require the proper modules into todo-router.js and export the router
  • In app.js, mount the router on /v1/todos/ path (aka mount point)
  • Remember to update the paths on the router files.

You have completed the task when all the unit tests pass and the client application works without any errors.