CRUD.js

'use strict';

const router = require('koa-router')({prefix: '/hooks'});
module.exports = router.routes();

router
  .post('/', function*() {
    yield this.db.raw('SELECT * FROM events_create(?, ?)', [this.request.body.webhookEvent, this.request.body]);
    this.body = {};
  })
  .get('/', function*() {
    const limit = this.request.query.limit;
    const page = this.request.query.page;
    const result = yield this.db.raw('SELECT * FROM events_list(?, ?)', [page, limit]);
    this.body = result.rows;
  })
  .get('/count', function*() {
    const result = yield this.db.raw('SELECT * FROM events_count()');
    this.body = result.rows[0];
  });