Skip to main content

Documentation Index

Fetch the complete documentation index at: https://openwearables.io/docs/llms.txt

Use this file to discover all available pages before exploring further.

Data migration scripts live in backend/scripts/data_migrations/. They are run manually — not applied automatically on deploy — and are intended for one-off corrections, backfills, or clean-ups that cannot be expressed as a zero-downtime Alembic migration.

​
Prerequisites

The scripts import from the app package and connect to the database via the environment variables in backend/config/.env. You need:
  • Docker Compose services running (docker compose up -d)
  • The app container healthy (check with docker compose ps)
  • A database with the latest Alembic migrations applied (docker compose exec app uv run alembic upgrade head)

​
Running a script

All scripts are run inside the app container using uv run: 
docker compose exec app uv run python scripts/data_migrations/<script_name>.py [options]

​
Dry run first

Every script supports a --dry-run flag. Always run it first — it prints the rows that would be affected without making any changes: 
docker compose exec app uv run python scripts/data_migrations/<script_name>.py --dry-run

​
Apply changes

Once satisfied with the dry-run output, run without the flag: 
docker compose exec app uv run python scripts/data_migrations/<script_name>.py
Scripts write directly to the database. There is no automatic rollback. Take a database snapshot before running against production.