18 group: "${{ github.workflow }}-${{ github.ref }}"
19 cancel-in-progress: true
23 runs-on: ubuntu-latest
28 #always tests higher stable php version with lower db version
29 #enable coverage on higher stable php version with higher postrgesql version
30 #higher stable php version
31 - { php-version: "8.3", db-image: "postgres:11", coverage: none, always: true }
32 - { php-version: "8.3", db-image: "postgres:16", coverage: 'xdebug', always: true }
33 - { php-version: "8.3", db-image: "mysql:5.7", coverage: none, always: true }
34 - { php-version: "8.3", db-image: "mysql:8.1", coverage: none, always: false }
35 - { php-version: "8.3", db-image: "mariadb:10.4", coverage: none, always: true }
36 - { php-version: "8.3", db-image: "mariadb:11.3", coverage: none, always: false }
38 - { php-version: "8.1", db-image: "postgres:11", coverage: none, always: false }
39 - { php-version: "8.1", db-image: "postgres:16", coverage: none, always: false }
40 - { php-version: "8.1", db-image: "mysql:5.7", coverage: none, always: false }
41 - { php-version: "8.1", db-image: "mysql:8.1", coverage: none, always: false }
42 - { php-version: "8.1", db-image: "mariadb:10.4", coverage: none, always: false }
43 - { php-version: "8.1", db-image: "mariadb:11.3", coverage: none, always: false }
47 skip: ${{ matrix.always == false && (github.event_name == 'pull_request' || github.repository != 'galette/galette' || !(github.event_name == 'workflow_dispatch' || github.ref == 'refs/heads/master' || github.ref == 'refs/heads/develop' || startsWith(github.ref, 'refs/tags'))) }}
48 DB: ${{ matrix.db-image }}
51 # Label used to access the service container
54 image: ${{ matrix.db-image }}
55 # Provide env variables for both mysql and pgsql
57 POSTGRES_USER: galette_tests
58 POSTGRES_PASSWORD: g@l3tte
59 POSTGRES_DB: galette_tests
60 MYSQL_USER: galette_tests
61 MYSQL_PASSWORD: g@l3tte
62 MYSQL_ROOT_PASSWORD: g@l3tte
63 MYSQL_DATABASE: galette_tests
64 # Open network ports for both mysql and pgsql
68 # Set health checks to wait until postgres has started
70 --health-cmd="bash -c 'if [[ -n $(command -v pg_isready) ]]; then pg_isready; else if [[ -n $(command -v mysqladmin) ]]; then mysqladmin ping; else mariadb-admin ping; fi fi'"
75 name: PHP ${{ matrix.php-version }} ${{ matrix.db-image }} ${{ (matrix.always == false && (github.event_name == 'pull_request' || github.repository != 'galette/galette' || !(github.event_name == 'workflow_dispatch' || github.ref == 'refs/heads/master' || github.ref == 'refs/heads/develop' || startsWith(github.ref, 'refs/tags')))) && ' (skipped)' || matrix.coverage == 'xdebug' && ' (with coverage)' || ''}}
79 if: env.skip != 'true'
80 uses: shivammathur/setup-php@v2
82 php-version: ${{ matrix.php-versions }}
84 coverage: ${{ matrix.coverage }}
86 ini-values: apc.enable_cli=1
88 - name: "Show versions"
89 if: env.skip != 'true'
93 echo "node $(node --version)"
94 echo "npm $(npm --version)"
95 docker exec ${{ job.services.db.id }} bash -c "if [[ -n \$(command -v psql) ]]; then psql --version; else if [[ -n \$(command -v mysql) ]]; then mysql --version; else mariadb --version; fi fi"
98 if: env.skip != 'true'
99 uses: actions/checkout@v4
103 - name: "Restore dependencies cache"
104 if: env.skip != 'true'
105 uses: actions/cache@v4
110 key: "${{ runner.os }}-galette-${{ matrix.php-version }}-${{ hashFiles('galette/composer.lock', 'package-lock.json') }}"
112 ${{ runner.os }}-galette-${{ matrix.php-version }}-
114 - name: Install dependencies
115 if: env.skip != 'true'
116 run: bin/install_deps
118 - name: Init for PostgreSQL (update)
120 POSTGRES_HOST: localhost
123 PGPASSWORD=g@l3tte psql -d galette_tests -a -f tests/pgsql_06.sql -U galette_tests -h localhost
124 if: env.skip != 'true' && startsWith(matrix.db-image, 'postgres')
126 - name: Init for MariaDB (update)
128 mysql -e 'create database IF NOT EXISTS galette_tests;' -u galette_tests --password=g@l3tte -h 127.0.0.1 -P 3306
129 mysql -e 'use galette_tests; source tests/mysql_06.sql;' -u galette_tests --password=g@l3tte -h 127.0.0.1 -P 3306
130 if: env.skip != 'true' && (startsWith(matrix.db-image, 'mysql') || startsWith(matrix.db-image, 'mariadb'))
132 - name: Update database tests
133 run: TESTENV=UPDATE galette/vendor/bin/phpunit --test-suffix=.php --bootstrap tests/TestsBootstrap.php --no-coverage --process-isolation tests/GaletteUpdate/
134 if: env.skip != 'true' && matrix.coverage != 'xdebug'
136 - name: Init for PostgreSQL
138 POSTGRES_HOST: localhost
141 PGPASSWORD=g@l3tte psql -d galette_tests -a -f galette/install/scripts/pgsql.sql -U galette_tests -h localhost
142 if: env.skip != 'true' && startsWith(matrix.db-image, 'postgres')
144 - name: Init for MariaDB
146 mysql -e 'create database IF NOT EXISTS galette_tests;' -u galette_tests --password=g@l3tte -h 127.0.0.1 -P 3306
147 mysql -e 'use galette_tests; source galette/install/scripts/mysql.sql;' -u galette_tests --password=g@l3tte -h 127.0.0.1 -P 3306
148 if: env.skip != 'true' && (startsWith(matrix.db-image, 'mysql') || startsWith(matrix.db-image, 'mariadb'))
151 run: galette/vendor/bin/phpunit --test-suffix=.php --bootstrap tests/TestsBootstrap.php --no-coverage --process-isolation tests/Galette/
152 if: env.skip != 'true' && matrix.coverage != 'xdebug'
154 - name: Unit tests (with coverage)
155 run: galette/vendor/bin/phpunit --test-suffix=.php --bootstrap tests/TestsBootstrap.php --process-isolation --coverage-filter galette/lib --coverage-clover tests/clover.xml tests/Galette/
156 if: env.skip != 'true' && matrix.coverage == 'xdebug'
158 - name: Upload code coverage (scrutinizer)
161 composer require scrutinizer/ocular --ignore-platform-reqs
163 php galette/vendor/bin/ocular code-coverage:upload --format=php-clover tests/clover.xml
164 if: env.skip != 'true' && matrix.coverage == 'xdebug'
166 - name: Upload code coverage (codecov)
167 uses: codecov/codecov-action@v3
169 file: tests/clover.xml
170 if: env.skip != 'true' && matrix.coverage == 'xdebug'
173 runs-on: ubuntu-latest
174 name: DB Fail on ${{ matrix.php-versions }} ${{ matrix.db-image }} ${{ (matrix.always == false && (github.event_name == 'pull_request' || github.repository != 'galette/galette' || !(github.event_name == 'workflow_dispatch' || github.ref == 'refs/heads/master' || github.ref == 'refs/heads/develop' || startsWith(github.ref, 'refs/tags')))) && ' (skipped)' || ''}}
179 - { php-version: "8.3", db-image: "postgres:10", always: true}
180 - { php-version: "8.3", db-image: "mysql:5.6", always: false}
181 - { php-version: "8.3", db-image: "mariadb:10.3", always: false}
185 skip: ${{ matrix.always == false && (github.event_name == 'pull_request' || github.repository != 'galette/galette' || !(github.event_name == 'workflow_dispatch' || github.ref == 'refs/heads/master' || github.ref == 'refs/heads/develop' || startsWith(github.ref, 'refs/tags'))) }}
186 DB: ${{ matrix.db-image }}
189 # Label used to access the service container
192 image: ${{ matrix.db-image }}
193 # Provide env variables for both mysql and pgsql
195 POSTGRES_USER: galette_tests
196 POSTGRES_PASSWORD: g@l3tte
197 POSTGRES_DB: galette_fail_tests
198 MYSQL_USER: galette_tests
199 MYSQL_PASSWORD: g@l3tte
200 MYSQL_ROOT_PASSWORD: g@l3tte
201 MYSQL_DATABASE: galette_fail_tests
202 # Open network ports for both mysql and pgsql
206 # Set health checks to wait until postgres has started
208 --health-cmd="bash -c 'if [[ -n $(command -v pg_isready) ]]; then pg_isready; else if [[ -n $(command -v mysqladmin) ]]; then mysqladmin ping; else mariadb-admin ping; fi fi'"
209 --health-interval=10s
215 if: env.skip != 'true'
216 uses: shivammathur/setup-php@v2
218 php-version: ${{ matrix.php-versions }}
219 tools: composer, pecl
221 ini-values: apc.enable_cli=1
223 - name: "Show versions"
224 if: env.skip != 'true'
228 echo "node $(node --version)"
229 echo "npm $(npm --version)"
230 docker exec ${{ job.services.db.id }} bash -c "if [[ -n \$(command -v psql) ]]; then psql --version; else if [[ -n \$(command -v mysql) ]]; then mysql --version; else mariadb --version; fi fi"
233 if: env.skip != 'true'
234 uses: actions/checkout@v4
238 - name: "Restore dependencies cache"
239 if: env.skip != 'true'
240 uses: actions/cache@v4
245 key: "${{ runner.os }}-galette-${{ matrix.php-version }}-${{ hashFiles('galette/composer.lock', 'package-lock.json') }}"
247 ${{ runner.os }}-galette-${{ matrix.php-version }}-
249 - name: Install dependencies
250 if: env.skip != 'true'
251 run: bin/install_deps
253 - name: Fail database tests
254 if: env.skip != 'true'
255 run: TESTENV=FAIL DB=${{ matrix.db-image }} galette/vendor/bin/phpunit --test-suffix=.php --bootstrap tests/TestsBootstrap.php --no-coverage --process-isolation tests/GaletteDbFails/
258 runs-on: ubuntu-latest
259 name: "Lint on PHP ${{ matrix.php-versions }}"
264 php-versions: [ '8.1', '8.3' ]
268 uses: shivammathur/setup-php@v2
270 php-version: ${{ matrix.php-versions }}
271 tools: composer, pecl
272 coverage: ${{ matrix.coverage }}
274 ini-values: apc.enable_cli=1
276 - name: "Show versions"
282 uses: actions/checkout@v4
286 - name: "Restore dependencies cache"
287 uses: actions/cache@v4
292 key: "${{ runner.os }}-galette-${{ matrix.php-version }}-${{ hashFiles('galette/composer.lock', 'package-lock.json') }}"
294 ${{ runner.os }}-galette-${{ matrix.php-version }}-
296 - name: Install dependencies
299 composer install --optimize-autoloader --ignore-platform-reqs
303 galette/vendor/bin/phpcs
307 galette/vendor/bin/twigcs galette/templates/default --severity error --display blocking
309 - name: Install checker
310 working-directory: galette
311 run: composer require maglnet/composer-require-checker -W --optimize-autoloader --ignore-platform-reqs
313 - name: Check missing symbols
315 galette/vendor/bin/composer-require-checker check --config-file=.composer-require-checker.config.json galette/composer.json
317 - name: PHPStan checks
319 galette/vendor/bin/phpstan analyze --ansi --memory-limit=2G --no-interaction --no-progress
321 - name: Headers checks
323 ./galette/vendor/bin/docheader check galette/config galette/lib galette/includes galette/install galette/webroot test