Split SQL query execution #1563
Workflow file for this run
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: UI Tests | |
| on: | |
| ## Check each PR | |
| push: | |
| branches: | |
| - dev | |
| - master | |
| pull_request: | |
| ## Manual execution on branch | |
| workflow_dispatch: | |
| ## Nightly | |
| ### Needs secrets | |
| #### GC_PROJECT_ID | |
| #### GC_SERVICE_KEY | |
| #### NIGHTLY_TOKEN | |
| schedule: | |
| - cron: '0 0 * * *' | |
| env: | |
| CAMPAIGN: 'autoupgrade' | |
| jobs: | |
| ui_test_matrix: | |
| if: github.event.pull_request.draft == false | |
| name: UI Tests (Matrix) | |
| runs-on: ubuntu-latest | |
| env: | |
| JSON_FILE: ${{ (github.event_name == 'schedule' || (github.event_name == 'pull_request' && github.event.pull_request.head.ref == 'dev' && github.event.pull_request.base.ref == 'master')) && 'nightly.json' || 'sanity.json' }} | |
| outputs: | |
| matrix: ${{ steps.set-matrix.outputs.matrix }} | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| - name: Set matrix | |
| id: set-matrix | |
| run: echo "matrix=$(jq -c '. | del(.include[] | select(has("comment")))' .github/workflows/ui-test/${{ env.JSON_FILE }})" >> $GITHUB_OUTPUT | |
| ui_test: | |
| name: UI Tests | |
| runs-on: ubuntu-latest | |
| needs: ui_test_matrix | |
| strategy: | |
| fail-fast: false | |
| matrix: ${{ fromJSON(needs.ui_test_matrix.outputs.matrix) }} | |
| env: | |
| PS_DOCKER: ${{ matrix.PS_VERSION_START }}-${{ matrix.PHP_VERSION }} | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| - name: Start containers | |
| working-directory: tests/UI/ | |
| env: | |
| PS_VERSION: ${{ env.PS_DOCKER }} | |
| run: | | |
| docker compose -f "docker-compose.yml" up -d --build | |
| bash -c 'while [[ "$(curl -L -s -o /dev/null -w %{http_code} http://localhost/en/)" != "200" ]]; do sleep 5; done' | |
| - name: Composer install | |
| run: composer install | |
| - name: Install module autoupgrade | |
| working-directory: tests/UI/ | |
| run: | | |
| docker exec -t prestashop php -v bin/console prestashop:module install autoupgrade | |
| - name: Backup | |
| run: | | |
| docker exec -t prestashop php modules/autoupgrade/bin/console backup:create admin-dev | |
| - name: Update | |
| run: | | |
| docker exec -t prestashop php modules/autoupgrade/bin/console update:start --channel=${{ matrix.UPGRADE_CHANNEL }} admin-dev | |
| docker exec -t prestashop chmod 777 -R /var/www/html/var/cache | |
| - name: Install dependencies | |
| working-directory: tests/UI/ | |
| run: npm ci | |
| - name: Install Playwright Browsers | |
| working-directory: tests/UI/ | |
| run: npx playwright install chromium --with-deps | |
| - name: Run Sanity tests | |
| working-directory: tests/UI/ | |
| env: | |
| PS_VERSION: ${{ matrix.PS_VERSION_END }} | |
| DB_USER: prestashop | |
| DB_PASSWD: prestashop | |
| DB_NAME: prestashop | |
| DB_PREFIX: ps_ | |
| run: npx playwright test | |
| - name: Rollback | |
| run: | | |
| backupName=$(docker exec -t prestashop bash -c "ls -td -- /var/www/html/admin-dev/autoupgrade/backup/*/ | head -n 1 | cut -d'/' -f8 | tr -d '\n'") | |
| docker exec -t prestashop php modules/autoupgrade/bin/console backup:restore --backup=$backupName admin-dev | |
| - name: Run Sanity tests | |
| working-directory: tests/UI/ | |
| env: | |
| PS_VERSION: ${{ matrix.PS_VERSION_START }} | |
| DB_USER: prestashop | |
| DB_PASSWD: prestashop | |
| DB_NAME: prestashop | |
| DB_PREFIX: ps_ | |
| run: npx playwright test | |
| - name: Export Docker errors | |
| working-directory: tests/UI/ | |
| if: always() | |
| run: docker compose logs --no-color >& docker-compose.log | |
| - name: Upload artifact | |
| uses: actions/upload-artifact@v4 | |
| if: always() | |
| with: | |
| name: playwright-report-${{ matrix.PS_VERSION_START }}-${{ matrix.PS_VERSION_END }}-${{ matrix.UPGRADE_CHANNEL }}-${{ matrix.PHP_VERSION }} | |
| path: | | |
| tests/UI/reports/ | |
| tests/UI/report.json | |
| tests/UI/docker-compose.log | |
| retention-days: 30 | |
| nightly: | |
| name: Nightly Report | |
| if: ${{ github.event_name == 'schedule' }} | |
| needs: | |
| - ui_test_matrix | |
| - ui_test | |
| runs-on: ubuntu-latest | |
| strategy: | |
| fail-fast: false | |
| matrix: ${{ fromJSON(needs.ui_test_matrix.outputs.matrix) }} | |
| permissions: | |
| contents: 'read' | |
| id-token: 'write' | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| - name: Download report | |
| uses: actions/download-artifact@v4 | |
| with: | |
| name: playwright-report-${{ matrix.PS_VERSION_START }}-${{ matrix.PS_VERSION_END }}-${{ matrix.UPGRADE_CHANNEL }}-${{ matrix.PHP_VERSION }} | |
| path: tests/UI/ | |
| # Nightly : Rename file | |
| - name: "Nightly : Rename file" | |
| working-directory: tests/UI/ | |
| run: | | |
| mkdir -p nightly | |
| REPORT_NAME="${{ env.CAMPAIGN }}_$(date +%Y-%m-%d)-${{ matrix.PS_VERSION_START }}_(Channel:_${{ matrix.UPGRADE_CHANNEL }}_PHP:_${{ matrix.PHP_VERSION }})" | |
| mv report.json nightly/${REPORT_NAME}.json | |
| # Nightly : Auth GCP | |
| - name: "Nightly : Auth GCP" | |
| uses: google-github-actions/auth@v2 | |
| with: | |
| credentials_json: ${{ secrets.GC_SERVICE_KEY }} | |
| project_id: ${{ secrets.GC_PROJECT_ID }} | |
| # Nightly : Setup GCP | |
| - name: "Nightly : Setup GCP" | |
| uses: google-github-actions/setup-gcloud@v2 | |
| # Nightly : Upload to Google Cloud Storage (GCS) | |
| - name: "Nightly : Upload to Google Cloud Storage (GCS)" | |
| working-directory: tests/UI/ | |
| run: gsutil cp -r "nightly/**" gs://prestashop-core-nightly/reports | |
| # Nightly : Push Report | |
| - name: "Nightly : Push Report" | |
| run: | | |
| REPORT_NAME="${{ env.CAMPAIGN }}_$(date +%Y-%m-%d)-${{ matrix.PS_VERSION_START }}_(Channel:_${{ matrix.UPGRADE_CHANNEL }}_PHP:_${{ matrix.PHP_VERSION }})" | |
| curl -v "https://api-nightly.prestashop-project.org/import/report/playwright?token=${{ secrets.NIGHTLY_TOKEN }}&filename=${REPORT_NAME}.json&campaign=${{ env.CAMPAIGN }}&platform=cli" |