Module Augumentation for User that has many to many fields on Adapter

[ebratz]

Hi!
I don't know if this is the right place to ask, but I could not easily find on the docs.

I'm using Auth.js with Prisma and I have extended the User model to include some many to many. I'm using database strategy and now I'm trying to include those many to many fields on my session callback so it generates the session with the additional info, but no luck yet. I'm testing including the "status" field which is a basic enum and it works like a charm to extend the session, but for many to many relationships I'm not able to resolve the query to bring the respective data. Any tip?

Prisma Model:

model User {
id String @id @default(cuid())
name String?
email String @unique
emailVerified DateTime?
image String?
status UserStatus @default(active)
accounts Account[]
sessions Session[]
// Optional for WebAuthn support
Authenticator Authenticator[]
roles Role[]
organizations Organization[]
createdAt DateTime @default(now())
updatedAt DateTime @updatedat
}

Session Callback:
callbacks: {
session: ({ session, newSession, user }) => {
session.user.organizations = user.organizations;

  console.log("Augumented Session", session);
  return session;
},

}

Module Augumentation (next-auth.d.ts):

import { type Organization } from "@prisma/client";
import NextAuth, { type DefaultSession } from "next-auth";

declare module "next-auth" {
interface User extends DefaultSession["user"] {
organizations: Organization[];
}

interface Session extends DefaultSession {
user: User;
}
}

Console return for the session callback:

Augumented Session {
sessionToken: '53a3b141-4629-4b79-a190-fbe80fc04145',
userId: 'clzhtv5my0000hbl9d2qdrk9b',
expires: 2024-09-05T03:16:29.247Z,
createdAt: 2024-08-06T03:16:29.248Z,
updatedAt: 2024-08-06T03:16:29.248Z,
user: {
id: 'clzhtv5my0000hbl9d2qdrk9b',
name: 'My Name',
email: 'email@email.com',
emailVerified: null,
image: 'https://image.com/picture.png,
status: 'active',
createdAt: 2024-08-06T02:55:15.274Z,
updatedAt: 2024-08-06T02:55:15.274Z,
organizations: undefined
}
}

Is this possible? What would be the correct way to handle this situation with Authjs?
Thanks in advance!

[ebratz]

For anybody trying to achieve the same, I was able to make it work by extending the PrismaAdapter overriding the getSessionAndUser method with another prisma query that include the organization array as part of it.
Took me 3 days to figure out, maybe some docs improvements on that would be good. The starting point to discover this was debugging the adapter queries and the Adapter docs helped me as well