Skip to content

boiawang/sequelize-db-export-import

Repository files navigation

Sequelize-DB-Export-Import

Build Status

Generate models files from db or generate tables from models.

Only mysql

cmd


preview

Install

npm install -g sequelize-db-export-import

Usage

seq-ei Create models by database or Create tables by models

-h, --help            output usage information
-V, --version         output the version number
-r, --reverse         is generate model files or generate tables
-H, --host <n>        host ip default: 127.0.0.1
-u, --user <n>        host user default: root
-p, --password <n>    host password. default: ""
-d, --database <n>    database name
-o, --output <dir>    select models dir
-m, --dialect <n>     db type
-P, --port <n>        db port. default: 3306
-e, --compile <type>  model file type
-c, --config <file>   config file
-C, --camel           convert tableName and file to camelCase
-s, --space <n>       you can select 2 space or 4 space
--no-default-value    exclude default data values

Export models from db

seq-ei -H 192.168.1.220 -u root -p 123 -d test -o ./models -m mysql -P 3306 -e coffee -s 2

Import tables from model files

seq-ei -r -H 192.168.1.220 -u root -p 123 -d test -o ./models -m mysql -P 3306 -e coffee -s 2

Also use config file

config.json

{
  "user": "root",
  "password": "",
  "host": "127.0.0.1",
  "database": "test",
  "dir": "./models",
  "port": 3306,
  "compile": "coffee",
  "logging": false,
  "space": 2,
  "reverse": false
}
seq-ei -c config.json

Test

# test all
make test

# test coverage
make test-cov

# test watch
make test-watch

Todo

  • postgres
  • add cmd color
  • add table output

License

The MIT License