benchmark.yml

name: Performance Benchmarks
defaults:
  run:
    shell: bash
  
permissions:
  contents: write
  pull-requests: write

env:
  DOTNET_VERSION: '8.0.x'

on:
  release:
    types: [ published ]
  workflow_dispatch:

jobs:  
  benchmark-mysql-reads:
    name: MySQL Reads Benchmark
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: ./benchmark
    
    steps:
      - uses: actions/checkout@v4

      - name: Set up .NET
        uses: actions/setup-dotnet@v4
        with:
          dotnet-version: ${{ env.DOTNET_VERSION }}

      - name: Load .env file
        uses: xom9ikk/dotenv@v2.3.0
        with:
          load-mode: strict
          path: benchmark

      - name: Docker compose
        uses: hoverkraft-tech/compose-action@v1.5.1
        with:
          services: mysqldb

      - name: Run Benchmark
        run: ./scripts/run_single_benchmark.sh mysql reads

      - name: Upload Results
        uses: actions/upload-artifact@v4
        if: success()
        with:
          name: mysql-reads-results
          path: BenchmarkDotNet.Artifacts/mysql/reads
  
  benchmark-mysql-writes:
    name: MySQL Writes Benchmark
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: ./benchmark
    
    steps:
      - uses: actions/checkout@v4

      - name: Set up .NET
        uses: actions/setup-dotnet@v4
        with:
          dotnet-version: ${{ env.DOTNET_VERSION }}

      - name: Load .env file
        uses: xom9ikk/dotenv@v2.3.0
        with:
          load-mode: strict
          path: benchmark

      - name: Docker compose
        uses: hoverkraft-tech/compose-action@v1.5.1
        with:
          services: mysqldb

      - name: Run Benchmark
        run: ./scripts/run_single_benchmark.sh mysql writes

      - name: Upload Results
        uses: actions/upload-artifact@v4
        if: success()
        with:
          name: mysql-writes-results
          path: BenchmarkDotNet.Artifacts/mysql/writes
  
  benchmark-postgresql-reads:
    name: PostgreSQL Reads Benchmark
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: ./benchmark
    
    steps:
      - uses: actions/checkout@v4

      - name: Set up .NET
        uses: actions/setup-dotnet@v4
        with:
          dotnet-version: ${{ env.DOTNET_VERSION }}

      - name: Load .env file
        uses: xom9ikk/dotenv@v2.3.0
        with:
          load-mode: strict
          path: benchmark

      - name: Docker compose
        uses: hoverkraft-tech/compose-action@v1.5.1
        with:
          services: postgresdb

      - name: Run Benchmark
        run: ./scripts/run_single_benchmark.sh postgresql reads

      - name: Upload Results
        uses: actions/upload-artifact@v4
        if: success()
        with:
          name: postgresql-reads-results
          path: BenchmarkDotNet.Artifacts/postgresql/reads

  benchmark-postgresql-writes:
    name: PostgreSQL Writes Benchmark
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: ./benchmark
    
    steps:
      - uses: actions/checkout@v4

      - name: Set up .NET
        uses: actions/setup-dotnet@v4
        with:
          dotnet-version: ${{ env.DOTNET_VERSION }}

      - name: Load .env file
        uses: xom9ikk/dotenv@v2.3.0
        with:
          load-mode: strict
          path: benchmark

      - name: Docker compose
        uses: hoverkraft-tech/compose-action@v1.5.1
        with:
          services: postgresdb

      - name: Run Benchmark
        run: ./scripts/run_single_benchmark.sh postgresql writes

      - name: Upload Results
        uses: actions/upload-artifact@v4
        if: success()
        with:
          name: postgresql-writes-results
          path: BenchmarkDotNet.Artifacts/postgresql/writes
        
  benchmark-sqlite-reads:
    name: SQLite Reads Benchmark
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: ./benchmark
    
    steps:
      - uses: actions/checkout@v4

      - name: Set up .NET
        uses: actions/setup-dotnet@v4
        with:
          dotnet-version: ${{ env.DOTNET_VERSION }}
    
      - name: Load .env file
        uses: xom9ikk/dotenv@v2.3.0
        with:
          load-mode: strict
          path: benchmark

      - name: Run Benchmark
        run: ./scripts/run_single_benchmark.sh sqlite reads

      - name: Upload Results
        uses: actions/upload-artifact@v4
        if: success()
        with:
          name: sqlite-reads-results
          path: BenchmarkDotNet.Artifacts/sqlite/reads

  benchmark-sqlite-writes:
    name: SQLite Writes Benchmark
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: ./benchmark
    
    steps:
      - uses: actions/checkout@v4

      - name: Set up .NET
        uses: actions/setup-dotnet@v4
        with:
          dotnet-version: ${{ env.DOTNET_VERSION }}
    
      - name: Load .env file
        uses: xom9ikk/dotenv@v2.3.0
        with:
          load-mode: strict
          path: benchmark

      - name: Run Benchmark
        run: ./scripts/run_single_benchmark.sh sqlite writes

      - name: Upload Results
        uses: actions/upload-artifact@v4
        if: success()
        with:
          name: sqlite-writes-results
          path: BenchmarkDotNet.Artifacts/sqlite/writes
        
  push-results:
    name: Push Results
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: ./benchmark
    if: always() && github.event_name == 'release'
    needs: [
      benchmark-mysql-reads, benchmark-mysql-writes, 
      benchmark-postgresql-reads, benchmark-postgresql-writes, 
      benchmark-sqlite-reads, benchmark-sqlite-writes
    ]

    steps:
      - uses: actions/checkout@v4

      - name: Download MySQL Reads Results
        uses: actions/download-artifact@v4
        with:
          name: mysql-reads-results
          path: BenchmarkDotNet.Artifacts/mysql/reads

      - name: Download MySQL Writes Results
        uses: actions/download-artifact@v4
        with:
          name: mysql-writes-results
          path: BenchmarkDotNet.Artifacts/mysql/writes

      - name: Download PostgreSQL Reads Results
        uses: actions/download-artifact@v4
        with:
          name: postgresql-reads-results
          path: BenchmarkDotNet.Artifacts/postgresql/reads

      - name: Download PostgreSQL Writes Results
        uses: actions/download-artifact@v4
        with:
          name: postgresql-writes-results
          path: BenchmarkDotNet.Artifacts/postgresql/writes

      - name: Download SQLite Reads Results
        uses: actions/download-artifact@v4
        with:
          name: sqlite-reads-results
          path: BenchmarkDotNet.Artifacts/sqlite/reads

      - name: Download SQLite Writes Results
        uses: actions/download-artifact@v4
        with:
          name: sqlite-writes-results
          path: BenchmarkDotNet.Artifacts/sqlite/writes

      - name: Update Wasm Plugin
        run: ./scripts/update_wasm_plugin.sh

      - name: Create Pull Request
        uses: peter-evans/create-pull-request@v6
        env:
          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        with:
          base: main
          title: update benchmark results
          commit-message: update benchmark results
          branch: update-benchmark-results
          branch-suffix: timestamp
          delete-branch: true