DT
Drizzle Team•2w ago
Kevintyj

Relationships not working? (Simplest one-one relationship)

I can't seem to have Drizzle return the correct query when using the relationship syntax. I have the following relationship defined: user-schema.ts 
export const manager = mysqlTable('manager', {
    userId: varchar('user_id', { length: 36 }).notNull().references(() => user.id, { onDelete: 'cascade' }),
});
export const manager = mysqlTable('manager', {
    userId: varchar('user_id', { length: 36 }).notNull().references(() => user.id, { onDelete: 'cascade' }),
});
auth-schema.ts 
export const user = mysqlTable('user', {
    id: varchar('id', { length: 36 }).primaryKey(),
export const user = mysqlTable('user', {
    id: varchar('id', { length: 36 }).primaryKey(),
relationship-schema.ts 
export const userRelations = relations(user, ({ one }) => ({
    manager: one(manager, {
        fields: [user.id],
        references: [manager.userId],
    }),
}));
export const userRelations = relations(user, ({ one }) => ({
    manager: one(manager, {
        fields: [user.id],
        references: [manager.userId],
    }),
}));
but however when I query: 
await db.query.user.findMany({
            with: {
                manager: true,
            },
        });
await db.query.user.findMany({
            with: {
                manager: true,
            },
        });
It returns users with no managers associated. Am I doing something wrong here? First time using drizzle! Tysm ❤️
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?