Deployments

// vercel.json
{
  "builds": [
    {
      "src": "package.json",
      "use": "@vercel/next"
    }
  ],
  "routes": [
    {
      "src": "/api/(.*)",
      "dest": "/api/$1"
    }
  ],
  "functions": {
    "app/api/**/*.ts": {
      "maxDuration": 30
    }
  }
}

# .github/workflows/deploy.yml
name: Deploy to Vercel

on:
  push:
    branches: [main, staging]
  pull_request:
    branches: [main]

jobs:
  test:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v3
      - uses: actions/setup-node@v3
        with:
          node-version: '18'
          cache: 'pnpm'
      
      - name: Install dependencies
        run: pnpm install
      
      - name: Run tests
        run: pnpm test
      
      - name: Run type check
        run: pnpm type-check
      
      - name: Run linting
        run: pnpm lint

  deploy:
    needs: test
    runs-on: ubuntu-latest
    if: github.ref == 'refs/heads/main'
    steps:
      - uses: actions/checkout@v3
      - name: Deploy to Vercel
        uses: amondnet/vercel-action@v20
        with:
          vercel-token: ${{ secrets.VERCEL_TOKEN }}
          vercel-org-id: ${{ secrets.ORG_ID }}
          vercel-project-id: ${{ secrets.PROJECT_ID }}
          vercel-args: '--prod'

# Create migration
supabase migration new add_new_feature

# Apply to staging
supabase db push --project-ref staging-project-ref

# Apply to production
supabase db push --project-ref production-project-ref

# Rollback last migration
supabase migration repair --status reverted

# Rollback specific migration
supabase db reset --project-ref project-ref

# Environment variables
NEXT_PUBLIC_SUPABASE_URL=https://your-project.supabase.co
NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key
SUPABASE_SERVICE_ROLE_KEY=your-service-role-key
NEXT_PUBLIC_APP_URL=https://talentg.vercel.app
NODE_ENV=production

# Environment variables
NEXT_PUBLIC_SUPABASE_URL=https://staging-project.supabase.co
NEXT_PUBLIC_SUPABASE_ANON_KEY=staging-anon-key
SUPABASE_SERVICE_ROLE_KEY=staging-service-role-key
NEXT_PUBLIC_APP_URL=https://talentg-staging.vercel.app
NODE_ENV=staging

// app/api/health/route.ts
export async function GET() {
  try {
    // Check database connection
    const { data } = await supabase.from('profiles').select('count').limit(1)
    
    // Check external services
    const services = await Promise.allSettled([
      checkSupabaseHealth(),
      checkEmailServiceHealth(),
      checkStorageHealth()
    ])
    
    const healthy = services.every(service => 
      service.status === 'fulfilled'
    )
    
    return Response.json({
      status: healthy ? 'healthy' : 'unhealthy',
      timestamp: new Date().toISOString(),
      services: services.map(s => ({
        name: s.status === 'fulfilled' ? s.value.name : 'unknown',
        status: s.status === 'fulfilled' ? 'up' : 'down'
      }))
    })
  } catch (error) {
    return Response.json(
      { status: 'unhealthy', error: error.message },
      { status: 500 }
    )
  }
}

// lib/analytics.ts
export const trackDeployment = (version: string) => {
  if (typeof window !== 'undefined' && window.gtag) {
    window.gtag('event', 'deployment', {
      version,
      timestamp: new Date().toISOString()
    })
  }
}

# Rollback to previous deployment
vercel rollback [deployment-url]

# Rollback database
supabase db reset --project-ref project-ref

# Security scanning in CI
- name: Run security audit
  run: pnpm audit --audit-level moderate

- name: Run Snyk security scan
  uses: snyk/actions/node@master
  with:
    args: --severity-threshold=high

# Check deployment status
vercel ls

# View deployment logs
vercel logs [deployment-url]

# Check database status
supabase status

# Test API endpoints
curl https://talentg.vercel.app/api/health