Python: Upsert data

Parameters

Examples

Upsert your data

response = (
    supabase.table("instruments")
    .upsert({"id": 1, "name": "piano"})
    .execute()
)

Bulk Upsert your data

response = (
    supabase.table("instruments")
    .upsert([{"id": 1, "name": "piano"}, {"id": 2, "name": "guitar"}])
    .execute()
)

Upserting into tables with constraints

response = (
    supabase.table("users")
    .upsert(
        {"id": 42, "handle": "saoirse", "display_name": "Saoirse"},
        on_conflict="handle",
    )
    .execute()
)