src/app/model 里面定义数据库模型
sequelize.define 定义模型

  1. sequelize.define('model_name',{filed:value})

创建表

  1. 首先定义模型： model
  2. 然后同步：model.sync()
  3. 创建表会自动创建主键，默认为 id，自增长

Object.keys(app)

  1.  [
  2.   '_events',
  3.   '_eventsCount',
  4.   '_maxListeners',
  5.   'subdomainOffset',
  6.   'proxyIpHeader',
  7.   'maxIpsCount',
  8.   'middleware',
  9.   'context',
  10.   'request',
  11.   'response',
  12.   'timing',
  13.   'options',
  14.   '_options',
  15.   'console',
  16.   'BaseContextClass',
  17.   'Controller',
  18.   'Service',
  19.   'lifecycle',
  20.   'loader',
  21.   'ContextCookies',
  22.   'ContextLogger',
  23.   'ContextHttpClient',
  24.   'HttpClient',
  25.   'messenger',
  26.   '_unhandledRejectionHandler',
  27.   'cluster',
  28.   'Subscription',
  29.   'BaseHookClass',
  30.   'Boot',
  31.   'safeCurl',
  32.   'ScheduleStrategy',
  33.   'TimerScheduleStrategy',
  34.   'schedule',
  35.   'LogRotator',
  36.   'watcher',
  37.   'Sequelize'
  38. ]

Model

image.png

  1. import { Application } from 'egg';
  2. import * as uuidv4 from 'uuid/v4';
  4. /** 用户资料表，修改邮箱和手机号时，需要同步到userAuth表 */
  5. export default function(app: Application) {
  6.   const { STRING, BOOLEAN, DATE, UUID, ARRAY } = app.Sequelize;
  7.   const tableName = 'user';
  9.   const User = app.model.define(
  10.     tableName,
  11.     {
  12.       id: {
  13.         type: UUID,
  14.         unique: true,
  15.         primaryKey: true,
  16.         allowNull: false,
  17.         defaultValue: () => {
  18.           return uuidv4().replace(/-/g, '');
  19.         },
  20.       },
  21.       username: {
  22.         type: STRING(32),
  23.         unique: true,
  24.         allowNull: false,
  25.         comment: '用户名',
  26.       },
  27.       password: {
  28.         type: STRING(255),
  29.         allowNull: false,
  30.         comment: '密码',
  31.       },
  32.       email: {
  33.         type: STRING(64),
  34.         unique: true,
  35.         allowNull: true,
  36.         comment: '邮箱地址',
  37.       },
  38.       phone: {
  39.         type: STRING(20),
  40.         unique: true,
  41.         allowNull: true,
  42.         comment: '手机号码',
  43.       },
  44.       avatar: {
  45.         type: STRING(150),
  46.         allowNull: true,
  47.         comment: '头像',
  48.       },
  49.       alias: {
  50.         type: STRING(30),
  51.         comment: '别名',
  52.       },
  53.       realName: {
  54.         type: STRING(30),
  55.         allowNull: true,
  56.         comment: '真实姓名',
  57.       },
  58.       signature: {
  59.         type: STRING(255),
  60.         allowNull: true,
  61.         comment: '签名',
  62.       },
  63.       status: {
  64.         type: BOOLEAN,
  65.         allowNull: false,
  66.         defaultValue: 1,
  67.         comment: '用户状态: 1 正常； 0 禁用',
  68.       },
  69.       lastActivedAt: DATE,
  70.       createdAt: DATE,
  71.       updatedAt: DATE,
  72.     },
  73.     {
  74.       tableName,
  75.       comment: '用户表',
  76.       timestamps: true,
  77.       underscored: false,
  78.     }
  79.   );
  81.   class UserModal extends User {
  82.     id: string;
  83.     username: string;
  84.     email: string;
  85.     phone: string;
  86.     avatar: string;
  87.     alias: string;
  88.     realName: string;
  89.     signature: string;
  90.     status: boolean;
  91.     roles: any[];
  92.     lastActivedAt: number;
  93.     static associate() {
  94.       app.model.User.hasMany(app.model.UserAuth, { as: 'userAuths', sourceKey: 'id', foreignKey: 'userId' });
  95.       app.model.User.belongsToMany(app.model.Role, { as: 'roles', through: app.model.UserRoleRelation, foreignKey: 'userId' });
  96.     }
  97.   }
  99.   return UserModal;
  100. }

Model属性和方法

https://sequelize.org/master/class/lib/model.js~Model.html

  1. instance.field
  3. // is the same as
  4. instance.get('field')
  6. // is the same as
  7. instance.getDataValue('field')