Skip to content

Make sure no API key is inside our repos #37

Make sure no API key is inside our repos

Make sure no API key is inside our repos #37

name: Workflow issue status
on:
workflow_call:
issues:
types:
- opened
pull_request:
types:
- opened
- synchronize
- reopened
- closed
- ready_for_review
- converted_to_draft
env:
OWNER: ai-cfia
REPO_PROJECT: github-workflows/repo_project.txt
jobs:
handle_issue_events:
runs-on: ubuntu-latest
permissions: write-all
steps:
# https://docs.github.com/en/issues/planning-and-tracking-with-projects/automating-your-project/automating-projects-using-actions
# GITHUB_TOKEN is scoped to the repository level and cannot access projects.
# To access projects you can either create a GitHub App (recommended for organization projects)
# or a personal access token (recommended for user projects).
# Workflow examples for both approaches are shown below.
- name: Generate token from Github application (GH app for workflows)
id: generate-token
uses: actions/create-github-app-token@v1
with:
app-id: ${{ secrets.GH_WORKFLOW_APP_ID }}
private-key: ${{ secrets.GH_WORKFLOW_APP_PEM }}
- name: Checkout current repository
uses: actions/checkout@v3
- name: Checkout ai-cfia/github-workflows repo (for repo_project.txt file)
uses: actions/checkout@v3
with:
repository: ai-cfia/github-workflows
token: ${{ secrets.GITHUB_TOKEN }}
path: github-workflows
- name: Extract issue number
run: |
ISSUE_NUMBER=""
if [ "$GITHUB_EVENT_NAME" == "issues" ] && [ "$GITHUB_EVENT_ACTION" == "opened" ]; then
ISSUE_NUMBER="$GITHUB_ISSUE_NUMBER"
elif [ "$GITHUB_EVENT_NAME" == "pull_request" ]; then
BRANCH_NAME="$GITHUB_HEAD_REF"
if [[ "$BRANCH_NAME" =~ ^[0-9]{1,} ]]; then
ISSUE_NUMBER=$(echo "$BRANCH_NAME" | grep -oE '^[0-9]+')
else
echo "1. No issue found. The branch must be created from the issue page so that its name is in the correct format (e.g., 123-my-new-feature)."
echo "2. This pull request was generated by a bot (e.g., Renovate or Dependabot), so it is expected that there isn't an associated issue linked to the pull request branch."
exit 0
fi
fi
if [ -n "$ISSUE_NUMBER" ]; then
echo "Issue number '$ISSUE_NUMBER'"
echo "ISSUE_NUMBER=$ISSUE_NUMBER" >> $GITHUB_ENV
fi
env:
GITHUB_EVENT_NAME: ${{ github.event_name }}
GITHUB_EVENT_ACTION: ${{ github.event.action }}
GITHUB_ISSUE_NUMBER: ${{ github.event.issue.number }}
GITHUB_HEAD_REF: ${{ github.event.pull_request.head.ref }}
- name: Fetch issue project(s) information(s)
if: ${{ env.ISSUE_NUMBER != '' }}
run: |
ISSUE_NUMBER="${ISSUE_NUMBER}"
OWNER="${OWNER}"
REPO_NAME="${{ github.repository }}"
FILE="${REPO_PROJECT}"
declare -A PROJECT_NUMBER_ID_MAP ITEM_ID_MAP STATUS_FIELD_ID_MAP STATUS_OPTIONS_MAP
echo "1. Project associated with this issue number #$ISSUE_NUMBER"
PROJECT_ITEMS_JSON=$(gh issue view "$ISSUE_NUMBER" --json projectItems)
if [ "$(echo "$PROJECT_ITEMS_JSON" | jq '.projectItems | length')" -eq 0 ]; then
echo "The projectItems list is empty. Assigning project from '$REPO_PROJECT'"
PROJECT=$(grep "^${REPO_NAME}_" "$FILE" | cut -d'_' -f2)
if [ -n "$PROJECT" ]; then
gh issue edit "$ISSUE_NUMBER" --add-project "$PROJECT"
PROJECT_ITEMS_JSON=$(gh issue view "$ISSUE_NUMBER" --json projectItems)
echo "Assigned project $PROJECT to issue $ISSUE_NUMBER."
else
echo "No matching project found for repository $REPO_NAME."
fi
fi
PROJECT_TITLES=$(echo "$PROJECT_ITEMS_JSON" | jq -r '.projectItems[].title')
echo "$PROJECT_TITLES"
echo "2. Project information"
PROJECT_LIST=$(gh project list --owner "$OWNER")
while read -r TITLE; do
PROJECT_LINE=$(echo "$PROJECT_LIST" | grep -F "$TITLE")
if [ -z "$PROJECT_LINE" ]; then
echo "Project '$TITLE' not found. Skipping..."
continue
fi
PROJECT_NUMBER=$(echo "$PROJECT_LINE" | awk '{print $1}')
PROJECT_ID=$(echo "$PROJECT_LINE" | awk '{print $NF}')
echo "Project '$TITLE' found with # '$PROJECT_NUMBER' and ID '$PROJECT_ID'"
PROJECT_NUMBER_ID_MAP[$PROJECT_NUMBER]=$PROJECT_ID
done <<< "$PROJECT_TITLES"
echo "3. Item id associated to each project for a specific issue and keep the associated ID of the related-project"
CURRENT_REPOSITORY="${{ github.repository }}"
echo "3.5 Current repository: '$CURRENT_REPOSITORY'"
for PROJECT_NUMBER in "${!PROJECT_NUMBER_ID_MAP[@]}"; do
PROJECT_ID=${PROJECT_NUMBER_ID_MAP[$PROJECT_NUMBER]}
echo "Searching #$ISSUE_NUMBER in '$PROJECT_NUMBER'"
ITEMS_JSON=$(gh project item-list "$PROJECT_NUMBER" --limit 2000 --owner "$OWNER" --format json)
ITEM_ENTRY=$(echo "$ITEMS_JSON" | jq -r --argjson ISSUE_NUMBER "$ISSUE_NUMBER" --arg REPO "$CURRENT_REPOSITORY" \
'.items[] | select(.content.number == $ISSUE_NUMBER and (.content.repository == $REPO))')
ITEM_ID=$(echo "$ITEM_ENTRY" | jq -r '.id')
if [ -z "$ITEM_ENTRY" ]; then
echo "Issue #$ISSUE_NUMBER with repository '$CURRENT_REPOSITORY' not found in '$PROJECT_NUMBER'. Skipping..."
continue
fi
echo "Item found #$ISSUE_NUMBER in '$PROJECT_NUMBER' with ID: '$ITEM_ID'"
ITEM_ID_MAP[$PROJECT_ID]=$ITEM_ID
done
echo "4. Find 'Status' field"
for PROJECT_ID in "${!ITEM_ID_MAP[@]}"; do
FIELDS_JSON=$(gh api graphql -f query='
query {
node(id: "'"$PROJECT_ID"'") {
... on ProjectV2 {
fields(first: 20) {
nodes {
... on ProjectV2SingleSelectField {
id
name
options {
id
name
}
}
}
}
}
}
}
')
STATUS_FIELD_ENTRY=$(echo "$FIELDS_JSON" | jq '.data.node.fields.nodes[] | select(.name=="Status")')
STATUS_FIELD_ID=$(echo "$STATUS_FIELD_ENTRY" | jq -r '.id')
if [ -z "$STATUS_FIELD_ID" ] || [ "$STATUS_FIELD_ID" == "null" ]; then
echo "Status not found in '$PROJECT_ID'. Skipping..."
continue
fi
echo "'Status' field found for project ID '$PROJECT_ID': '$STATUS_FIELD_ID'"
OPTIONS_JSON=$(echo "$STATUS_FIELD_ENTRY" | jq -c '.options')
STATUS_FIELD_ID_MAP[$PROJECT_ID]=$STATUS_FIELD_ID
STATUS_OPTIONS_MAP[$PROJECT_ID]=$OPTIONS_JSON
done
echo "5. Update item card for each project"
EVENT_NAME="${{ github.event_name }}"
EVENT_ACTION="${{ github.event.action }}"
for PROJECT_ID in "${!ITEM_ID_MAP[@]}"; do
ITEM_ID=${ITEM_ID_MAP[$PROJECT_ID]}
STATUS_FIELD_ID=${STATUS_FIELD_ID_MAP[$PROJECT_ID]}
OPTIONS=${STATUS_OPTIONS_MAP[$PROJECT_ID]}
if [ -z "$STATUS_FIELD_ID" ]; then
echo "STATUS_FIELD_ID for project $PROJECT_ID not found. Skipping..."
continue
fi
TARGET_STATUS_NAME=""
case "$EVENT_NAME" in
"issues")
case "$EVENT_ACTION" in
"opened")
echo "Targeted field name: Todo"
TARGET_STATUS_NAME="Todo"
;;
esac
;;
"pull_request")
case "$EVENT_ACTION" in
"opened")
if [ "${{ github.event.pull_request.draft }}" == "true" ]; then
echo "Targeted field name: In Progress"
TARGET_STATUS_NAME="In Progress"
else
echo "Targeted field name: In Review"
TARGET_STATUS_NAME="In Review"
fi
;;
"ready_for_review")
echo "Targeted field name: In Review"
TARGET_STATUS_NAME="In Review"
;;
"converted_to_draft")
echo "Targeted field name: In Progress"
TARGET_STATUS_NAME="In Progress"
;;
"reopened")
echo "Targeted field name: In Progress"
TARGET_STATUS_NAME="In Progress"
;;
"closed")
if [ "${{ github.event.pull_request.merged }}" == "true" ]; then
echo "Targeted field name: Done"
TARGET_STATUS_NAME="Done"
else
echo "Targeted field name: Won't do"
TARGET_STATUS_NAME="Won't do"
fi
;;
"synchronize")
STATUS=$(gh pr view ${{ github.event.pull_request.number }} --json isDraft --jq '.isDraft')
if [ "$STATUS" == "false" ]; then
echo "Targeted field name: In Review"
TARGET_STATUS_NAME="In Review"
else
echo "Targeted field name: In Progress"
TARGET_STATUS_NAME="In Progress"
fi
;;
esac
;;
esac
if [ -z "$TARGET_STATUS_NAME" ]; then
echo "No appropriate status for event $EVENT_NAME/$EVENT_ACTION. Use case not managed."
exit 1
fi
TARGET_STATUS_NAME_LOWER=$(echo "$TARGET_STATUS_NAME" | tr '[:upper:]' '[:lower:]')
NEW_OPTION_ID=$(echo "$OPTIONS" | jq -r --arg name "$TARGET_STATUS_NAME_LOWER" '.[] | select(.name | ascii_downcase == $name) | .id')
if [ -z "$NEW_OPTION_ID" ]; then
echo "Could not find status '$TARGET_STATUS_NAME'. Using default ID."
exit 1
else
echo "Found status '$TARGET_STATUS_NAME' with ID: $NEW_OPTION_ID"
fi
echo "Updating..."
gh project item-edit --id "$ITEM_ID" --project-id "$PROJECT_ID" --field-id "$STATUS_FIELD_ID" --single-select-option-id "$NEW_OPTION_ID"
echo "Done!"
done
env:
GITHUB_TOKEN: ${{ steps.generate-token.outputs.token }}
ISSUE_NUMBER: ${{ env.ISSUE_NUMBER }}
OWNER: ${{ env.OWNER }}