Problem with findMany with many-to-many relations
First, here's my schema file:
import { integer, primaryKey, sqliteTable, text } from 'drizzle-orm/sqlite-core'
import { relations } from 'drizzle-orm'
export const Entries = sqliteTable('Entries', {
Id: integer('Id', { mode: 'number' }).primaryKey({ autoIncrement: true }),
PersonId: integer('PersonId', { mode: 'number' }).notNull(),
Content: text('Content').notNull(),
Timestamp: text('Timestamp').notNull(),
})
export const EntriesRelations = relations(Entries, ({ many }) => ({
EntriesTags: many(EntriesTags),
}))
export const Tags = sqliteTable('Tags', {
Id: integer('Id', { mode: 'number' }).primaryKey({ autoIncrement: true }),
Tag: text('Tag').notNull(),
})
export const TagsRelations = relations(Tags, ({ many }) => ({
EntriesTags: many(EntriesTags),
}))
export const EntriesTags = sqliteTable(
'EntriesTags',
{
EntryId: integer('EntryId', { mode: 'number' })
.notNull()
.references(() => Entries.Id),
TagId: integer('TagId', { mode: 'number' })
.notNull()
.references(() => Tags.Id),
},
(t) => ({
pk: primaryKey({ columns: [t.EntryId, t.TagId] }),
})
)
export const EntriesTagsRelations = relations(
EntriesTags,
({ one }) => ({
Entry: one(Entries, {
fields: [EntriesTags.EntryId],
references: [Entries.Id],
}),
Tag: one(Tags, {
fields: [EntriesTags.TagId],
references: [Tags.Id],
}),
})
)
