Better support for COPY FROM statements #773
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: Regression Tests | |
| on: | |
| pull_request: | |
| types: [opened, synchronize, reopened] | |
| env: | |
| REGRESSION_TESTING: true | |
| permissions: | |
| contents: read | |
| pull-requests: write | |
| jobs: | |
| regression-tests: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Checkout DoltgreSQL | |
| uses: actions/checkout@v4 | |
| with: | |
| ref: ${{ github.event.pull_request.head.sha }} | |
| - name: Setup Git User | |
| uses: fregante/setup-git-user@v2 | |
| - name: Merge main into PR | |
| id: merge_main | |
| run: | | |
| git fetch --all --unshallow | |
| git merge origin/main --no-commit --no-ff | |
| if [ $? -ne 0 ]; then | |
| echo "Skipping the remainder of the workflow due to a merge conflict." | |
| echo "skip=true" >> $GITHUB_OUTPUT | |
| else | |
| echo "Merge performed successfully, continuing workflow." | |
| echo "skip=false" >> $GITHUB_OUTPUT | |
| fi | |
| - name: Install Go | |
| uses: actions/setup-go@v5 | |
| if: steps.merge_main.outputs.skip == 'false' | |
| with: | |
| go-version-file: go.mod | |
| - name: Test PR branch | |
| id: test_doltgresql_pr | |
| if: steps.merge_main.outputs.skip == 'false' | |
| continue-on-error: true | |
| run: | | |
| ./postgres/parser/build.sh | |
| cd testing/go/regression | |
| mkdir -p out | |
| cd tool | |
| go test --timeout=20m ./... --count=1 | |
| cp ../out/results.trackers ../out/results2.trackers | |
| - name: Test main branch | |
| id: test_doltgresql_main | |
| if: steps.merge_main.outputs.skip == 'false' | |
| continue-on-error: true | |
| run: | | |
| git reset --hard | |
| git checkout origin/main | |
| ./postgres/parser/build.sh | |
| cd testing/go/regression | |
| mkdir -p out | |
| cd tool | |
| go test --timeout=20m ./... --count=1 | |
| cp ../out/results.trackers ../out/results1.trackers | |
| - name: Check result trackers | |
| id: check_trackers | |
| if: steps.merge_main.outputs.skip == 'false' | |
| run: | | |
| cd testing/go/regression/out | |
| if [[ -f "results1.trackers" && -f "results2.trackers" ]]; then | |
| echo "trackers_exist=true" >> $GITHUB_OUTPUT | |
| echo "trackers exist" | |
| else | |
| echo "trackers_exist=false" >> $GITHUB_OUTPUT | |
| echo "One of the branches could not successfully complete their tests." | |
| echo "Please review them for errors, which must be fixed." | |
| exit 1 | |
| fi | |
| - name: Build Regression Test Results Comment | |
| id: build_results | |
| if: steps.check_trackers.outputs.trackers_exist == 'true' | |
| run: | | |
| cd testing/go/regression/tool | |
| output=$(go run . results1.trackers results2.trackers) | |
| echo "program_output<<EOF" >> $GITHUB_OUTPUT | |
| echo "$output" >> $GITHUB_OUTPUT | |
| echo "EOF" >> $GITHUB_OUTPUT | |
| echo "$output" | |
| - name: Is PR From Fork | |
| id: from_fork | |
| run: | | |
| if [ "${{ github.event.pull_request.head.repo.full_name }}" != "${{ github.repository }}" ]; then | |
| echo "This is running from a fork, skipping commenting" | |
| echo "fork=true" >> $GITHUB_OUTPUT | |
| else | |
| echo "This is not running from a fork" | |
| echo "fork=false" >> $GITHUB_OUTPUT | |
| fi | |
| - name: Post Comment | |
| if: steps.from_fork.outputs.fork == 'false' && steps.build_results.outputs.program_output | |
| uses: actions/github-script@v6 | |
| env: | |
| PROGRAM_OUTPUT: ${{ steps.build_results.outputs.program_output }} | |
| with: | |
| github-token: ${{ secrets.GITHUB_TOKEN }} | |
| script: | | |
| const commentMarker = '<!-- go-run-output -->' | |
| const output = process.env.PROGRAM_OUTPUT | |
| const body = `${commentMarker}\n${output}` | |
| // List comments on the PR | |
| const { data: comments } = await github.rest.issues.listComments({ | |
| issue_number: context.issue.number, | |
| owner: context.repo.owner, | |
| repo: context.repo.repo, | |
| }) | |
| // Check if a comment already exists | |
| const comment = comments.find(comment => comment.body.includes(commentMarker)) | |
| if (comment) { | |
| // Update the existing comment | |
| await github.rest.issues.updateComment({ | |
| comment_id: comment.id, | |
| owner: context.repo.owner, | |
| repo: context.repo.repo, | |
| body: body | |
| }) | |
| } else { | |
| // Create a new comment | |
| await github.rest.issues.createComment({ | |
| issue_number: context.issue.number, | |
| owner: context.repo.owner, | |
| repo: context.repo.repo, | |
| body: body | |
| }) | |
| } |