Refactor JIRA Notebook Data Schema Architecture #373
Description
As-is
Currently the full Jira module contains these tables.
Task List
Overview of the schema.
download_jira_issues.Rmd Overview
Takes either a public or private repo and gathers data based on date, ID and or custom Jira Query Language into a JSON. It then takes the JSON and transforms it into two tables (issues and comments). download_jira_issues.Rmd also contains filters and transformation but they only affect the amount of rows or change the rows format so they will be left out. All unique tables are included (different columns).
kaiaulu/vignettes/download_jira_issues.Rmd
Line 157 in 5bbdbb2
parsed_jira_issues
Contains the metadata (priority, status, assigned developer) of a Jira repo.
| issue_key | issue_summary | issue_type | issue_status | issue_resolution | issue_componets | issue_description | issue_priority | issue_affect_version | issue_fix_version | issue_lables | issue_votes | issue_watchers | issue_created_datetimetz | issue_updated_datetimetz | issue_resolution_datetimetz | isssue_creator_id | issue_creator_name | issue_creator_timezone | issue_assignee_id | issue_assignee_name | issue_assignee_timezone | issue_reporter_id | issue_reporter_name | issue_reporter_timezone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| "KAFKA-14666" | string | "bug" | "done" | "fixed" | "connect" | string | "Major" | "3.2.0" | "3.3.0" | "" | 1 | 3 | 2023-01-31T19:41:42.00+0000 | 2023-01-31T19:41:42.00+0001 | 2023-01-31T19:41:42.00+0002 | username | joe doe | Etc/UTC | username | joe doe | Etc/UTC | username | joe doe | Etc/UTC |
parsed_jira_comments
Contains the "conversation" (who said what and when) and is meant to be linked with #374.
| issue_key | comment_id | comment_update_datetimetz | comment_update_datetimetz | comment_author_id | comment_author_name | comment_author_timezones | comment_author_update_id | comment_author_update_name | comment_author_update_timezones | comment_body |
|---|---|---|---|---|---|---|---|---|---|---|
| "KAFKA-14666" | int | 2023-01-31T19:41:42.00+0000 | 2023-01-31T19:41:42.00+0001 | username | joe doe | "America/New_York" | username | joe doe | "America/New_York" | string |
Task List
Target Files: All .Rmd files
Proposed updates
All functions will be kept since they are all essential to run the notebook and connections to other modules.
All column names will be kept since they are all essential to run the notebook and connections to other modules.
Add table jira_issues_path from bug_count.Rmd The reason is because these are new tables essential for the connection to gitlog module.
1. Schema
2. Function signatures
Issues is used for the gitlog connections #358
- issues
Comments is used for the mail connection #374
- comments
Add table jira_issues_path from bug_count.Rmd
- jira_issues_path (added)
Proposal to add jira_issues_path from bug_count.Rmd which is the notebook that connects Jira issues and #358 and it reduces many rows in download_jira.issues
3. Renamed column
- None