Refactor database connections and add integration tests

- Use context managers for sqlite3 connections in cron, vclogs, and database utils
- Add URL helper utility for yt-dlp with clean_url_for_ytdlp function
- Add slow integration test markers and new integration test files
- Fix test imports to use conftest directly instead of tests.conftest
- Improve downloader error handling and use COPYPARTY_URL_UPLOAD env var
- Update pytest.ini with slow test markers and warning filters
- Document slow test usage in AGENTS.md

1 files changed, 7 insertions, 5 deletions

diff --git a/pytest.ini b/pytest.ini
index 03a070f..23e8e9c 100644
--- a/pytest.ini
+++ b/pytest.ini
@@ -1,7 +1,9 @@
 [pytest]
+markers =
+    slow: marks tests as slow (deselect with '-m "not slow"')
+asyncio_mode = strict
 asyncio_default_fixture_loop_scope = function
-python_files = test_*.py
-python_classes = Test*
-python_functions = test_*
-testpaths = tests
-pythonpath = .
\ No newline at end of file
+filterwarnings =
+    ignore::RuntimeWarning
+    ignore::pytest.PytestUnraisableExceptionWarning
+    ignore::DeprecationWarning:discord.client
\ No newline at end of file