Support Cleaning files for Array type column

[sumitsharansatsangi]

await MOVIE_POSTER_MEDIA.delete_unused_files()

doesn't support for Array column type.

Received following error :

File ~/.cache/pypoetry/virtualenvs/proj-haD7zQkN-py3.10/lib/python3.10/site-packages/piccolo_api/media/base.py:297, in MediaStorage.delete_unused_files(self, number_shown, auto)
    274 async def delete_unused_files(
    275     self, number_shown: int = 10, auto: bool = False
    276 ):
    277     """
    278     Over time, you will end up with files stored which are no longer
    279     needed. For example, if a row is deleted in the database, which
   (...)
    295 
    296     """
--> 297     unused_file_keys = await self.get_unused_file_keys()
    299     number_unused = len(unused_file_keys)
    301     print(f"There are {number_unused} unused files.")

File ~/.cache/pypoetry/virtualenvs/ducofastapi-haD7zQkN-py3.10/lib/python3.10/site-packages/piccolo_api/media/base.py:272, in MediaStorage.get_unused_file_keys(self)
    266 """
    267 Compares the file keys we have stored, vs what's in the database.
    268 """
    269 db_keys, disk_keys = await asyncio.gather(
    270     self.get_file_keys_from_db(), self.get_file_keys()
    271 )
--> 272 return list(set(disk_keys) - set(db_keys))

TypeError: unhashable type: 'list'

[dantownsend]

Ah, good catch - this needs fixing.

[sumitsharansatsangi]

Hmm, Please fix it.

[dantownsend]

It's fixed in this PR #176

[dantownsend]

Fixed in 0.43.0