how to get all items from a table where a column i...
# python
a
how to get all items from a table where a column is null.
supabase.table('vehicles').select('id').is('deleted', None).execute()
python library does not seem to support the
.is
like in subabase-js
m
It does, but it is a bit hacky. Please try
.is_("deleted","NULL").execute()
d
right, there is a good first issue in postgrest-py, it's a one line change, which would allow us to use python values like None instead of having to write json values as strings like "NULL"
m
The python client is maintained by the community but I agree with your point. Perhaps I'll make this my first commit to the client. 🙂
d
Nice!
Thanks!