Merge pull request #91 from blocknotes/switch-to-double-quotes-for-st… #92

	---
	name: Specs MSSQL Rails 7.2

	on:
	pull_request:
	branches: [main]
	push:
	branches: [main]

	jobs:
	tests:
	runs-on: ubuntu-latest

	strategy:
	matrix:
	ruby: ['3.4', '4.0']

	env:
	DB_TEST: mssql
	RAILS_VERSION: 7.2
	RUBY_VERSION: ${{ matrix.ruby }}

	services:
	mssql:
	image: mcr.microsoft.com/mssql/server:2022-latest
	env:
	ACCEPT_EULA: 'Y'
	SA_PASSWORD: Pa%%w0rd
	options: >-
	--health-cmd "/opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P 'Pa%%w0rd' -C -Q 'SELECT 1' \|\| /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'Pa%%w0rd' -Q 'SELECT 1'"
	--health-interval 10s
	--health-timeout 5s
	--health-retries 10
	ports:
	- 1433:1433

	steps:
	- name: Install dependencies
	run: sudo apt-get update -qq && sudo apt-get install -yqq freetds-dev freetds-bin libvips-dev

	- name: Checkout repository
	uses: actions/checkout@v4

	- name: Set up Ruby
	uses: ruby/setup-ruby@v1
	with:
	ruby-version: ${{ matrix.ruby }}
	bundler-cache: true

	- name: Database setup
	run: bin/rails db:create db:migrate db:test:prepare

	- name: Run tests
	run: bin/rspec --profile

Provide feedback