nightly-performance-benchmarks-email-report.yaml

name: Nightly Benchmarks

on:
  workflow_dispatch:
  schedule:
    - cron: '0 2 * * *'

jobs:
  perf:
    runs-on: ubuntu-22.04
    name: Trigger Benchmark Latency, Benchmark Import, and SQL Correctness K8s Workflows
    steps:
      - uses: peter-evans/repository-dispatch@v2.0.0
        with:
          token: ${{ secrets.REPO_ACCESS_TOKEN }}
          event-type: benchmark-latency
          client-payload: '{"from_server": "mysql", "from_version": "8.0.35", "to_server": "dolt", "to_version": "${{ github.sha }}", "mode": "nightly", "actor": "${{ github.actor }}", "template_script": "./.github/scripts/performance-benchmarking/get-mysql-dolt-job-json.sh"}'
      - uses: peter-evans/repository-dispatch@v2.0.0
        with:
          token: ${{ secrets.REPO_ACCESS_TOKEN }}
          event-type: sql-correctness
          client-payload: '{"to_version": "${{ github.sha }}", "mode": "nightly", "actor": "${{ github.actor }}", "template_script": "./.github/scripts/sql-correctness/get-dolt-correctness-job-json.sh"}'
      - uses: peter-evans/repository-dispatch@v2.0.0
        with:
          token: ${{ secrets.REPO_ACCESS_TOKEN }}
          event-type: benchmark-import
          client-payload: |
            {
              "email_recipient": "${{ secrets.PERF_REPORTS_EMAIL_ADDRESS }}",
              "version": "${{ github.sha }}",
              "run_file": "ci.yaml",
              "summary": "summary.sql",
              "report": "three_way_compare.sql",
              "commit_to_branch": "nightly",
              "actor": "${{ github.actor }}"
            }
      - uses: peter-evans/repository-dispatch@v2.0.0
        with:
          token: ${{ secrets.REPO_ACCESS_TOKEN }}
          event-type: test-orm-integrations
      - uses: peter-evans/repository-dispatch@v2.0.0
        with:
          token: ${{ secrets.REPO_ACCESS_TOKEN }}
          event-type: benchmark-systab
          client-payload: |
            {
              "email_recipient": "${{ secrets.PERF_REPORTS_EMAIL_ADDRESS }}",
              "version": "${{ github.sha }}",
              "run_file": "systab.yaml",
              "report": "systab.sql",
              "summary": "systab_summary.sql",
              "commit_to_branch": "nightly",
              "actor": "${{ github.actor }}"
            }
      - uses: peter-evans/repository-dispatch@v2.0.0
        with:
          token: ${{ secrets.REPO_ACCESS_TOKEN }}
          event-type: benchmark-merge
          client-payload: |
            {
              "email_recipient": "${{ secrets.PERF_REPORTS_EMAIL_ADDRESS }}",
              "version": "${{ github.sha }}",
              "commit_to_branch": "nightly",
              "actor": "${{ github.actor }}"
            }