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 PostgreSQL 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: 'pcov', 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 == 'pcov' && ' (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 != 'pcov'
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 != 'pcov'
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 == 'pcov'
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 == 'pcov'
166 - name: Upload code coverage (codecov)
167 uses: codecov/codecov-action@v4
169 CODECOV_TOKEN: 2d9dd954-bed8-4628-a267-28cd0108771b
171 file: tests/clover.xml
172 if: env.skip != 'true' && matrix.coverage == 'pcov'
175 runs-on: ubuntu-latest
176 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)' || ''}}
181 - { php-version: "8.3", db-image: "postgres:10", always: true}
182 - { php-version: "8.3", db-image: "mysql:5.6", always: false}
183 - { php-version: "8.3", db-image: "mariadb:10.3", always: false}
187 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'))) }}
188 DB: ${{ matrix.db-image }}
191 # Label used to access the service container
194 image: ${{ matrix.db-image }}
195 # Provide env variables for both mysql and pgsql
197 POSTGRES_USER: galette_tests
198 POSTGRES_PASSWORD: g@l3tte
199 POSTGRES_DB: galette_fail_tests
200 MYSQL_USER: galette_tests
201 MYSQL_PASSWORD: g@l3tte
202 MYSQL_ROOT_PASSWORD: g@l3tte
203 MYSQL_DATABASE: galette_fail_tests
204 # Open network ports for both mysql and pgsql
208 # Set health checks to wait until postgres has started
210 --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'"
211 --health-interval=10s
217 if: env.skip != 'true'
218 uses: shivammathur/setup-php@v2
220 php-version: ${{ matrix.php-versions }}
221 tools: composer, pecl
223 ini-values: apc.enable_cli=1
225 - name: "Show versions"
226 if: env.skip != 'true'
230 echo "node $(node --version)"
231 echo "npm $(npm --version)"
232 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"
235 if: env.skip != 'true'
236 uses: actions/checkout@v4
240 - name: "Restore dependencies cache"
241 if: env.skip != 'true'
242 uses: actions/cache@v4
247 key: "${{ runner.os }}-galette-${{ matrix.php-version }}-${{ hashFiles('galette/composer.lock', 'package-lock.json') }}"
249 ${{ runner.os }}-galette-${{ matrix.php-version }}-
251 - name: Install dependencies
252 if: env.skip != 'true'
253 run: bin/install_deps
255 - name: Fail database tests
256 if: env.skip != 'true'
257 run: TESTENV=FAIL DB=${{ matrix.db-image }} galette/vendor/bin/phpunit --test-suffix=.php --bootstrap tests/TestsBootstrap.php --no-coverage --process-isolation tests/GaletteDbFails/
260 runs-on: ubuntu-latest
261 name: "Lint on PHP ${{ matrix.php-versions }}"
266 php-versions: [ '8.1', '8.3' ]
270 uses: shivammathur/setup-php@v2
272 php-version: ${{ matrix.php-versions }}
273 tools: composer, pecl
274 coverage: ${{ matrix.coverage }}
276 ini-values: apc.enable_cli=1
278 - name: "Show versions"
284 uses: actions/checkout@v4
288 - name: "Restore dependencies cache"
289 uses: actions/cache@v4
294 key: "${{ runner.os }}-galette-${{ matrix.php-version }}-${{ hashFiles('galette/composer.lock', 'package-lock.json') }}"
296 ${{ runner.os }}-galette-${{ matrix.php-version }}-
298 - name: Install dependencies
301 composer install --optimize-autoloader --ignore-platform-reqs
305 galette/vendor/bin/phpcs
309 galette/vendor/bin/twigcs galette/templates/default --severity error --display blocking
311 - name: Install checker
312 working-directory: galette
313 run: composer require maglnet/composer-require-checker -W --optimize-autoloader --ignore-platform-reqs
315 - name: Check missing symbols
317 galette/vendor/bin/composer-require-checker check --config-file=.composer-require-checker.config.json galette/composer.json
319 - name: PHPStan checks
321 galette/vendor/bin/phpstan analyze --ansi --memory-limit=2G --no-interaction --no-progress
323 - name: Headers checks
325 ./galette/vendor/bin/docheader check galette/config galette/lib galette/includes galette/install galette/webroot test