Skip to content

Bump github/codeql-action from 4.35.3 to 4.36.1 #1727

Bump github/codeql-action from 4.35.3 to 4.36.1

Bump github/codeql-action from 4.35.3 to 4.36.1 #1727

Workflow file for this run

name: CI
on:
# We would like to trigger for CI for any pull request action -
# both from QuantCo's branches as well as forks.
pull_request:
types: [opened, labeled, unlabeled, synchronize]
# In addition to pull requests, we want to run CI for pushes
# to the main branches and tags.
push:
branches:
- "main"
- "pre-commit-autoupdate"
tags:
- "v*"
jobs:
pre-commit-checks:
name: Pre-commit Checks
runs-on: ubuntu-latest
steps:
- name: Checkout branch
uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
- name: Set up pixi
uses: prefix-dev/setup-pixi@1b2de7f3351f171c8b4dfeb558c639cb58ed4ec0 # v0.9.5
with:
environments: default lint
- name: pre-commit
run: pixi run pre-commit-run --color=always --show-diff-on-failure
unit-tests:
name: "unit tests"
strategy:
fail-fast: true
matrix:
env:
- py310
- py311
- py312
- py313
- py314
- sa1
- sa2
os:
- ubuntu-latest
- macos-latest
- windows-latest
runs-on: ${{ matrix.os }}
steps:
- name: Checkout branch
uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
- name: Set up pixi
uses: prefix-dev/setup-pixi@1b2de7f3351f171c8b4dfeb558c639cb58ed4ec0 # v0.9.5
with:
environments: ${{ matrix.env }}
- run: |
pixi run -e ${{ matrix.env }} postinstall
pixi run -e ${{ matrix.env }} coverage --color=yes
- name: Generate code coverage report
uses: codecov/codecov-action@57e3a136b779b570ffcdbf80b3bdc90e7fab3de2 # v6.0.0
with:
file: ./coverage.xml
token: ${{ secrets.CODECOV_TOKEN }}
mssql:
if: ${{ contains(github.event.pull_request.labels.*.name, 'sqlserver') || contains(github.event.pull_request.labels.*.name, 'ready') || github.ref == 'refs/heads/main' }}
name: "mssql"
runs-on: ubuntu-latest
strategy:
fail-fast: false
matrix:
env:
- mssql-py310
- mssql-py311
- mssql-py312
- mssql-py313
- mssql-py314
- mssql-sa1
- mssql-sa2
services:
DB:
image: mcr.microsoft.com/mssql/server:2019-latest
env:
ACCEPT_EULA: Y
SA_PASSWORD: datajudge-123
ports:
- 1433:1433
steps:
- name: Checkout branch
uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
- name: Set up pixi
uses: prefix-dev/setup-pixi@1b2de7f3351f171c8b4dfeb558c639cb58ed4ec0 # v0.9.5
with:
environments: ${{ matrix.env }}
- name: Wait for SQL Server
timeout-minutes: 1
run: until docker logs "${{ job.services.db.id }}" 2>&1 | grep -q "SQL Server is now ready"; do sleep 10; done
- run: |
pixi run -e ${{ matrix.env }} postinstall
pixi run -e ${{ matrix.env }} coverage --color=yes
- name: Generate code coverage report
uses: codecov/codecov-action@57e3a136b779b570ffcdbf80b3bdc90e7fab3de2 # v6.0.0
with:
file: ./coverage.xml
token: ${{ secrets.CODECOV_TOKEN }}
postgres:
if: ${{ contains(github.event.pull_request.labels.*.name, 'postgres') || contains(github.event.pull_request.labels.*.name, 'ready') || github.ref == 'refs/heads/main' }}
name: PostgreSQL
runs-on: ubuntu-latest
strategy:
fail-fast: false
matrix:
postgres_version:
- latest
- 11
env:
- postgres-py310
- postgres-py311
- postgres-py312
- postgres-py313
- postgres-py314
- postgres-sa1
- postgres-sa2
services:
DB:
image: postgres:${{ matrix.postgres_version }}
env:
POSTGRES_USER: datajudge
POSTGRES_PASSWORD: datajudge
POSTGRES_DB: datajudge
ports:
- 5432:5432
steps:
- name: Checkout branch
uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
- name: Set up pixi
uses: prefix-dev/setup-pixi@1b2de7f3351f171c8b4dfeb558c639cb58ed4ec0 # v0.9.5
with:
environments: ${{ matrix.env }}
- run: |
pixi run -e ${{ matrix.env }} postinstall
pixi run -e ${{ matrix.env }} coverage --color=yes
- name: Generate code coverage report
uses: codecov/codecov-action@57e3a136b779b570ffcdbf80b3bdc90e7fab3de2 # v6.0.0
with:
file: ./coverage.xml
token: ${{ secrets.CODECOV_TOKEN }}
db2:
if: ${{ contains(github.event.pull_request.labels.*.name, 'db2') || contains(github.event.pull_request.labels.*.name, 'ready') || github.ref == 'refs/heads/main' }}
name: DB2
runs-on: ubuntu-latest
strategy:
fail-fast: false
matrix:
env:
- db2-py310
# Environment can't be solved.
# - db2-py311
- db2-py312
- db2-py313
# Environment can't be solved.
# - db2-py314
services:
DB:
image: ibmcom/db2:11.5.5.1
env:
LICENSE: accept
DB2INSTANCE: db2inst1
DB2INST1_PASSWORD: password
DBNAME: testdb
UPDATEAVAIL: "NO"
options: --privileged
ports:
- 50000:50000
steps:
- name: Checkout branch
uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
- name: Set up pixi
uses: prefix-dev/setup-pixi@1b2de7f3351f171c8b4dfeb558c639cb58ed4ec0 # v0.9.5
with:
environments: ${{ matrix.env }}
- name: Wait for db2 to load
timeout-minutes: 2
run: until docker logs "${{ job.services.db.id }}" 2>&1 | grep -q 'Setup has completed.'; do sleep 5; done
- run: |
pixi run -e ${{ matrix.env }} postinstall
pixi run -e ${{ matrix.env }} coverage --color=yes
- name: Generate code coverage report
uses: codecov/codecov-action@57e3a136b779b570ffcdbf80b3bdc90e7fab3de2 # v6.0.0
with:
file: ./coverage.xml
token: ${{ secrets.CODECOV_TOKEN }}
snowflake:
if: ${{ contains(github.event.pull_request.labels.*.name, 'snowflake') || contains(github.event.pull_request.labels.*.name, 'ready') || github.ref == 'refs/heads/main' }}
name: "Snowflake"
runs-on: ubuntu-latest
env:
SNOWFLAKE_USER: DATAJUDGE
SNOWFLAKE_PRIVATE_KEY: ${{ secrets.SNOWFLAKE_PRIVATE_KEY }}
SNOWFLAKE_ACCOUNT: ${{ secrets.SNOWFLAKE_ACCOUNT }}
strategy:
fail-fast: false
matrix:
env:
- snowflake-py310
steps:
- name: Checkout branch
uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
- name: Set up pixi
uses: prefix-dev/setup-pixi@1b2de7f3351f171c8b4dfeb558c639cb58ed4ec0 # v0.9.5
with:
environments: ${{ matrix.env }}
- run: |
pixi run -e ${{ matrix.env }} postinstall
pixi run -e ${{ matrix.env }} coverage --color=yes
- name: Generate code coverage report
uses: codecov/codecov-action@57e3a136b779b570ffcdbf80b3bdc90e7fab3de2 # v6.0.0
with:
file: ./coverage.xml
token: ${{ secrets.CODECOV_TOKEN }}
duckdb:
if: ${{ contains(github.event.pull_request.labels.*.name, 'duckdb') || contains(github.event.pull_request.labels.*.name, 'ready') || github.ref == 'refs/heads/main' }}
name: "DuckDB"
runs-on: ubuntu-latest
strategy:
fail-fast: false
matrix:
env:
- duckdb-py310
- duckdb-py314
- duckdb-sa2
steps:
- name: Checkout branch
uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
- name: Set up pixi
uses: prefix-dev/setup-pixi@1b2de7f3351f171c8b4dfeb558c639cb58ed4ec0 # v0.9.5
with:
environments: ${{ matrix.env }}
- run: |
pixi run -e ${{ matrix.env }} postinstall
pixi run -e ${{ matrix.env }} coverage --color=yes
- name: Generate code coverage report
uses: codecov/codecov-action@57e3a136b779b570ffcdbf80b3bdc90e7fab3de2 # v6.0.0
with:
file: ./coverage.xml
token: ${{ secrets.CODECOV_TOKEN }}
bigquery:
if: ${{ contains(github.event.pull_request.labels.*.name, 'bigquery') || contains(github.event.pull_request.labels.*.name, 'ready') || github.ref == 'refs/heads/main' }}
name: "BigQuery"
runs-on: ubuntu-latest
strategy:
fail-fast: false
matrix:
env:
- bigquery-py310
- bigquery-sa1
- bigquery-sa2
steps:
- name: Checkout branch
uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
- name: "Authenticate to Google Cloud"
uses: "google-github-actions/auth@7c6bc770dae815cd3e89ee6cdf493a5fab2cc093"
with:
credentials_json: "${{ secrets.GCP_KEY }}"
- name: Set up pixi
uses: prefix-dev/setup-pixi@1b2de7f3351f171c8b4dfeb558c639cb58ed4ec0 # v0.9.5
with:
environments: ${{ matrix.env }}
- run: |
pixi run -e ${{ matrix.env }} postinstall
pixi run -e ${{ matrix.env }} coverage
- name: Generate code coverage report
uses: codecov/codecov-action@57e3a136b779b570ffcdbf80b3bdc90e7fab3de2 # v6.0.0
with:
file: ./coverage.xml
token: ${{ secrets.CODECOV_TOKEN }}