run MySQL on CI
#71
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
| # https://help.github.com/en/categories/automating-your-workflow-with-github-actions | |
| # https://github.com/sebastianbergmann/phpunit/blob/master/.github/workflows/ci.yml | |
| # https://github.com/ikalnytskyi/action-setup-postgres | |
| # https://github.com/marketplace/actions/actions-setup-mysql | |
| name: "Continuous Integration" | |
| on: | |
| push: | |
| branches: | |
| - main | |
| pull_request: | |
| branches: | |
| - main | |
| env: | |
| PHP_EXTENSIONS: json, mbstring, simplexml, sodium, odbc, pdo_odbc, mysqli, pdo_mysql, pgsql, pdo_pgsql, sqlite3, pdo_sqlite, sqlsrv, pdo_sqlsrv, pdo_firebird | |
| PHP_INI_VALUES: memory_limit=-1, error_reporting=-1, display_errors=On | |
| jobs: | |
| static-code-analysis: | |
| name: "Static Code Analysis" | |
| runs-on: ubuntu-latest | |
| strategy: | |
| fail-fast: true | |
| matrix: | |
| php-version: | |
| - "8.2" | |
| - "8.3" | |
| # - "8.4" | |
| env: | |
| PHAN_ALLOW_XDEBUG: 0 | |
| PHAN_DISABLE_XDEBUG_WARN: 1 | |
| steps: | |
| - name: "Checkout" | |
| uses: actions/checkout@v4 | |
| - name: "Install PHP" | |
| uses: shivammathur/setup-php@v2 | |
| with: | |
| php-version: ${{ matrix.php-version }} | |
| extensions: ast, ${{ env.PHP_EXTENSIONS }} | |
| ini-values: ${{ env.PHP_INI_VALUES }} | |
| coverage: none | |
| - name: "Update dependencies with composer" | |
| uses: ramsey/composer-install@v3 | |
| - name: "Run phan" | |
| run: php vendor/bin/phan --target-php-version=${{ matrix.php-version }} | |
| build-docs: | |
| name: "Build and publish Docs" | |
| if: github.ref_name == 'main' | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: "Checkout sources" | |
| uses: actions/checkout@v4 | |
| - name: "Install PHP" | |
| uses: shivammathur/setup-php@v2 | |
| with: | |
| php-version: "8.2" | |
| coverage: none | |
| tools: phpDocumentor | |
| extensions: gd, imagick, json, mbstring | |
| - name: "Build Docs" | |
| run: phpdoc --config=phpdoc.xml | |
| - name: "Publish Docs to gh-pages" | |
| uses: JamesIves/github-pages-deploy-action@v4 | |
| with: | |
| branch: gh-pages | |
| folder: docs | |
| clean: true | |
| tests: | |
| name: "Unit Tests" | |
| needs: static-code-analysis | |
| runs-on: ${{ matrix.os }} | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| os: | |
| - ubuntu-latest | |
| - windows-latest | |
| php-version: | |
| - "8.2" | |
| - "8.3" | |
| - "8.4" | |
| steps: | |
| - name: "Checkout" | |
| uses: actions/checkout@v4 | |
| - name: "Install SQLite (Linux)" | |
| if: ${{ runner.os == 'Linux' }} | |
| run: sudo apt-get -y install sqlite3 libsqlite3-dev | |
| - name: "Install SQLite (Windows)" | |
| if: ${{ runner.os == 'Windows' }} | |
| run: choco install sqlite | |
| - name: "Install Postgres" | |
| uses: ikalnytskyi/action-setup-postgres@v6 | |
| with: | |
| postgres-version: 14 | |
| username: postgres | |
| password: root | |
| database: dbtest | |
| port: 5432 | |
| - name: "Install MySQL" | |
| uses: shogo82148/actions-setup-mysql@v1 | |
| with: | |
| mysql-version: "8.0" | |
| - name: "Create MySQL test database" | |
| run: mysql --user="root" --host="127.0.0.1" -e "CREATE DATABASE dbtest character set UTF8mb4 collate utf8mb4_bin;" | |
| # - name: "Install Firebird (Linux)" | |
| # if: ${{ runner.os == 'Linux' }} | |
| # run: | | |
| # sudo add-apt-repository ppa:mapopa/firebird3.0 | |
| # sudo apt-get update | |
| # sudo apt-get install -y firebird2.5-superclassic | |
| # sudo cp ./config/firebird.conf /etc/firebird/2.5/firebird.conf | |
| # sudo service firebird2.5 restart | |
| # - name: "Install Firebird (Windows)" | |
| # if: ${{ runner.os == 'Windows' }} | |
| # run: choco install firebird --version=2.5.8 -params '/ClientAndDevTools' | |
| # - name: "Install MSSQL Server (Linux)" | |
| # if: ${{ runner.os == 'Linux' }} | |
| # run: sh ./scripts/install-mssql.sh | |
| # - name: "Start SQL LocalDB (Windows)" | |
| # if: ${{ runner.os == 'Windows' }} | |
| # run: | | |
| # # MSSQLLocalDB is the default SQL LocalDB instance | |
| # SqlLocalDB start MSSQLLocalDB | |
| # SqlLocalDB info MSSQLLocalDB | |
| # sqlcmd -S "(localdb)\MSSQLLocalDB" -Q "create database dbtest;" | |
| - name: "Install PHP with extensions" | |
| uses: shivammathur/setup-php@v2 | |
| with: | |
| php-version: ${{ matrix.php-version }} | |
| extensions: ${{ env.PHP_EXTENSIONS }} | |
| ini-values: ${{ env.PHP_INI_VALUES }} | |
| coverage: pcov | |
| - name: "Update dependencies with composer" | |
| uses: ramsey/composer-install@v3 | |
| - name: "Run tests with phpunit" | |
| run: php vendor/phpunit/phpunit/phpunit --configuration=phpunit.xml.dist | |
| - name: "Send code coverage report to Codecov.io" | |
| uses: codecov/codecov-action@v4 | |
| with: | |
| token: ${{ secrets.CODECOV_TOKEN }} | |
| files: .build/coverage/clover.xml |