nightly-remove-stale-review-apps.yml

name: Nightly Remove Stale Review Apps and Images

on:
  # Allows you to run this workflow manually from the Actions tab
  workflow_dispatch:
  schedule:
    - cron: '0 0 * * *'

jobs:
  remove-stale-review-apps:
    runs-on: ubuntu-latest

    steps:
      - name: Checkout repository
        uses: actions/checkout@v4

      - name: Setup Environment
        uses: ./.github/actions/setup-environment
        with:
          token: ${{ secrets.CPLN_TOKEN_STAGING }}
          org: ${{ vars.CPLN_ORG_STAGING }}

      - name: Get Stale PRs
        id: stale_prs
        uses: actions/github-script@v7
        with:
          script: |
            const thirtyDaysAgo = new Date();
            thirtyDaysAgo.setDate(thirtyDaysAgo.getDate() - 30);
            
            const prs = await github.rest.pulls.list({
              owner: context.repo.owner,
              repo: context.repo.repo,
              state: 'closed',
              sort: 'updated',
              direction: 'desc'
            });
            
            const stalePRs = prs.data
              .filter(pr => new Date(pr.updated_at) < thirtyDaysAgo)
              .map(pr => pr.number);
            
            console.log('Found stale PRs:', stalePRs);
            return stalePRs;

      - name: Delete Stale Review Apps
        if: ${{ steps.stale_prs.outputs.result != '[]' }}
        run: |
          for pr in $(echo "${{ steps.stale_prs.outputs.result }}" | jq -r '.[]'); do
            APP_NAME="qa-react-webpack-rails-tutorial-pr-$pr"
            CPLN_ORG=${{ vars.CPLN_ORG_STAGING }}
            echo "🗑️ Deleting stale review app for PR #$pr: $APP_NAME"
            ${{ github.workspace }}/.github/actions/delete-control-plane-app/scripts/delete-app.sh
          done