Groovy To Extract Comma Separated List Into Separate Properties
Hi, So this is on the end of one of my previous posts - nmrao spoonfed me until I got there (so all cred to him) - this is the next step. I have a string of comma separated values stored as a custom testSuite level property. I want to extract the individual values from the single property into multiple separate properties for later use. I've managed to do it - but it's shockingly bad groovy - so I'm wondering if anyone can guide me into a way of doing it more efficiently The testSuite level 'MY_SUBLIST' property has the value of: 3K684,3K686,3K688,3U3750 As stated above, I want to separate out each comma separated value into it's own testSuite level property. As stated above - I've managed it - but it's poor groovy. Please see as follows: //get the comma separated list in my testSuite level property entitled MY_SUBLIST and save it to the mySubListToString variable def mySubListToString = context.testCase.testSuite.getPropertyValue('MY_SUBLIST') log.info mySubListToString // log response was --> Thu May 23 00:20:30 BST 2024: INFO: 3K684,3K686,3K688,3U3750 //use split() to extract the first route_code value and save this value to the splitString1 property def splitString1 = mySubListToString.split(',')[0].toString() log.info(splitString1) //log response was --> Thu May 23 00:20:30 BST 2024: INFO: 3K684 //save splitString1 value to a new testSuite level property entitled splitString1 testRunner.testCase.testSuite.setPropertyValue( "splitString1", splitString1) //use split() to extract the second route_code value and save this value to the splitString2 property def splitString2 = mySubListToString.split(',')[1].toString() log.info(splitString2) //log response was --> Thu May 23 00:20:30 BST 2024: INFO: 3K686 //save splitString2 value to a new testSuite level property entitled splitString2 testRunner.testCase.testSuite.setPropertyValue( "splitString2", splitString2) //use split() to extract the third route_code value and save this value to the splitString3 property def splitString3 = mySubListToString.split(',')[2].toString() log.info(splitString3) //log response was --> Thu May 23 00:20:30 BST 2024: INFO: 3K688 //save splitString3 value to a new testSuite level property entitled splitString3 testRunner.testCase.testSuite.setPropertyValue( "splitString3", splitString3) //use split() to extract the fourth route_code value and save this value to the splitString4 property def splitString4 = mySubListToString.split(',')[3].toString() log.info(splitString4) //log response was --> Thu May 23 00:20:30 BST 2024: INFO: 3U3750 //save splitString4 value to a new testSuite level property entitled splitString4 testRunner.testCase.testSuite.setPropertyValue( "splitString4", splitString4) As you can see - I'm not going to win any awards with the code above. Can anyone advise on a more efficient/effective way of doing it? It's rubbish to have to explicitly define a variable and a new property for each comma separated value - so I'd welcome if anyone has a more efficient way I can do this. As you can see - what I've done gets the job done - but it's a shonky way of doing it! Cheers! rich
JDBC Request/Query for value located within data BLOB
I am attempting to execute the following query within a ReadyAPI JDBC request SELECT * FROM consumer WHERE consumer.payload LIKE '%name%' The issue is that ReadyAPI treats the '%' as part of the literal string which from what I understand is a sort of wildcard and used to match the given name exactly so instead of just using name it uses %name% and then returns null Within Oracle SQL Developer the query executes just fine and returns the expected corresponding row(s) but when attempting to execute it within ReadyAPI JDBC request i get null. How exactly do I go about writing the query in ReadyAPI to treat the '%' as a sort of wildcard and not actually part of the string/value?
Assertion error log
Hi All, I need suggestion please on how to approach the following: I created a script to compare 2 very large tables before and after deployment. in the beginning I was looping thru each row and column to compare values and I was able to see the exact field that has a mismatch in the assertion log but the issue is the script was taking way too long. So I decided to to compare the whole resultSet received from both tables but and now I am facing a different issue, when there is a mismatch the assertion error log doesn't show where the exact discrepancy is but rather it shows the error mismatch between the full resultSet. is there a way to capture few lines in the error log around the mismatched string in the resultSet from the assertion instead of the whole thing ERROR: Assertion failed: assert beforeTable == afterTable | | | | | '<ResultSet ..... </ResultSet>' | false '<ResultSet ..... </ResultSet>'Multi Thread Groovy test step
Hello, I would really appreciate help with this. I create a test that compares data between 2 tables with large data return. the script does the job perfectly but it takes very long time to execute as it loops thru hundreds of thousands of records and verify value to value from each column. I was wondering if there is a way to run the test step groovy script in multi thread instead of doing one value at a time. thanks in advance!using groovy script in readyapi
I have maven project for my readyapi, have java and groovy script in it, and placed jar into C:\Program Files\SmartBear\ReadyAPI-3.51.0\lib my groovy script directory is in src/main/groovy directory. So I am able to use java classes but when I try to use groovy script in readyapi step it doesn't work, not able to find groovy class. I can add my groovy script to C:\Program Files\SmartBear\ReadyAPI-3.51.0\bin\scripts and that works as expected, but how can I use groovy script in my maven project from jar file I added it to C:\Program Files\SmartBear\ReadyAPI-3.51.0\lib ? Here is the groovy script I use in my readyapi to call groovy script in maven project: import src.main.groovy.Utilities def utilities = new Utilities(context, context.testCase.testSuite, log) utilities.loadConfigurations() Thanks in advance,
