Forum Discussion

jkrier's avatar
jkrier
Regular Contributor
9 years ago

Parsing XML file with Groovy script

I am trying to read in a naked xml file and parse it but for some reason XMLSlurper doesn't seem to be able to see child nodes. To make things easy I have created a groovy script with the xml inside ...
  • nmrao's avatar
    nmrao
    9 years ago

    jkrier

    Sorry about it, that was actually done quickly (could not test) for the change that you requested ( to loop thru all environments, and connection names)

    That was happening because, you provided all connection names, but some of them are not present in all environments.

    Handled now, please take the updated script from github.

jkrier's avatar
jkrier
Regular Contributor

Rao,

 

The script at https://github.com/nmrao/groovyScripts/blob/master/xml/ConnectionString.groovy is throwing an error. I made no changes to it and ran it as is.

 

The output is

 

Environment : test, Connection name : wba
Details followed: 
Host : host01
Port : 1500
User : wbauser
Password: wbapassword
Sid  : test
Exception thrown

groovy.lang.MissingPropertyException: No such property: connectionDetails for class: ConsoleScript0

	at ConsoleScript0.run(ConsoleScript0:89)

 I ran this from the Groovy console from ReadyAPI, I also changed all of the println lines to log.info and ran from groovy script in SoapUI NG and got the same error

 

I made a change from

 

def connStr = getConnectionString(connectionDetails) 

 

to

 

def connStr = getConnectionString(connetionDetails)

 

Now when I run the script I see all of the connections being logged to the output but it still throws an error at the very end

 

Exception thrown

java.lang.NullPointerException: Cannot invoke method parent() on null object

	at ConsoleScript2.getConnectionDetails(ConsoleScript2:96)

	at ConsoleScript2$getConnectionDetails.callCurrent(Unknown Source)

	at ConsoleScript2.run(ConsoleScript2:87)

 

This is all very promising though, I added a few lines to pull out some data

 

def showConnectionDetails(def connexionDetails, String environmentName, String connectionName){
  log.info "Environment : ${environmentName}, Connection name : ${connectionName}"
  hostName = "${connectionName}"+"host" //new line
  testRunner.testCase.testSteps['InputValues'].setPropertyValue(hostName, "${connexionDetails.host}") //new line

And in my Properties step "InputValues" all of the hosts are being logged as I need. If it could just run without the error at the end I think it would be exactly what I want.

 

I apologize if I am being confusing to you. I am trying not to be and I very much appreciate your help and your time.

 

 

nmrao's avatar
nmrao
Champion Level 3
9 years ago

jkrier

Sorry about it, that was actually done quickly (could not test) for the change that you requested ( to loop thru all environments, and connection names)

That was happening because, you provided all connection names, but some of them are not present in all environments.

Handled now, please take the updated script from github.

  • jkrier's avatar
    jkrier
    Regular Contributor
    9 years ago

    Rao,

     

    Thank you so much, this is what I needed. I cannot thank you enough for your help!

  • nmrao's avatar
    nmrao
    Champion Level 3
    9 years ago

    jkrier,

     

    Glad to know.
    Not sure if you needed that creating final connection string (using combination of all the values, of course you can directly set that value in test case / test suite property to use property expansion in jdbc step), but that was done keeping in mind that it might be helpful, like a bonus?

  • jkrier's avatar
    jkrier
    Regular Contributor
    9 years ago

    Hi Rao,

     

    I had some free time so I looked into using the connection string versus setting the individual connection values and I think it is the smarter way to go about it. Pretty good bonus, thanks for providing it.