Ok I found that this was actually quite simple... just do it as usual insert and include the forign key id.

    const result = await prisma.posts.createMany([
      {
        ...postData,
       userId,
      },
    ]);

Hi @MatheusGNachtigall 👋

Thank you for raising this question.

Prisma does not support the createMany operation with nested writes, which includes the connect operation for relations. The createMany operation is designed to create multiple records in a single model without handling relations. See this section of the documentation.

However, you can use the create operation to create a single record along with its relations in a nested write. For example, to create a Post and connect it to existing Category records by their unique identifier, you would use the following code:

const createPostWithCategories = await prisma.post.create({
  data: {
    title: 'Post 1',
    categories: {
      connect: [{ id: 'category-id-1' }, { id: 'category-id-2' }],
    },
  },
});

In your case, since you want to create multiple posts and connect them to existing categories, you would need to loop through your postsData array and call prisma.post.create for each post. Here's an example of how you might do this:

async function createPostsAndConnectCategories(postsData) {
  return Promise.all(
    postsData.map(postData =>
      prisma.post.create({
        data: postData,
      })
    )
  );
}

const postsData = [
  {
    title: "Post 1",
    categories: {
      connect: [{ name: "Category1" }, { name: "Category2" }],
    },
  },
  {
    title: "Post 2",
    categories: {
      connect: [{ name: "Category2" }, { name: "Category3" }],
    },
  },
  // Add more posts as needed
];

const createdPosts = await createPostsAndConnectCategories(postsData);

This approach will execute the creation of each post and its connections to categories in parallel, which may help with performance compared to a sequential loop. However, it's important to note that this could still be a time-consuming operation given the large number of records you mentioned.

If this answers your question, it would be great if you could mark this Discussion as answered to indicate that it has been resolved.

Otherwise please let us know how else we can help you further or close the Discussion if it was resolved in some other way 🙏

What you need here is connectOrCreate.

So something like this should work:

      await prisma.post.create({
        data: {
          title: 'Hello',
          categories: {
            create: [
              {
                category: {
                  create: {
                    name: 'category-1',
                  },
                },
              },
              { category: { connect: { id: 10 } } },
            ],
          },
        },
      });

You can also read more about this in the docs here

Hello @fotoflo 👋

If you just need to connect an id, can you try directly setting the foreign key if you are sure that it exists?
Here's an example of what I am suggesting:

import { Prisma, PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

// A `main` function so that you can use async/await
async function main() {
  await prisma.reportingBatch.create({
    data: {
      id: 1,
    },
  });

  await prisma.scores.createMany({
    data: [
      {
        reportingBatchId: 1,
        score: 1,
        title: "title1",
      },
    ],
  });
}

main()
  .catch((e) => {
    throw e;
  })
  .finally(async () => {
    await prisma.$disconnect();
  });

Based on your schema, first a reporting batch is created and then a createMany query on scores model directly sets the foreign key reportingBatchId instead of using connect. Would this work for your case?

Hello @parnexcodes 👋

connect cannot be used with top-level createMany. You would need to manually loop over the data and use a create query instead.

Docs Reference:https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#remarks-10

Ahh I see. just found this. createMany is not supported for SQLite.

createMany is not supported on SQLite unfortunately: #10710 Documented here: https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#remarks-10

https://github.com/prisma/prisma/issues/11507#issuecomment-1025587202

Does it answer to your question ?

https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries#nested-writes

Edit : if you scroll down this page you will see how to createMany inside the create statement. Look at the given example :

const user = await prisma.user.create({
  data: {
    email: '[email protected]',
    posts: {
      createMany: {
        data: [{ title: 'My first post' }, { title: 'My second post' }],
      },
    },
  },
  include: {
    posts: true,
  },
})