Nodejs sequelize cli 使用介紹

Sequelize CLI

1. 安裝cli環境

$npm install --save sequelize-cli or $npm install —g sequelize-cli
$npm install — g mysql2

or

$sequelize init — force

若db名稱需要自訂，則去config的config.json裡修改
http://logdown.com/account/posts/2069083-nodejs-sequelize-cli-using/edit#help

Ex:

$sequelize model:create — name User — attributes first_name:string,last_name:string,bio:text

Ex:

$sequelize model:create — name User — attributes first_name:string,last_name:string,bio:text — force (若原本已存在model — force 則強制修改)

當創建model時，會在models 和 migrations資料夾裡自動新增程式，
migrations資料夾紀錄model修改後的table

$sequelize db:migrate

則在DB新增table完成

查詢seed功能

$sequelize help:seed:create

新增seed的js檔， — name 檔案名
Ex:

$sequelize seed:create — name member

執行所有seed檔，新增假資料進db
Ex:

$sequelize db:seed:all

Author : Eric Hong (eric@appmaster.cc)