Add step to install sqlcmd #697
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: test | |
| on: [push, pull_request] | |
| jobs: | |
| test: | |
| name: test | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| go: [1.19, 1.18] | |
| services: | |
| postgres: | |
| image: postgres:12 | |
| ports: | |
| - 5432:5432 | |
| env: | |
| POSTGRES_PASSWORD: psqlpassword | |
| options: >- | |
| --health-cmd pg_isready | |
| --health-interval 10s | |
| --health-timeout 5s | |
| --health-retries 5 | |
| mysql: | |
| image: mysql:8.0 | |
| ports: | |
| - 3306:3306 | |
| env: | |
| MYSQL_ROOT_PASSWORD: mysqlpassword | |
| mssql: | |
| image: mcr.microsoft.com/mssql/server:2019-latest | |
| ports: | |
| - 1433:1433 | |
| env: | |
| ACCEPT_EULA: 'Y' | |
| SA_PASSWORD: 'Sqlboiler@1234' | |
| steps: | |
| # - name: install_tools | |
| # run: > | |
| # apt-get update | |
| # && apt-get install -y apt-transport-https software-properties-common python3-software-properties | |
| # && apt-add-repository ppa:git-core/ppa | |
| # && apt-get update | |
| # && apt-get install -y curl locales | |
| - name: install_sqlcmd | |
| # run: > | |
| # curl https://packages.microsoft.com/keys/microsoft.asc | tee /etc/apt/trusted.gpg.d/microsoft.asc | |
| # && curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list | tee /etc/apt/sources.list.d/mssql-release.list | |
| # && apt-get update && apt-get install mssql-tools18 unixodbc-dev | |
| # && echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' >> ~/.bashrc | |
| # && source ~/.bashrc | |
| # | |
| # - name: Install a SQL Server suite of tools | |
| uses: potatoqualitee/mssqlsuite@v1.7 | |
| with: | |
| install: sqlclient | |
| # # Set up locales for sqlcmd (otherwise it breaks) | |
| # - name: setup_locales | |
| # run: > | |
| # locale-gen en_US.UTF-8 | |
| # && echo "LC_ALL=en_US.UTF-8" >> /etc/default/locale | |
| # && echo "LANG=en_US.UTF-8" >> /etc/default/locale | |
| # # Install database clients | |
| # # MySQL 8.0 is still in development, so we're using 5.7 which is already | |
| # # available in Ubuntu 18.04 | |
| # - name: install_clients | |
| # run: > | |
| # curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add - | |
| # && echo 'deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main' > /etc/apt/sources.list.d/psql.list | |
| # && curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - | |
| # && curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list > /etc/apt/sources.list.d/msprod.list | |
| # && apt-get update | |
| # && env ACCEPT_EULA=Y apt-get install -y git postgresql-client-12.2 mysql-client-5.7 mssql-tools unixodbc-dev | |
| - name: psql_creds | |
| run: > | |
| echo "*:*:*:*:psqlpassword" > $HOME/.pgpass | |
| && chmod 600 $HOME/.pgpass | |
| - name: mysql_creds | |
| run: > | |
| echo -e "[client]\nuser = root\npassword = mysqlpassword\nhost = localhost\nprotocol = tcp" > $HOME/.my.cnf | |
| && chmod 600 $HOME/.my.cnf | |
| - name: psql_wait | |
| run: | | |
| set -o errexit; | |
| c=0; | |
| for i in `seq 30`; do | |
| echo "psql_wait" | |
| psql --host localhost --username postgres --dbname template1 -c 'select * from information_schema.tables;' > /dev/null && c=0 && break || c=$? && sleep 1 | |
| done; | |
| exit $c | |
| - name: mysql_wait | |
| run: | | |
| set -o errexit; | |
| c=0; | |
| for i in `seq 30`; do | |
| echo "mysql_wait" | |
| mysql --execute 'select * from information_schema.tables;' > /dev/null > /dev/null && c=0 && break || c=$? && sleep 1 | |
| done; | |
| exit $c | |
| - name: mssql_wait | |
| run: | | |
| set -o errexit; | |
| c=0; | |
| for i in `seq 30`; do | |
| echo "mssql_wait" | |
| sqlcmd -H localhost -U sa -P Sqlboiler@1234 -Q "select * from information_schema.tables;" > /dev/null > /dev/null && c=0 && break || c=$? && sleep 1 | |
| done; | |
| exit $c | |
| - name: checkout | |
| uses: actions/checkout@v2 | |
| with: { fetch-depth: 1 } | |
| - name: psql_db | |
| run: > | |
| cd $GITHUB_WORKSPACE | |
| && ./boil.sh test-user psql | |
| && ./boil.sh test-db psql | |
| && ./boil.sh driver-test-db psql | |
| && ./boil.sh driver-test-user psql | |
| - name: mysql_db | |
| run: > | |
| cd $GITHUB_WORKSPACE | |
| && ./boil.sh test-user mysql | |
| && ./boil.sh test-db mysql | |
| && ./boil.sh driver-test-db mysql | |
| && ./boil.sh driver-test-user mysql | |
| - name: mssql_db | |
| run: > | |
| cd $GITHUB_WORKSPACE | |
| && ./boil.sh test-user mssql | |
| && ./boil.sh test-db mssql | |
| && ./boil.sh driver-test-db mssql | |
| && ./boil.sh driver-test-user mssql | |
| - name: go | |
| uses: actions/setup-go@v3 | |
| with: | |
| go-version: ${{matrix.go}} | |
| - name: deps | |
| run: go mod download | |
| env: { GOPROXY: 'https://proxy.golang.org' } | |
| - name: chmodhome | |
| run: chmod 0755 $HOME | |
| - name: build | |
| run: > | |
| cd $GITHUB_WORKSPACE | |
| && ./boil.sh build | |
| && ./boil.sh build all | |
| - name: test | |
| run: > | |
| cd $GITHUB_WORKSPACE | |
| && go test -v ./... |