Closed
Description
Bug report
Describe the bug
after inserting the following values into the table:
instance_id # None
organization_guid # value
plan_id # value
active # value
order_date # None, but is set on insert
updated_at # update trigger from extension
I want to set the active flag to true by creating an update, but it fails with this error message: 'Error in $: not enough input'
order_book = OrderBook(instance_id=instance_id, organization_guid=organization_guid, plan_id=details.plan_id,
active=False)
response = supabase.table("instance").insert(order_book).execute() # works
order_book['active'] = True
response: OrderBook = supabase.from_("instance").update(order_book).eq(
'id', f"{order_book['id']}").execute() # fails with - Error in $: not enough input
I tried also with only active = true like below, but it didn't work eighter.
supabase.from_("instance").update({'active': 'true'}).eq( 'id', f"{order_book['id']}").execute()
Its not clear to me what is actually wrong or what is missing or how to properly debug the query.