package.yaml

# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.

name: Package

on:
  pull_request:
  push:
    branches:
      - "*"
    tags:
      - "*-rc*"

concurrency:
  group: ${{ github.head_ref || github.sha }}-${{ github.workflow }}
  cancel-in-progress: true

permissions:
  contents: write
  packages: write

jobs:
  source:
    name: Source
    timeout-minutes: 5
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      - uses: ruby/setup-ruby@v1
        with:
          ruby-version: ruby
      - name: Build archive
        run: |
          rake dist
      - uses: actions/upload-artifact@v3
        with:
          name: source
          path: apache-arrow-flight-sql-postgresql-*.tar.gz
      - name: Upload to release
        if: |
          github.ref_type == 'tag'
        run: |
          ruby \
            -e 'print("## Apache Arrow Flight SQL adapter for PostgreSQL "); \
                puts(ARGF.read.split(/^## Version /)[1]. \
                       gsub(/ {.+?}/, ""). \
                       gsub(/\[(.+?)\]\[.+?\]/) {$1})' \
            doc/source/release-notes.md > release-note.md
          rc=${GITHUB_REF_NAME#*-rc}
          title="$(head -n1 release-note.md | sed -e 's/^## //') RC${rc}"
          tail -n +2 release-note.md > release-note-without-version.md
          gh release create ${GITHUB_REF_NAME} \
            --prerelease \
            --notes-file release-note-without-version.md \
            --title "${title}" \
            apache-arrow-flight-sql-postgresql-*.tar.gz
        env:
          GH_TOKEN: ${{ github.token }}

  linux:
    name: Linux
    needs:
      - source
    runs-on: ubuntu-latest
    timeout-minutes: 10
    strategy:
      fail-fast: false
      matrix:
        target:
          - "debian-bookworm-amd64-postgresql-15-pgdg"
          - "ubuntu-jammy-amd64-postgresql-15-pgdg"
    steps:
      - uses: actions/checkout@v4
        with:
          repository: apache/arrow
          path: arrow
      - uses: actions/download-artifact@v3
        with:
          name: source
      - name: Prepare
        run: |
          BASE_NAME=apache-arrow-flight-sql-postgresql
          echo "BASE_NAME=${BASE_NAME}" >> $GITHUB_ENV
          echo "ARROW_SOURCE=$(pwd)/arrow" >> $GITHUB_ENV
          full_target=${{ matrix.target }}
          # debian-bookworm-amd64-postgresql-15-pgdg ->
          # postgresql-15-pgdg
          PACKAGE=postgresql-${full_target#*-postgresql-}
          echo "PACKAGE=${PACKAGE}" >> $GITHUB_ENV
          # debian-bookworm-amd64-postgresql-15-pgdg ->
          # debian-bookworm-amd64
          PACKAGE_TARGET=${full_target%-postgresql-*}
          echo "APT_TARGETS=${PACKAGE_TARGET}" >> $GITHUB_ENV
          echo "YUM_TARGETS=${PACKAGE_TARGET}" >> $GITHUB_ENV
          case ${PACKAGE_TARGET} in
            almalinux-*)
              echo "TASK_NAMESPACE=yum" >> $GITHUB_ENV
              ;;
            debian-*|ubuntu-*)
              echo "TASK_NAMESPACE=apt" >> $GITHUB_ENV
              ;;
          esac
          DISTRIBUTION=${PACKAGE_TARGET%%-*}
          echo "DISTRIBUTION=${DISTRIBUTION}" >> $GITHUB_ENV
          DISTRIBUTION_VERSION=${PACKAGE_TARGET#*-}
          DISTRIBUTION_VERSION=${DISTRIBUTION_VERSION%-*}
          echo "DISTRIBUTION_VERSION=${DISTRIBUTION_VERSION}" >> $GITHUB_ENV
          ARCHITECTURE=${PACKAGE_TARGET##*-}
          echo "ARCHITECTURE=${ARCHITECTURE}" >> $GITHUB_ENV

          source_archive=$(echo ${BASE_NAME}-*.tar.gz)
          VERSION=${source_archive#${BASE_NAME}-}
          VERSION=${VERSION%.tar.gz}
          echo "VERSION=${VERSION}" >> $GITHUB_ENV
      - name: Extract source archive
        run: |
          tar xf ${BASE_NAME}-${VERSION}.tar.gz
          ln -s ${BASE_NAME}-${VERSION} ${BASE_NAME}
          mv ${BASE_NAME}-${VERSION}.tar.gz ${BASE_NAME}/
      - name: Set up Ruby
        uses: ruby/setup-ruby@v1
        with:
          ruby-version: ruby
      - name: Login to GitHub Container registry
        uses: docker/login-action@v2
        with:
          registry: ghcr.io
          username: ${{ github.actor }}
          password: ${{ github.token }}
      - name: Build
        run: |
          pushd ${BASE_NAME}/package/${PACKAGE}
          if [ "${GITHUB_REF_TYPE}" != "tag" ]; then
            rake version:update
          fi
          rake docker:pull || :
          rake --trace ${TASK_NAMESPACE}:build
          popd
      - name: Prepare artifacts
        run: |
          cp -a \
            ${BASE_NAME}/package/${PACKAGE}/${TASK_NAMESPACE}/repositories/${DISTRIBUTION} \
            ./
          tar czf ${{ matrix.target }}.tar.gz ${DISTRIBUTION}
      - name: Upload artifacts
        uses: actions/upload-artifact@v3
        with:
          name: ${{ matrix.target }}
          path: |
            ${{ matrix.target }}.tar.gz
      - name: Upload to release
        if: |
          github.ref_type == 'tag'
        run: |
          gh release upload --repo ${GITHUB_REPOSITORY} ${GITHUB_REF_NAME} \
            ${{ matrix.target }}.tar.gz
        env:
          GH_TOKEN: ${{ github.token }}
      - name: Push Docker image
        run: |
          pushd ${BASE_NAME}/package/${PACKAGE}
          rake docker:push || :
          popd
      - name: Test
        run: |
          pushd ${BASE_NAME}
          docker run \
            --rm \
            --volume ${PWD}:/host \
            ${ARCHITECTURE}/${DISTRIBUTION}:${DISTRIBUTION_VERSION} \
            /host/package/${TASK_NAMESPACE}/test.sh \
            ${VERSION} \
            local \
            package/${PACKAGE}/${TASK_NAMESPACE}/repositories
          popd

  verify-source:
    name: Verify source on ${{ matrix.os }}
    needs:
      - source
    runs-on: ${{ matrix.os }}-latest
    timeout-minutes: 15
    strategy:
      fail-fast: false
      matrix:
        os:
          - macos
          - ubuntu
        postgresql-version:
          - "15"
    env:
      BUNDLE_GEMFILE: ${{ github.workspace }}/apache-arrow-flight-sql-postgresql/Gemfile
    steps:
      - uses: actions/download-artifact@v3
        with:
          name: source
      - name: Extract source archive
        run: |
          tar_gz=$(echo apache-arrow-flight-sql-postgresql-*.tar.gz)
          tar xf ${tar_gz}
          ln -s ${tar_gz%.tar.gz} apache-arrow-flight-sql-postgresql
      - name: Install dependencies on Ubuntu
        if: matrix.os == 'ubuntu'
        run: |
          sudo apt update
          sudo apt install -y -V \
            ca-certificates \
            gpg \
            lsb-release \
            wget
          os=$(lsb_release --id --short | tr 'A-Z' 'a-z')
          code_name=$(lsb_release --codename --short)

          apt_source_deb=apache-arrow-apt-source-latest-${code_name}.deb
          wget https://apache.jfrog.io/artifactory/arrow/${os}/${apt_source_deb}
          sudo apt install -y -V ./${apt_source_deb}

          wget -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
            sudo gpg --no-default-keyring --keyring /usr/share/keyrings/pgdg.gpg --import -
          (echo "Types: deb"; \
           echo "URIs: http://apt.postgresql.org/pub/repos/apt"; \
           echo "Suites: ${code_name}-pgdg"; \
           echo "Components: main"; \
           echo "Signed-By: /usr/share/keyrings/pgdg.gpg") | \
            sudo tee /etc/apt/sources.list.d/pgdg.sources

          sudo apt update
          sudo apt -y -V purge '^postgresql'
          sudo apt install -y -V \
            libarrow-flight-sql-glib-dev \
            libkrb5-dev \
            meson \
            ninja-build \
            postgresql-${{ matrix.postgresql-version }} \
            postgresql-server-dev-${{ matrix.postgresql-version }}
      - name: Install dependencies on macOS
        if: matrix.os == 'macos'
        run: |
          pushd apache-arrow-flight-sql-postgresql
          sed \
            -i '' \
            -e 's/postgresql@[0-9]*/postgresql@${{ matrix.postgresql-version }}/g' \
            Brewfile
          brew update
          brew bundle
          echo "$(brew --prefix postgresql@${{ matrix.postgresql-version }})/bin" >> $GITHUB_PATH
          popd
      - uses: ruby/setup-ruby@v1
        with:
          ruby-version: ruby
          bundler-cache: true
          cache-version: 1
      - name: Run
        run: |
          pushd apache-arrow-flight-sql-postgresql
          bundle exec dev/release/verify-rc.sh
          popd
        env:
          TEST_DEFAULT: "0"
          TEST_SOURCE: "1"

  verify-binaries:
    name: Verify binaries
    if: >-
      github.ref_type == 'tag'
    needs:
      - linux
    runs-on: ubuntu-latest
    timeout-minutes: 10
    steps:
      - uses: actions/checkout@v4
      - name: Run
        run: |
          version=${GITHUB_REF_NAME%-rc*}
          rc=${GITHUB_REF_NAME#*-rc}
          dev/release/verify-rc.sh ${version} ${rc}
        env:
          TEST_BINARIES: "1"
          TEST_DEFAULT: "0"