GitHub Actionsを使ってLookML開発フローをちょっと自動化する

on:
  push:
    branches:
      - master
name:repoBのmasterブランチをrepoAのstagingブランチに同期
jobs:
  PushStagingToProductionRepository:
    #repoBでしかgithub actionsが発火しないようにフィルタ
    if: ${{ github.repository == 'yourorg/repoB' }}
    name: git push
    runs-on: ubuntu-latest
    steps:
    - uses: actions/[email protected]
      with:
        fetch-depth: 0
    - run: |
        #repoAに書き込むための設定
        git remote set-url origin https://x-access-token:${GH_TOKEN_REPOA_PUSH}@github.com/${GITHUB_REPOSITORY}.git
        git remote add prod https://x-access-token:${GH_TOKEN_REPOA_PUSH}@github.com/yourorg/repoA.git
      env:
        # repoAにpushするためのgithub tokenを発行してsecretに設定
        GH_TOKEN_REPOA_PUSH: ${{ secrets.GH_TOKEN_REPOA_PUSH }}
    - run: |
        git fetch origin master
        git checkout master
        git pull --ff-only origin master
        # 他のprivate repositoryにアクセスするための設定
        git config --local --remove-section http."https://github.com/"
        git config --global url."https://x-access-token:${GH_TOKEN_REPOA_PUSH}@github.com/".insteadOf "https://github.com/"
        git fetch prod
        git push -f prod master:staging
      env:
        GH_TOKEN_REPOA_PUSH: ${{ secrets.GH_TOKEN_REPOA_PUSH }}

on:
  push:
    branches:
      - staging
name: 本番インスタンスリリース用PR作成
jobs:
  PRReleaseProd:
    #repoAでしかgithub actionsが発火しないようにフィルタ
    if: ${{ github.repository == 'yourorg/repoA' }}
    name: リリースPR作成
    runs-on: ubuntu-latest
    steps:
    - uses: actions/[email protected]
      with:
        fetch-depth: 0
    - run: git remote set-url origin https://x-access-token:${GITHUB_TOKEN}@github.com/${GITHUB_REPOSITORY}.git
      env:
        GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        TZ: Asia/Tokyo
    - run: |
        CURRENT_REF=$(git rev-parse HEAD)
        echo ::set-output name=pr_title::"[Production] LookML本番インスタンスへデプロイ $(date +%Y%m%d)"
      id: vars
      env:
        GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        TZ: Asia/Tokyo
    - name: pull-request
      uses: ainoya/pull-request@master
      with:
        source_branch: staging
        destination_branch: master
        pr_title: ${{ steps.vars.outputs.pr_title }}
        pr_body: "このPRをマージすることでLookMLを本番インスタンスにデプロイします。"
        github_token: ${{ secrets.GITHUB_TOKEN }}

on:
  push:
    branches:
      - master
name: Create PR releasing Production
jobs:
  PRReleaseProd:
    name: Create PR releasing Production
    runs-on: ubuntu-latest
    steps:
    - uses: actions/[email protected]
      with:
        fetch-depth: 0
    - run: |
        git remote set-url origin https://x-access-token:${GITHUB_TOKEN}@github.com/${GITHUB_REPOSITORY}.git
        git fetch origin master
        git fetch origin prod
      env:
        GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        TZ: Asia/Tokyo
    - run: |
        cat << EOF > pr.template
        [Production] Release <%= Time.now.strftime("%F %T") %>
        <% pull_requests.each do |pr| -%>
        <%=  pr.to_checklist_item %>
        <% end -%>
        EOF
    - name: git-pr-release-prod
      uses: ainoya/git-pr-release-action@master
      env:
        GIT_PR_RELEASE_TEMPLATE: ./pr.template
        GIT_PR_RELEASE_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        GIT_PR_RELEASE_BRANCH_STAGING: master
        GIT_PR_RELEASE_BRANCH_PRODUCTION: prod
        GIT_PR_RELEASE_LABELS: "Release/Production"
        TZ: Asia/Tokyo

on:
  push:
    branches:
      - prod
name: Looker APIを叩いてデプロイを起動する
jobs:
  PRReleaseProd:
    name: Create PR releasing Production
    runs-on: ubuntu-latest
    steps:
    - uses: actions/[email protected]
      with:
        fetch-depth: 0
    - run: |
        # webhook経由でprodブランチからの
        # 事前にAdvanced deploy modeをLookerの設定で有効にしておく
　　　　 # https://docs.looker.com/data-modeling/getting-started/advanced-deploy-mode
        curl -X POST -H "X-Looker-Deploy-Secret:${LOOKER_WEBHOOK_SECRET}" 
             https://yourinstance.looker.com/webhooks/projects/yourproject/deploy/prod
      env:
        GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        LOOKER_WEBHOOK_SECRET: ${{ secrets.LOOKER_WEBHOOK_SECRET }}

# ベースのLookMLから各環境用の定義を自動生成する
on:
  push:
    branches:
      - master
name: ベースのLookMLから各環境用の定義を自動生成する
jobs:
  generateLookML:
    name: git push
    runs-on: ubuntu-latest
    steps:
    - uses: actions/[email protected]
      with:
        fetch-depth: 0
    - run: |
        git remote set-url origin https://x-access-token:${GITHUB_TOKEN}@github.com/${GITHUB_REPOSITORY}.git
    - run: |
        git switch -c generate-lookml
        git config --global user.email "[email protected]"
        git config --global user.name "github-actions"
        make build # ベースの定義を生成するスクリプトを走らせる
        git add generated # generatedディレクトリ配下に自動生成したものが配置されるとして、generatedディレクトリをgit add
        git commit -am 'LookML定義自動生成'
        git push -f origin generate-lookml # 生成結果をgit push
    - name: pull-request
      uses: ainoya/pull-request@master
      with:
        source_branch: generate-lookml
        destination_branch: master
        pr_title: LookML定義 自動生成
        pr_body: "各環境用のLookML定義を生成しました"
        github_token: ${{ secrets.GITHUB_TOKEN }}