Migrations de Base de Données en Production

Running database schema migrations safely in production requires isolating schema DDL operations from the application container lifecycle.

Workflow de Migration Sécurisé

Pre-Deployment Check: Test migration scripts in a staging environment matching production TimescaleDB versions:
```
alembic current
alembic heads
```
Execute Migrations Before Code Rollout: Déclencher le conteneur de profil de migration à exécution unique :
```
docker compose --profile migrate run --rm fonrex-migrate
```
Deploy New API Containers: Once alembic upgrade head finishes successfully, update your API application image:
```
docker compose up -d fonrex-api
```

Rollback Strategy: If a migration fails, revert to the previous migration revision:

docker compose --profile migrate run --rm fonrex-migrate alembic downgrade -1