mirror of
https://github.com/BerriAI/litellm.git
synced 2026-09-13 23:11:40 +00:00
This is the rip-and-replace counterpart to the phased migration in PR #28366. The proxy database layer is moved to SQLAlchemy + asyncpg in a single PR. Existing prisma_client.db.<table>.<method>(...) call sites keep working unchanged via a compatibility shim; the prisma PyPI package is dropped from runtime dependencies. The PR description carries the full breakage inventory. Test pass rates after rip-and-replace: * tests/test_litellm/proxy/db/ 247 / 263 = 93.9% * tests/test_litellm/proxy/management_endpoints/ 1288 / 1289 = 99.9% * tests/test_litellm/proxy/db/sqlmodel_orm/ 38 / 38 = 100% * combined 1573 / 1590 = 98.9% The 17 failures are all in tests of Prisma-internal subprocess / watchdog / RoutingPrismaWrapper mechanics that no longer apply to a SQLAlchemy backend. Architecture: * litellm/proxy/db/sqlmodel/schema_parser.py Pure-Python parser for the subset of Prisma DSL used by schema.prisma. (carried forward from the Phase 1 PR.) * litellm/proxy/db/sqlmodel/_generate.py Code generator that emits Black-formatted SQLModel classes from a parsed schema. Output uses JSONB().with_variant(JSON(), 'sqlite') so the model definitions are portable to SQLite test environments. * litellm/proxy/db/sqlmodel/models.py SQLModel classes for all 64 Prisma models, generator-seeded. * litellm/proxy/db/sqlmodel/engine.py LiteLLMDB wrapping the async SQLAlchemy engine + sessionmaker, with pluggable RDS IAM token rotation (engine recreate on each tick) and optional read-replica routing. * litellm/proxy/db/sqlmodel/compat.py PrismaCompatClient exposes the historical Prisma surface -- per-table accessors, find_unique/first/many, create/update/upsert/ delete/update_many/delete_many/create_many/count, query_raw/ execute_raw, batch_(), tx() -- backed by SQLAlchemy. Filter translation covers in/contains/startswith/endswith/lt/lte/gt/gte/has /AND/OR/NOT/equals plus mode:insensitive and data={...:{increment:N}}. * litellm/proxy/db/sqlmodel/errors.py Native error classes (PrismaError, UniqueViolationError, ...) raised by the shim. SQLAlchemy IntegrityError / NoResultFound / ProgrammingError are translated to the corresponding LiteLLM-native types. * tests/_prisma_compat.py + conftest.py Test-only stand-in for the prisma namespace so legacy from prisma.errors import X imports in test fixtures still resolve to the LiteLLM-native errors. Production code has been ported off from prisma imports entirely. Wiring: * litellm/proxy/utils.py PrismaClient.__init__ now constructs LiteLLMDB + PrismaCompatClient instead of Prisma + PrismaWrapper + RoutingPrismaWrapper. _get_engine_pid returns 0 (no subprocess). * The 9 production files that used from prisma.errors import ... / import prisma are redirected to the native errors module: exception_handler, log_db_metrics, toolset_db, budget/config_override /mcp/workflow management endpoints, key_management_endpoints. The prisma.Json(...) marker in key_management is replaced by an identity shim (SQLAlchemy JSONB accepts dicts directly). * prisma==0.11.0 dropped from extra_proxy and proxy-dev in pyproject.toml. Known gaps (called out explicitly in the PR body): * include= for relation eager-loading is logged-and-ignored. SQLModel classes don't carry SQLAlchemy relationship() defs yet; ~55 production sites pass include={} and would see None for the relation attribute. Hand-written relationships per table is the next step. * select=, group_by, and some/every relation filters raise NotImplementedError -- 3, 4, and 2 production sites respectively. * litellm-proxy-extras Prisma migration bundle is unchanged. Alembic baseline + recovery path is the next mechanical step. * schema.prisma copies, the sync workflows, helm migration jobs, and Dockerfile prisma-generate steps are unchanged. All rote follow-ups. Co-authored-by: Mateo Wang <mateo-berri@users.noreply.github.com> |
||
|---|---|---|
| .. | ||
| agent_tests | ||
| audio_tests | ||
| basic_proxy_startup_tests | ||
| batches_tests | ||
| benchmarks | ||
| code_coverage_tests | ||
| documentation_tests | ||
| enterprise | ||
| guardrails_tests | ||
| image_gen_tests | ||
| litellm | ||
| litellm-proxy-extras | ||
| litellm_core_utils | ||
| litellm_utils_tests | ||
| llm_responses_api_testing | ||
| llm_translation | ||
| load_tests | ||
| local_testing | ||
| logging_callback_tests | ||
| mcp_tests | ||
| multi_instance_e2e_tests | ||
| ocr_tests | ||
| old_proxy_tests/tests | ||
| openai_endpoints_tests | ||
| otel_tests | ||
| pass_through_tests | ||
| pass_through_unit_tests | ||
| proxy_admin_ui_tests | ||
| proxy_e2e_anthropic_messages_tests | ||
| proxy_security_tests | ||
| proxy_unit_tests | ||
| router_unit_tests | ||
| scim_tests | ||
| search_tests | ||
| spend_tracking_tests | ||
| store_model_in_db_tests | ||
| test_litellm | ||
| unified_google_tests | ||
| vector_store_tests | ||
| windows_tests | ||
| __init__.py | ||
| _flush_vcr_cache.py | ||
| _prisma_compat.py | ||
| _vcr_conftest_common.py | ||
| _vcr_redis_persister.py | ||
| eval_swe_bench.py | ||
| gettysburg.wav | ||
| large_text.py | ||
| openai_batch_completions.jsonl | ||
| README.MD | ||
| test_budget_management.py | ||
| test_callbacks_on_proxy.py | ||
| test_config.py | ||
| test_debug_warning.py | ||
| test_default_encoding_non_root.py | ||
| test_end_users.py | ||
| test_entrypoint.py | ||
| test_fallbacks.py | ||
| test_gpt5_azure_temperature_support.py | ||
| test_health.py | ||
| test_keys.py | ||
| test_litellm_proxy_responses_config.py | ||
| test_logging.conf | ||
| test_models.py | ||
| test_new_vector_store_endpoints.py | ||
| test_openai_endpoints.py | ||
| test_organizations.py | ||
| test_otel_thread_leak.py | ||
| test_passthrough_endpoints.py | ||
| test_presidio_latency.py | ||
| test_proxy_server_non_root.py | ||
| test_ratelimit.py | ||
| test_resource_cleanup.py | ||
| test_service_logger_otel.py | ||
| test_spend_logs.py | ||
| test_team.py | ||
| test_team_logging.py | ||
| test_team_members.py | ||
| test_users.py | ||
In total litellm runs 1000+ tests
[02/20/2025] Update:
To make it easier to contribute and map what behavior is tested,
we've started mapping the litellm directory in tests/test_litellm
This folder can only run mock tests.