Add conditions on relationships

Is it possible to add conditions when declaring relationships?

In my example, I have books that have many resources. And one of those resources might be marked as the 'cover' of the book. I already have resources defined as a

many

many

relationship, but I want to add an additional

one

one

relationship for the cover resource, with an extra condition of

isCover:true

isCover:true

.

e.g. something like this:

export const booksRelations = relations(books, ({ many, one }) => ({
    chapters: many(chapters),
    resources: many(resources),
    coverResource: one(resources, {
        fields: [books.id],
        references: [resources.bookId],
        where: eq(resources.isCover, true),, // not supported
    }),
}));

export const booksRelations = relations(books, ({ many, one }) => ({
    chapters: many(chapters),
    resources: many(resources),
    coverResource: one(resources, {
        fields: [books.id],
        references: [resources.bookId],
        where: eq(resources.isCover, true),, // not supported
    }),
}));

but it's not supported as far as I can tell, and I don't see anything mentioned about adding extra conditions to relationships in the docs.

Drizzle Team•3y ago

j25

Add conditions on relationships

many

many

relationship, but I want to add an additional

one

one

relationship for the cover resource, with an extra condition of

isCover:true

isCover:true

.

e.g. something like this:

export const booksRelations = relations(books, ({ many, one }) => ({
    chapters: many(chapters),
    resources: many(resources),
    coverResource: one(resources, {
        fields: [books.id],
        references: [resources.bookId],
        where: eq(resources.isCover, true),, // not supported
    }),
}));

export const booksRelations = relations(books, ({ many, one }) => ({
    chapters: many(chapters),
    resources: many(resources),
    coverResource: one(resources, {
        fields: [books.id],
        references: [resources.bookId],
        where: eq(resources.isCover, true),, // not supported
    }),
}));

but it's not supported as far as I can tell, and I don't see anything mentioned about adding extra conditions to relationships in the docs.

Add conditions on relationships

Similar Threads

Add conditions on relationships

Similar Threads

Similar Threads

Similar Threads