Capture connections errors

[romainberger]

Hi, first thanks for this module!

I was wondering if there is a way to catch errors when creating the connection. With co-pg you can wrap the code in a try/catch block, so I tried the same with koa-pg but it doesn't seem to work:

var database = process.env.DATABASE_URL || 'postgres://user@localhost:5432/database/'
try {
  app.use(koaPg(database))
}
catch (e) {
  console.log('error')
}

I've tried wrapping the koaPg(database) alone too but it's not better. Am I doing this wrong is this not possible at all with this module?

Thanks

[rxw1]

Hi there,

afaik the koa way to catch errors goes like this:

app.use(function*(next) {
  try {
    yield next;
    console.log('db connect success');
  } catch (err) {
    console.error('db connect failure', err);
    throw new Error('DB FAILURE');
  }
});

app.use(pg('postgres://user@localhost/database'));

It must have something to with that try/catch is synchronous and yield/next (or promises) are asynchronous.

Here's a Gist: https://gist.github.com/rwilhelm/aab3270c7c8ffabb18d2