model User {
  id                Int     @id @default(autoincrement())
  email             String  @unique
  password          String
  role              Role
  profile_completed Boolean @default(false)

  teacher    Teacher?
  student    Student?
  subjects   Subject[]
  languages  Language[]
  educations Education[]

  @@map("users")
}
model Language {
  id    Int    @id @default(autoincrement())
  name  String
  users User[]

  @@map("languages")
}

model Education {
  id    Int    @id @default(autoincrement())
  name  String
  users User[]

  @@map("education_levels")
}

model Subject {
  id   Int    @id @default(autoincrement())
  name String

  users User[]

  @@map("subjects")
}

model User {
  id                Int     @id @default(autoincrement())
  email             String  @unique
  password          String
  role              Role
  profile_completed Boolean @default(false)

  teacher    Teacher?
  student    Student?
  subjects   Subject[]
  languages  Language[]
  educations Education[]

  @@map("users")
}
model Language {
  id    Int    @id @default(autoincrement())
  name  String
  users User[]

  @@map("languages")
}

model Education {
  id    Int    @id @default(autoincrement())
  name  String
  users User[]

  @@map("education_levels")
}

model Subject {
  id   Int    @id @default(autoincrement())
  name String

  users User[]

  @@map("subjects")
}

export async function getTeachersSubjects(
  subject: string,
  page: number,
  queries: {
    subject?: string | string[];
    language?: string | string[];
    studentLevel?: string | string[];
    educationLevel?: string | string[];
  },
): Promise<Teacher[]> {
  const teachers = await prisma.user.findMany({
    where: {
      role: Role.TEACHER,
      subjects: {
        some: { name: subject },
      },
    },
    select: {
      teacher: true,
      educations: true,
      languages: true,
      subjects: true,
    },
    take: PERPAGE,
    skip: (page - 1) * PERPAGE,
  });

 
  return JSON.parse(
    JSON.stringify(
      teachers.map((user) => ({
        ...toCamelCase(user.teacher),
        educations: user.educations,
        languages: user.languages,
        subjects: user.subjects,
      })),
    ),
  );
}

export async function getTeachersSubjects(
  subject: string,
  page: number,
  queries: {
    subject?: string | string[];
    language?: string | string[];
    studentLevel?: string | string[];
    educationLevel?: string | string[];
  },
): Promise<Teacher[]> {
  const teachers = await prisma.user.findMany({
    where: {
      role: Role.TEACHER,
      subjects: {
        some: { name: subject },
      },
    },
    select: {
      teacher: true,
      educations: true,
      languages: true,
      subjects: true,
    },
    take: PERPAGE,
    skip: (page - 1) * PERPAGE,
  });

 
  return JSON.parse(
    JSON.stringify(
      teachers.map((user) => ({
        ...toCamelCase(user.teacher),
        educations: user.educations,
        languages: user.languages,
        subjects: user.subjects,
      })),
    ),
  );
}