Support upsert functionality about storage HOT 9 CLOSED

@inian Is this issue being worked on or can I take it up?

from storage.

That worked. Thanks. I will work on the issue for now.

from storage.

Hi @ankitjena, you don't need to change any other variables in the .env file. This sets up a full local environment and apart from a S3 bucket, you don't need anything external like a Supabase Project to begin development.

I have updated the README to add some instructions on local testing and the API docs are here. Can you pull from master and give it a shot?

from storage.

You will need to add RLS policies to get around this permission issues Ankit. For local dev, you can use the service key instead which bypasses RLS

from storage.

Go for it @ankitjena! Let me know if there are any issues in getting started.

from storage.

Hey @inian , the readme says to only set GLOBAL_S3_BUCKET and REGION, in the .env and set up the aws config. What about the other fields in the .env field?

• The ANON_KEY, SERVICE_KEY, PROJECT_REF are we supposed to use those from project created in supabase
• Also how do I test it using an api client, looking at the code I think an authorization header was required

Some clarity on the entire setup process would surely help. Thanks

from storage.

@inian The create bucket and get buckets API works, I was trying to create an object and it returns this error to me

POST http://localhost:5000/object/avatars/folder/trust.png

{
  "statusCode": "42501",
  "error": "",
  "message": "new row violates row-level security policy for table \"objects\""
}

Something I am doing wrong here?

from storage.

@inian Created a PR

from storage.

@inian can you explain what row-level policies I should add (presumably to the "Other policies under storage.objects" section)? I want the following simple rule actually work for insert/update/delete on the frontend (so no service key), but I get the same error as @ankitjena when I use upsert: true

(
  (bucket_id = 'test-bucket':: text)
  AND ((uid()):: text = (storage.foldername(name)) [ 1 ])
)

from storage.