Description
All CLI list actions are capable of creating or updating a database table provided the appropriate parameters are provided - see the various db related parameters in any CLI reference. This is part of a more general concept and documentation being developed as part of Data Warehouse for DevOps.
Database access parameters
See Database related parameters.
Examples
Jira issues
Create or Replace Table
-a runFromProjectList --continue --common "-a getIssueList --dbTable jira_issues --project \"@projectId@\" --outputFormat 999 --dateFormat \"yyyy-MM-dd HH:mm:ss.SSS\" --dateFormat2 yyyy-MM-dd --file "" --propertyFile src/main/resources/database.properties --dbPassword ******** " --dbCreateTable --replace --comment "JIRA CLI action: getIssueList"
Update Table with Recent Changes
-a getIssueList --dbTable jira_issues --jql "updated > -1d order by key asc" --outputFormat 999 --dateFormat "yyyy-MM-dd HH:mm:ss.SSS" --dateFormat2 yyyy-MM-dd --file "" --propertyFile src/main/resources/database.properties --dbPassword ******** --comment "JIRA CLI action: getIssueList" 94 issues discarded 94 rows updated. Table was 'jira_issues'.
Related issues