feat: add TCP keepalive for MySQL and PostgresSQL. #1546

Workflow file for this run

.github/workflows/examples.yml at 2bb710d

	name: Examples

	on:
	pull_request:
	push:
	branches:
	- main
	- '*-dev'

	jobs:
	sqlx-cli:
	name: Build SQLx CLI
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4

	- name: Use latest Rust
	run: rustup override set stable

	- uses: Swatinem/rust-cache@v2
	with:
	key: sqlx-cli

	- run: >
	cargo build
	-p sqlx-cli
	--bin sqlx
	--release
	--no-default-features
	--features mysql,postgres,sqlite

	- uses: actions/upload-artifact@v4
	with:
	name: sqlx-cli
	path: target/release/sqlx

	mysql:
	name: MySQL Examples
	runs-on: ubuntu-latest
	needs: sqlx-cli

	services:
	mysql:
	image: mysql:latest
	env:
	MYSQL_ROOT_PASSWORD: password
	ports:
	- 3306:3306

	steps:
	- name: Get SQLx-CLI
	uses: actions/download-artifact@v4
	with:
	name: sqlx-cli
	# $HOME is interpreted differently by the shell
	path: /home/runner/.local/bin

	- run: \|
	ls -R /home/runner/.local/bin
	chmod +x /home/runner/.local/bin/sqlx
	echo /home/runner/.local/bin >> $GITHUB_PATH
	sleep 10

	- uses: actions/checkout@v4

	- uses: Swatinem/rust-cache@v2
	with:
	key: mysql-examples

	- name: Todos (Setup)
	working-directory: examples/mysql/todos
	env:
	DATABASE_URL: mysql://root:password@localhost:3306/todos?ssl-mode=disabled
	run: sqlx db setup

	- name: Todos (Run)
	env:
	DATABASE_URL: mysql://root:password@localhost:3306/todos?ssl-mode=disabled
	run: cargo run -p sqlx-example-mysql-todos

	postgres:
	name: PostgreSQL Examples
	runs-on: ubuntu-latest
	needs: sqlx-cli

	services:
	postgres:
	image: postgres:latest
	env:
	POSTGRES_PASSWORD: password
	ports:
	- 5432:5432

	steps:
	- name: Get SQLx-CLI
	uses: actions/download-artifact@v4
	with:
	name: sqlx-cli
	path: /home/runner/.local/bin

	- run: \|
	ls -R /home/runner/.local/bin
	chmod +x $HOME/.local/bin/sqlx
	echo $HOME/.local/bin >> $GITHUB_PATH
	sleep 10

	- uses: actions/checkout@v4

	- uses: Swatinem/rust-cache@v2
	with:
	key: pg-examples

	- name: Axum Social with Tests (Setup)
	working-directory: examples/postgres/axum-social-with-tests
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/axum-social
	run: sqlx db setup

	- name: Axum Social with Tests (Check)
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/axum-social
	run: cargo check -p sqlx-example-postgres-axum-social

	- name: Axum Social with Tests (Test)
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/axum-social
	run: cargo test -p sqlx-example-postgres-axum-social

	# The Chat example has an interactive TUI which is not trivial to test automatically,
	# so we only check that it compiles.
	- name: Chat (Check)
	run: cargo check -p sqlx-example-postgres-chat

	- name: Files (Setup)
	working-directory: examples/postgres/files
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/files
	run: sqlx db setup

	- name: Files (Run)
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/files
	run: cargo run -p sqlx-example-postgres-files

	- name: JSON (Setup)
	working-directory: examples/postgres/json
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/json
	run: sqlx db setup

	- name: JSON (Run)
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/json
	run: cargo run -p sqlx-example-postgres-json

	- name: Listen (Setup)
	working-directory: examples/postgres/listen
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/listen
	run: sqlx db create

	- name: Listen (Run)
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/listen
	run: cargo run -p sqlx-example-postgres-listen

	- name: Mockable TODOs (Setup)
	working-directory: examples/postgres/mockable-todos
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/mockable-todos
	run: sqlx db setup

	- name: Mockable TODOs (Run)
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/mockable-todos
	run: cargo run -p sqlx-example-postgres-mockable-todos

	- name: TODOs (Setup)
	working-directory: examples/postgres/todos
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/todos
	run: sqlx db setup

	- name: TODOs (Run)
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/todos
	# TODO: test full CLI
	run: cargo run -p sqlx-example-postgres-todos

	- name: Transaction (Setup)
	working-directory: examples/postgres/transaction
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/txn
	run: sqlx db setup

	- name: Transaction (Run)
	env:
	DATABASE_URL: postgres://postgres:password@localhost:5432/txn
	run: cargo run -p sqlx-example-postgres-transaction

	sqlite:
	name: SQLite Examples
	runs-on: ubuntu-latest
	needs: sqlx-cli

	steps:
	- name: Get SQLx-CLI
	uses: actions/download-artifact@v4
	with:
	name: sqlx-cli
	path: /home/runner/.local/bin

	- run: \|
	ls -R /home/runner/.local/bin
	chmod +x /home/runner/.local/bin/sqlx
	echo /home/runner/.local/bin >> $GITHUB_PATH

	- uses: actions/checkout@v4

	- uses: Swatinem/rust-cache@v2
	with:
	key: sqlite-examples

	- name: TODOs (Setup)
	env:
	DATABASE_URL: sqlite://todos.sqlite
	run: sqlx db setup --source=examples/sqlite/todos/migrations

	- name: TODOs (Run)
	env:
	DATABASE_URL: sqlite://todos.sqlite
	run: cargo run -p sqlx-example-sqlite-todos

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

feat: add TCP keepalive for MySQL and PostgresSQL. #1546

Workflow file

feat: add TCP keepalive for MySQL and PostgresSQL. #1546

Jobs

Run details

Workflow file for this run