refresh-sqlite-integration.yml

name: 'Refresh SQLite plugin'

on:
    workflow_dispatch:
    # Every 20 minutes
    schedule:
        - cron: '0 9 * * *'

jobs:
    build_and_deploy:
        # Only run this workflow from the trunk branch and when it's triggered by a Playground maintainer
        if: >
            github.ref == 'refs/heads/trunk' && (
                github.actor == 'adamziel' ||
                github.actor == 'dmsnell' ||
                github.actor == 'bgrgicak' ||
                github.actor == 'brandonpayton' ||
                github.actor == 'zaerl'
            )

        runs-on: ubuntu-latest
        environment:
            name: wordpress-assets
        concurrency:
            group: check-version-and-run-build
        steps:
            - uses: actions/checkout@v4
              with:
                  ref: ${{ github.event.pull_request.head.ref }}
                  clean: true
                  persist-credentials: false
                  submodules: true
            - uses: ./.github/actions/prepare-playground
            - name: 'Refresh the SQLite bundle'
              shell: bash
              run: npx nx bundle-sqlite-database playground-wordpress-builds
            - name: Check for uncommitted changes
              id: changes
              run: |
                  if [ -z "$(git status --porcelain)" ]; then
                      echo "No changes"
                      echo 'CHANGES=0' >> $GITHUB_OUTPUT
                  else
                      echo "Changes detected"
                      echo 'CHANGES=1' >> $GITHUB_OUTPUT
                  fi
            - name: Push changes to GitHub
              if: steps.changes.outputs.CHANGES == '1'
              run: |
                  git config --global user.name "deployment_bot"
                  git config --global user.email "deployment_bot@users.noreply.github.com"
                  git remote set-url origin https://${{ secrets.GH_ACTOR }}:${{ secrets.GH_TOKEN }}@github.com/${{ github.repository }}
                  git add -A
                  git commit -a -m "Refresh SQLite integration plugin"
                  git pull --rebase
                  # Push if the pull did not result in a conflict
                  if [ $? -eq 0 ]; then
                      git push origin HEAD:trunk
                  fi;
            - name: Deploy website
              if: steps.changes.outputs.CHANGES == '1'
              uses: benc-uk/workflow-dispatch@v1
              with:
                  workflow: build-website.yml
                  token: ${{ secrets.GITHUB_TOKEN }}