provide me a way to post the SQL that DB DevOps runs to a jira ticket
complete
H
Horizon blue Marmot
I need a way to retrieve the SQL that DB DevOps runs and post it to a jira ticket. If I could access the logs from the 'preview' part of the apply step from an expression that would meet my needs.
Log In
S
Stephen Atwell
complete
S
Stephen Atwell
pending feedback
S
Stephen Atwell
This can be done today. To achieve this:
1) add the step named 'Liquibase Command' to your pipeline
2) for 'Command' specify 'update-sql'
3) under 'Command Arguments' specify:
a) Key = output-file
b) value = output.log
place this step before the 'apply' step in your pipeline.
This step will generate the same preview of the sql, but instead of outputing it to console, it will put it in a file named 'output.log' on the container. From there you can use a run step to access it, and either move it into a pipeline variable, or send it to your external system.
S
Stephen Atwell
under review