dispatched-pgsql10-tests.yml

name: 🛠🐘 PostgreSQL 10+ tests
run-name: Run database tests on PostgreSQL on dispatch. Run No ${{ github.run_number }}.
on:
  workflow_dispatch:
    inputs:
      specific_sha:
        description: 'Commit SHA to checkout'
        required: false
        default: ''
        type: string
      show_all_fails:
        description: 'No mute tests'
        type: boolean
        default: false
        required: true
      # EOL - moved to addtional versions
      #pgsql110:
      #  description: 'PostgreSQL 11'
      #  type: boolean
      #  default: false
      #  required: true
      # EOL - moved to addtional versions
      #pgsql120:
      #  description: 'PostgreSQL 12'
      #  type: boolean
      #  default: false
      #  required: true
      pgsql130:
        description: 'PostgreSQL 13'
        type: boolean
        default: true
        required: true
      pgsql140:
        description: 'PostgreSQL 14'
        type: boolean
        default: false
        required: true
      pgsql150:
        description: 'PostgreSQL 15'
        type: boolean
        default: false
        required: true
      pgsql160:
        description: 'PostgreSQL 16'
        type: boolean
        default: false
        required: true
      pgsql170:
        description: 'PostgreSQL 17'
        type: boolean
        default: true
        required: true
      pgsql180:
        description: 'PostgreSQL 18'
        type: boolean
        default: false
        required: true
      #pgsql190:
      #  description: 'PostgreSQL 19'
      #  type: boolean
      #  default: false
      #  required: true
      additional_versions:
        description: 'Additional versions (separated by ;)'
        required: false
        default: 'pgsql100;pgsql110;pgsql120'
        type: string
      

# new commits with the same key will cancel previously run workflows
concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

permissions:
  contents: read
  actions: read
  checks: write

jobs:
  test_on_pgsql110:
    name: Tests on PostgreSQL 11
    if: ${{ contains(inputs.additional_versions, 'pgsql110') }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: pgsql110
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 30
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  test_on_pgsql120:
    name: Tests on PostgreSQL 12
    if: ${{ contains(inputs.additional_versions, 'pgsql120') }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: pgsql120
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 30
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  test_on_pgsql130:
    name: Tests on PostgreSQL 13
    if: ${{ inputs.pgsql130 }}
    strategy:
      fail-fast: false
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: pgsql130
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 30
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  test_on_pgsql140:
    name: Tests on PostgreSQL 14
    if: ${{ inputs.pgsql140 }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: pgsql140
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 30
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  test_on_pgsql150:
    name: Tests on PostgreSQL 15
    if: ${{ inputs.pgsql150 }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: pgsql150
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 30
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  test_on_pgsql160:
    name: Tests on PostgreSQL 16
    if: ${{ inputs.pgsql160 }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: pgsql160
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 30
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  test_on_pgsql170:
    name: Tests on PostgreSQL 17
    if: ${{ inputs.pgsql170 }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: pgsql170
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 30
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  test_on_pgsql180:
    name: Tests on PostgreSQL 18
    if: ${{ inputs.pgsql180 }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: pgsql180
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 30
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  #test_on_pgsql190:
  #  name: Tests on PostgreSQL 19
  #  if: ${{ inputs.pgsql190 }}
  #  strategy:
  #    matrix:
  #      net: [ 'net8.0', 'net10.0' ]
  #  uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
  #  with:
  #    storage: pgsql190
  #    build_config: Release
  #    target_framework: ${{ matrix.net }}
  #    specific_sha: ${{ inputs.specific_sha }}
  #    show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
  #    test_output_verbosity: minimal
  #    test_run_timeout: 30
  #    run_main: true
  #    run_sql: true
  #    run_extensions: true
  #    publish_raw_results: true