Project

General

Profile

action #69322

coordination #69310: [epic] SUSE QA tools team ticket process helpers

Automatic check for SUSE QA tools WIP-Limit based on tickets

Added by okurz about 1 year ago. Updated 7 months ago.

Status:
Resolved
Priority:
Normal
Assignee:
Target version:
Start date:
2020-07-24
Due date:
% Done:

0%

Estimated time:

Description

Acceptance criteria

Suggestions

History

#1 Updated by okurz 12 months ago

We can query all issues that "SUSE QA tools" team members are working on:

curl -s -H "X-Redmine-API-Key: $redmine_api_key" "https://progress.opensuse.org/issues.json?query_id=400&project_id=18&limit=200" | jq

with $redmine_api_key being my personal redmine API key that can be created in each person's profile, query_id=400 is the id for the query "tools team - what members of the team are working on" and project_id=18 is for "openQA". I added limit=200 as otherwise some tickets were not shown and we will filter down later anyway. It should be possible to include a "status" filter in the query directly but did not manage to do that, e.g. with status_id=2 to only return "In Progress" according to https://www.redmine.org/projects/redmine/wiki/Rest_Issues , maybe not for json api, only xml.

So with saving the query result for reuse:

curl -s -H "X-Redmine-API-Key: $redmine_api_key" "https://progress.opensuse.org/issues.json?query_id=400&project_id=18&limit=200" > working_on.json
cat working_on.json | jq -r '.issues | .[] | select(.status.name=="In Progress") | .id' | wc -l

returning correctly 9 tickets as of now.

#2 Updated by okurz 12 months ago

  • Status changed from Workable to In Progress
  • Assignee set to okurz

I added the user "openqa_review" to the QA project in https://progress.opensuse.org/projects/qa/settings/members so that the bot can access the internal ticket query. I added the redmine api key of said user as REDMINE_API_KEY in https://github.com/os-autoinst/scripts/settings/secrets/new

Created https://github.com/os-autoinst/scripts/pull/31 with a script and a github actions pipeline.

We have yet to see if the syntax in the workflow file is correct and if it triggers as expected. Another way might be https://github.blog/changelog/2020-07-06-github-actions-manual-triggers-with-workflow_dispatch/ to trigger manually but I guess I can wait for now :)

#3 Updated by okurz 12 months ago

  • Status changed from In Progress to Resolved

https://github.com/os-autoinst/scripts/actions?query=workflow%3A%22Check+SUSE+QA+Tools+WIP-Limit%22 shows the checks working fine. Created https://github.com/os-autoinst/scripts/pull/33 to show a bit more output but without functional impact.

Also available in: Atom PDF