i am new to prisma, i have a wordpress db table w_integrations. Below is the prisma.schema for it:
model w_integrations {
integration_id String @unique(map: "integration_id") @db.Char(36)
integration_platform String @db.VarChar(255)
streamspace_id String @unique(map: "streamspace_id_2") @db.Char(36)
oasis_id String? @db.Char(36)
w_streamspaces w_streamspaces @relation(fields: [streamspace_id], references: [streamspace_id], onUpdate: Restrict, map: "w_integrations_ibfk_1")
@@index([streamspace_id], map: "streamspace_id")
}
also below is the code where i am getting the error:
const integrationDetails = await prisma.w_integrations.findUnique({
where: { integration_id: initID },
});
if (!integrationDetails) {
throw new Error("Invalid Integration Id !");
}
The error i am getting is:
PrismaClientValidationError:
Invalid `prisma.w_integrations.findUnique()` invocation:
{
where: {
integration_id: "81e04c7-03c9-11ef-9346-4ed5aa47b855",
? integration_id_streamspace_id?: w_integrationsIntegration_idStreamspace_idCompoundUniqueInput,
? AND?: w_integrationsWhereInput | w_integrationsWhereInput[],
? OR?: w_integrationsWhereInput[],
? NOT?: w_integrationsWhereInput | w_integrationsWhereInput[],
? integration_platform?: StringFilter | String,
? streamspace_id?: StringFilter | String,
? oasis_id?: StringNullableFilter | String | Null,
? w_streamspaces?: W_streamspacesRelationFilter | w_streamspacesWhereInput
}
}
Argument where
of type w_integrationsWhereUniqueInput needs at least one of integration_id_streamspace_id
arguments. Available options are marked with ?.
Any small help will be really appreciated !!!
i have tried several stackoverflow solutions but i was unable to solve the issue.
New contributor
kvell Team is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.