swift.yml

name: CI

on:
  push:
    branches: [ main ]
  pull_request:
    branches: [ main ]

jobs:
  build:
    name: Build & Test
    runs-on: macos-14

    steps:
      - name: Checkout
        uses: actions/checkout@v4

      - name: Select Xcode
        run: sudo xcode-select -s /Applications/Xcode_15.4.app

      - name: Install Dependencies
        run: brew install freetds pkg-config

      - name: Setup pkg-config
        run: |
          # Generate freetds.pc dynamically to match runner architecture (Intel/ARM)
          mkdir -p pkgconfig
          FREETDS_PREFIX=$(brew --prefix freetds)
          cat <<EOF > pkgconfig/freetds.pc
          prefix=${FREETDS_PREFIX}
          exec_prefix=\${prefix}
          libdir=\${exec_prefix}/lib
          includedir=\${prefix}/include

          Name: FreeTDS
          Description: FreeTDS library
          Version: 1.5
          Libs: -L\${libdir} -lsybdb -liconv
          Cflags: -I\${includedir}
          EOF
          echo "PKG_CONFIG_PATH=${GITHUB_WORKSPACE}/pkgconfig" >> $GITHUB_ENV

      - name: Build
        run: |
          echo "pkg-config check: $(pkg-config --cflags --libs freetds)"
          swift build -v

      - name: Test
        run: |
          swift test -v
        env:
          HOST:     ${{ secrets.DB_HOST }}
          USERNAME: ${{ secrets.DB_USERNAME }}
          PASSWORD: ${{ secrets.DB_PASSWORD }}
          DATABASE: ${{ secrets.DB_DATABASE }}