d2a4813a9b
## What We have a workflow that once a day checks if the latest CDK version would break any connector. If there are test failures, it sends a slack alert. In addition to sending a slack alert, we would like to get an oncall ticket in our github project. We should only do this for destinations (connectors owned by move) ## How Added a few extra steps to the workflow that calls a script that creates gh issues. It checks if an issue already exists for the connector. If it does it will update the description with information about the new failure. If it doesn't it will create a new ticket ## How did I test this? Tested in this PR https://github.com/airbytehq/airbyte/pull/67617. Confirmed that tickets were created if they didn't exist and that they were updated if they did exist. ## Can this PR be safely reverted and rolled back? <!-- * If unsure, leave it blank. --> - [x] YES 💚 - [ ] NO ❌
55 lines
2.5 KiB
Bash
Executable File
55 lines
2.5 KiB
Bash
Executable File
#!/usr/bin/env bash
|
|
|
|
set -euo pipefail
|
|
|
|
# Creates a GitHub issue for CDK connector compatibility test failures.
|
|
# If an issue for the connector already exists, appends a new entry to the existing issue
|
|
# instead of creating a new issue.
|
|
#
|
|
# This is intended to be used by the move team since it has specific logic to how the move team manages oncall issues.
|
|
#
|
|
# Usage: tools/bin/bulk-cdk-compatibility-test/create-gh-issue.sh <connector_name> <job_url> <commit_sha>
|
|
# Example: tools/bin/bulk-cdk-compatibility-test/create-gh-issue.sh destination-dev-null www.myjoburl.com abcdef123456
|
|
|
|
# default values are specific to how the move team manages issues
|
|
# Getting these ids is not straightforward:
|
|
# - project number: from the project URL `https://github.com/orgs/airbytehq/projects/98`
|
|
# - status field id and oncall option id: using `gh project field-list 98 --owner airbytehq --format json` to explore the project fields and options
|
|
ISSUES_REPOSITORY="${ISSUES_REPOSITORY:-airbytehq/airbyte-internal-issues}"
|
|
PROJECT_NUMBER="${PROJECT_NUMBER:-98}"
|
|
STATUS_FIELD_ID="${STATUS_FIELD_ID:-PVTSSF_lADOA4_XW84Am4WkzgetXZM}"
|
|
ONCALL_OPTION_ID="${ONCALL_OPTION_ID:-3ecf8bb4}"
|
|
|
|
connector_name=$1
|
|
job_url=$2
|
|
commit_sha=$3
|
|
|
|
title="[CDK Connector Compatibility Test] Failures for $connector_name"
|
|
|
|
existing_issue_number=$(gh issue list --state open --search "$title in:title" -R $ISSUES_REPOSITORY --json number --jq '.[0].number')
|
|
|
|
# Build new entry
|
|
timestamp="$(date -u +'%Y-%m-%d %H:%M:%SZ')"
|
|
entry=$'#### ❌ '"$timestamp"$'\n'"Run: $job_url"$'\n'"Commit: ${commit_sha}"
|
|
|
|
if [ -n "${existing_issue_number:-}" ]; then
|
|
# add new entry to existing issue
|
|
existing_issue_body="$(gh issue view "$existing_issue_number" -R "$ISSUES_REPOSITORY" --json body --jq .body)"
|
|
updated_issue_body="$existing_issue_body"$'\n'"${entry}"
|
|
gh issue edit "$existing_issue_number" -R "$ISSUES_REPOSITORY" -b "$updated_issue_body"
|
|
echo "Updated issue #${existing_issue_number} with new failure entry."
|
|
else
|
|
# create new issue
|
|
INITIAL_BODY=$'# Test failure history\n\n'"${entry}"
|
|
issue_url=$(gh issue create -t "$title" -b "$INITIAL_BODY" -R $ISSUES_REPOSITORY)
|
|
echo "Created issue ${issue_url}."
|
|
item_id=$(gh project item-add $PROJECT_NUMBER --owner "airbytehq" --url "$issue_url" --format json --jq '.id')
|
|
project_id=$(gh project view $PROJECT_NUMBER --owner "airbytehq" --format json --jq '.id')
|
|
gh project item-edit \
|
|
--id $item_id \
|
|
--project-id $project_id \
|
|
--field-id $STATUS_FIELD_ID \
|
|
--single-select-option-id "$ONCALL_OPTION_ID"
|
|
echo "Created new issue for $connector_name."
|
|
fi
|