How to create and update database tables from list actions

Owned by Bob Swift
Last updated: Apr 21, 2023 by Taiwo AkindeleVersion comment
1 min read

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

key summary type created updated resolutiondate resolution status assignee
Refresh

Â