rykr
Explore posts from serversDTDrizzle Team
•Created by rykr on 3/24/2025 in #help
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"'.
4 replies
DTDrizzle Team
•Created by rykr on 3/21/2025 in #help
do I still need to use drizzle-kit?
I"m not doing any migrations or generation. Just doing selects, inserts, and updates into existing tables. I have most everything working and didn't instal drizzle-kit. But not sure how to do relations so not sure if drizzle-kit plays a part there?
2 replies