What does "Unchecked" mean?

[topbloc-beiswenger]

Hi there 👋

Most CRUD operations take in a data object with either a checked or unchecked type. For example, the API reference for create takes in data of type XOR<UserCreateInput, UserUncheckedCreateInput>. What exactly does unchecked type mean and how does Prisma choose whether it should use the checked or unchecked type?

Curious about this because I'm currently getting an error along the lines of Unknown arg "teams" in data.teams for type UserUncheckedCreateInput when trying to do:

prisma.user.create({
    data: {
      teams: {
        connectOrCreate: teams.map((team) => {
          return {
            where: { name: team.name },
            create: {
              name: team.name,
              color: team.color,
            },
          };
        }),
      },
    },
  });

Thanks in advance 🙂

[austincrim]

Hi @topbloc-beiswenger! This is a great question.

"Unchecked" input types allow you to perform some operations that are often considered "dangerous", like directly writing foreign keys. Prisma allows you to choose either a safe or an unchecked input type when doing operations like create.

I'm unsure why you are hitting your specific error, but if you could share your schema file with me, I can do some digging on my side.

[topbloc-beiswenger]

Thanks for the response!

I found out that my problem was that team.name was undefined in where: { name: team.name } 😅

I think the error was just a bit misleading but I'll make sure to treat it as a catch-all in the future