cleanup and fix resource handling

[shcheklein]

Fix resources cleanup. Mostly to avoid tons of warnings in tests, but also probably avoid some leaks.

[codecov[bot]]

Codecov Report

:x: Patch coverage is 85.71429% with 28 lines in your changes missing coverage. Please review.

Files with missing lines	Patch %	Lines
src/datachain/catalog/catalog.py	84.90%	8 Missing and 8 partials :warning:
src/datachain/query/session.py	75.00%	3 Missing and 1 partial :warning:
src/datachain/cli/__init__.py	50.00%	2 Missing and 1 partial :warning:
src/datachain/listing.py	71.42%	1 Missing and 1 partial :warning:
src/datachain/sql/sqlite/base.py	89.47%	1 Missing and 1 partial :warning:
src/datachain/cli/commands/ls.py	80.00%	1 Missing :warning:

:loudspeaker: Thoughts on this report? Let us know!

[cloudflare-workers-and-pages[bot]]

Deploying with    Cloudflare Workers

The latest updates on your project. Learn more about integrating Git with Workers.

Status	Name	Latest Commit	Updated (UTC)
✅ Deployment successful! View logs	datachain-docs	f0bce782	Dec 01 2025, 06:59 PM