Merge pull request #1614 from nextcloud/chore/stable24/audit-dependen… #1368
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: Integration | |
| on: | |
| pull_request: | |
| paths: | |
| - '.github/workflows/integration.yml' | |
| - 'appinfo/**' | |
| - 'lib/**' | |
| - 'templates/**' | |
| - 'tests/**' | |
| push: | |
| branches: | |
| - master | |
| - stable* | |
| env: | |
| APP_NAME: notifications | |
| jobs: | |
| sqlite: | |
| runs-on: ubuntu-latest | |
| strategy: | |
| # do not stop on another job's failure | |
| fail-fast: false | |
| matrix: | |
| php-versions: ['7.4'] | |
| databases: ['sqlite'] | |
| server-versions: ['stable24'] | |
| name: integration-php${{ matrix.php-versions }}-${{ matrix.databases }} | |
| steps: | |
| - name: Checkout server | |
| uses: actions/checkout@v2 | |
| with: | |
| repository: nextcloud/server | |
| ref: ${{ matrix.server-versions }} | |
| - name: Checkout submodules | |
| shell: bash | |
| run: | | |
| auth_header="$(git config --local --get http.https://github.com/.extraheader)" | |
| git submodule sync --recursive | |
| git -c "http.extraheader=$auth_header" -c protocol.version=2 submodule update --init --force --recursive --depth=1 | |
| - name: Checkout app | |
| uses: actions/checkout@v2 | |
| with: | |
| path: apps/${{ env.APP_NAME }} | |
| - name: Set up php ${{ matrix.php-versions }} | |
| uses: shivammathur/setup-php@v2 | |
| with: | |
| php-version: ${{ matrix.php-versions }} | |
| extensions: mbstring, iconv, fileinfo, intl, sqlite, pdo_sqlite | |
| coverage: none | |
| - name: Set up PHPUnit | |
| working-directory: apps/${{ env.APP_NAME }}/tests/Integration | |
| run: composer i | |
| - name: Set up Nextcloud | |
| env: | |
| DB_PORT: 4444 | |
| run: | | |
| mkdir data | |
| ./occ maintenance:install --verbose --database=${{ matrix.databases }} --database-name=nextcloud --database-host=127.0.0.1 --database-port=$DB_PORT --database-user=root --database-pass=rootpassword --admin-user admin --admin-pass admin | |
| php -f index.php | |
| ./occ app:enable --force ${{ env.APP_NAME }} | |
| php -S localhost:8080 & | |
| ./occ config:system:set query_log_file --value '/home/runner/work/notifications/notifications/query.log' | |
| - name: Integration | |
| working-directory: apps/${{ env.APP_NAME }}/tests/Integration | |
| run: bash run.sh | |
| - name: Print query.log | |
| run: cat /home/runner/work/notifications/notifications/query.log | |
| - name: Query count | |
| uses: actions/github-script@v5 | |
| with: | |
| github-token: ${{secrets.GITHUB_TOKEN}} | |
| script: | | |
| let myOutput = '' | |
| let myError = '' | |
| const options = {} | |
| options.listeners = { | |
| stdout: (data) => { | |
| myOutput += data.toString() | |
| }, | |
| stderr: (data) => { | |
| myError += data.toString() | |
| } | |
| } | |
| await exec.exec(`/bin/bash -c "cat /home/runner/work/notifications/notifications/query.log | wc -l"`, [], options) | |
| msg = myOutput | |
| const queryCount = parseInt(myOutput, 10) | |
| myOutput = '' | |
| await exec.exec('cat', ['/home/runner/work/notifications/notifications/apps/notifications/tests/Integration/base-query-count.txt'], options) | |
| const baseCount = parseInt(myOutput, 10) | |
| const absoluteIncrease = queryCount - baseCount | |
| const relativeIncrease = baseCount <= 0 ? 100 : (parseInt((absoluteIncrease / baseCount * 10000), 10) / 100) | |
| if (absoluteIncrease >= 100 || relativeIncrease > 5) { | |
| const comment = `🐢 Performance warning.\nIt looks like the query count of the integration tests increased with this PR.\nDatabase query count is now ` + queryCount + ' was ' + baseCount + ' (+' + relativeIncrease + '%)\nPlease check your code again. If you added a new test this can be expected and the base value in tests/Integration/base-query-count.txt can be increased.' | |
| github.rest.issues.createComment({ | |
| issue_number: context.issue.number, | |
| owner: context.repo.owner, | |
| repo: context.repo.repo, | |
| body: comment | |
| }) | |
| } | |
| if (queryCount < 100) { | |
| const comment = `🐈 Performance messuring seems broken. Failed to get query count.` | |
| github.rest.issues.createComment({ | |
| issue_number: context.issue.number, | |
| owner: context.repo.owner, | |
| repo: context.repo.repo, | |
| body: comment | |
| }) | |
| } | |
| mysql: | |
| runs-on: ubuntu-latest | |
| strategy: | |
| # do not stop on another job's failure | |
| fail-fast: false | |
| matrix: | |
| php-versions: ['7.4', '8.0', "8.1"] | |
| databases: ['mysql'] | |
| server-versions: ['stable24'] | |
| name: integration-php${{ matrix.php-versions }}-${{ matrix.databases }} | |
| services: | |
| mysql: | |
| image: mariadb:10.5 | |
| ports: | |
| - 4444:3306/tcp | |
| env: | |
| MYSQL_ROOT_PASSWORD: rootpassword | |
| options: --health-cmd="mysqladmin ping" --health-interval 5s --health-timeout 2s --health-retries 5 | |
| steps: | |
| - name: Checkout server | |
| uses: actions/checkout@v2 | |
| with: | |
| repository: nextcloud/server | |
| ref: ${{ matrix.server-versions }} | |
| - name: Checkout submodules | |
| shell: bash | |
| run: | | |
| auth_header="$(git config --local --get http.https://github.com/.extraheader)" | |
| git submodule sync --recursive | |
| git -c "http.extraheader=$auth_header" -c protocol.version=2 submodule update --init --force --recursive --depth=1 | |
| - name: Checkout app | |
| uses: actions/checkout@v2 | |
| with: | |
| path: apps/${{ env.APP_NAME }} | |
| - name: Set up php ${{ matrix.php-versions }} | |
| uses: shivammathur/setup-php@v2 | |
| with: | |
| php-version: ${{ matrix.php-versions }} | |
| extensions: mbstring, iconv, fileinfo, intl, mysql, pdo_mysql, gd, zip | |
| coverage: none | |
| - name: Set up PHPUnit | |
| working-directory: apps/${{ env.APP_NAME }}/tests/Integration | |
| run: composer i | |
| - name: Set up Nextcloud | |
| env: | |
| DB_PORT: 4444 | |
| run: | | |
| mkdir data | |
| ./occ maintenance:install --verbose --database=${{ matrix.databases }} --database-name=nextcloud --database-host=127.0.0.1 --database-port=$DB_PORT --database-user=root --database-pass=rootpassword --admin-user admin --admin-pass admin | |
| php -f index.php | |
| ./occ app:enable --force ${{ env.APP_NAME }} | |
| php -S localhost:8080 & | |
| - name: Integration | |
| working-directory: apps/${{ env.APP_NAME }}/tests/Integration | |
| run: bash run.sh | |
| pgsql: | |
| runs-on: ubuntu-latest | |
| strategy: | |
| # do not stop on another job's failure | |
| fail-fast: false | |
| matrix: | |
| php-versions: ['7.4'] | |
| databases: ['pgsql'] | |
| server-versions: ['stable24'] | |
| name: integration-php${{ matrix.php-versions }}-${{ matrix.databases }} | |
| services: | |
| postgres: | |
| image: postgres:14 | |
| ports: | |
| - 4444:5432/tcp | |
| env: | |
| POSTGRES_USER: root | |
| POSTGRES_PASSWORD: rootpassword | |
| POSTGRES_DB: nextcloud | |
| options: --health-cmd pg_isready --health-interval 5s --health-timeout 2s --health-retries 5 | |
| steps: | |
| - name: Checkout server | |
| uses: actions/checkout@v2 | |
| with: | |
| repository: nextcloud/server | |
| ref: ${{ matrix.server-versions }} | |
| - name: Checkout submodules | |
| shell: bash | |
| run: | | |
| auth_header="$(git config --local --get http.https://github.com/.extraheader)" | |
| git submodule sync --recursive | |
| git -c "http.extraheader=$auth_header" -c protocol.version=2 submodule update --init --force --recursive --depth=1 | |
| - name: Checkout app | |
| uses: actions/checkout@v2 | |
| with: | |
| path: apps/${{ env.APP_NAME }} | |
| - name: Set up php ${{ matrix.php-versions }} | |
| uses: shivammathur/setup-php@v2 | |
| with: | |
| php-version: ${{ matrix.php-versions }} | |
| extensions: mbstring, iconv, fileinfo, intl, pgsql, pdo_pgsql | |
| coverage: none | |
| - name: Set up PHPUnit | |
| working-directory: apps/${{ env.APP_NAME }}/tests/Integration | |
| run: composer i | |
| - name: Set up Nextcloud | |
| env: | |
| DB_PORT: 4444 | |
| run: | | |
| mkdir data | |
| ./occ maintenance:install --verbose --database=${{ matrix.databases }} --database-name=nextcloud --database-host=127.0.0.1 --database-port=$DB_PORT --database-user=root --database-pass=rootpassword --admin-user admin --admin-pass admin | |
| php -f index.php | |
| ./occ app:enable --force ${{ env.APP_NAME }} | |
| php -S localhost:8080 & | |
| - name: Integration | |
| working-directory: apps/${{ env.APP_NAME }}/tests/Integration | |
| run: bash run.sh | |
| oci: | |
| runs-on: ubuntu-latest | |
| strategy: | |
| # do not stop on another job's failure | |
| fail-fast: false | |
| matrix: | |
| php-versions: ['7.4'] | |
| databases: ['oci'] | |
| server-versions: ['stable24'] | |
| name: integration-php${{ matrix.php-versions }}-${{ matrix.databases }} | |
| services: | |
| oracle: | |
| image: deepdiver/docker-oracle-xe-11g # "wnameless/oracle-xe-11g-r2" | |
| ports: | |
| - "1521:1521" | |
| steps: | |
| - name: Checkout server | |
| uses: actions/checkout@v2 | |
| with: | |
| repository: nextcloud/server | |
| ref: ${{ matrix.server-versions }} | |
| - name: Checkout submodules | |
| shell: bash | |
| run: | | |
| auth_header="$(git config --local --get http.https://github.com/.extraheader)" | |
| git submodule sync --recursive | |
| git -c "http.extraheader=$auth_header" -c protocol.version=2 submodule update --init --force --recursive --depth=1 | |
| - name: Checkout app | |
| uses: actions/checkout@v2 | |
| with: | |
| path: apps/${{ env.APP_NAME }} | |
| - name: Set up php ${{ matrix.php-versions }} | |
| uses: shivammathur/setup-php@v2 | |
| with: | |
| php-version: ${{ matrix.php-versions }} | |
| extensions: mbstring, iconv, fileinfo, intl, oci8 | |
| coverage: none | |
| - name: Set up PHPUnit | |
| working-directory: apps/${{ env.APP_NAME }}/tests/Integration | |
| run: composer i | |
| - name: Set up Nextcloud | |
| run: | | |
| mkdir data | |
| ./occ maintenance:install --verbose --database=${{ matrix.databases }} --database-name=XE --database-host=127.0.0.1 --database-port=1521 --database-user=autotest --database-pass=owncloud --admin-user admin --admin-pass admin | |
| php -f index.php | |
| ./occ app:enable --force ${{ env.APP_NAME }} | |
| php -S localhost:8080 & | |
| - name: Integration | |
| working-directory: apps/${{ env.APP_NAME }}/tests/Integration | |
| run: bash run.sh |