ci: Test mysql #32
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Build+Test | |
| on: | |
| push: | |
| branches: [ main ] | |
| pull_request: | |
| branches: [ main ] | |
| jobs: | |
| build: | |
| 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 | |
| steps: | |
| - 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 | |
| - uses: actions/checkout@v4 | |
| - name: Apt packages | |
| run: sudo apt install sqlite3 postgresql-client gcc-mingw-w64-x86-64 mysql-client | |
| - 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 -json sse_test.go \ | |
| --driver=sqlite \ | |
| --display-name=testing-flags \ | |
| --live=true \ | |
| --listen-on-port=9999 \ | |
| --sqlite-file="$file" \ | |
| 2>&1 | go-junit-report -parser gojson -iocopy -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 -json sse_test.go \ | |
| 2>&1 | go-junit-report -parser gojson -iocopy -out results-sqlite-env-${{ matrix.go-version }}.xml | |
| - name: Test - pg | |
| env: | |
| schemaexplorer_driver: pg | |
| schemaexplorer_pg_connection_string: "postgres://ssetestusr:ssetestusr@localhost/ssetest?sslmode=disable" | |
| run: | | |
| pushd . | |
| cd pg | |
| ./setup-ssetest.sh | |
| popd | |
| go clean -testcache | |
| go test -json sse_test.go \ | |
| 2>&1 | go-junit-report -parser gojson -iocopy -out results-pg-${{ matrix.go-version }}.xml | |
| - name: Test - mysql | |
| env: | |
| schemaexplorer_driver: mysql | |
| schemaexplorer_live: false | |
| schemaexplorer_mysql_database: ssetest | |
| schemaexplorer_mysql_user: ssetestusr | |
| schemaexplorer_mysql_password: ssetestusrpass | |
| run: | | |
| pushd . | |
| cd mysql | |
| mysql -h localhost -pomgroot ssetest < test-db.sql | |
| popd | |
| go clean -testcache | |
| go test -json sse_test.go \ | |
| 2>&1 | go-junit-report -parser gojson -iocopy -out results-mysql-${{ 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: Tests # Name of the check run which will be created | |
| path: results-*.xml # Path to test results | |
| reporter: jest-junit # Format of test results |