Use POSIX collation in the Postgres registry #366
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
| # This workflow creates the services and installs the clients in order to run | |
| # coverage tests. Each engine must be accessible for a complete coverage report. | |
| # It runs for pushes and pull requests on the `main`, `develop`, and `**cover**` | |
| # branches. | |
| name: 📈 Coverage | |
| on: | |
| push: | |
| branches: [main, develop, "**cover**"] | |
| pull_request: | |
| branches: [main, develop, "**cover**"] | |
| jobs: | |
| Snowflake: | |
| name: 📈 Coverage | |
| runs-on: ubuntu-latest | |
| services: | |
| exasol: | |
| image: exasol/docker-db:latest | |
| ports: [ 8563 ] | |
| options: --privileged | |
| firebird: | |
| image: jacobalberty/firebird:latest | |
| ports: [ 3050 ] | |
| env: | |
| ISC_PASSWORD: nix | |
| FIREBIRD_DATABASE: sqitchtest.db | |
| mysql: | |
| image: mysql:latest | |
| env: { MYSQL_ALLOW_EMPTY_PASSWORD: yes } | |
| ports: [ 3306 ] | |
| options: --health-cmd="mysqladmin ping" --health-interval=5s --health-timeout=2s --health-retries=3 | |
| oracle: | |
| image: gvenzl/oracle-xe:latest | |
| ports: [ 1521 ] | |
| env: | |
| ORACLE_PASSWORD: oracle | |
| APP_USER: sqitchtest | |
| APP_USER_PASSWORD: sqitchtest | |
| options: >- | |
| --health-cmd healthcheck.sh | |
| --health-interval 20s | |
| --health-timeout 10s | |
| --health-retries 10 | |
| vertica: | |
| image: vertica/vertica-ce:latest | |
| ports: [ 5433 ] | |
| steps: | |
| # https://github.com/orgs/community/discussions/25678#discussioncomment-5242449 | |
| - name: Free Disk Space | |
| run: rm -rf /opt/hostedtoolcache | |
| - name: Start CockroachDB | |
| run: docker run -d -p 26257:26257 cockroachdb/cockroach:latest start-single-node --insecure | |
| - uses: actions/checkout@v4 | |
| - name: Setup Perl | |
| id: perl | |
| uses: shogo82148/actions-setup-perl@v1 | |
| with: { perl-version: latest } | |
| - name: Cache CPAN Modules | |
| uses: actions/cache@v4 | |
| with: | |
| path: local | |
| key: perl-${{ steps.perl.outputs.perl-hash }} | |
| - name: Install SQLite | |
| env: { PERL5LIB: "${{ github.workspace }}/local/lib/perl5" } | |
| run: .github/ubuntu/sqlite.sh | |
| - name: Setup Clients | |
| env: | |
| SKIP_DEPENDS: true | |
| run: | | |
| .github/ubuntu/all-apt-prereqs.sh | |
| .github/ubuntu/exasol.sh | |
| .github/ubuntu/firebird.sh | |
| .github/ubuntu/mysql.sh | |
| .github/ubuntu/oracle.sh | |
| .github/ubuntu/pg.sh | |
| .github/ubuntu/snowflake.sh | |
| .github/ubuntu/vertica.sh | |
| - run: cpm install --verbose --show-build-log-on-failure --no-test --with-recommends --cpanfile dist/cpanfile | |
| - run: cpm install --verbose --show-build-log-on-failure --no-test --with-recommends DBI DBD::ODBC DBD::Firebird DBD::Oracle DBD::mysql DBD::Pg Devel::Cover Devel::Cover::Report::Coveralls | |
| - name: Run Tests | |
| env: | |
| PERL5LIB: "${{ github.workspace }}/local/lib/perl5" | |
| HARNESS_PERL_SWITCHES: -MDevel::Cover=-ignore,^(?:x?t|inc|bin|local)/ | |
| LIVE_EXASOL_REQUIRED: true | |
| SQITCH_TEST_EXASOL_URI: db:exasol://sys:exasol@127.0.0.1:${{ job.services.exasol.ports[8563] }}/?Driver=Exasol;SSLCertificate=SSL_VERIFY_NONE | |
| LIVE_FIREBIRD_REQUIRED: true | |
| SQITCH_TEST_FIREBIRD_URI: db:firebird://sysdba:nix@127.0.0.1:${{ job.services.firebird.ports[3050] }}//firebird/data/sqitchtest.db | |
| LIVE_MYSQL_REQUIRED: true | |
| SQITCH_TEST_MYSQL_URI: "db:mysql://root@127.0.0.1:${{ job.services.mysql.ports[3306] }}/information_schema" | |
| LIVE_ORACLE_REQUIRED: true | |
| SQITCH_TEST_ALT_ORACLE_REGISTRY: dbsnmp | |
| SQITCH_TEST_ORACLE_URI: db:oracle://system:oracle@127.0.0.1:${{ job.services.oracle.ports[1521] }}/XE | |
| LIVE_PG_REQUIRED: true | |
| SQITCH_TEST_PG_URI: db:pg://postgres@/postgres | |
| LIVE_SNOWFLAKE_REQUIRED: true | |
| SQITCH_TEST_SNOWFLAKE_URI: db:snowflake://${{ secrets.SNOWFLAKE_USERNAME }}:${{ secrets.SNOWFLAKE_PASSWORD }}@sra81677.us-east-1/sqitchtest?Driver=Snowflake;warehouse=compute_wh | |
| LIVE_SQLITE_REQUIRED: true | |
| LIVE_VERTICA_REQUIRED: true | |
| SQITCH_TEST_VSQL_URI: db:vertica://dbadmin@localhost:${{ job.services.vertica.ports[5433] }}/VMart?Driver=Vertica | |
| LIVE_COCKROACH_REQUIRED: true | |
| SQITCH_TEST_COCKROACH_URI: db:cockroach://root@localhost:26257/ | |
| run: prove -lrj4 t | |
| - name: Report Coverage | |
| env: | |
| PERL5LIB: "${{ github.workspace }}/local/lib/perl5" | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} | |
| run: local/bin/cover -report coveralls |