Delete collection fails with 'collection does not exist' about stac-fastapi HOT 3 CLOSED

Once I've deleted all rows in data.items where collection_id equals the identifier, then the DELETE request works fine.

from stac-fastapi.

Sqlalchemy has support for a delete cascade which deletes all of the children first, but we decided not to implement it for reasons I can't remember at the moment.

It would also be nicer to respond with a more accurate error message, since the collection does indeed exist.

We are definitely overloading the ForeignKeyViolation (https://github.com/arturo-ai/arturo-stac-api/blob/7d4c9572981e935de2521441878f3ffb78f6b9b7/stac_api/clients/postgres/session.py#L30-L31) exception. I'll create an issue for this.

from stac-fastapi.

I think I found my issue here. I assumed that if you did an HTTP DELETE request on a collection it would delete all the items in the collection, but that’s not the case.

Here I tried to delete a collection that contains some items:

Here's the log from the server:

So I gather that it's necessary to first delete all the items before you delete the collection. It would also be nicer to respond with a more accurate error message, since the collection does indeed exist.

from stac-fastapi.