sqlc-gen-csharp/.github/workflows/benchmark.yml at 8a630ae429922b38583b6131c39dd57f7d5259c2 · DaredevilOSS/sqlc-gen-csharp · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
name: Performance Benchmark
defaults:
  run:
    shell: bash

env:
  DOTNET_VERSION: '8.0.x'

on:
  push:
    branches: [ "add-performance-benchmark-with-efcore" ]
  release:
    types: [ published ]
  workflow_dispatch:

jobs:
  benchmark-mysql:
    name: MySQL Benchmark
    runs-on: ubuntu-latest

    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

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

      - name: Run Benchmark
        run: ./benchmark/scripts/run_benchmark_for_db.sh mysql

  benchmark-postgresql:
    name: PostgreSQL Benchmark
    runs-on: ubuntu-latest

    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

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

      - name: Run Benchmark
        run: ./benchmark/scripts/run_benchmark_for_db.sh postgresql

  benchmark-sqlite:
    name: SQLite Benchmark
    runs-on: ubuntu-latest

    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

      - name: Run Benchmark
        run: ./benchmark/scripts/run_benchmark_for_db.sh sqlite