Updating Null Values

[vibhav-zf]

Hi, I was trying to update a column to NULL but couldn't find anything in the docs and the prisma official docs are for js where null and undefined are different.

I tried with None but that didn't do anything (I assume it corresponds to undefined).
How can I update a value to NULL?

Thanks!

[royalbhati]

+1

[zfundsdushyant]

Facing the same issue

[RobertCraigie]

Hey @vibhav-zf @royalbhati @zfundsdushyant, can you share a code sample that isn't working for you?

This should be possible by just passing None, see this test case for an example:

prisma-client-py/databases/tests/test_update.py

Lines 154 to 162 in 805136e

	updated = await client.post.update(
	where={
	'id': post.id,
	},
	data={'description': None},
	)
	assert updated is not None
	assert updated.id == post.id
	assert updated.description is None

[vibhav-zf]

I tried this and it did not work - I must be doing something wrong, I just tried this again and it does, thanks.