使用sequelize-typescript调用Street.create()时遇类型匹配错误求助

问题现象 #

调用Street.create(obj)时出现类型错误：

参数类型'plainObject'无法赋值给类型'Optional<Street, NullishPropertiesOf>'。类型'plainObject'缺少类型'Omit<Street, NullishPropertiesOf>'中的sequelize、destroy、restore、update及另外39个属性。

对应的Street模型代码 #

import { Table, Model, Column, PrimaryKey } from 'sequelize-typescript';

@Table({ timestamps: false, tableName: 'street' })
class Street extends Model<Street> {
    @PrimaryKey
    @Column
    street_id: string;

    @Column
    location_id: string;

    @Column
    location_symbol: string;

    @Column
    street_name: string;

    @Column
    street_synonym: string;

    @Column
    street_symbol: string;

    @Column
    updated: Date;
}

export default Street;

调用代码 #

Street.create({
    location_id: 'string',
    location_symbol: 'string',
    street_name: 'string',
    street_synonym: 'string',
    street_id: 'string',
    street_symbol: 'string',
    updated: new Date(),
});

解决方法 #

问题出在Model的泛型参数定义上。原代码中Street extends Model<Street>仅指定了实例属性类型，导致create方法错误地期望传入包含Model所有内置方法（如sequelize、destroy等）的完整实例对象，而非纯数据对象。

只需修改模型类的泛型参数，显式指定创建时的属性类型（排除Model自带的方法和属性）：

修改后的Street模型 #

import { Table, Model, Column, PrimaryKey } from 'sequelize-typescript';

@Table({ timestamps: false, tableName: 'street' })
// 第二个泛型参数指定创建时的属性类型：排除Model自带的所有属性
class Street extends Model<Street, Omit<Street, keyof Model>> {
    @PrimaryKey
    @Column
    street_id: string;

    @Column
    location_id: string;

    @Column
    location_symbol: string;

    @Column
    street_name: string;

    @Column
    street_synonym: string;

    @Column
    street_symbol: string;

    @Column
    updated: Date;
}

export default Street;

或者提前定义创建类型，让代码更清晰：

import { Table, Model, Column, PrimaryKey } from 'sequelize-typescript';

// 定义创建Street所需的纯数据属性类型
type StreetCreationAttributes = Omit<Street, keyof Model>;

@Table({ timestamps: false, tableName: 'street' })
class Street extends Model<Street, StreetCreationAttributes> {
    @PrimaryKey
    @Column
    street_id: string;

    @Column
    location_id: string;

    @Column
    location_symbol: string;

    @Column
    street_name: string;

    @Column
    street_synonym: string;

    @Column
    street_symbol: string;

    @Column
    updated: Date;
}

export default Street;

修改后，create方法就能正确识别传入的纯数据对象类型，类型错误会消失。

内容的提问来源于stack exchange，提问作者Avi E. Koenig