Merge pull request #247 from supabase/feat/release-v0.3.0 #26
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Release | |
| on: | |
| push: | |
| # Sequence of patterns matched against refs/tags | |
| tags: | |
| - 'v*' # Push events to matching v*, i.e. v1.0, v20.15.10 | |
| permissions: | |
| contents: write | |
| jobs: | |
| release: | |
| name: Create Release | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Checkout code | |
| uses: actions/checkout@v3 | |
| - name: Create Release | |
| id: create_release | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} | |
| tag: ${{ github.ref_name }} | |
| run: | | |
| gh release create "$tag" \ | |
| --repo="$GITHUB_REPOSITORY" \ | |
| --title="${tag}" \ | |
| --generate-notes | |
| build-linux-gnu: | |
| name: release artifacts | |
| needs: | |
| - release | |
| strategy: | |
| matrix: | |
| extension_name: | |
| - wrappers | |
| pgrx_version: | |
| - 0.11.2 | |
| postgres: [14, 15, 16] | |
| features: | |
| - "all_fdws" | |
| box: | |
| - { runner: ubuntu-20.04, arch: amd64 } | |
| - { runner: arm-runner, arch: arm64 } | |
| runs-on: ${{ matrix.box.runner }} | |
| timeout-minutes: 90 | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: build release artifacts | |
| run: | | |
| cd wrappers | |
| # Add postgres package repo | |
| sudo sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' | |
| wget -qO- https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo tee /etc/apt/trusted.gpg.d/pgdg.asc &>/dev/null | |
| sudo apt-get update | |
| sudo apt-get install -y --no-install-recommends git build-essential libpq-dev curl libreadline6-dev zlib1g-dev pkg-config cmake | |
| sudo apt-get install -y --no-install-recommends libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt-dev libssl-dev libxml2-utils xsltproc ccache | |
| sudo apt-get install -y --no-install-recommends clang libclang-dev gcc tree | |
| # Install requested postgres version | |
| sudo apt install -y postgresql-${{ matrix.postgres }} postgresql-server-dev-${{ matrix.postgres }} -y | |
| # Ensure installed pg_config is first on path | |
| export PATH=$PATH:/usr/lib/postgresql/${{ matrix.postgres }}/bin | |
| curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs | sh -s -- -y --no-modify-path --profile minimal --default-toolchain stable && \ | |
| rustup --version && \ | |
| rustc --version && \ | |
| cargo --version | |
| # Ensure cargo/rust on path | |
| source "$HOME/.cargo/env" | |
| cargo install cargo-pgrx --version ${{ matrix.pgrx_version }} --locked | |
| cargo pgrx init --pg${{ matrix.postgres }}=/usr/lib/postgresql/${{ matrix.postgres }}/bin/pg_config | |
| # selects the pgVer from pg_config on path | |
| # https://github.com/tcdi/pgrx/issues/288 | |
| cargo pgrx package --no-default-features --features pg${{ matrix.postgres }},${{ matrix.features }} | |
| # Extension version and path | |
| extension_version=${{ github.ref_name }} | |
| extension_dir=../target/release/${{ matrix.extension_name }}-pg${{ matrix.postgres }}/usr/share/postgresql/${{ matrix.postgres }}/extension | |
| # strip the leading v | |
| deb_version=${extension_version:1} | |
| # copy schema file to version update sql files | |
| # Note: some version numbers may be skipped | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.6--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.7--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.8--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.9--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.10--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.11--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.14--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.15--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.16--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.17--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.18--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.1.19--${deb_version}.sql | |
| cp ${extension_dir}/${{ matrix.extension_name }}--${deb_version}.sql ${extension_dir}/${{ matrix.extension_name }}--0.2.0--${deb_version}.sql | |
| # Create installable package | |
| mkdir archive | |
| cp `find ../target/release -type f -name "${{ matrix.extension_name }}*"` archive | |
| # name of the package directory before packaging | |
| package_dir=${{ matrix.extension_name }}-${{ github.ref_name }}-pg${{ matrix.postgres }}-${{ matrix.box.arch }}-linux-gnu | |
| # Copy files into directory structure | |
| mkdir -p ${package_dir}/usr/lib/postgresql/lib | |
| mkdir -p ${package_dir}/var/lib/postgresql/extension | |
| cp archive/*.so ${package_dir}/usr/lib/postgresql/lib | |
| cp archive/*.control ${package_dir}/var/lib/postgresql/extension | |
| cp archive/*.sql ${package_dir}/var/lib/postgresql/extension | |
| # symlinks to Copy files into directory structure | |
| mkdir -p ${package_dir}/usr/lib/postgresql/${{ matrix.postgres }}/lib | |
| cd ${package_dir}/usr/lib/postgresql/${{ matrix.postgres }}/lib | |
| cp -s ../../lib/*.so . | |
| cd ../../../../../.. | |
| mkdir -p ${package_dir}/usr/share/postgresql/${{ matrix.postgres }}/extension | |
| cd ${package_dir}/usr/share/postgresql/${{ matrix.postgres }}/extension | |
| cp -s ../../../../../var/lib/postgresql/extension/${{ matrix.extension_name }}.control . | |
| cp -s ../../../../../var/lib/postgresql/extension/${{ matrix.extension_name }}*.sql . | |
| cd ../../../../../.. | |
| mkdir -p ${package_dir}/DEBIAN | |
| touch ${package_dir}/DEBIAN/control | |
| echo 'Package: ${{ matrix.extension_name }}' >> ${package_dir}/DEBIAN/control | |
| echo 'Version:' ${deb_version} >> ${package_dir}/DEBIAN/control | |
| echo 'Architecture: ${{ matrix.box.arch }}' >> ${package_dir}/DEBIAN/control | |
| echo 'Maintainer: supabase' >> ${package_dir}/DEBIAN/control | |
| echo 'Description: A PostgreSQL extension' >> ${package_dir}/DEBIAN/control | |
| # Create deb package | |
| sudo chown -R root:root ${package_dir} | |
| sudo chmod -R 00755 ${package_dir} | |
| sudo dpkg-deb --build --root-owner-group ${package_dir} | |
| - name: Get upload url | |
| run: echo UPLOAD_URL=$(curl --silent https://api.github.com/repos/${{ github.repository }}/releases/latest | jq .upload_url --raw-output) >> $GITHUB_ENV | |
| - name: Upload release asset | |
| uses: actions/upload-release-asset@v1 | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} | |
| with: | |
| upload_url: ${{ env.UPLOAD_URL }} | |
| asset_path: ./wrappers/${{ matrix.extension_name }}-${{ github.ref_name }}-pg${{ matrix.postgres }}-${{ matrix.box.arch }}-linux-gnu.deb | |
| asset_name: ${{ matrix.extension_name }}-${{ github.ref_name }}-pg${{ matrix.postgres }}-${{ matrix.box.arch }}-linux-gnu.deb | |
| asset_content_type: application/vnd.debian.binary-package |