Mocking knex with mock-knex

mock-knex.js

'use strict';

var mockKnex = require('mock-knex');
var knex = require('knex')({
  client: 'mysql',
  connection: {
      host: 'localhost',
      user: 'user',
      password: 'password',
      database: 'database',
      port: 3306
  },
  debug: false
});
var tracker = mockKnex.getTracker();

mockKnex.mock(knex, '[email protected]');

tracker.install();

tracker.on('query', function checkResult(query) {
  console.assert(query.method === 'first');
  query.response([
    {
      fielda: 'A',
      fieldb: 'B'
    },
    {
      fielda: 'C',
      fieldb: 'D'
    },
    {
      fielda: 'E',
      fieldb: 'F'
    }
  ]);
});

knex
  .table('table')
  .first('fielda', 'fieldb')
  .then(function checkFirstArrResults(model) {
    console.log(model.fielda, 'A', model.fielda === 'A');
    console.assert(model.fieldb === 'B');
  });