Support YDB settings service in EM #671
This file contains hidden or 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: Update Calculated Priority | |
| on: | |
| issues: | |
| types: [opened, labeled, unlabeled, edited] | |
| jobs: | |
| update-priority: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Update CalculatedPriority field | |
| uses: actions/github-script@v7 | |
| with: | |
| github-token: ${{ secrets.YDBOT_TOKEN }} | |
| script: | | |
| // Priority estimation based on reach/impact/effort methodology | |
| const reachWeights = { | |
| "reach:high": 100, | |
| "reach:medium": 75, | |
| "reach:low": 50 | |
| }; | |
| const impactWeights = { | |
| "impact:high": 200, | |
| "impact:medium": 137.5, | |
| "impact:low": 75 | |
| }; | |
| const effortWeights = { | |
| "effort:high": 10, | |
| "effort:medium": 5, | |
| "effort:low": 2 | |
| }; | |
| const issue = context.payload.issue; | |
| const labels = issue.labels.map(l => l.name); | |
| // Find reach, impact, and effort values from labels | |
| let reach = null; | |
| let impact = null; | |
| let effort = null; | |
| for (const label of labels) { | |
| if (reachWeights[label] !== undefined) { | |
| reach = reachWeights[label]; | |
| } | |
| if (impactWeights[label] !== undefined) { | |
| impact = impactWeights[label]; | |
| } | |
| if (effortWeights[label] !== undefined) { | |
| effort = effortWeights[label]; | |
| } | |
| } | |
| // Calculate priority score using formula: (reach * impact) / effort | |
| let finalScore = 0; | |
| if (reach !== null && impact !== null && effort !== null) { | |
| finalScore = Math.round((reach * impact) / effort); | |
| } else { | |
| // Fallback to default values if labels are missing | |
| const defaultReach = reach || 50; // default to medium-low reach | |
| const defaultImpact = impact || 75; // default to low impact | |
| const defaultEffort = effort || 5; // default to medium effort | |
| finalScore = Math.round((defaultReach * defaultImpact) / defaultEffort); | |
| } | |
| console.log(`📊 Priority calculation: reach=${reach || 'default'}, impact=${impact || 'default'}, effort=${effort || 'default'} → score=${finalScore}`); | |
| const projectNumber = 24; | |
| const org = "ydb-platform"; | |
| const issueNumber = issue.number; | |
| const repoName = context.repo.repo; | |
| const repoOwner = context.repo.owner; | |
| const projectQuery = await github.graphql(` | |
| query($org: String!, $number: Int!) { | |
| organization(login: $org) { | |
| projectV2(number: $number) { | |
| id | |
| fields(first: 50) { | |
| nodes { | |
| ... on ProjectV2Field { | |
| id | |
| name | |
| } | |
| } | |
| } | |
| } | |
| } | |
| } | |
| `, { org, number: projectNumber }); | |
| const projectId = projectQuery.organization.projectV2.id; | |
| const field = projectQuery.organization.projectV2.fields.nodes.find(f => f.name === "CalculatedPriority"); | |
| if (!field) { | |
| core.setFailed("Field 'CalculatedPriority' not found."); | |
| return; | |
| } | |
| const fieldId = field.id; | |
| // Now paginate to find the matching item | |
| let item = null; | |
| let cursor = null; | |
| let hasNextPage = true; | |
| while (hasNextPage && !item) { | |
| const response = await github.graphql(` | |
| query($org: String!, $number: Int!, $after: String) { | |
| organization(login: $org) { | |
| projectV2(number: $number) { | |
| items(first: 100, after: $after) { | |
| pageInfo { | |
| hasNextPage | |
| endCursor | |
| } | |
| nodes { | |
| id | |
| content { | |
| __typename | |
| ... on Issue { | |
| number | |
| repository { | |
| name | |
| owner { login } | |
| } | |
| } | |
| } | |
| } | |
| } | |
| } | |
| } | |
| } | |
| `, { org, number: projectNumber, after: cursor }); | |
| const items = response.organization.projectV2.items.nodes; | |
| item = items.find(n => | |
| n.content?.__typename === "Issue" && | |
| n.content?.number === issueNumber && | |
| n.content?.repository?.name === repoName && | |
| n.content?.repository?.owner?.login === repoOwner | |
| ); | |
| hasNextPage = response.organization.projectV2.items.pageInfo.hasNextPage; | |
| cursor = response.organization.projectV2.items.pageInfo.endCursor; | |
| } | |
| if (!item) { | |
| console.log(`Issue #${issueNumber} not found in project (repo=${repoName}).`); | |
| return; | |
| } | |
| // Update field | |
| await github.graphql(` | |
| mutation($input: UpdateProjectV2ItemFieldValueInput!) { | |
| updateProjectV2ItemFieldValue(input: $input) { | |
| projectV2Item { | |
| id | |
| } | |
| } | |
| } | |
| `, { | |
| input: { | |
| projectId, | |
| itemId: item.id, | |
| fieldId, | |
| value: { number: finalScore } | |
| } | |
| }); | |
| console.log(`✅ Updated CalculatedPriority of issue #${issueNumber} to ${finalScore}`); |