Extends result relations

Hi,
I have 3 different objects:

model User {
    id           String                   @id @default(uuid())
    auth_id      String                   @unique
    firstname    String
    lastname     String
    createdAt    DateTime                 @default(now())
    updatedAt    DateTime                 @updatedAt
    sessions     Session[]
    challenges   Challenge[]
    exoskeletons ExoskeletonAttribution[]
}

model Exoskeleton {
    id           String                   @id @default(uuid())
    serial       String
    createdAt    DateTime                 @default(now())
    updatedAt    DateTime                 @updatedAt
    sessions     Session[]
    attributions ExoskeletonAttribution[]
}

model ExoskeletonAttribution {
    id            String      @id @default(uuid())
    exoskeletonId String
    userId        String
    createdAt     DateTime    @default(now())
    revokedAt     DateTime?
    exoskeleton   Exoskeleton @relation(fields: [exoskeletonId], references: [id])
    user          User        @relation(fields: [userId], references: [id])
}

model User {
    id           String                   @id @default(uuid())
    auth_id      String                   @unique
    firstname    String
    lastname     String
    createdAt    DateTime                 @default(now())
    updatedAt    DateTime                 @updatedAt
    sessions     Session[]
    challenges   Challenge[]
    exoskeletons ExoskeletonAttribution[]
}

model Exoskeleton {
    id           String                   @id @default(uuid())
    serial       String
    createdAt    DateTime                 @default(now())
    updatedAt    DateTime                 @updatedAt
    sessions     Session[]
    attributions ExoskeletonAttribution[]
}

model ExoskeletonAttribution {
    id            String      @id @default(uuid())
    exoskeletonId String
    userId        String
    createdAt     DateTime    @default(now())
    revokedAt     DateTime?
    exoskeleton   Exoskeleton @relation(fields: [exoskeletonId], references: [id])
    user          User        @relation(fields: [userId], references: [id])
}

The last one have a manyToOne relation for both User & Exoskeleton.
My goal is to add a custom field to User, named

currentExoskeleton

currentExoskeleton

, based on the relation to exoskeletonAttribution (i take the last in date), to fetch to associated Exoskeleton.

So i started to wrote this:

result: {
  user: {
    currentExoskeleton: {
      needs: {
        exoskeletonAttribution: true,
      },
      compute(user) {
          // nothing here for the moment
      }
    },
  },
},

result: {
  user: {
    currentExoskeleton: {
      needs: {
        exoskeletonAttribution: true,
      },
      compute(user) {
          // nothing here for the moment
      }
    },
  },
},

But typescript already crying on me on the needs part, "impossible to align type boolean to never". And i would also like to know if it's possible to user async/await on compute ? (if yes, how ? should i return an async function from the compute function ?)

Thanks

Prisma•2y ago•

1 reply

DollarNavalex

Extends result relations

Hi,
I have 3 different objects:

model User {
    id           String                   @id @default(uuid())
    auth_id      String                   @unique
    firstname    String
    lastname     String
    createdAt    DateTime                 @default(now())
    updatedAt    DateTime                 @updatedAt
    sessions     Session[]
    challenges   Challenge[]
    exoskeletons ExoskeletonAttribution[]
}

model Exoskeleton {
    id           String                   @id @default(uuid())
    serial       String
    createdAt    DateTime                 @default(now())
    updatedAt    DateTime                 @updatedAt
    sessions     Session[]
    attributions ExoskeletonAttribution[]
}

model ExoskeletonAttribution {
    id            String      @id @default(uuid())
    exoskeletonId String
    userId        String
    createdAt     DateTime    @default(now())
    revokedAt     DateTime?
    exoskeleton   Exoskeleton @relation(fields: [exoskeletonId], references: [id])
    user          User        @relation(fields: [userId], references: [id])
}

model User {
    id           String                   @id @default(uuid())
    auth_id      String                   @unique
    firstname    String
    lastname     String
    createdAt    DateTime                 @default(now())
    updatedAt    DateTime                 @updatedAt
    sessions     Session[]
    challenges   Challenge[]
    exoskeletons ExoskeletonAttribution[]
}

model Exoskeleton {
    id           String                   @id @default(uuid())
    serial       String
    createdAt    DateTime                 @default(now())
    updatedAt    DateTime                 @updatedAt
    sessions     Session[]
    attributions ExoskeletonAttribution[]
}

model ExoskeletonAttribution {
    id            String      @id @default(uuid())
    exoskeletonId String
    userId        String
    createdAt     DateTime    @default(now())
    revokedAt     DateTime?
    exoskeleton   Exoskeleton @relation(fields: [exoskeletonId], references: [id])
    user          User        @relation(fields: [userId], references: [id])
}

The last one have a manyToOne relation for both User & Exoskeleton.
My goal is to add a custom field to User, named

currentExoskeleton

currentExoskeleton

, based on the relation to exoskeletonAttribution (i take the last in date), to fetch to associated Exoskeleton.

So i started to wrote this:

result: {
  user: {
    currentExoskeleton: {
      needs: {
        exoskeletonAttribution: true,
      },
      compute(user) {
          // nothing here for the moment
      }
    },
  },
},

result: {
  user: {
    currentExoskeleton: {
      needs: {
        exoskeletonAttribution: true,
      },
      compute(user) {
          // nothing here for the moment
      }
    },
  },
},

Extends result relations

Similar Threads

Extends result relations

Similar Threads

Similar Threads

Similar Threads