Menggunakan Sequelize CLI

npm install -g sequelize-cli

inisialisasi proyek Sequelize dengan perintah berikut:

sequelize init

Buat Model Sequelize

sequelize model:generate --name Country --attributes id:string(15):primaryKey,name:string,code:string

sequelize model:generate --name Salesorg --attributes id:string,name:string

sequelize model:generate --name Company --attributes name:string,industry:string,countryId:integer

Migrasi Tabel

sequelize db:migrate

Contoh penggunaan di Grapql

Create Data

mutation {
  createCountries(countries: [{id: "IDN", name: "Indonesia", code: "ID"}, {id: "MYS", name: "Malaysia", code: "MY"}]) {
    id
    name
    code
  }
}

Get List Data

{
  getCountries {
    id
    name
    code
  }
}

Update Data

mutation {
  updateCountry(id: "IDN", name: "Indonesia Raya") {
    id
    name
    code
  }
}

Delete Data

 mutation {
  deleteCountry(id: "IDN") {
    id
    name
    code
  }
}

Test By Postman

curl -X POST http://localhost:4000/graphql -H "Content-Type: application/json" -d "{\"query\": \"{ getCountries { id name code }}\"}"