Set up knex db-manager

[zkwsk]

Set up knex-db-manager to make it easy to truncate the database from npm scripts. Replace the db:clean job that is currently relying on migrations with truncating the DB. Alter the test that is using db:clean to test the it is possible to migrate down to use knex db:migrate down instead.

Reason being that while developing migrations locally, you can easily end up in an inconsistent state (your up and down migrations did not actually match) so the recommended practice is to truncate before each run locally.

https://github.com/Vincit/knex-db-manager

[senner007]

What would be the best approach to do testing with knex? I understand that the knex-manager can clear the database on each setup and teardown, but what about the time penalty after say a 100 tests using this approach. You could create stubs to replace the db, but it wouldn't be the same.

[senner007]

I made a setup using knex manager and parallel thread testing with docker and jest.
Here
https://github.com/senner007/Simple-api-with-parallel-integration-tests