performance-tests.yml

name: GraphQL performance tests (auto)

on:
  workflow_dispatch:
  schedule:
    - cron: "37 * * * *"

jobs:
  run_tests:
    name: Run tests
    runs-on: ubuntu-latest
    steps:
      - name: Check out
        uses: actions/checkout@v2
      - name: Run k6 and upload results to Prometheus
        uses: addnab/docker-run-action@v3
        with:
          image: grafana/k6:latest
          options: |
            -v ${{ github.workspace }}:/root
            -e K6_PROMETHEUS_RW_USERNAME=${{ secrets.K6_PROMETHEUS_RW_USERNAME }}
            -e K6_PROMETHEUS_RW_PASSWORD=${{ secrets.K6_PROMETHEUS_RW_PASSWORD }}
            -e K6_PROMETHEUS_RW_SERVER_URL=${{ secrets.K6_PROMETHEUS_RW_SERVER_URL }}
            -e K6_PROMETHEUS_RW_TREND_STATS=avg
          run: |
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeComponents --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeComponents.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeComponents --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeComponents.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeComponents --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeComponents.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeMetadata --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeMetadata.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeMetadata --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeMetadata.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeMetadata --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeMetadata.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeObservations --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeObservations.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeObservations --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeObservations.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeObservations --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeObservations.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubePreview --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubePreview.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubePreview --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubePreview.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubePreview --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubePreview.js &&
            k6 run -o experimental-prometheus-rw --tag testid=PossibleFilters --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/PossibleFilters.js &&
            k6 run -o experimental-prometheus-rw --tag testid=PossibleFilters --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/PossibleFilters.js &&
            k6 run -o experimental-prometheus-rw --tag testid=PossibleFilters --env ENV=test --env ENDPOINT=https://test.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/PossibleFilters.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeComponents --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeComponents.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeComponents --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeComponents.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeComponents --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeComponents.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeMetadata --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeMetadata.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeMetadata --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeMetadata.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeMetadata --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeMetadata.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeObservations --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeObservations.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeObservations --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeObservations.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeObservations --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeObservations.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubePreview --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubePreview.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubePreview --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubePreview.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubePreview --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubePreview.js &&
            k6 run -o experimental-prometheus-rw --tag testid=PossibleFilters --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/PossibleFilters.js &&
            k6 run -o experimental-prometheus-rw --tag testid=PossibleFilters --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/PossibleFilters.js &&
            k6 run -o experimental-prometheus-rw --tag testid=PossibleFilters --env ENV=int --env ENDPOINT=https://int.visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/PossibleFilters.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeComponents --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeComponents.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeComponents --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeComponents.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeComponents --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeComponents.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeMetadata --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeMetadata.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeMetadata --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeMetadata.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeMetadata --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeMetadata.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeObservations --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeObservations.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeObservations --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeObservations.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubeObservations --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubeObservations.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubePreview --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubePreview.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubePreview --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubePreview.js &&
            k6 run -o experimental-prometheus-rw --tag testid=DataCubePreview --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/DataCubePreview.js &&
            k6 run -o experimental-prometheus-rw --tag testid=PossibleFilters --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/sfoe/bfe_ogd84_einmalverguetung_fuer_photovoltaikanlagen/9 --env CUBE_LABEL=Photovoltaikanlagen/9 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/PossibleFilters.js &&
            k6 run -o experimental-prometheus-rw --tag testid=PossibleFilters --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://environment.ld.admin.ch/foen/nfi/nfi_C-20/cube/2023-3 --env CUBE_LABEL=NFI/2023-3 --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/PossibleFilters.js &&
            k6 run -o experimental-prometheus-rw --tag testid=PossibleFilters --env ENV=prod --env ENDPOINT=https://visualize.admin.ch/api/graphql --env CUBE_IRI=https://energy.ld.admin.ch/elcom/electricityprice --env CUBE_LABEL=Elcom --env ROOT_PATH=/root/ - </root/k6/performance-tests/graphql/PossibleFilters.js