DbApi - Game API Router

[russleyshaw]

file: /dbapi/src/routers/api/game.ts

The express router needs to be developed for the gamelog router api

NOTE: Schemas must also be developed at /dbapi/src/schemas/game.ts. A schema should be created for each use of params, query, or body in the express router

import { Validator } from 'jsonschema';
import { team as schemas } from '../../schemas';

let v: Validator = new Validator();

let result = v.validate(thing, schemas.getTeamParams);
if(result.errors.length > 0) {
    return foo('did bad');
}

NOTE: Make sure to add the exported router to /dbapi/src/routers/api/index.ts. Then, if the dbapi/src/routers folder is imported as routers, it can be retrieved as routers.api.game

NOTE: Currently, the gamelog itself is stored in the game table. Endpoints should not return (or even SELECT at the SQL level) for the gamelog column as it will only slow things down. Add seperate endpoints for adding and getting gamelogs

Endpoints

• [ ] GET /api/v2/game/:id/
  • Get a game based on id. Should not select for gamelog column
• [ ] GET /api/v2/game/:id/gamelog/
  • Get a gamelog based on a game id
• [ ] GET /api/v2/game/
  • Get a list of games based on query parameters
  • Example: /api/v2/game/?teams=1&teams=2&status=finished
    • Gets all the finished games where teams 1 and 2 played each other
• [ ] POST /api/v2/game/
  • Creates a new game from the request body. Should not accept gamelog column
• [ ] POST /api/v2/game/:id/
  • Updates a game, given by id, from the request body. Should not accept gamelog column
• [ ] POST /api/v2/game/:id/gamelog/
  • Creates/Updates a gamelog for a game, given by id, from the request body.