{
  "scripts": {
    "test": "NODE_OPTIONS='--experimental-vm-modules' jest --bail --maxWorkers=1 --forceExit",
    // ... other scripts ...
    "test": "tests"  // ← DUPLICATE! This overwrites the real test command
  }
}

# After fix, run:
npm test
# Should execute Jest, not fail with "command not found: tests"

- name: Create integration test database
  run: |
    sqlite3 ${{ env.INTEGRATION_DB_PATH }} << 'EOF'
    # ... SQL commands ...

- name: Install SQLite3
  run: |
    sudo apt-get update -qq
    sudo apt-get install -y sqlite3
    sqlite3 --version

- name: Setup integration test environment
  run: |
    echo "🔧 Setting up integration test environment..."

    # Install SQLite3
    sudo apt-get update -qq
    sudo apt-get install -y sqlite3

    # Verify installation
    if ! command -v sqlite3 &> /dev/null; then
      echo "❌ SQLite3 installation failed"
      exit 1
    fi

    echo "✅ SQLite3 installed: $(sqlite3 --version)"

- name: Create integration test database
  run: |
    echo "🗄️ Creating integration test database..."

    DB_PATH="${{ env.INTEGRATION_DB_PATH }}"
    mkdir -p "$(dirname "$DB_PATH")"
    mkdir -p integration-test-data

    # Create database (existing SQL commands)
    sqlite3 "$DB_PATH" <<'SQL'
    -- SQL commands here
SQL

    # Verify creation
    if [ ! -f "$DB_PATH" ]; then
      echo "❌ Database creation failed"
      exit 1
    fi

    echo "✅ Database created successfully"

- name: Test rollback target viability
  run: |
    # ...
    npm ci || true            # ← Masks failures
    npm run build:ts || echo "⚠️ Build test failed"  # ← Masks failures

- name: Test rollback target viability
  run: |
    echo "🧪 Testing rollback target viability..."

    ROLLBACK_TARGET="${{ github.event.inputs.rollback_target || needs.failure-detection.outputs.rollback-target }}"

    # Create temporary branch for testing
    git checkout -b test-rollback-temp "$ROLLBACK_TARGET"

    # STRICT MODE: Exit on any failure
    set -e
    set -o pipefail

    echo "Installing dependencies..."
    npm ci

    echo "Testing TypeScript compilation..."
    npm run build:ts

    echo "Running smoke tests..."
    npm run test:health || true  # This one can be optional

    # Clean up
    git checkout "${{ github.ref_name }}"
    git branch -D test-rollback-temp

    echo "✅ Rollback target is viable"

# 1. Open package.json
code package.json

# 2. Find and remove this line:
#    "test": "tests"
#    (It's likely near the end of the scripts section)

# 3. Save the file

# 4. Test locally:
npm test
# Should see Jest starting, not "command not found: tests"

# 5. Commit:
git add package.json
git commit -m "fix: Remove duplicate test script key in package.json

- Removed duplicate 'test': 'tests' key that was overwriting the Jest test command
- This was causing all CI test runs to fail with 'command not found: tests'
- Fixes CI/CD Pipeline workflow failures"

# 1. Open integration tests workflow
code .github/workflows/integration-tests.yml

# 2. Find line ~86 (Create integration test database)

# 3. ADD NEW STEP BEFORE IT:
#    Copy the "Install SQLite3" step from Issue #2 above

# 4. OPTIONAL: Also update the database creation step to include error checking

# 5. Commit:
git add .github/workflows/integration-tests.yml
git commit -m "fix: Add SQLite3 installation to integration test workflow

- Integration test setup was failing due to missing sqlite3 command
- Added apt-get installation of sqlite3 with verification
- Added error checking for database creation
- Fixes Integration Tests workflow failures"

# 1. Open rollback manager workflow
code .github/workflows/rollback-manager.yml

# 2. Find line ~249 (Test rollback target viability)

# 3. Replace the entire step with the strict version from Issue #3 above

# 4. Commit:
git add .github/workflows/rollback-manager.yml
git commit -m "fix: Enforce strict validation in rollback target testing

- Removed || true and || echo that masked failures
- Added set -e to exit immediately on errors
- Added proper error propagation
- Prevents rollback to broken commits
- Fixes Rollback Manager workflow failures"

# 1. Push all commits
git push origin claude/align-flow-with-mcp-011CV45c34eF2MawJHUpj9XD

# 2. Monitor workflow runs
gh run watch

# 3. Check individual workflow statuses
gh run list --limit 5

# 4. If failures persist, check logs:
gh run view --log-failed

# Check if tests run locally
npm test

# Check if there are other test issues
npm run test:ci

# Check build works
npm run build:ts

# Check for TypeScript errors
npm run typecheck

# Check for linting errors
npm run lint

# Verify SQLite3 is available in CI
# Add this temporary debug step:
- name: Debug SQLite installation
  run: |
    which sqlite3
    sqlite3 --version
    echo "PATH: $PATH"

# Check database path
# Add this debug step:
- name: Debug database creation
  run: |
    echo "DB_PATH: ${{ env.INTEGRATION_DB_PATH }}"
    ls -la "$(dirname "${{ env.INTEGRATION_DB_PATH }}")"
    if [ -f "${{ env.INTEGRATION_DB_PATH }}" ]; then
      echo "Database exists"
      sqlite3 "${{ env.INTEGRATION_DB_PATH }}" "SELECT name FROM sqlite_master WHERE type='table';"
    else
      echo "Database does not exist"
    fi

# Check git history
git log --oneline -10

# Test rollback target locally
git checkout HEAD~1
npm ci
npm run build:ts
git checkout -

# Verify package-lock.json is valid
jq empty package-lock.json && echo "Valid JSON" || echo "Invalid JSON"