cakephp-dump-sql/.github/workflows/ci.yml at 66ebdc1326bd2cad9ced1363d5524aa0b27f0ded · LordSimal/cakephp-dump-sql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
name: CI

on:
    push:
        branches:
            - '2.x'
            - '2.next'
    pull_request:
        branches:
            - '*'
    workflow_dispatch:

permissions:
    contents: read # to fetch code (actions/checkout)

jobs:
    testsuite-linux:
        runs-on: ubuntu-24.04
        strategy:
            fail-fast: false
            matrix:
                php-version: [ '8.1', '8.2', '8.3', '8.4' ]
                db-type: [ sqlite, mysql, mariadb, pgsql ]

        services:
            mariadb:
                image: mariadb:11
                env:
                    MARIADB_ROOT_PASSWORD: root
                    MARIADB_DATABASE: cakephp
                ports:
                    - 3307:3306
                options: >-
                    --health-cmd "mariadb-admin ping -h localhost -proot"
                    --health-interval 10s
                    --health-timeout 5s
                    --health-retries 5
            postgres:
                image: postgres:14
                env:
                    POSTGRES_PASSWORD: postgres
                ports:
                    - 5432:5432
                options: >-
                    --health-cmd pg_isready
                    --health-interval 10s
                    --health-timeout 5s
                    --health-retries 5

        steps:
            -   uses: actions/checkout@v5

            -   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;'

            -   name: Install MariaDB dump tools
                if: matrix.db-type == 'mariadb'
                run: sudo apt-get install mariadb-client

            -   name: Setup Postgres
                if: matrix.db-type == 'pgsql'
                run: |
                    PGPASSWORD=postgres psql -h 127.0.0.1 -U postgres -c 'GRANT ALL ON SCHEMA public to postgres;'

            -   name: Install pg_dump
                if: matrix.db-type == 'pgsql'
                run: sudo apt-get install postgresql-client

            -   name: Setup PHP
                uses: shivammathur/setup-php@v2
                with:
                    php-version: ${{ matrix.php-version }}
                    extensions: mbstring, intl, ${{ matrix.db-type == 'sqlite' && 'pdo_sqlite' || matrix.db-type == 'pgsql' && 'pdo_pgsql' || 'pdo_mysql' }}
                    ini-values: zend.assertions=1
                    coverage: pcov

            -   name: Composer install
                uses: ramsey/composer-install@v3
                with:
                    dependency-versions: ${{ matrix.dependencies }}
                    composer-options: ${{ matrix.composer-options }}

            -   name: Run PHPUnit
                run: |
                    if [[ ${{ matrix.db-type }} == 'sqlite' ]]; then
                        export DB_URL=sqlite:///testdb.sqlite3
                    fi
                    if [[ ${{ matrix.db-type }} == 'mysql' ]]; then
                        export DB_URL=mysql://root:root@127.0.0.1/cakephp
                    fi
                    if [[ ${{ matrix.db-type }} == 'mariadb' ]]; then
                        export DB_URL=mysql://root:root@127.0.0.1:3307/cakephp
                    fi
                    if [[ ${{ matrix.db-type }} == 'pgsql' ]]; then
                        export DB_URL=postgres://postgres:postgres@127.0.0.1/postgres
                    fi
                    if [[ ${{ matrix.php-version }} == '8.2' ]]; then
                        vendor/bin/phpunit --coverage-clover=coverage.xml
                    else
                        vendor/bin/phpunit
                    fi

            -   name: Code Coverage Report
                if: success() && matrix.php-version == '8.2'
                uses: codecov/codecov-action@v5

    cs-stan:
        name: Coding Standard & Static Analysis
        runs-on: ubuntu-22.04

        steps:
            -   uses: actions/checkout@v5

            -   name: Setup PHP
                uses: shivammathur/setup-php@v2
                with:
                    php-version: '8.3'
                    extensions: mbstring, intl
                    coverage: none
                    tools: phive, cs2pr

            -   name: Composer install
                uses: ramsey/composer-install@v3

            -   name: Install PHP tools with phive.
                run: "phive install --trust-gpg-keys '51C67305FFC2E5C0,12CE0F1D262429A5,99BF4D9A33D65E1E'"

            -   name: Run phpcs
                if: always()
                run: vendor/bin/phpcs --report=checkstyle src/ tests/ | cs2pr

            -   name: Run psalm
                if: always()
                run: tools/psalm --output-format=github

            -   name: Run phpstan
                if: always()
                run: tools/phpstan analyse --error-format=github