Skip to content

Latest commit

 

History

History
39 lines (28 loc) · 1.12 KB

README.md

File metadata and controls

39 lines (28 loc) · 1.12 KB
Raw

Sequelize Test Setup

Tool for setting up a test database and loading fixtures with Sequelize.

It runs migrations and destroys all models before loading the fixtures via sequelize-fixtures.

Install

npm install sequelize-test-setup

Usage

var sequelizeTestSetup = require('sequelize-test-setup');
var models = require('./models');
sequelizeTestSetup({
  sequelize: models.sequelize,
  models: models,
  migrationsPath: 'migrations',
  fixtures: ['fixtures/test_data.json']
});

Options

  • sequelize Sequelize - Sequelize instance
  • models Array - Sequelize models
  • migrationsPath String - path to migrations
  • fixtures Array - fixture filenames to load via sequelize-fixtures
  • truncate Boolean - use TRUNCATE instead of DELETE queries (default: true)

Tips

MySQL does not support using TRUNCATE TABLE for an InnoDB table if there are any FOREIGN KEY constraints. If you get ER_TRUNCATE_ILLEGAL_FK errors you should set truncate to false to use DELETE queries instead.