Method defineModel

packages/node-core/src/indexer/store.service.ts:250–294

(
    model: GraphQLModelsType,
    attributes: ModelAttributes<any>,
    indexes: IndexesOptions[],
    schema: string
  )

  }

  defineModel(
    model: GraphQLModelsType,
    attributes: ModelAttributes<any>,
    indexes: IndexesOptions[],
    schema: string
  ): ModelStatic<any> {
    const sequelizeModel = this.sequelize.define(model.name, attributes, {
      underscored: true,
      comment: model.description,
      freezeTableName: false,
      timestamps: false,
      schema,
      indexes,
    });

    if (this.historical) {
      // WARNING these hooks depend on `this.blockHeight` which is a changing value. DO NOT move this into a function outside of this class
      sequelizeModel.addScope('defaultScope', {
        attributes: {
          exclude: ['__id', '__block_range'],
        },
      });

      sequelizeModel.addHook('beforeFind', (options) => {
        (options.where as any).__block_range = {
          [Op.contains]: this.getHistoricalUnit(),
        };
      });
      sequelizeModel.addHook('beforeValidate', (attributes, options) => {
        attributes.__block_range = [this.getHistoricalUnit(), null];
      });

      if (!this.config.enableCache) {
        sequelizeModel.addHook('beforeBulkCreate', (instances, options) => {
          instances.forEach((item) => {
            item.__block_range = [this.getHistoricalUnit(), null];
          });
        });
      }
      // TODO, remove id and block_range constraint, check id manually
      // see https://github.com/subquery/subql/issues/1542
    }

    return sequelizeModel;
  }

  private async useDeprecatePoi(schema: string): Promise<boolean> {
    const sql = `SELECT * FROM information_schema.columns WHERE table_schema = ? AND table_name = '_poi' AND column_name = 'projectId'`;