Phase 6: Scripts & Automation

[lsetiawan]

Parent Issue: #54

Goal

Create helper scripts for common development tasks.

Tasks

• Create scripts/ directory
• Write scripts/setup_dev.sh
  • Install Pixi (if not installed)
  • Run pixi install
  • Copy .env.example to .env
  • Build Docker containers
  • Run initial migrations
  • Verify setup
• Write scripts/migrate_db.sh
  • Wrapper for Alembic commands
  • ./scripts/migrate_db.sh upgrade runs upgrade
  • ./scripts/migrate_db.sh downgrade runs downgrade
  • Checks for Docker running
• Write scripts/seed_data.sh (optional)
  • Load sample data for development
  • Reset database to known state
• Write scripts/test_all.sh
  • Run all tests (unit, integration, API)
  • Generate coverage reports
  • Return appropriate exit codes
• Write scripts/deploy.sh (future use)
  • Placeholder for deployment automation
• Make all scripts executable: chmod +x scripts/*.sh
• Document scripts in README.md

Success Criteria

• All scripts are executable and documented
• setup_dev.sh successfully sets up development environment
• migrate_db.sh simplifies database migration workflow
• test_all.sh runs complete test suite
• Scripts documented in README.md

Dependencies

• Depends on: Phase 4: Update Docker for Namespace Packages #59 (Phase 4) - Docker setup

Labels

Sub-task, phase-6, scripts, automation, developer-experience