summaryrefslogtreecommitdiff
path: root/Makefile
diff options
context:
space:
mode:
authorTheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com>2026-04-01 16:00:38 +0900
committerTheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com>2026-04-01 16:02:03 +0900
commit2b1db156c7ea7e0be543ab91813922b95eb043cb (patch)
treefd19abb0845d96e160c68817190b33a0f6c0034d /Makefile
parent33b14aaa2344b0fd95d1629627c3d135b24ae102 (diff)
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.
Diffstat (limited to 'Makefile')
-rw-r--r--Makefile11
1 files changed, 10 insertions, 1 deletions
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)"