Delete Collection Api

Delete a collection and all its data.

This function ensures data consistency by attempting physical file deletion before database deletion. If physical deletion fails, the operation is aborted to prevent inconsistent state.

Args: collection_name: Name of the collection to delete

Returns: Deletion result with status, affected documents, and cleanup information

Raises: HTTPException: If physical deletion fails (prevents database deletion)