Abbreviations, used in manual:
QG - Quality Gates
DB - Data Base
This manual will guide you on how to create a Script of type "SQL Execute".
Script of type "SQL Execute" allows the end User to implement changes on DB level from quilliup's UI.
Follow the next steps:
1. In the QG module, in the left side menu, under specific Project, go to the “Scripts” component:
Click “Add Script” button:
2. Fill in all required fields - See details in manual Quality Gates, Scripts:
- Name - Script`s name.
- Description - Describe the Script purpose.
Severity - The impact level of a script failure
Tags - Variable can be related to appropriate Tag(s).
- Script Type - In our case we'll choose "SQL Execute":
-
Data Source Name - select a Data Source from the list.
- Return type (*Optional) - chose "Success" or "Failure".
- Success Message - This value will be returned in case of successful Script termination.
- Error Message - This value will be returned in case of the Script's failure.
Script Code - insert required SQL query. The Script needs to be related to the true or false conditions in order to enable or disable return type.
Note: do not use the ";" sign at the end of the SQL query!
Example:
Script Code: update qg_demo.country SET Units = 10 Where Price = 115
To add an additional step to the Script, click the "Add Script" button located in the bottom left corner of the page:
Comments
0 comments
Please sign in to leave a comment.