Hapi 17 support

[jedireza]

See: https://github.com/hapijs/hapi/issues/3658

[siarcarse]

Have you any notice about this?

[jedireza]

Nothing new yet, I've been time poor. A PR is welcome if anyone gets time before I do.

[mikejerome]

This is very rough but I needed this for a new project so maybe this will help someone get started...

'use strict';

const Hoek = require('hoek');
let Pg = require('pg');

const DEFAULTS = {
  connectionString: undefined,
  attach: 'onPreAuth',
  detach: 'response'
};

exports.plugin = {
  name: 'car-hapi-pg',
  register: function(server, options) {

    const config = Hoek.applyToDefaults(DEFAULTS, options);

    server.ext(config.attach, async (request, h) => {
      const client = new Pg.Client({connectionString: config.connectionString});
      await client.connect();
      console.log('connected to pg');
      request.pg = {
        client
      };

      return h.continue;
    });

    server.events.on(config.detach, (request, err) => {

      if (request.pg) {
        request.pg.client.end().then(() => console.log('client disconnected'));
      }
    });
  }
};