triviathang/MIGRATION_GUIDE.md

Database Migration Guide

After updating the code, run these commands to create and apply the database migration:

# Build and start containers
docker compose up --build -d

# Create migration
docker compose exec backend uv run flask db migrate -m "Add YouTube audio support and download job tracking"

# Apply migration
docker compose exec backend uv run flask db upgrade

# Verify services are running
docker compose ps

# View logs
docker compose logs -f backend
docker compose logs -f celery-worker

Services

• Backend: http://localhost:5001
• Frontend: http://localhost:3000
• Celery Flower (monitoring): http://localhost:5555
• Redis: localhost:6379

Troubleshooting

If migration fails:

# Check if database is accessible
docker compose exec backend ls -la backend/instance/

# Reset if needed (WARNING: destroys data)
docker compose down -v
docker compose up --build -d
docker compose exec backend uv run flask db init
docker compose exec backend uv run flask db migrate -m "Initial migration"
docker compose exec backend uv run flask db upgrade