storage folder size

[JamesWong1999]

Hi there,

Is there a way to find out a folder size from the storage API?

bucket A -> FolderA (find out the total folder size)

Do I need to list the entire bucket files and do a total sum?

many thanks

[GaryAustin1]

Using list with the bucket and folder path is the easist way (IF the user has access to all the files you want to total) and then sum the loop. That is just like querying the storage object table on bucket and partial path, but you maintain compatibility if things change. There is really no structure called a folder, just path names in the object table.

You could also write a function with sql to query the storage object table for the bucket and partial path and sum in sql. Then call it with an rpc call to return just the total. This is less work on client and would allow you to securely get a total of a "folder" even if the user does not have access to all the files. Of course then have to maintain if the storage object were to change much in the future.

Edit: It is alot more complex but doable if you have "subfolders" and need their totals included.

[JamesWong1999]

Thanks @GaryAustin1 for the reply! Make sense. I think query with clients js is the cheapest, but not as robust as store meta data inside a table. I may go with the complex solution tho.

[moinism]

@GaryAustin1 is there such an SQL code available, to return the size of a folder? I could not find doc on what variables are available in a policy (e.g: storage, etc.) and their methods (storage.folder).

[lukechinworth]

The size of the object is in column metadata which is json at key size. you'd need to sum this up for all objects in your "folder"