tests

aware table schema on function ColumnTypes #110

	name: tests

	on:
	push:
	pull_request:

	permissions:
	contents: read

	jobs:
	run-tests:
	strategy:
	matrix:
	go: [ '1.21', '1.20', '1.19' ]
	platform: [ ubuntu-latest ]
	runs-on: ubuntu-latest

	env:
	MSSQL_DB: gorm
	MSSQL_USER: gorm
	MSSQL_PASSWORD: LoremIpsum86

	services:
	mssql:
	image: mcr.microsoft.com/mssql/server:2022-latest
	env:
	ACCEPT_EULA: Y
	MSSQL_SA_PASSWORD: ${{ env.MSSQL_PASSWORD }}
	MSSQL_PID: Developer
	ports:
	- 9930:1433
	options: >-
	--health-cmd="/opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P ${MSSQL_SA_PASSWORD} -N -C -l 30 -Q \"SELECT 1\" \|\| exit 1"
	--health-start-period 10s
	--health-interval 5s
	--health-timeout 10s
	--health-retries 10

	steps:
	- name: Set up Go 1.x
	uses: actions/setup-go@v5
	with:
	go-version: ${{ matrix.go }}
	cache: false

	- name: Check out code into the Go module directory
	uses: actions/checkout@v4

	- name: Create gorm database and user in SQL Server
	run: \|
	docker exec $(docker ps --filter "name=sqlserver" --format "{{.Names}}") \
	/opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P ${MSSQL_PASSWORD} -N -C -l 30 \
	-Q "CREATE DATABASE ${MSSQL_DB}; CREATE LOGIN ${MSSQL_USER} WITH PASSWORD='${MSSQL_PASSWORD}'; CREATE USER ${MSSQL_USER} FOR LOGIN ${MSSQL_USER}; ALTER SERVER ROLE sysadmin ADD MEMBER [${MSSQL_USER}];"

	# Run build of the application
	- name: Run build
	run: go build .

	- name: Run tests
	run: go test -race -count=1 -v ./...

Provide feedback