bookshelf-fixture-loader

Bookshelf fixtures loader

Installation

npm install bookshelf-fixture-loader --save-dev

Usage

Fixture file format is inspired by Django fixture file format.

fixtures/test.yaml

- id: 2
  model: 'Test'
  fields:
    name: 'test 2'

fixtures/test.json

[
  {
    "id": 1,
    "model": "Test",
    "fields": {
      "name": "test 1"
    }
  }
]

In test file:

var knex = require('knex')({
  client: 'sqlite3',
  connection: {
    filename: ':memory:'
  },
  useNullAsDefault: true
});

var bookshelf = require('bookshelf')(knex);
bookshelf.plugin('registry');

var BookshelfFixtureLoader = require('bookshelf-fixture-loader')(bookshelf, __dirname);

describe('BookshelfFixtureLoader', function() {
  it('should load json file', function() {
    BookshelfFixtureLoader('test.json');

    var Model = bookshelf.model('Test');
    Model.forge({id: 1}).fetch().then(function(row) {
      row.get('name').should.equal('test 1');
    });
  });
});

or define absolute path:

BookshelfFixtureLoader('/path/to/fixtures/test.yaml');