TypeError: Cannot read properties of undefined (reading 'referencedTable')
C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\relations.ts:571
const referencedTableTsName = tableNamesMap[getTableUniqueName(relation.referencedTable)];
^
TypeError: Cannot read properties of undefined (reading 'referencedTable')
at normalizeRelation (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\relations.ts:571:74)
at SQLiteAsyncDialect.buildRelationalQuery (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\sqlite-core\dialect.ts:673:32)
at QueryPromise._toSQL (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\sqlite-core\query-builders\query.ts:169:30)
at QueryPromise._prepare (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\sqlite-core\query-builders\query.ts:145:38)
at QueryPromise.executeRaw (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\sqlite-core\query-builders\query.ts:193:15)
at QueryPromise.execute (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\sqlite-core\query-builders\query.ts:197:15)
at QueryPromise.then (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\query-promise.ts:31:15)
C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\relations.ts:571
const referencedTableTsName = tableNamesMap[getTableUniqueName(relation.referencedTable)];
^
TypeError: Cannot read properties of undefined (reading 'referencedTable')
at normalizeRelation (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\relations.ts:571:74)
at SQLiteAsyncDialect.buildRelationalQuery (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\sqlite-core\dialect.ts:673:32)
at QueryPromise._toSQL (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\sqlite-core\query-builders\query.ts:169:30)
at QueryPromise._prepare (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\sqlite-core\query-builders\query.ts:145:38)
at QueryPromise.executeRaw (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\sqlite-core\query-builders\query.ts:193:15)
at QueryPromise.execute (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\sqlite-core\query-builders\query.ts:197:15)
at QueryPromise.then (C:\Users\Wiktor\WebstormProjects\verzio\node_modules\src\query-promise.ts:31:15)
const builder = await db.query.files.findMany({
with: {
versions: true
}
})
const builder = await db.query.files.findMany({
with: {
versions: true
}
})
1 Reply
schema.ts
relations.ts
export const versions = sqliteTable("versions", {
id: int("id").primaryKey({ autoIncrement: true }),
version: text("version").notNull(),
fileId: text("file_id")
.notNull()
.references(() => files.id, { onDelete: "cascade", onUpdate: "cascade" }),
});
export const files = sqliteTable("files", {
id: text("id").primaryKey().unique(),
originalName: text(),
name: text().notNull(),
description: text().notNull(),
categoryId: text("category_id")
.notNull()
.references(() => categories.id, { onDelete: "cascade", onUpdate: "cascade" }),
});
export const versions = sqliteTable("versions", {
id: int("id").primaryKey({ autoIncrement: true }),
version: text("version").notNull(),
fileId: text("file_id")
.notNull()
.references(() => files.id, { onDelete: "cascade", onUpdate: "cascade" }),
});
export const files = sqliteTable("files", {
id: text("id").primaryKey().unique(),
originalName: text(),
name: text().notNull(),
description: text().notNull(),
categoryId: text("category_id")
.notNull()
.references(() => categories.id, { onDelete: "cascade", onUpdate: "cascade" }),
});
export const filesRelations = relations(files, ({ one, many }) => ({
category: one(categories, {
fields: [files.categoryId],
references: [categories.id],
}),
versions: many(versions)
}));
export const versionsRelations = relations(versions, ({ one }) => ({
file: one(files, {
fields: [versions.fileId],
references: [files.id],
}),
}));
export const filesRelations = relations(files, ({ one, many }) => ({
category: one(categories, {
fields: [files.categoryId],
references: [categories.id],
}),
versions: many(versions)
}));
export const versionsRelations = relations(versions, ({ one }) => ({
file: one(files, {
fields: [versions.fileId],
references: [files.id],
}),
}));