Use new usable hosts endpoint #7519

	name: Test
	on:
	workflow_dispatch:
	pull_request:
	push:
	branches:
	- master

	jobs:
	analyze:
	runs-on: ubuntu-latest
	steps:
	- name: Checkout
	uses: actions/checkout@v4
	- name: Lint
	uses: golangci/golangci-lint-action@v3
	with:
	args: --timeout=30m
	- name: Jape Analyzer
	uses: SiaFoundation/action-golang-analysis@HEAD
	with:
	analyzers: \|
	go.sia.tech/jape.Analyzer@master
	directories: \|
	autopilot
	bus bus/client
	worker worker/client
	flags: \|
	-japecheck.types=false

	test-sqlite: # Run all tests against SQLite
	needs: analyze
	uses: SiaFoundation/workflows/.github/workflows/go-test.yml@master
	secrets: inherit

	test-mysql: # Run all tests against MySQL
	needs: analyze
	runs-on: ubuntu-latest
	strategy:
	matrix:
	go-version: ["1.22", "1.23"]
	steps:
	- name: Checkout
	uses: actions/checkout@v4
	- name: Setup Go
	uses: actions/setup-go@v5
	with:
	go-version: ${{ matrix.go-version }}
	- name: Configure MySQL
	uses: mirromutth/[email protected]
	with:
	host port: 3800
	mysql version: "8"
	mysql root password: test
	- name: Test
	uses: SiaFoundation/workflows/.github/actions/go-test@master
	env:
	RENTERD_DB_URI: 127.0.0.1:3800
	RENTERD_DB_USER: root
	RENTERD_DB_PASSWORD: test
	with:
	go-test-args: "-race;-timeout=20m;-tags=netgo"

	success: # Use in branch rulesets to ensure all matrix jobs completed successfully
	needs: [test-sqlite, test-mysql]
	runs-on: ubuntu-latest
	steps:
	- run: echo "Success!"

Provide feedback