Creating a one-to-many relationship between a User and a Product using sequelize-typescript.
Below are the Models:
Product.ts
@Table
export class Product extends Model {
@Column({ primaryKey: true })
id!: string
@Column
title!: string
@Column({ type: DataType.DOUBLE })
price!: number
@Column
imageUrl!: string
@Column
description?: string
@ForeignKey(() => User)
@Column
userId?: string
@BelongsTo(() => User)
user?: User
}
User.ts
@Table
export class User extends Model {
@Column({ primaryKey: true })
id!: string
@Column
name!: string
@Column
email!: string
@Column
@HasMany(() => Product)
products?: Product[]
}
Encountering the error message below:
Specified type of property 'products' cannot be automatically resolved to a sequelize data type. Please define the data type manually
Here's the full stack trace:
*ProjectPath*/node_modules/sequelize-typescript/dist/model/shared/model-service.js:64
throw new Error(`Specified type of property '${propertyName}'
^
Error: Specified type of property 'products'
cannot be automatically resolved to a sequelize data type. Please
define the data type manually
at Object.getSequelizeTypeByDesignType (*ProjectPath*/node_modules/sequelize-typescript/dist/model/shared/model-service.js:64:11)
at annotate (*ProjectPath*/node_modules/sequelize-typescript/dist/model/column/column.js:32:44)
at Column (*ProjectPath*/node_modules/sequelize-typescript/dist/model/column/column.js:14:9)
at DecorateProperty (*ProjectPath*/node_modules/reflect-metadata/Reflect.js:553:33)
at Object.decorate (*ProjectPath*/node_modules/reflect-metadata/Reflect.js:123:24)
at __decorate (*ProjectPath*/src/models/user.ts:4:92)
at Object.<anonymous> (*ProjectPath*/src/models/user.ts:27:5)
at Module._compile (internal/modules/cjs/loader.js:1156:30)
at Module.m._compile (*ProjectPath*/node_modules/ts-node/src/index.ts:1043:23)
at Module._extensions..js (internal/modules/cjs/loader.js:1176:10)
Any assistance on this matter would be highly appreciated.