Hey guys could use some help, been at this all night with no luck, geatly appreciate it

model Domain {
  id                 String              @id @default(cuid())
  domain             String              @unique
  majesticDomainData MajesticDomainData?
}

model MajesticDomainData {
  id                     String                @id @default(cuid())
  domain                 Domain                @relation(fields: [domainId], references: [id])
  domainId               String                @unique
  topics                 MajesticTopicalData[]
}

model MajesticTopicalTrustFlow {
  id         String                @id @default(cuid())
  topic      String                @unique
  domainData MajesticTopicalData[]
}

model MajesticTopicalData {
  domainData         MajesticDomainData       @relation(fields: [domainDataId], references: [id])
  domainDataId       String
  topicalTrustFlow   MajesticTopicalTrustFlow @relation(fields: [topicalTrustFlowId], references: [id])
  topicalTrustFlowId String
  topicalPercent     Decimal                  @db.Decimal(5, 4)

  @@id([domainDataId, topicalTrustFlowId])
}

prisma.domain.update({
                            where: {<http://asd.com|asd.com>},
                            data: {
                                majesticDomainData: {
                                    create: {
                                        topics: {
                                            create: [
                                                {
                                           topic: 'health',
                                           topicalPercent: 0.24
                                                },
                                                {
                                          topic: 'rec',
                                         topicalPercent: 0.33
                                                },
                                            ]
                                        },
                                    }
                                }
                            },
                        })

+             topicalTrustFlow: {
+               create?: MajesticTopicalTrustFlowCreateWithoutDomainInput | MajesticTopicalTrustFlowUncheckedCreateWithoutDomainInput,
+               connectOrCreate?: MajesticTopicalTrustFlowCreateOrConnectWithoutDomainInput,
+               connect?: MajesticTopicalTrustFlowWhereUniqueInput
+             }

Im not sure if im connecting the many to many relationship correctly, its asking for my explicit table

what's the problem?

Hi @Peter 👋 Can you please describe what the issue is so we can know how to help?

I have a domain table with a one to one with majesticdomaindata table and that has a many to many relationship with MajesticTopicalTrustFlow table and I am connecting them using the explicit MajesticTopicalData table but I am having trouble connecting the tables properly

Let me reproduce this scenario, I'll get back to you on this.

Are there any glaring mistakes within the prisma.domain.update code?

From what i can see,

topic

is not a property of

MajesticTopicalData

. You should not have topic as part of the fields.

So im assuming there is no way I can create the topic through here. Ive also tried adding the tropicaltrustflow

topics: {
                                            create: [
                                                {
                                                    topicalPercent: 0.24,
                                                    topicalTrustFlow: {
                                                        create: {topic: 'asdfsd'}
                                                    }
                                                },
                                                // {
                                                //     topicalPercent: 0.44
                                                // },
                                            ]
                                        },

But get this error:

The change you are trying to make would violate the required relation 'DomainToMajesticDomainData' between the `Domain` and `MajesticDomainData` models.

  code: 'P2014',
  clientVersion: '4.1.1',
  meta: {
    relation_name: 'DomainToMajesticDomainData',
    model_a_name: 'Domain',
    model_b_name: 'MajesticDomainData'
  }
}

I'm looking into it

Updated to do this and it now I am getting a unique contraint error:

topics: {
                                create: [
                                    {
                                        topicalPercent: 0.514,
                                        topicalTrustFlow: {
                                            connectOrCreate: {
                                                where: {topic: 'Health'},
                                                create: {topic: 'Health'}
                                            }
                                        }
                                    },
                                    {
                                        topicalPercent: 0.15,
                                        topicalTrustFlow: {
                                            connectOrCreate: {
                                                where: {topic: 'Rec'},
                                                create: {topic: 'Rec'}
                                            }
                                        }
                                    }
                                ]
                            },

Response error PrismaClientKnownRequestError: 
Invalid `prisma.domain.update()` invocation:


  Unique constraint failed on the (not available)

Hi @Peter, I've shared this query with another team member and we'll try to come up with a potential solution.

Hey Peter, According to me this error is occurring because you are creating a

MajesticDomainData

record without creating a

domain

record. This would result in violating one-to-one relation between them.

The change you are trying to make would violate the required relation ‘DomainToMajesticDomainData’ between the

Domain

and

MajesticDomainData

models

I am trying to understand what’s the exact use case that you are trying to achieve.

I use a create many to add domains

const addDomains = await prisma.domain.createMany({
                    data: allDomains,
                    skipDuplicates: true
                });

What Im trying to do is add the majesticDomainData to the domain itself

return prisma.domain.update({
                            where: {domain: p.domain},
                            data: {
                                majesticDomainData: {
                                    create: majesticDomainData,
                                }
                            },
                            select: {
                                domain: true
                            }
                        })

Is your code perhaps open-source? If yes, can you share it with us even if the query doesn’t work, I can have a look at it and try to fix it by trying to have a holistic view of your app.