From 7c05359bccfa0ca50a8f55c1a99cfadd731c8e89 Mon Sep 17 00:00:00 2001
From: TheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com>
Date: Wed, 1 Apr 2026 18:06:25 +0900
Subject: fix: resolve final 3 issues for production readiness

- Fix API strategies endpoint path resolution (use STRATEGIES_DIR env var)
- Add DATABASE_URL env var override in alembic env.py
- Move risk config fields to shared Settings base class
- Remove duplicate fields from ExecutorConfig
---
 shared/alembic/env.py | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'shared/alembic')

diff --git a/shared/alembic/env.py b/shared/alembic/env.py
index 14303f6..18687f2 100644
--- a/shared/alembic/env.py
+++ b/shared/alembic/env.py
@@ -1,6 +1,7 @@
 """Alembic environment configuration for async PostgreSQL migrations."""
 
 import asyncio
+import os
 from logging.config import fileConfig
 
 from alembic import context
@@ -14,6 +15,13 @@ config = context.config
 if config.config_file_name is not None:
     fileConfig(config.config_file_name)
 
+# Override URL from DATABASE_URL env var if set
+database_url = os.environ.get("DATABASE_URL")
+if database_url:
+    if database_url.startswith("postgresql://"):
+        database_url = database_url.replace("postgresql://", "postgresql+asyncpg://", 1)
+    config.set_main_option("sqlalchemy.url", database_url)
+
 target_metadata = Base.metadata
 
 
-- 
cgit v1.2.3