Sequelize-Templates

This project was originally forked from sequelize-auto, but uses a template engine to generate the models.

Generating the tempaltes will generate the template(s) for each table found in the given schema.

Uses jsRender for the template engine.

Install

npm install sequelize-templates

Prerequisites

You will need to install the correct dialect binding globally before using sequelize-templates.

Example for MySQL/MariaDB

npm install -g mysql

Example for Postgres

npm install -g pg pg-hstore

Example for Sqlite3

npm install -g sqlite

Example for MSSQL

npm install -g mssql

See Sequelize for more information

Usage

Sequelize-Templates can be used as a command line utility or can be imported as a node module

Command Line Example

sequelize-templates g templates.json --host localhost

Call sequelize-templates with no parameters for the full list of settings

All settings can be configured in the config file, but the command line takes priority.

Testing

You must setup a database called sequelize_templates_test first, edit the test/config.js file accordingly, and then enter in any of the following:

# for all
npm run test

# mysql only
npm run test-mysql

# postgres only
npm run test-postgres

# postgres native only
npm run test-postgres-native

# sqlite only
npm run test-sqlite