ci.yml

name: CI

on:
  push:
    branches:
      - main
  pull_request:
    branches:
      - main

concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true


jobs:

  test:
    name: "Run tests via nox"
    runs-on: ubuntu-latest
    services:
      postgres:
        image: postgres:16-alpine
        env:
          POSTGRES_USER: postgres
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: testdb
        ports:
          - 5432/tcp              # host‑port is picked automatically
        options: >-
          --health-cmd="pg_isready -U postgres -d testdb"
          --health-interval=10s
          --health-timeout=5s
          --health-retries=5

    strategy:
      fail-fast: false
      matrix:
        python-version: [ "3.10", "3.11", "3.12", "3.13" ]


    steps:
      - name: Checkout repository
        uses: actions/checkout@v6

      - name: Install uv
        uses: astral-sh/setup-uv@v7
        with:
          version: "0.6.9"
          python-version: ${{ matrix.python-version }}
          prune-cache: true

      - name: Run tests via nox
        env:
          # GitHub tells you which host‑port was assigned via the `job.services` context
          POSTGRES_URI: postgres://postgres:postgres@localhost:${{ job.services.postgres.ports['5432'] }}/testdb
        run: |
          uv run nox -s pytest -- --coverage

      - name: Upload coverage
        uses: actions/upload-artifact@v7
        with:
          name: .coverage.${{ matrix.python-version }}
          path: .coverage
          retention-days: 1
          if-no-files-found: error
          include-hidden-files: true

  # upload-coverage taken from: https://github.com/hikari-py/hikari/blob/master/.github/workflows/ci.yml#L66
  #
  # Copyright (c) 2020 Nekokatt
  # Copyright (c) 2021-present davfsa
  #
  # Permission is hereby granted, free of charge, to any person obtaining a copy
  # of this software and associated documentation files (the "Software"), to deal
  # in the Software without restriction, including without limitation the rights
  # to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
  # copies of the Software, and to permit persons to whom the Software is
  # furnished to do so, subject to the following conditions:
  #
  # The above copyright notice and this permission notice shall be included in all
  # copies or substantial portions of the Software.
  upload-coverage:
    needs: [ test ]
    runs-on: ubuntu-latest

    steps:
      - uses: actions/checkout@v6
      - name: Install uv
        uses: astral-sh/setup-uv@v7
        with:
          version: "0.6.9"
          python-version: "3.13"
          activate-environment: true

      - name: Download coverage
        uses: actions/download-artifact@v7
        with:
          path: coverages/

      - name: Extract individual coverage files
        run: |
          cd coverages
          
          for coverage_dir in ./.coverage.*; do
              mv "$coverage_dir/.coverage" "../$coverage_dir"
              rmdir "$coverage_dir"
          done
          
          cd ..

      - name: Combine coverage
        run: |
          uv sync --frozen --only-group coverage
          
          coverage combine
          coverage xml
          coverage report

      - name: Upload coverage to codecov
        uses: codecov/codecov-action@v5
        with:
          token: ${{ secrets.CODECOV_TOKEN }}





  ruff:
    runs-on: ubuntu-latest
    name: "Run ruff via nox"
    steps:
      - uses: actions/checkout@v6
      - name: Install uv
        uses: astral-sh/setup-uv@v7
        with:
          version: "0.6.9"
          python-version: "3.13"

      - name: Run ruff via nox
        run: |
          uv run nox -s ruff_check -- --output-format=github
  pyright:
    runs-on: ubuntu-latest
    name: "Run pyright via nox"
    steps:
      - uses: actions/checkout@v6
      - name: Install uv
        uses: astral-sh/setup-uv@v7
        with:
          version: "0.6.9"
          python-version: "3.13"
      - name: Run pyright via nox
        run: |
          uv run nox -s pyright
  asyncpg:
    runs-on: ubuntu-latest
    name: "Run asyncpg check via nox"
    steps:
      - uses: actions/checkout@v6
      - name: Install uv
        uses: astral-sh/setup-uv@v7
        with:
          version: "0.6.9"
          python-version: "3.13"

      - name: Install sqlc
        uses: sqlc-dev/setup-sqlc@v4
        with:
          sqlc-version: '1.30.0'

      - name: Run sqlc verify via nox
        run: |
          uv run nox -s asyncpg_check

  aiosqlite:
    runs-on: ubuntu-latest
    name: "Run aiosqlite check via nox"
    steps:
      - uses: actions/checkout@v6
      - name: Install uv
        uses: astral-sh/setup-uv@v7
        with:
          version: "0.6.9"
          python-version: "3.13"

      - name: Install sqlc
        uses: sqlc-dev/setup-sqlc@v4
        with:
          sqlc-version: '1.30.0'

      - name: Run sqlc verify via nox
        run: |
          uv run nox -s aiosqlite_check

  sqlite3:
    runs-on: ubuntu-latest
    name: "Run sqlite3 check via nox"
    steps:
      - uses: actions/checkout@v6
      - name: Install uv
        uses: astral-sh/setup-uv@v7
        with:
          version: "0.6.9"
          python-version: "3.13"

      - name: Install sqlc
        uses: sqlc-dev/setup-sqlc@v4
        with:
          sqlc-version: '1.30.0'

      - name: Run sqlc verify via nox
        run: |
          uv run nox -s sqlite3_check

  test-build:
    runs-on: ubuntu-latest

    steps:
      - name: Checkout repository
        uses: actions/checkout@v6

      - name: Set up Go
        uses: actions/setup-go@v6
        with:
          go-version: '1.24.1'

      - name: Make build script executable
        run: chmod +x scripts/build/build.sh

      - name: Run build.sh
        run: ./scripts/build/build.sh

      - name: Upload wasm artifact
        uses: actions/upload-artifact@v7
        with:
          name: wasm-artifact
          path: sqlc-gen-better-python.wasm
          if-no-files-found: error
          retention-days: 30

  ci-done:
    needs: [ test, upload-coverage, asyncpg, aiosqlite, sqlite3, pyright, ruff, test-build ]
    if: always() && !cancelled()

    runs-on: ubuntu-latest

    steps:
      - name: Set status based on required jobs
        env:
          RESULTS: ${{ join(needs.*.result, ' ') }}
        run: |
          for result in $RESULTS; do
            if [ "$result" != "success" ]; then
              exit 1
            fi
          done