┌─────────────────────────────────────────────────────────────┐
│                      FIXLIFY INFRASTRUCTURE                  │
├─────────────────────────────────────────────────────────────┤
│                                                              │
│  ┌──────────────┐     ┌──────────────┐     ┌─────────────┐ │
│  │   Vercel     │     │   Supabase   │     │   External  │ │
│  │  (Frontend)  │────▶│  (Backend)   │────▶│   Services  │ │
│  └──────────────┘     └──────────────┘     └─────────────┘ │
│        │                    │                     │         │
│        ▼                    ▼                     ▼         │
│  - React App          - PostgreSQL          - Telnyx SMS    │
│  - Static Assets      - Edge Functions      - Mailgun       │
│  - API Routes         - Auth                - Stripe        │
│  - Preview Deploys    - Storage             - OpenAI        │
│                       - Realtime                            │
└─────────────────────────────────────────────────────────────┘

# Preview deployment (automatic on PR)
git push origin feature/branch

# Production deployment
git checkout main
git merge staging
git push origin main

# Manual deployment
vercel --prod

# Rollback
vercel rollback

# Link to project
supabase link --project-ref mqppvcrlvsgrsqelglod

# Push migrations to staging
supabase db push --db-url "postgres://..."

# Push to production
supabase db push

# Deploy edge functions
supabase functions deploy function-name

# Deploy all functions
supabase functions deploy

# Create new migration
supabase migration new migration_name

# Generate from diff
supabase db diff -f migration_name

# Test locally
supabase db reset

-- Migration: add_client_tags
-- Description: Add tags support for clients
-- Rollback: DROP TABLE IF EXISTS client_tags;

CREATE TABLE IF NOT EXISTS client_tags (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  client_id UUID REFERENCES clients(id) ON DELETE CASCADE,
  tag TEXT NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

-- RLS
ALTER TABLE client_tags ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Users can manage own organization tags"
ON client_tags FOR ALL
USING (
  client_id IN (
    SELECT id FROM clients
    WHERE organization_id = (SELECT organization_id FROM profiles WHERE id = auth.uid())
  )
);

supabase/functions/
├── _shared/           # Shared utilities
│   ├── cors.ts
│   └── supabase-client.ts
├── function-name/
│   └── index.ts
└── .env              # Local env vars

# Single function
supabase functions deploy send-sms --no-verify-jwt

# All functions
supabase functions deploy

# Set secrets
supabase secrets set KEY=value

# Check Vercel status
curl -I https://fixlify.app/api/health

# Check Supabase
curl -I https://mqppvcrlvsgrsqelglod.supabase.co/rest/v1/

# Check Edge Functions
curl https://mqppvcrlvsgrsqelglod.supabase.co/functions/v1/health

# List deployments
vercel ls

# Rollback to previous
vercel rollback

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

-- Check migration history
SELECT * FROM supabase_migrations.schema_migrations ORDER BY version DESC;

-- Manual rollback (use with caution)
-- Execute rollback SQL from migration file

name: Deploy

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

jobs:
  test:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      - uses: actions/setup-node@v4
        with:
          node-version: '20'
          cache: 'npm'
      - run: npm ci
      - run: npm run lint
      - run: npm run build
      - run: npm test

  deploy-staging:
    needs: test
    if: github.ref == 'refs/heads/staging'
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      - uses: supabase/setup-cli@v1
      - run: supabase link --project-ref ${{ secrets.SUPABASE_PROJECT_ID }}
      - run: supabase db push
      - run: supabase functions deploy

  deploy-production:
    needs: test
    if: github.ref == 'refs/heads/main'
    runs-on: ubuntu-latest
    environment: production
    steps:
      - uses: actions/checkout@v4
      - uses: supabase/setup-cli@v1
      - run: supabase link --project-ref ${{ secrets.SUPABASE_PROJECT_ID }}
      - run: supabase db push
      - run: supabase functions deploy

-- Kill long-running queries
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE duration > interval '5 minutes';

-- Check connections
SELECT count(*) FROM pg_stat_activity;

VITE_SUPABASE_URL=https://mqppvcrlvsgrsqelglod.supabase.co
VITE_SUPABASE_ANON_KEY=...
VITE_STRIPE_PUBLISHABLE_KEY=...

supabase secrets list
supabase secrets set OPENAI_API_KEY=...
supabase secrets set TELNYX_API_KEY=...
supabase secrets set MAILGUN_API_KEY=...