Skip to content
SQLx

Update sqlx and related packages to version 0.6.49-beta in Cargo.toml… #374

Sign in to view logs

Update sqlx and related packages to version 0.6.49-beta in Cargo.toml…

Update sqlx and related packages to version 0.6.49-beta in Cargo.toml… #374

Workflow file for this run

.github/workflows/sqlx.yml at 82df55d
name: SQLx
on:
pull_request:
push:
branches:
- main
jobs:
format:
name: Format
runs-on: ubuntu-24.04
steps:
- uses: actions/checkout@v4
- run: cargo fmt --all -- --check
check:
name: Check
runs-on: ubuntu-24.04
strategy:
matrix:
runtime: [async-std, tokio]
tls: [native-tls, rustls]
steps:
- uses: actions/checkout@v4
- uses: Swatinem/rust-cache@v2
with:
prefix-key: v1-sqlx
save-if: ${{ false }}
- name: Run clippy for core with all features
run: |
cargo clippy --manifest-path sqlx-core/Cargo.toml \
--no-default-features \
--features offline,all-databases,all-types,migrate,runtime-${{ matrix.runtime }}-${{ matrix.tls }} \
-- -D warnings
- name: Run clippy for root with all features
run: |
cargo clippy \
--no-default-features \
--features offline,all-databases,all-types,migrate,runtime-${{ matrix.runtime }}-${{ matrix.tls }},macros \
-- -D warnings
- name: Run clippy for all targets
run: |
cargo clippy \
--no-default-features \
--all-targets \
--features offline,all-databases,all-types,migrate,runtime-${{ matrix.runtime }}-${{ matrix.tls }} \
-- -D warnings
test:
name: Unit Test
runs-on: ubuntu-24.04
steps:
- uses: actions/checkout@v4
- uses: Swatinem/rust-cache@v2
with:
prefix-key: v1-sqlx
save-if: ${{ false }}
- run: sudo apt-get update && sudo apt-get install -y libodbc2 unixodbc-dev
- run: cargo test
--manifest-path sqlx-core/Cargo.toml
--features offline,all-databases,all-types,runtime-tokio-rustls
cli:
name: CLI Binaries
runs-on: ${{ matrix.os }}
strategy:
matrix:
os: [ubuntu-latest, windows-latest] #, macOS-latest]
include:
- os: ubuntu-latest
target: x86_64-unknown-linux-musl
args: --features openssl-vendored
bin: target/debug/cargo-sqlx
- os: windows-latest
target: x86_64-pc-windows-msvc
bin: target/debug/cargo-sqlx.exe
# FIXME: macOS build fails because of missing pin-project-internal
# - os: macOS-latest
# target: x86_64-apple-darwin
# bin: target/debug/cargo-sqlx
steps:
- uses: actions/checkout@v4
- uses: Swatinem/rust-cache@v2
with:
prefix-key: v1-sqlx
save-if: ${{ github.ref == 'refs/heads/main' }}
- run: cargo build
--manifest-path sqlx-cli/Cargo.toml
--bin cargo-sqlx
${{ matrix.args }}
- uses: actions/upload-artifact@v4
with:
name: cargo-sqlx-${{ matrix.target }}
path: ${{ matrix.bin }}
sqlite:
name: SQLite
runs-on: ubuntu-24.04
strategy:
matrix:
runtime: [async-std, tokio, actix]
tls: [native-tls, rustls]
needs: check
steps:
- uses: actions/checkout@v4
- run: mkdir /tmp/sqlite3-lib && wget -O /tmp/sqlite3-lib/ipaddr.so https://github.com/nalgeon/sqlean/releases/download/0.15.2/ipaddr.so
- uses: Swatinem/rust-cache@v2
with:
prefix-key: v1-sqlx
shared-key: sqlite-${{ matrix.runtime }}-${{ matrix.tls }}
save-if: ${{ github.ref == 'refs/heads/main' && matrix.runtime == 'tokio' && matrix.tls == 'native-tls' }}
- name: Run clippy for sqlite
run: |
cargo clippy \
--no-default-features \
--features sqlite,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }},macros,migrate \
-- -D warnings
- run: cargo test
--no-default-features
--features any,macros,migrate,sqlite,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
--
--test-threads=1
env:
DATABASE_URL: sqlite://tests/sqlite/sqlite.db
RUSTFLAGS: --cfg sqlite_ipaddr
LD_LIBRARY_PATH: /tmp/sqlite3-lib
postgres:
name: Postgres
runs-on: ubuntu-24.04
strategy:
matrix:
postgres: [14, 10]
runtime: [async-std, tokio, actix]
tls: [native-tls, rustls]
needs: check
steps:
- uses: actions/checkout@v4
- uses: Swatinem/rust-cache@v2
with:
prefix-key: v1-sqlx
shared-key: postgres-${{ matrix.runtime }}-${{ matrix.tls }}
save-if: ${{ github.ref == 'refs/heads/main' && matrix.postgres == '14' }}
- run: |
cargo build --features postgres,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
env:
# FIXME: needed to disable `ltree` tests in Postgres 9.6
# but `PgLTree` should just fall back to text format
RUSTFLAGS: --cfg postgres_${{ matrix.postgres }}
- name: Run clippy for postgres
run: |
cargo clippy \
--no-default-features \
--features postgres,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }},macros,migrate \
-- -D warnings
env:
RUSTFLAGS: --cfg postgres_${{ matrix.postgres }}
- run: |
docker compose -f tests/docker-compose.yml run -d -p 5432:5432 --name postgres_${{ matrix.postgres }} postgres_${{ matrix.postgres }}
docker exec postgres_${{ matrix.postgres }} bash -c "until pg_isready; do sleep 1; done"
- run: |
cargo test --no-default-features --features any,postgres,macros,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
env:
DATABASE_URL: postgres://postgres:password@localhost:5432/sqlx
# FIXME: needed to disable `ltree` tests in Postgres 9.6
# but `PgLTree` should just fall back to text format
RUSTFLAGS: --cfg postgres_${{ matrix.postgres }}
- run: |
cargo test --no-default-features --features any,postgres,macros,migrate,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
env:
DATABASE_URL: postgres://postgres:password@localhost:5432/sqlx?sslmode=verify-ca&sslrootcert=./tests/certs/ca.crt
# FIXME: needed to disable `ltree` tests in Postgres 9.6
# but `PgLTree` should just fall back to text format
RUSTFLAGS: --cfg postgres_${{ matrix.postgres }}
postgres_ssl_client_cert:
name: Postgres with SSL client cert
runs-on: ubuntu-24.04
needs: check
steps:
- uses: actions/checkout@v4
- uses: Swatinem/rust-cache@v2
with:
prefix-key: v1-sqlx
shared-key: postgres-actix-rustls
save-if: ${{ false }}
- run: docker compose up --wait postgres_16
working-directory: tests
- run: cargo test --no-default-features --features any,postgres,macros,all-types,runtime-actix-rustls
env:
DATABASE_URL: postgres://postgres@localhost:5432/sqlx?sslmode=verify-ca&sslrootcert=./tests/certs/ca.crt&sslcert=./tests/certs/client.crt&sslkey=./tests/keys/client.key
mysql:
name: MySQL
runs-on: ubuntu-24.04
strategy:
matrix:
mysql: [8, 5_7]
runtime: [async-std, tokio, actix]
tls: [native-tls, rustls]
needs: check
steps:
- uses: actions/checkout@v4
- uses: Swatinem/rust-cache@v2
with:
prefix-key: v1-sqlx
shared-key: mysql-${{ matrix.runtime }}-${{ matrix.tls }}
save-if: ${{ github.ref == 'refs/heads/main' && matrix.mysql == '8' }}
- run: |
cargo build --features mysql,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
- name: Run clippy for mysql
run: |
cargo clippy \
--no-default-features \
--features mysql,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }},macros,migrate \
-- -D warnings
- run: docker compose -f tests/docker-compose.yml run -d -p 3306:3306 mysql_${{ matrix.mysql }}
- run: sleep 60
- run: |
cargo test --no-default-features --features any,mysql,macros,migrate,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
env:
DATABASE_URL: mysql://root:password@localhost:3306/sqlx?ssl-mode=disabled
# MySQL 5.7 supports TLS but not TLSv1.3 as required by RusTLS.
- run: |
cargo test --no-default-features --features any,mysql,macros,migrate,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
if: ${{ !(matrix.mysql == '5_7' && matrix.tls == 'rustls') }}
env:
DATABASE_URL: mysql://root:password@localhost:3306/sqlx
mariadb:
name: MariaDB
runs-on: ubuntu-24.04
strategy:
matrix:
mariadb: [10_6, 10_3]
runtime: [async-std, tokio, actix]
tls: [native-tls, rustls]
needs: check
steps:
- uses: actions/checkout@v4
- uses: Swatinem/rust-cache@v2
with:
prefix-key: v1-sqlx
shared-key: mariadb-${{ matrix.runtime }}-${{ matrix.tls }}
save-if: ${{ github.ref == 'refs/heads/main' && matrix.mariadb == '10_6' }}
- run: |
cargo build --features mysql,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
- name: Run clippy for mariadb
run: |
cargo clippy \
--no-default-features \
--features mysql,runtime-${{ matrix.runtime }}-${{ matrix.tls }},macros,migrate \
-- -D warnings
- run: docker compose -f tests/docker-compose.yml run -d -p 3306:3306 mariadb_${{ matrix.mariadb }}
- run: sleep 30
- run: |
cargo test --no-default-features --features any,mysql,macros,migrate,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
env:
DATABASE_URL: mysql://root:password@localhost:3306/sqlx
mssql:
name: MSSQL
runs-on: ubuntu-24.04
strategy:
matrix:
mssql: [2019, 2022]
runtime: [async-std, tokio, actix]
tls: [native-tls, rustls]
needs: check
steps:
- uses: actions/checkout@v4
- uses: Swatinem/rust-cache@v2
with:
prefix-key: v1-sqlx
shared-key: mssql-${{ matrix.runtime }}-${{ matrix.tls }}
save-if: ${{ github.ref == 'refs/heads/main' && matrix.mssql == '2022' }}
- run: |
cargo build --features mssql,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
- name: Run clippy for mssql
run: |
cargo clippy \
--no-default-features \
--features mssql,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }},macros,migrate \
-- -D warnings
- run: docker compose -f tests/docker-compose.yml run -d -p 1433:1433 mssql_${{ matrix.mssql }}
- run: sleep 80 # MSSQL takes a "bit" to startup
- run: |
cargo test --no-default-features --features any,mssql,macros,migrate,all-types,runtime-${{ matrix.runtime }}-${{ matrix.tls }}
env:
DATABASE_URL: mssql://sa:Password123!@localhost/sqlx
odbc:
name: ODBC (PostgreSQL and SQLite)
runs-on: ubuntu-24.04
needs: check
timeout-minutes: 15
steps:
- uses: actions/checkout@v4
- uses: Swatinem/rust-cache@v2
with:
prefix-key: v1-sqlx
shared-key: odbc
save-if: ${{ github.ref == 'refs/heads/main' }}
- name: Start Postgres (no SSL)
run: |
docker compose -f tests/docker-compose.yml run -d -p 5432:5432 --name postgres_16_no_ssl postgres_16_no_ssl
docker exec postgres_16_no_ssl bash -c "until pg_isready; do sleep 1; done"
- name: Install unixODBC and ODBC drivers (PostgreSQL, SQLite)
run: |
sudo apt-get update
sudo apt-get install -y unixodbc odbcinst unixodbc-common libodbcinst2 odbc-postgresql libsqliteodbc libodbc2 unixodbc-dev
odbcinst -j
- name: Configure system/user DSN for PostgreSQL
run: |
cp tests/odbc.ini ~/.odbc.ini
odbcinst -q -s || true
echo "select 1;" | isql -v SQLX_PG_5432 || true
- name: Run ODBC tests (PostgreSQL DSN)
run: cargo test --no-default-features --features any,odbc,macros,all-types,runtime-tokio-rustls
env:
DATABASE_URL: DSN=SQLX_PG_5432;UID=postgres;PWD=password
- name: Run ODBC tests (SQLite driver)
run: cargo test --no-default-features --features any,odbc,macros,all-types,runtime-tokio-rustls
env:
DATABASE_URL: Driver={SQLite3};Database=./tests/odbc/sqlite.db