PaulMS
Super Contributor
User Profile
User Widgets
Contributions
Re: adding assertions in soap ui to validate xml response tags with database values
Did you click the Declare button under the XPath expression header to add namespace declaration? A wildcard could be used to skip the declaration if that causes a problem //*:counter_party_risk_list[1]/*:counter_party_risk[1] https://www.soapui.org/docs/functional-testing/validating-messages/validating-xml-messages.html3.9KViews0likes1CommentRe: adding assertions in soap ui to validate xml response tags with database values
You can start with a JDBC request to query database values and XPath assertions to compare the result to XML response. https://community.smartbear.com/t5/SoapUI-Pro/Compare-Results-of-Soap-Response-with-JDBC-Response/td-p/352793.8KViews0likes3CommentsRe: Groovy Script To Read Pattern in a logfile, extract data and do date calculation
def logfile = '''2018-02-26 10:41:21,076 [KilimWorker-4] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [VARCHAR] - REFER 2018-02-26 10:41:21,077 [KilimWorker-4] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [7] as [VARCHAR] - PRE_REFER 2018-02-26 10:41:21,077 [KilimWorker-4] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [8] as [TIMESTAMP] - 2018-02-08 23:00:52 2018-02-26 10:41:21,078 [KilimWorker-4] DEBUG com.vedaadvantage.dp3.manager.actor.Message - Audit event Individual_Duplicate_Check_Referred - End 2018-02-26 10:41:21,078 [KilimWorker-4] DEBUG com.vedaadvantage.dp3.manager.actor.DispatcherActor - execute ''' logfile.eachLine { currentLine, lineNumber -> if (currentLine.contains( 'Individual_Duplicate_Check_Referred' )) { previousLine = logfile.readLines()[lineNumber - 1] } } def timeStamp = previousLine.split(' - ').last(); def Date ts = new Date().parse("yyyy-MM-dd HH:mm:ss", timeStamp) log.info new Date() - ts1.6KViews0likes1Comment