44 lines
1.1 KiB
Markdown
44 lines
1.1 KiB
Markdown
# Database Migration Guide
|
|
|
|
After updating the code, run these commands to create and apply the database migration:
|
|
|
|
```bash
|
|
# 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:
|
|
```bash
|
|
# 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
|
|
```
|