Skip to content
Build & Test

ci: Checkout before golang setup #71

Sign in to view logs

ci: Checkout before golang setup

ci: Checkout before golang setup #71

Workflow file for this run

.github/workflows/main.yml at 043d385
name: Build & Test
on:
push:
branches: [ main ]
pull_request:
branches: [ main ]
jobs:
build:
name: Build & Test
runs-on: ubuntu-latest
strategy:
matrix:
go-version: [ '1.21.6' ]
services:
postgres:
image: postgres:9.6
ports:
- 5432:5432
env:
POSTGRES_USER: postgres
POSTGRES_PASSWORD: postgres
POSTGRES_DB: ssetest
mysql:
image: mysql:8.3
ports:
- 3306:3306
env:
MYSQL_ROOT_PASSWORD: omgroot
MYSQL_DATABASE: ssetest
MYSQL_USER: ssetestusr
MYSQL_PASSWORD: ssetestusrpass
mssql:
image: mcr.microsoft.com/mssql/server:2017-latest
env:
SA_PASSWORD: GithubIs2broken
ACCEPT_EULA: Y
ports:
- 1433:1433
# options: --health-cmd="SELECT 1;" --health-interval=10s --health-timeout=5s --health-retries=10
steps:
- name: Add mssql source
run: |
curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list
sudo apt-get update
- name: Apt packages
run: sudo apt-get install sqlite3 postgresql-client gcc-mingw-w64-x86-64 mysql-client mssql-tools18 unixodbc-dev
- uses: actions/checkout@v4
- name: Setup Go
uses: actions/setup-go@v4
with:
go-version: ${{ matrix.go-version }}
- name: install go-junit-report
run: go install github.com/jstemmer/go-junit-report/v2@latest
- name: Install dependencies
run: go get .
- name: Test - sqlite flags
run: |
pushd .
cd sqlite
./setup.sh
file="`pwd`/db/test.db" # relative path hack with pwd, otherwise not resolved.
popd
go clean -testcache
go test sse_test.go \
--driver=sqlite \
--display-name=testing-flags \
--live=true \
--listen-on-port=9999 \
--sqlite-file="$file" \
2>&1 | go-junit-report -iocopy -set-exit-code -out results-sqlite-flags-${{ matrix.go-version }}.xml
- name: Test - sqlite env
env:
schemaexplorer_driver: sqlite
schemaexplorer_live: false
run: |
pushd .
cd sqlite
./setup.sh
file="`pwd`/db/test.db" # relative path hack with pwd, otherwise not resolved.
export schemaexplorer_sqlite_file="$file"
popd
go clean -testcache
go test sse_test.go \
2>&1 | go-junit-report -iocopy -set-exit-code -out results-sqlite-env-${{ matrix.go-version }}.xml
- name: Setup - pg
run: |
pushd .
cd pg
./setup-ssetest.sh
popd
- name: Test - pg
env:
schemaexplorer_driver: pg
schemaexplorer_pg_connection_string: "postgres://ssetestusr:ssetestusr@localhost/ssetest?sslmode=disable"
run: |
go clean -testcache
go test sse_test.go \
2>&1 | go-junit-report -iocopy -set-exit-code -out results-pg-${{ matrix.go-version }}.xml
- name: Setup - mysql
run: |
#!/usr/bin/env bash -v
set -e
pushd .
cd mysql
# Use ip address to stop mysql trying to use sockets, which it does for "localhost"
mysql -h 127.0.0.1 -u root -pomgroot ssetest < test-db.sql
mysql -h 127.0.0.1 -u root -pomgroot ssetest -e "show tables;"
mysql -h 127.0.0.1 -u root -pomgroot ssetest -e "describe CompoundKeyChild;"
popd
- name: Test - mysql
env:
schemaexplorer_driver: mysql
schemaexplorer_live: false
schemaexplorer_mysql_connection_string: "ssetestusr:ssetestusrpass@tcp(localhost:3306)/ssetest"
run: |
go clean -testcache
go test -v sse_test.go \
2>&1 | go-junit-report -iocopy -set-exit-code -out results-mysql-${{ matrix.go-version }}.xml
- name: Setup - MSSQL
run: |
pushd .
cd mssql
/opt/mssql-tools18/bin/sqlcmd -C -S localhost -W -U sa -P GithubIs2broken -d "master" -Q "create database ssetest;"
/opt/mssql-tools18/bin/sqlcmd -C -S localhost -W -U sa -P GithubIs2broken -d "ssetest" -i test-db.sql
/opt/mssql-tools18/bin/sqlcmd -C -S localhost -W -U sa -P GithubIs2broken -d "ssetest" -i test-db-ms_descriptions.sql
popd
- name: Test - MSSQL
env:
schemaexplorer_driver: mssql
schemaexplorer_mssql_connection_string: "server=localhost;user id=sa;password=GithubIs2broken;database=ssetest"
run: |
go clean -testcache
go test sse_test.go \
2>&1 | go-junit-report -iocopy -set-exit-code -out results-MSSQL-${{ matrix.go-version }}.xml
# - name: Upload Go test results
# uses: actions/upload-artifact@v3
# with:
# name: Go-results-${{ matrix.go-version }}
# path: TestResults-${{ matrix.go-version }}.json
- name: Test Report
uses: dorny/test-reporter@v1
if: success() || failure() # run this step even if previous step failed
with:
name: Test Report # Name of the check run which will be created
path: results-*.xml # Path to test results
reporter: java-junit # Format of test results