tbaraza/housing-api

An api for management of rental houses

housing-api's Issues

Create houses model, controllers and routes

• House model should have the following properties
  - name
  - location
  - created_at
  - updated_at
• The routes
  - The route name should be/houses
  - Create routes to
  - fetch all houses
  - fetch one house
  - create a house
  - update a house
• Add tests

Set up dev env

• Set up the server using hapi.js
• Set up eslint
• Set up tests
• Set up nodemon
• Set up npm scripts for starting the server, running coverage and tests
• Set up CircleCI
• Set up Objection.js

Implement soft delete

Currently, once a record is deleted, it's permanently deleted from the database. It will be great to have a soft delete whereby a deleted_at column is added. instead.

Create model, routes and controllers for rooms

• Rooms model should have the following properties
  - room_number
  - house_id
  - room_number
  - status -> 0 - vacant, 1 - occupied, 2 - under renovation
  - tenant_id
  - created_at
  - updated_at

• The routes
  - The route name should be/rooms
  - Create routes to
  - fetch all rooms
  - fetch one room
  - create a room
  - update a room

• Add tests

Create model, controllers and routes for tenants

• Tenants model should have the following properties
  - id
  - first_name
  - last_name
  - national_id_number
  - created_at
  - updated_at

• The routes
  - The route name should be/tenants
  - Create routes to
  - fetch all tenants
  - fetch one tenant
  - create a tenant
  - update a tenant

• Add tests

Add a route for assigning a tenant to a room

This involves:

• adding a tenant_id column to the rooms table
• creating a tenant assignment routes
• add tests