battlesheep123
battlesheep123
Explore posts from servers
NNuxtPPrisma
PostsComments
PPrisma
Created by battlesheep123 on 5/15/2024 in #help-and-questions
Relation not included in the generated types
Hello, I have the following model, generated from a database-first approach. 
model Entry {
  project       String    @db.Uuid
  description   String
  comment       String?
  status        String
  projects      Projects  @relation(fields: [project], references: [uuid], onDelete: NoAction, onUpdate: NoAction, map: "entry_projects_uuid_fk")

  @@map("entry")
}

model Projects {
  uuid         String      @id(map: "projects_pk") @default(dbgenerated("gen_random_uuid()")) @db.Uuid
  name         String
  entry        Entry[]

  @@map("projects")
}
model Entry {
  project       String    @db.Uuid
  description   String
  comment       String?
  status        String
  projects      Projects  @relation(fields: [project], references: [uuid], onDelete: NoAction, onUpdate: NoAction, map: "entry_projects_uuid_fk")

  @@map("entry")
}

model Projects {
  uuid         String      @id(map: "projects_pk") @default(dbgenerated("gen_random_uuid()")) @db.Uuid
  name         String
  entry        Entry[]

  @@map("projects")
}
The query: 
const entries: Entry[] = await prisma.entry.findMany({
        include: {
            projects: true,
        },
    });
const entries: Entry[] = await prisma.entry.findMany({
        include: {
            projects: true,
        },
    });
...returns the following data: 
[
    {
        project: '5d117ed0-1391-4925-bde0-22412825cd54',
        description: 'xxxx',
        comment: 'xxx',
        status: 'xxx',
        projects: {
            uuid: '5d117ed0-1391-4925-bde0-22412825cd54',
            name: 'xxx'
        }
    }
]
[
    {
        project: '5d117ed0-1391-4925-bde0-22412825cd54',
        description: 'xxxx',
        comment: 'xxx',
        status: 'xxx',
        projects: {
            uuid: '5d117ed0-1391-4925-bde0-22412825cd54',
            name: 'xxx'
        }
    }
]
Unfortunately, the generated Prisma type does not include the relation "projects". This means, the following typing does not include the relation. const entries: Entry[] = await prisma.entry.findMany({ ... }) Any idea why that is?
16 replies