Direct queries to Jira have two issues:
- they are sloooooow
- many queries are impossible with JQL
This project attempts to alleviate those problems by first caching all issues as JSON to an SQLite database, then extracting various pieces of information to 'view' tables.
Example
The following example updates the cache with all issues changes then displays all requested issues, subtasks and blocking tasks, then filters out "Done" issues from the blockers:
cache-issues.py
list-issues.py --query 'summary ~ ios AND status in ("Code review", "In Progress", "To Do") AND AND Sprint = 10' | grep -v <0001f7e9>
Cache issues
Cache JIRA issues in a database and generate 'view' tables to allow easier data access (e.g. parent child relationships).
usage: cache-issues.py [-h] --jira-url JIRA_URL --jira-user JIRA_USER --jira-password JIRA_PASSWORD --cache-path CACHE_PATH [--json]
Cache data from JIRA
optional arguments:
-h, --help show this help message and exit
--jira-url JIRA_URL JIRA base URL (default: None)
--jira-user JIRA_USER
username to access JIRA (default: None)
--jira-password JIRA_PASSWORD
password to access JIRA (default: None)
--cache-path CACHE_PATH
path of the cache (default: None)
--json output progress JSON fragments (default: False)
Dump issue
usage: dump-issue.py [-h] --jira-url JIRA_URL --jira-user JIRA_USER --jira-password JIRA_PASSWORD [--fields FIELDS] --query QUERY
Dump a JIRA issue to STDOUT
optional arguments:
-h, --help show this help message and exit
--jira-url JIRA_URL JIRA base URL (default: http://jira.example.com)
--jira-user JIRA_USER
username to access JIRA (default: None)
--jira-password JIRA_PASSWORD
password to access JIRA (default: None)
--fields FIELDS password to access JIRA (default: *all)
--query QUERY JQL to search for (default: None)
List issues
Use the issues cached by cache-issues.py to add subtasks to the query results.
usage: list-issues.py [-h] --jira-url JIRA_URL --jira-user JIRA_USER
--jira-password JIRA_PASSWORD --cache-path CACHE_PATH
[--json] [--fields FIELDS] --query QUERY
List issues using the JIRA cache
optional arguments:
-h, --help show this help message and exit
--jira-url JIRA_URL JIRA base URL (default: None)
--jira-user JIRA_USER
username to access JIRA (default: None)
--jira-password JIRA_PASSWORD
password to access JIRA (default: None)
--cache-path CACHE_PATH
path of the cache (default: None)
--json output progress JSON fragments (default: False)
--fields FIELDS password to access JIRA (default: *all)
--query QUERY JQL to search for (default: None)
3 Jan 06, 2022
6 Jun 27, 2022
1 Dec 10, 2021
7 Apr 11, 2022
38 Jan 02, 2023
222 Jan 04, 2023
6.5k Jan 02, 2023
700 Dec 26, 2022
4 Jan 30, 2022
8 Nov 19, 2022
59 Nov 27, 2022
12 Jul 02, 2022
2 May 14, 2022
5.7k Jan 06, 2023
655 Jan 03, 2023
2 Jan 18, 2022
3 Jun 27, 2022
17 Jul 07, 2022
104 Dec 01, 2022
0 Jan 15, 2022