Alex99
Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: JSON Path evaluation
You are right, try this one: $..phoneNumbers[?(@.type == "iPhone")].type $..phoneNumbers[?(@.type == "iPhone")].number *edit: changed expression But, just to point out, you asked for the type first, not the number. -->> But I'm expecting value ["iPhone","iPhone","iPhone"], which is the one I'm getting from online json path evaluators.Re: Query to compare the latest number by transaction time
Hi, I shortened the xml and added a third transaction, so that we can test the negative case also: import javax.xml.xpath.* import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import org.w3c.dom.Document; import org.w3c.dom.Element; import org.w3c.dom.Node; import org.w3c.dom.NodeList; import org.xml.sax.InputSource; def xml = """ <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <soapenv:Header/> <soapenv:Body> <ac:getConsumerProfileTransactionHistoryResponse xmlns:ac="http://www.moneygram.com/AgentConnect1705"> <ac:payload> <ac:doCheckIn>true</ac:doCheckIn> <ac:timeStamp>2018-07-18T16:37:24.679-05:00</ac:timeStamp> <ac:flags>18</ac:flags> <ac:mgiSessionID>443077301E15319498444757393417</ac:mgiSessionID> <ac:GAFVersionNumber>1.1.20180612</ac:GAFVersionNumber> <ac:numberOfRowsFound>1</ac:numberOfRowsFound> <ac:transactions> <ac:transaction> <ac:currentValues> <ac:currentValue> <ac:infoKey>transactionStatusUpdateDate</ac:infoKey> <ac:value>2018-07-18T14:19:30-05:00</ac:value> </ac:currentValue> </ac:currentValues> </ac:transaction> <ac:transaction> <ac:currentValues> <ac:currentValue> <ac:infoKey>transactionStatusUpdateDate</ac:infoKey> <ac:value>2018-07-18T14:19:02-05:00</ac:value> </ac:currentValue> </ac:currentValues> </ac:transaction> <ac:transaction> <ac:currentValues> <ac:currentValue> <ac:infoKey>transactionStatusUpdateDate</ac:infoKey> <ac:value>2018-07-18T22:19:02-05:00</ac:value> </ac:currentValue> </ac:currentValues> </ac:transaction> </ac:transactions> <ac:infos/> </ac:payload> </ac:getConsumerProfileTransactionHistoryResponse> </soapenv:Body> </soapenv:Envelope>""" def date1 = null def date2 = null def rootNode = new XmlSlurper().parseText(xml) rootNode.'**'.findAll { node-> node.text() == 'transactionStatusUpdateDate' }.each { node-> if(date1 == null) { date1 = new Date().parse("yyyy-MM-dd'T'HH:mm:ss", node.parent().value.toString().substring(0,19)) } else { date2 = new Date().parse("yyyy-MM-dd'T'HH:mm:ss", node.parent().value.toString().substring(0,19)) log.info("${date1.format('yyyy-MM-dd HH:mm:ss')} newer than ${date2.format('yyyy-MM-dd HH:mm:ss')} = ${checkDates(date1, date2)}") date1 = date2 } } log.info "done" def checkDates(date1, date2) { try { assert date1 > date2 return true } catch (AssertionError e) { return false } } The result looks like this: Thu Nov 01 14:12:09 CET 2018:INFO:2018-07-18 14:19:30 newer than 2018-07-18 14:19:02 = true Thu Nov 01 14:12:09 CET 2018:INFO:2018-07-18 14:19:02 newer than 2018-07-18 22:19:02 = false Thu Nov 01 14:12:09 CET 2018:INFO:doneRe: How to get a steps index number using groovy?
If you are still looking into it, here is one possible solution. The little script will collect all test step names, according to their place//occurence inside a test case, then you can get their index by calling the .findIndexOf method. See example below. This should work for you, since you are calling all steps from one script step (Step 5). Let that step collect all names beforehand and everytime it runs one of the steps, check their index in the collection. Also, since no duplicate names are allowed within one test case, it should work perfectly. See also both screenshots. log.info context.currentStepIndex //will give you 3 def l = [] context.testCase.getTestStepList().each { l.add(it.getName()) } log.info l.findIndexOf {it == 'script 2'} //will return 3 log.info "done"Re: Groovy script - How to run a teststep from another testsuite in your testsuite teardown script?
Dunno if you are still looking for a solution, but maybe this workaround will help you. I created a test suite, with 1 test case from which I can basically run as many test suites as I desire. Here is the code. See also the attached screenshot. Code: testRunner.testCase.testSuite.project.getTestSuiteList().each { testsuite -> if(['ts'].contains(testsuite.getName())) { //filter testsuite we want to run testsuite.getTestCaseList().each { testcase -> if(testcase.getName().toLowerCase().startsWith('renderer')) { //filter testcases we want to run testcase.getTestStepList().each { teststep -> if(teststep.getName().equalsIgnoreCase('request')) { //finally filter all teststep we want to run log.info "running ${testcase.getName()} -> ${teststep.getName()}" def r = teststep.run(testRunner, context) log.info r.getStatus() } } } } } }Re: Count the number of tags
Given that your response looks something like this: ... <phoneNumber> <countryDialInNumber>1</countryDialInNumber> <mobileFlag>true</mobileFlag> <phoneNumber>5128797895</phoneNumber> <startDate>2018-10-19T21:10:52-05:00</startDate> <stronglyAuthenticated>false</stronglyAuthenticated> ... ... and that you want the value for the phone number, in the above example 5128797895, than you can use a variation of jhunter's solution, here you go: def xml = '''<xml> <phoneNumber> <countryDialInNumber>1</countryDialInNumber> <mobileFlag>true</mobileFlag> <phoneNumber>5128797895</phoneNumber> <startDate>2018-10-19T21:10:52-05:00</startDate> <stronglyAuthenticated>false</stronglyAuthenticated> <type>PRM</type> <notificationPreference> <method>SMS</method> <optIn>false</optIn> <preferredLanguage>en-US</preferredLanguage> <startDate>2018-10-19T21:10:52-05:00</startDate> <stronglyAuthenticated>false</stronglyAuthenticated> <type>TXNN</type> </notificationPreference> <notificationPreference> <method>SMS</method> <optIn>true</optIn> <preferredLanguage>en-US</preferredLanguage> <startDate>2018-10-19T21:10:52-05:00</startDate> <stronglyAuthenticated>false</stronglyAuthenticated> <type>MKTN</type> </notificationPreference> </phoneNumber> <phoneNumber> <countryDialInNumber>1</countryDialInNumber> <mobileFlag>true</mobileFlag> <phoneNumber>6124045907</phoneNumber> <startDate>2018-10-19T21:10:52-05:00</startDate> <stronglyAuthenticated>false</stronglyAuthenticated> <type>SEC</type> <notificationPreference> <method>SMS</method> <optIn>false</optIn> <preferredLanguage>en-US</preferredLanguage> <startDate>2018-10-19T21:10:52-05:00</startDate> <stronglyAuthenticated>false</stronglyAuthenticated> <type>MKTN</type> </notificationPreference> <notificationPreference> <method>SMS</method> <optIn>false</optIn> <preferredLanguage>en-US</preferredLanguage> <startDate>2018-10-19T21:10:52-05:00</startDate> <stronglyAuthenticated>false</stronglyAuthenticated> <type>TXNN</type> </notificationPreference> </phoneNumber> </xml> ''' new XmlSlurper().parseText(xml).'**'.findAll { it.name() == 'phoneNumber' && !it.childNodes() }.each { log.info it //this will output the phone numbers only! } The result will look like this: Mon Oct 29 18:55:19 CET 2018:INFO:5128797895 Mon Oct 29 18:55:19 CET 2018:INFO:6124045907 To write the results into a file, edit the below code to your desired destination and format: def file = new File("<your filepath and filename here, e.g. c:/output.txt>") new XmlSlurper().parseText(xml).'**'.findAll { it.name() == 'phoneNumber' && !it.childNodes() }.each { log.info it //this will output the phone numbers only! file << it // see also here: http://mrhaki.blogspot.com/2009/08/groovy-goodness-working-with-files.html }
