Knex TDD Experiment, as explained at:
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.

Knex TDD Experiments

The purpose of this repo is to experiment with Test-Driven Development (TDD) using Restify, Knex and Mock-Knex as cornerstones of working with an SQL DB system. The code used herein is specific to PostgreSQL, but minor adjustments could be made to enable usage with MySQL and other database systems compatible with Knex.

Problem statement

Using Knex for schema-building can be an amazing tool for tracking changes to database tables and schemas in Node.js. It is also a great tool for setup & teardown in integration tests, but lacks tools for proper mocking of unit tests. This is where Mock-Knex comes in.

Mock-Knex provides functions for assertion libraries to use in unit tests. However, it is unnervingly easy to create non-falsifiable tests unless specific patterns are followed when using Mocha and Chai as the testing framework and assertion library.

The purpose of this experiment is to identify good patterns for use in this combination of libraries, and to explore alternatives that are less brittle.


Each test case is in a seperate hypothesis/* branch depending on the framework(s) being used to test with.