# sequelize-test-setup

> set up test database and load fixtures with sequelize

Latest version **1.0.0** (published 2019-05-07) · MIT license · 0 weekly downloads

> **Deprecated.** This package is deprecated.

## Install

```sh
npm install sequelize-test-setup
pnpm add sequelize-test-setup
yarn add sequelize-test-setup
bun add sequelize-test-setup
```

## Health

**Score 10/100 (F)** — status: deprecated.

Negative: deprecated.

## Facts

| | |
|---|---|
| Version | 1.0.0 |
| Published | 2019-05-07 |
| First published | 2015-08-12 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 2 |
| Unpacked size | 4.7 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 2 |
| Author | Bound State Software Inc |
| Maintainers | guiltyspark, mikejpeters |
| Keywords | sequelize, test, fixtures, migrations |

## Links

- npm: https://www.npmjs.com/package/sequelize-test-setup
- Repository: https://github.com/boundstate/sequelize-test-setup
- Homepage: https://github.com/boundstate/sequelize-test-setup#readme
- Issues: https://github.com/boundstate/sequelize-test-setup/issues
- npm.io page: https://npm.io/package/sequelize-test-setup

## Dependencies (2)

- [umzug](https://npm.io/package/umzug.md) ^2.2.0
- [sequelize-fixtures](https://npm.io/package/sequelize-fixtures.md) ^0.10.0

## Alternatives

- [duck](https://npm.io/package/duck.md) — 4.2M weekly downloads
- [ava](https://npm.io/package/ava.md) — 560.2K weekly downloads
- [storybook-addon-module-mock](https://npm.io/package/storybook-addon-module-mock.md) — 71.7K weekly downloads
- [@ethereum-waffle/mock-contract](https://npm.io/package/@ethereum-waffle/mock-contract.md) — 40.0K weekly downloads
- [aws-elasticsearch-connector](https://npm.io/package/aws-elasticsearch-connector.md) — 37.4K weekly downloads

## Recent versions

- 1.0.0 (latest) — 2019-05-07
- 0.0.5 — 2019-01-16
- 0.0.4 — 2016-03-21
- 0.0.3 — 2015-08-31
- 0.0.2 — 2015-08-12
- 0.0.1 — 2015-08-12

## README

# 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

```sh
npm install sequelize-test-setup
```

## Usage

```sh
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.

[Sequelize]: http://sequelizejs.com
[sequelize-fixtures]: https://github.com/domasx2/sequelize-fixtures

---
_Source: https://npm.io/package/sequelize-test-setup · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._