Function getUserAccount

packages/db/src/services/user.service.ts:13–44

({
  email,
  provider,
  providerId,
}: { email: string; provider: string; providerId?: string })

}

export async function getUserAccount({
  email,
  provider,
  providerId,
}: { email: string; provider: string; providerId?: string }) {
  const res = await db.user.findFirst({
    where: {
      email: {
        equals: email,
        mode: 'insensitive',
      },
    },
    include: {
      accounts: {
        where: {
          provider,
          providerId: providerId ? String(providerId) : undefined,
        },
        take: 1,
      },
    },
  });

  if (!res?.accounts[0]) {
    return null;
  }

  return {
    ...res,
    account: res?.accounts[0],
  };
}