How navigate back in XML tree to get to an adjacent child element using parent method

Question

Given the following XML:

<list version="1.0">
    <meta>...</meta>
    <resources start="0" count="167">
        <resource classname="Quote">
            <field name="name">USD/KRW</field>
            <field name="price">1024.400024</field>
            <field name="symbol">KRW=X</field>
        </resource>
        ...
     </resources>
</list>

In order to find the right <resource> and get it's price I do the following:

def slurper = new XmlSlurper()
def result = slurper.parse(XML_URL)
def node = result.depthFirst().find { it.text() == "KRW=X" }
println node.parent().find { it['@name'] == "price" }.text()

However the result is that parent() does not implement find(Closure) which doesn't quite match with the docs: http://groovy.codehaus.org/gapi/groovy/util/slurpersupport/GPathResult.html

More strange node.parent().size() returns 1 when I expect it to return 3 as per the above XML

My questions:

Is my code correct and why is not working?
Is this the shortest way of achieving the expected result?
Why node.parent().size() is returning 1 ? The same goes for node.parent().parent().size(), node.parent().parent().parent().size() and so on...

tim_yates · Answer 1 · 2014-07-23T21:42:09.237

1

Can you try

def resource = result.'**'.find { 
    it.field.@name == 'symbol' &&
    it.field.text() == 'KRW=X'
}

println resource?.'**'.find {
    it.@name == 'price'
}?.text()

edited Jul 23 '14 at 21:42

answered Jul 23 '14 at 20:09

tim_yates

167,322
27
342
338

it says `Cannot invoke method text() on null object`. `resource` is returning `null` – Saba Ahang Jul 23 '14 at 21:17
It totally looks correct. Don't understanding what is wrong with it – Saba Ahang Jul 23 '14 at 21:27
I guess you would need `def resource = result.'**'.find { it.@name == 'symbol' && it.text() == 'KRW=X' }.parent() ` – dmahapatro Jul 23 '14 at 22:08

score 0 · Answer 2 · answered Jul 23 '14 at 20:10

Something quick and dirty, but this should work:

new XmlSlurper().parseText("""
<list version="1.0">
    <meta>...</meta>
    <resources start="0" count="167">
        <resource classname="Quote">
            <field name="name">USD/KRW</field>
            <field name="price">1024.400024</field>
            <field name="symbol">KRW=X</field>
        </resource>

        <resource classname="Quote">
            <field name="name">USD/KRW</field>
            <field name="price">2222</field>
            <field name="symbol">KRW=Y</field>
        </resource>

     </resources>
</list>
""").resources.resource.find{ 
    it.field.find {it.@name == "symbol" && it.text() == "KRW=X"}
}.field.find {it.@name == "price"}.text()

this is basically another equivalent of my own solution. The error is `No such property: field for class: groovy.util.slurpersupport.Node` which surprises me because it should be `slurpersupport.NodeChild` — Saba Ahang, Jul 23 '14 at 21:25

score 0 · Answer 3 · answered Jul 23 '14 at 22:00

0

You can use:

def desiredPrice = new XmlSlurper().parse( XML_URL ).'**'.findResult { 
    it.name() == 'field' && it.@name == 'symbol' && it.text() == 'KRW=X' ? 
        it.parent().field.find { it.@name == 'price' }.text() : null
}

answered Jul 23 '14 at 22:00

dmahapatro

49,365
7
88
117

How navigate back in XML tree to get to an adjacent child element using parent method

3 Answers3