Knex.js Middleware for Koa. Package is versioned in step with http://knexjs.org/#changelog
0. Installation (via npm)
$ npm install koa-knex --save var _ = require('koa-route');
var knex = require('koa-knex');
...
app.use(knex({
client: 'pg',
connection: {
/** typical knex connection object */
}
});
app.use(_.get('/:userid', function *(userid) {
this.body = {
profile: yield this.knex('users').where('id', userid);
};
});The following environment variables will be automatically used for the Knex.js connection object if set:
KOA_KNEX_HOST
KOA_KNEX_PORT
KOA_KNEX_USER
KOA_KNEX_PASSWORD
KOA_KNEX_DATABASE
KOA_KNEX_CHARSET
KOA_KNEX_SSL
KOA_KNEX_DEBUG