https://supabase.com/ logo
Join DiscordCommunities
Powered by
# python
  • u
    is there a way to pass RLS using python?
  • u
    @User
  • s
    @User please don't at Team in the channel, just ask and someone will answer, the python library is community developed
  • u
    sorry
  • n
    hello, I can't figure out how to update a row from the database using python from the docs, this is my code:
    Copy code
    py
supabase.from_("users").eq("id", user["id"]).update({"files": filesAlreadyUploaded["files"].append(fileUploaded["id"])}).execute()
    and the error is 
    AttributeError: 'RequestBuilder' object has no attribute 'eq'
  • n
    also if I change the code to
    Copy code
    py
supabase.table("users").select("*").eq("id", user["id"]).update({"files": filesAlreadyUploaded["files"].append(fileUploaded["id"])}).execute()
    I get this error: 
    AttributeError: 'SelectRequestBuilder' object has no attribute 'update'
  • p
    Hello
  • p
    Try with something like this:
    Copy code
    py
supabase.table("users").update(
   { 'name': 'Auckland' }, # Selection/Target column
   { 'name': 'Middle Earth' } # Update
)
  • p
  • n
    I get 
    TypeError: 'SelectRequestBuilder' object is not subscriptable
  • n
    does it have something to do with not being async?
  • p
    It's because you're using a select statement
  • p
    What does this is just a request to the database to select the rows with equal id
    Copy code
    py
supabase.table("users").select("*").eq("id", user["id"])
  • p
    is not an object with a .update method
  • p
    can I see your request, please?
  • a
    i believe the 
    .eq
    filter has to be applied after the `.update`; there's an error in the examples
  • n
    now I have 
    TypeError: update() takes 2 positional arguments but 3 were given
  • n
    Copy code
    py
supabase.table("users").update({"id": user["id"]}, {"files": files})
  • a
    i already answered this above? the .eq has to come after the .update
    Copy code
    py
supabase.table("users").update({"files": files}).eq("id", user["id"])
  • n
    Doesn't work
  • n
    It can't find eq
  • a
    "can't find"? can you elaborate?
  • s
    Apologies if this has been answered before, but I am unable to compile my python script using PyInstaller when 
    import supabase
    is called
  • s
    It happens only when I am importing supabase, with the error 
    IndexError: tuple index out of range
  • a
    Odd
  • a
    Can you send the entire traceback?
  • s
    So I ended up fixing it. Turns out it’s a Python bug that handles certain packages incorrectly. it’s fixed in 3.11
  • a
    Cool 👍
  • l
    @User I think that adding codecov.io to repositories for automatic coverage reports in pull requests will be good. What do you think?
  • l
    This will encourage us to try to increase the coverage in each pull request.
1...789...19Latest