Update table with NULL value

[MarcoFFSiciliano]

I'm trying to update optional / nullable table values with null.

When i do this:

await prisma.testTable.update(
  data: PrismaUnion.$1(
    TestTableUpdateInput(
      myNullableColumn: obj.value != null
          ? PrismaUnion.$1(obj.value!)
          : null)));

the column 'myNullableColumn' stays unchanged and gets NOT overwritten with NULL as expected.

I can not figure out how to update table columns with NULL in dart prisma orm.

Any ideas?

[medz]

To update a database field that allows null to a null value, use const PrismaNull() as the value.

This is a legacy issue. Since Dart does not distinguish between unset and declared null values, you will end up with null. Hence PrismaNull which represents a declared null value.

[medz]

For example:

model User {
    ....
    name String?
}

It generates the Type PrismaUnion<String, PrismaUnion<NullableStringFieldUpdateOperationsInput, PrismaNull>>?

[medz]

PrismaUnion.$2(PrismaUnion.$2(const PrismaNull()))

[MarcoFFSiciliano]

Thank you so mich, that was exactly what i was looking for.