From 2b1db156c7ea7e0be543ab91813922b95eb043cb Mon Sep 17 00:00:00 2001
From: TheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com>
Date: Wed, 1 Apr 2026 16:00:38 +0900
Subject: feat: add SQLAlchemy ORM models and Alembic migration setup

Add SA 2.0 declarative models (CandleRow, SignalRow, OrderRow, TradeRow,
PositionRow, PortfolioSnapshotRow) mirroring existing asyncpg tables.
Set up Alembic with async PostgreSQL support and add migrate/migrate-down/
migrate-new Makefile targets. Update shared dependencies with sqlalchemy,
alembic, structlog, prometheus-client, pyyaml, aiohttp, and rich.
---
 Makefile | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'Makefile')

diff --git a/Makefile b/Makefile
index e852fac..e7878d6 100644
--- a/Makefile
+++ b/Makefile
@@ -1,4 +1,4 @@
-.PHONY: infra up down logs test lint format
+.PHONY: infra up down logs test lint format migrate migrate-down migrate-new
 
 infra:
 	docker compose up -d redis postgres
@@ -22,3 +22,12 @@ lint:
 format:
 	ruff check --fix .
 	ruff format .
+
+migrate:
+	cd shared && alembic upgrade head
+
+migrate-down:
+	cd shared && alembic downgrade -1
+
+migrate-new:
+	cd shared && alembic revision --autogenerate -m "$(msg)"
-- 
cgit v1.2.3