Prisma•13mo ago

Using OR in connectOrCreate

I want to connect to an image if imageId is defined. If not, I want to connect to an image with a matching fileStorageObjectId. If it is not found I want to create a new image.

        featuredImage: {
          delete: true,
          connectOrCreate: input.featuredImage
            ? {
                where: {
                  OR: [
                    { id: input.featuredImage.imageId },
                    {
                      fileStorageObjectId:
                        input.featuredImage.fileStorageObjectId,
                    },
                  ],
                },
                create: input.featuredImage,
              }
            : undefined,
        },

        featuredImage: {
          delete: true,
          connectOrCreate: input.featuredImage
            ? {
                where: {
                  OR: [
                    { id: input.featuredImage.imageId },
                    {
                      fileStorageObjectId:
                        input.featuredImage.fileStorageObjectId,
                    },
                  ],
                },
                create: input.featuredImage,
              }
            : undefined,
        },

I get the error: Type '{ OR: ({ id: string | undefined; } | { fileStorageObjectId: string; })[]; }' is missing the following properties from type '{ fileStorageObjectId: string; id: string; entryId: string; }': fileStorageObjectId, id, entryId ts (2322) [511, 11]

Nurul•11/25/24, 12:37 PM

Hello @monkeysjump

Prisma expects the where clause in to contain unique fields that can identify a single record. Your current approach using OR in the where clause is not directly supported by Prisma's connectOrCreate operation. The where clause should typically contain a single unique identifier.

Nurul•11/25/24, 12:38 PM

To achieve what you're trying to do, you might need to split this operation into multiple queries

Try to find an existing image based on imageId or fileStorageObjectId
If found, connect to it.
If not found, create a new image.

monkeysjumpOP•11/26/24, 1:30 PM

Got it. Thank you!!