Description
When SentinelPay moves from in-memory storage to PostgreSQL, we need
database migration scripts to create the schema. This issue sets up
Alembic and creates the initial migration for the three core tables.
Tasks
Acceptance Criteria
alembic upgrade head creates all three tables
alembic downgrade -1 rolls back cleanly
- Migration scripts are committed in
migrations/versions/
Good first issue because
Alembic has excellent documentation. This task does not require
understanding the fraud detection logic.
Description
When SentinelPay moves from in-memory storage to PostgreSQL, we need
database migration scripts to create the schema. This issue sets up
Alembic and creates the initial migration for the three core tables.
Tasks
alembicandsqlalchemyalembic init migrationsat repo roottransactions,fraud_cases,audit_recordsalembic revision --autogeneratealembic upgrade headruns without errors againsta local PostgreSQL instance
Acceptance Criteria
alembic upgrade headcreates all three tablesalembic downgrade -1rolls back cleanlymigrations/versions/Good first issue because
Alembic has excellent documentation. This task does not require
understanding the fraud detection logic.