Groovy Script for assertion to check whether the value is 0 or null in groovy script response

Question

Hi&nbsp;&nbsp;I have executed the python script from readyAPi successfully, where as in response i get some value, i have to put an assertion, that value should not be 0 or null&nbsp;the response when i run the python script using groovy in readyAPi is.&nbsp;Wed Jun 17 23:48:09 EDT 2020: WARN: 44&nbsp;Please let me know how this can be achieved.&nbsp;&nbsp;Thanks in Advance.

nmrao · Accepted Answer

You haven't followed what is suggested.

nmrao · Answer

Please show how the python script is run or the script which is being used.

doubtsreadyapi · Answer

nmrao&nbsp;&nbsp;Below is the groovy script i am using to execute the python script from ReadyApi&nbsp;def table_count = ["python" , "C:/Pythonscripts/test.py", host,db_password,db_id]def process = new ProcessBuilder(table_count).redirectErrorStream(true).start()process.inputStream.eachLine {log.warn(it)}process.waitFor()return process.exitValue()&nbsp;In the groovy response i got&nbsp;&nbsp;Thu Jun 18 03:20:19 EDT 2020: WARN: 44&nbsp;So i must put an assertion that 0 or null should not come in the response.&nbsp;&nbsp;&nbsp;Thanks

nmrao · Answer

what is the value of "process.exitValue()"?Using that you can have the assertion.

doubtsreadyapi · Answer

nmrao&nbsp;&nbsp;Thank you&nbsp;Now i have written the script like below, the script is executed fine where as&nbsp;&nbsp;def table_count = ["python" , "C:/Pythonscripts/test.py", host,db_password,db_id]def process = new ProcessBuilder(table_count).redirectErrorStream(true).start()def count = 0process.inputStream.eachLine {count=log.warn(it)assert count !=0 : "The table count is Zero or null"}process.waitFor()return process.exitValue()&nbsp;When i change the script to&nbsp;&nbsp;def table_count = ["python" , "C:/Pythonscripts/test.py", host,db_password,db_id]def process = new ProcessBuilder(table_count).redirectErrorStream(true).start()def count = 0process.inputStream.eachLine {count=log.warn(it)assert count ==0 : "The table count is Zero or null"}process.waitFor()return process.exitValue()&nbsp;i am getting error&nbsp;java.lang.AssertionError: The table count is Zero or null. Expression: (count == 0). Values: count = null error at line: 17&nbsp;In the error message its showing count = null but actual value is 44, So how in the error message the actual count i will get?&nbsp;Thanks

doubtsreadyapi · Answer

Hi&nbsp;nmrao&nbsp;&nbsp;Thanks for the update i have kept assertion on log.warn(it), below is the new code i have written and it worked.&nbsp;def table_count = ["python" , "C:/Pythonscripts/test.py", host,db_password,db_id]def process = new ProcessBuilder(table_count).redirectErrorStream(true).start()process.inputStream.eachLine {log.info(it)assert it !=0 : "The count is Zero"assert it != null : "The count is null"}process.waitFor()return process.exitValue()

Forum Discussion

Groovy Script for assertion to check whether the value is 0 or null in groovy script response

6 Replies

Related Content

Smart Assertion - assert logical/relationship contracts in response

Assertion for raw response

Disable Response SLA assertion on all REST test steps

How to assert on HTTP response code?

Json response format assertion

Recent Discussions

MyFirstPlugin - button Project menu in Ready Api

Integrate ReadyApi with Devops Release pipelines

Is it possible to integrate the Azure TestPlan Test cases and the ReadyAPI tests ?

How to connect to Azure blob storage in Ready API

JDBC Request/Query for value located within data BLOB