sequelize

• sequelize/sequelizeGitHubsequelize/sequelizesequelize/sequelize · src/query-types.ts · 依赖 · dottie · 对象路径 · validator · 验证 · inflection, lodash, moment · 参考 · v7 · sequelize -> @sequelize/core笔记：sequelize
• src/query-types.tsGitHub Filesequelize/sequelize/src/query-types.ts
• 依赖Linkdeps.dev/npm/sequelizesequelize/sequelize · src/query-types.ts · 依赖 · dottie · 对象路径 · validator · 验证 · inflection, lodash, moment · 参考 · v7 · sequelize -> @sequelize/core笔记：sequelize
  • dottieGitHubmickhansen/dottie.js
    • 对象路径
  • validatorGitHubvalidatorjs/validator.js
    • 验证
  • inflection, lodash, moment
• 参考
  • v7
    • sequelize -> @sequelize/core
    • nodejs 14+, ts 4.4+
  • demopark/sequelize-docs-Zh-CNGitHubdemopark/sequelize-docs-Zh-CNsequelize/sequelize · src/query-types.ts · 依赖 · dottie · 对象路径 · validator · 验证 · inflection, lodash, moment · 参考 · v7 · sequelize -> @sequelize/core笔记：sequelize
    • demopark.github.io/sequelize-docs-Zh-CN
  • umzugGitHubsequelize/umzugsequelize/umzug · MIT, TS笔记：umzug
    • migration
  • sequelize-autoGitHubsequelize/sequelize-autosequelize/sequelize · src/query-types.ts · 依赖 · dottie · 对象路径 · validator · 验证 · inflection, lodash, moment · 参考 · v7 · sequelize -> @sequelize/core笔记：sequelize
    • db schema -> sequelize schema
  • sequelize-cliGitHubsequelize/cli
  • sequelize.org/docs/v7/other-topics/resources
  • sequelize/sequelize-typescriptGitHubsequelize/sequelize-typescript
    • 注解支持 - 类似 typeorm
    • 会合并到 v7 #15334GitHub Issuesequelize/sequelize#15334
• used by
  • nocobaseGitHubnocobase/nocobase
  • atulmy/crateGitHubatulmy/crate

# v7
npm add @sequelize/core

Packages@sequelize/corenpm Package@sequelize/coreNPM

export enum QueryTypes {
  SELECT = 'SELECT',
  INSERT = 'INSERT',
  UPDATE = 'UPDATE',
  BULKUPDATE = 'BULKUPDATE',
  BULKDELETE = 'BULKDELETE',
  DELETE = 'DELETE',
  UPSERT = 'UPSERT',
  VERSION = 'VERSION',
  SHOWTABLES = 'SHOWTABLES',
  SHOWINDEXES = 'SHOWINDEXES',
  DESCRIBE = 'DESCRIBE',
  RAW = 'RAW',
  FOREIGNKEYS = 'FOREIGNKEYS',
  SHOWCONSTRAINTS = 'SHOWCONSTRAINTS',
}

builkUpsert

Model.bulkCreate([], { updateOnDuplicate: ['user_id', 'token', 'created_at'] });

sequelize-cli

• 不支持 typescript sequelize/cli#328GitHub Issuesequelize/cli#328

npm add sequelize
npm add -D sequelize-cli

# config/config.json
# models
# migrations
# seeders
npx sequelize init

# 生成模型
# 会生成 migrations
npx sequelize model:create --name User --attributes name:string,state:boolean,birth:date,card:integer,role:enum:'{Admin,Guest}'

Packagessequelizenpm PackagesequelizeNPMsequelize-clinpm Packagesequelize-cliNPM

{
  "development": {
    "username": "root",
    "password": null,
    "database": "database_development",
    "host": "127.0.0.1",
    "dialect": "mysql"
  }
}

• --env
  • development
  • test
  • production
• --url

API

• order

The number NaN cannot be converted to a BigInt because it is not an integer

• sequelize/sequelize#1774GitHub Issuesequelize/sequelize#1774