Create multiple elements when using the mutation createOneTable

[GioPat]

First of all I'd like to congratulate for this amazing library!
I've the following simple prisma.schema:

model Tag {
  id        Int      @id @default(autoincrement())
  name      String   @unique
  filesTags FileTag[]
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model File {
  id        Int      @id @default(autoincrement())
  name      String
  url       String
  filesTags FileTag[]
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model FileTag {
  id        Int      @id @default(autoincrement())
  file      File     @relation(fields: [fileId], references: [id])
  fileId    Int
  tag       Tag      @relation(fields: [tagId], references: [id])
  tagId     Int
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

I'm trying to use the generated createOneFile mutation with the very handy CreatedNestedMany parameter.
The idea is that I create a file and associate its relative tags and, if the tags are not present, I want to create them.

I tried with the following (accepted) graphql query but it's working (as I expect) just for the last tag (tag2).

{
    "file": {
    "name": "filesample",
    "url": "urlidentifier",
    "filesTags": {
      "create":{
        "tag": {
          "connectOrCreate": {
            "where": {
              "name": "tag1"
            },
            "create": {
              "name": "tag1"
            }
          }
        }
      },
      "create":{
        "tag": {
          "connectOrCreate": {
            "where": {
              "name": "tag2"
            },
            "create": {
              "name": "tag2"
            }
          }
        }
      }
    }
  }
}

Is there any way to achieve the following functionality?

Thanks!

[MichalLytek]

TypeGraphQL-Prisma integration is mostly 1:1 copy of Prisma Client API.

So if you can show the Prisma Client call that does the job, then I could help you with the graphql query.
Now I'm not sure if you're asking for inserting multiple relation entities at once?

[GioPat]

Hello @MichalLytek, thanks for the answer.
Exactly, I'd like to insert multiple relation entities at once and if they are not present (the foreign element) create it.
the query is the following with the variables that I've pasted in the previous message:

mutation CreateOneFile($file: FileCreateInput!) {
  createOneFile(data: $file) {
    id
  }
}

And I'm using the graphiql interface.

Thanks!

[GioPat]

Ok I've solved the issue by changing the variables to the following (by using an array for the create key:

{
    "file": {
    "name": "filesample",
    "url": "urlidentifier",
    "filesTags": {
      "create": [
        {
          "tag": {
            "connectOrCreate": {
              "where": {
                "name": "tag1"
              },
              "create": {
                "name": "tag1"
              }
            }
          }
        },
        {
          "tag": {
            "connectOrCreate": {
              "where": {
                "name": "tag2"
              },
              "create": {
                "name": "tag2"
              }
            }
          }
        }
      ]
    }
  }
}

Thanks for the support.

[MichalLytek]

Have you tried this approach with array?
https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries#create-a-single-record-and-multiple-related-records

const user = await prisma.user.create({
  data: {
    email: '[email protected]',
    name: 'Yvette',
    posts: {
      create: [
        {
          title: 'How to make an omelette',
          categories: {
            create: {
              name: 'Easy cooking',
            },
          },
        },
        { title: 'How to eat an omelette' },
      ],
    },
  },
  include: {
    // Include posts
    posts: {
      include: {
        categories: true, // Include post categories
      },
    },
  },
})