Skip to content

Add force_readonly option for owner of a FOREIGN SERVER in context of SQLite connection management #23

Add force_readonly option for owner of a FOREIGN SERVER in context of SQLite connection management

Add force_readonly option for owner of a FOREIGN SERVER in context of SQLite connection management #23

Workflow file for this run

name: SQLite FDW test
on:
workflow_dispatch:
pull_request:
push:
branches:
- master
- main
jobs:
detect-pgversion:
runs-on: ubuntu-22.04
outputs:
pgversion: ${{ steps.detect-pgversion.outputs.targets }}
steps:
- uses: actions/checkout@v4
- name: detect-pgversion
id: detect-pgversion
run: |
targets=`bash GitHubActions/detect_targets.sh`
echo "targets=$targets" >> $GITHUB_OUTPUT
test:
needs: detect-pgversion
env:
SQLITE_VERSION : "3420000"
SQLITE_YEAR: "2023"
HTTP_PROXY: ""
HTTPS_PROXY: ""
strategy:
fail-fast: false
matrix:
pg: ${{ fromJSON(needs.detect-pgversion.outputs.pgversion) }}
name: Test on PostgreSQL ${{ matrix.pg }}
runs-on: ubuntu-22.04
steps:
- uses: actions/checkout@v4
- name: tar
run: tar zcvf sqlite_fdw.tar.gz ./*
- name: set_proxy
run: bash GitHubActions/env.sh
- name: install locales
run: bash GitHubActions/install_locales.sh
- name: build PostgreSQL ${{ matrix.pg }}
run: bash GitHubActions/build_postgres.sh ${{ matrix.pg }}
- name: install SQLite
run: bash GitHubActions/install_sqlite.sh ${{ env.SQLITE_VERSION }} ${{ env.SQLITE_YEAR }}
- name: build sqlite_fdw
run: bash GitHubActions/build_sqlite_fdw.sh ${{ matrix.pg }}
- name: execute sqlite_fdw test
run: bash GitHubActions/execute_test.sh ${{ matrix.pg }}