'Error in $: not enough input' on .update() about supabase-py HOT 12 CLOSED

Hello @dreinon - I am running into the same issue again despite having the latest supabase version.

I am trying to update a single column using id as the matching value. My id is stored in uuid format and is generated using uuid_generate_v4()

supabase_client.table("table").update({"field": "True"}).eq("id", str(local_data.iloc[x]['id'])).execute()

from supabase-py.

Temporary workaround is to use .insert() with upsert=True

from supabase-py.

Yes noticing this too. Is upsert actually working or is it simply inserting a new row? From what I've noticed it's inserting new rows so would be helpful to get confirmation thats what you are seeing. Perhaps request headers/jwt is misconfigured somehow..

from supabase-py.

@fedden it updates the row when I use insert with upsert=true.

To be clear, I don't think partial updates work.
What I'm doing is editing parts of the row and then executing db.table("notes").insert(data, upsert=True)

Think PUT not PATCH

from supabase-py.

It would be nice to have this documented somewhere. Without this issue there is no way to know how to update a row.

from supabase-py.

Hey @remybroun @rphly,

We have tested this issue and it seems to work fine now. We are closing this for now but please feel free to let us know if you're still facing any issues.

Thanks!

from supabase-py.

Hey @remybroun @rphly,

We have tested this issue and it seems to work fine now. We are closing this for now but please feel free to let us know if you're still facing any issues.

Thanks!

I am still facing the same issue :(

res = supabase.table("Servers").update({"Server_ID" : "test-id, "Server_Name" : "test-server,"Channel_ID" : "test-channel", }).execute()

from supabase-py.

Make sure to update your supabase version to the latest and tell us if you still face the issue please 😊
@Krish-Nerkar

from supabase-py.

I recently faced this issue. If anyone comes across this again this was how I solved it:
I was using supabase-py instead of supabase. Also I updated supabase to latest version (1.0.3 as of this date) and my python version was 3.10.10.

from supabase-py.

@smandava98 how were you able to use supabase in a python project without using supabase-py ??

from supabase-py.

@smandava98 how were you able to use supabase in a python project without using supabase-py ??

You can try pip install supabase and you will have no errors))))

from supabase-py.

if you are using supabase_py or supabase-py instead use supabase alone to create client

it is working for me any more issues add a comment

from supabase-py.