Align postgres build config with no-phinx #579
Workflow file for this run
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: CI | |
| on: | |
| push: | |
| branches: | |
| - 3.x | |
| - 4.x | |
| pull_request: | |
| branches: | |
| - '*' | |
| workflow_dispatch: | |
| permissions: | |
| contents: read | |
| jobs: | |
| testsuite-linux: | |
| runs-on: ubuntu-22.04 | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| php-version: ['8.1', '8.2'] | |
| db-type: [mysql, pgsql, sqlite] | |
| prefer-lowest: [''] | |
| include: | |
| - php-version: '8.1' | |
| db-type: 'sqlite' | |
| prefer-lowest: 'prefer-lowest' | |
| services: | |
| postgres: | |
| image: postgres | |
| ports: | |
| - 5432:5432 | |
| env: | |
| POSTGRES_USER: postgres | |
| POSTGRES_PASSWORD: pg-password | |
| PGPASSWORD: pg-password | |
| POSTGRES_DB: cakephp_test | |
| options: >- | |
| --health-cmd pg_isready | |
| --health-interval 10s | |
| --health-timeout 5s | |
| --health-retries 5 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Setup MySQL | |
| if: matrix.db-type == 'mysql' | |
| run: | | |
| sudo service mysql start | |
| mysql -h 127.0.0.1 -u root -proot -e 'CREATE DATABASE cakephp_test DEFAULT COLLATE=utf8mb4_general_ci;' | |
| mysql -h 127.0.0.1 -u root -proot -e 'CREATE DATABASE cakephp_comparisons;' | |
| mysql -h 127.0.0.1 -u root -proot -e 'CREATE DATABASE cakephp_snapshot;' | |
| - name: Setup Postgres | |
| if: matrix.db-type == 'pgsql' | |
| env: | |
| PGUSER: postgres | |
| PGPASSWORD: pg-password | |
| run: | | |
| psql -h 127.0.0.1 -c 'CREATE DATABASE "cakephp_snapshot";' | |
| - name: Setup PHP | |
| uses: shivammathur/setup-php@v2 | |
| with: | |
| php-version: ${{ matrix.php-version }} | |
| extensions: mbstring, intl, pdo_${{ matrix.db-type }} | |
| coverage: pcov | |
| - name: Get composer cache directory | |
| id: composer-cache | |
| run: echo "dir=$(composer config cache-files-dir)" >> $GITHUB_OUTPUT | |
| - name: Get date part for cache key | |
| id: key-date | |
| run: echo "date=$(date +'%Y-%m')" >> $GITHUB_OUTPUT | |
| - name: Cache composer dependencies | |
| uses: actions/cache@v4 | |
| with: | |
| path: ${{ steps.composer-cache.outputs.dir }} | |
| key: ${{ runner.os }}-composer-${{ steps.key-date.outputs.date }}-${{ hashFiles('composer.json') }}-${{ matrix.prefer-lowest }} | |
| - name: Composer install | |
| run: | | |
| if [[ ${{ matrix.php-version }} == '8.2' ]]; then | |
| composer install --ignore-platform-req=php | |
| elif ${{ matrix.prefer-lowest == 'prefer-lowest' }}; then | |
| composer update --prefer-lowest --prefer-stable | |
| else | |
| composer update | |
| fi | |
| - name: Run PHPUnit | |
| run: | | |
| if [[ ${{ matrix.db-type }} == 'sqlite' ]]; then | |
| export DB='sqlite' | |
| fi | |
| if [[ ${{ matrix.db-type }} == 'mysql' ]]; then | |
| export DB='mysql' | |
| export DB_URL='mysql://root:[email protected]/cakephp_test' | |
| export DB_URL_COMPARE='mysql://root:[email protected]/cakephp_comparisons' | |
| export DB_URL_SNAPSHOT='mysql://root:[email protected]/cakephp_snapshot' | |
| fi | |
| if [[ ${{ matrix.db-type }} == 'pgsql' ]]; then | |
| export DB='pgsql' | |
| export DB_URL='postgres://postgres:[email protected]/cakephp_test' | |
| export DB_URL_SNAPSHOT='postgres://postgres:[email protected]/cakephp_snapshot' | |
| fi | |
| if [[ ${{ matrix.php-version }} == '8.1' && ${{ matrix.db-type }} == 'mysql' ]]; then | |
| vendor/bin/phpunit --coverage-clover=coverage.xml | |
| else | |
| vendor/bin/phpunit | |
| fi | |
| - name: Code Coverage Report | |
| if: success() && matrix.php-version == '8.1' && matrix.db-type == 'mysql' | |
| uses: codecov/codecov-action@v4 | |
| cs-stan: | |
| uses: cakephp/.github/.github/workflows/[email protected] | |
| secrets: inherit |