can someone help me with this relation?
export const Worklog = mysqlTable('tasks', {
id: int().primaryKey().autoincrement(),
... other columns ...
categoryId: int("catid").notNull().references(() => WorklogCategory.id),
.. other columns...
})
export const WorklogCategory = mysqlTable('categories', {
id: int().primaryKey().autoincrement(),
.. other columns...
});
export const WorklogRelations = relations(Worklog, ({ one }) => ({
Worklog: one(Worklog, { fields: [Worklog.categoryId], references: [WorklogCategory.id]})
}))
This last one shows the following error:
Type 'MySqlColumn<{ name: "id"; tableName: "categories"; dataType: "number"; columnType: "MySqlInt"; data: number; driverParam: string | number; notNull: true; hasDefault: true; isPrimaryKey: true; isAutoincrement: true; ... 4 more ...; generated: undefined; }, {}, {}>' is not assignable to type 'AnyColumn<{ tableName: "tasks"; }>'.
Types of property '' are incompatible.
Type 'ColumnTypeConfig<{ name: "id"; tableName: "categories"; dataType: "number"; columnType: "MySqlInt"; data: number; driverParam: string | number; notNull: true; hasDefault: true; isPrimaryKey: true; isAutoincrement: true; ... 4 more ...; generated: undefined; }, {} & { ...; }>' is not assignable to type 'ColumnTypeConfig<Required<Update<ColumnBaseConfig<ColumnDataType, string>, { tableName: "tasks"; }>>, object>'.
Type 'ColumnTypeConfig<{ name: "id"; tableName: "categories"; dataType: "number"; columnType: "MySqlInt"; data: number; driverParam: string | number; notNull: true; hasDefault: true; isPrimaryKey: true; isAutoincrement: true; ... 4 more ...; generated: undefined; }, {} & { ...; }>' is not assignable to type 'Required<Update<ColumnBaseConfig<ColumnDataType, string>, { tableName: "tasks"; }>>'.
Types of property 'tableName' are incompatible.
Type '"categories"' is not assignable to type '"tasks"'.
1 Reply
punted to select with inner join but really want to use the relation
no idea what's wrong
I"m using a relation in a different area with no issue. they appear to be identical but this one has some weird error message that I don't undersatnd