如何使用Node(Date)的值使用Groovy对XML进行排序 [英] How to sort XML with Groovy using value of Node (Date)

问题描述

我无法使用Groovy对XML进行排序.我知道如何使用属性来执行此操作，但是我想使用节点的值进行排序.

I am having trouble sorting my XML with Groovy. I understand how to do it using the attribute but I want to sort using the value of a node.

例如，我想按StartDate排序此XML:

For instance I want to sort this XML by the StartDate :

<GetActivitiesByDatesResponse>
    <GetActivitiesByDatesResult>
        <Event>
            <EventCode>1244</EventCode>
            <Name>Event1</Name>
            <StartDate>2015-08-13T10:00:00</StartDate>
        </Event>
        <Event>
            <EventCode>1245</EventCode>
            <Name>Event2</Name>
            <StartDate>2015-07-15T10:00:00</StartDate>
        </Event>
        <Event>
            <EventCode>1246</EventCode>
            <Name>Event3</Name>
            <StartDate>2015-07-30T10:00:00</StartDate>
        </Event>
    </GetActivitiesByDatesResult>
</GetActivitiesByDatesResponse>

这是我的代码:

root = new XmlSlurper(false,false).parseText(payload)

if(root.name() == 'GetActivitiesResponse' || root.name() == 'GetActivitiesByDatesResponse')
{
    startEach = root.children().children()
}
else
{
    startEach = root.children()    
}
startEach.sort(true) {it.StartDate}


def xml = new StringWriter().with { w -> new groovy.xml.MarkupBuilder(w).with {
        mkp.xmlDeclaration(version: "1.0", encoding: "utf-8")
                 escapeAttributes = false  
                 getPrinter().setAutoIndent(false);  
                 "newroot"() {
                    startEach.each { p -> "w_evenement"() {
                        ///allmylogic
                    }
                }
    }
    w.toString().replaceAll(">\\s+<", "><").trim();
}

我的有效载荷是我发布的较高的XML，这是因为它来自MuleESB，但假设它是字符串.

My payload is the XML i posted higher this is because it comes from MuleESB but just assume it is a string.

感谢您的帮助.

推荐答案

您可以为给定的示例XML执行此操作:

You could do this for the given example XML:

def xml = '''<GetActivitiesByDatesResponse>
    <GetActivitiesByDatesResult>
        <Event>
            <EventCode>1244</EventCode>
            <Name>Event1</Name>
            <StartDate>2015-08-13T10:00:00</StartDate>
        </Event>
        <Event>
            <EventCode>1245</EventCode>
            <Name>Event2</Name>
            <StartDate>2015-07-15T10:00:00</StartDate>
        </Event>
        <Event>
            <EventCode>1246</EventCode>
            <Name>Event3</Name>
            <StartDate>2015-07-30T10:00:00</StartDate>
        </Event>
    </GetActivitiesByDatesResult>
</GetActivitiesByDatesResponse>'''

import groovy.xml.*

def x = new XmlParser().parseText(xml)

println XmlUtil.serialize(new StreamingMarkupBuilder().bind {
    GetActivitiesByDatesResponse {
        GetActivitiesByDatesResult {
            x.GetActivitiesByDatesResult[0]
             .children()
             .sort { Date.parse("yyyy-MM-dd'T'HH:mm:ss", it.StartDate.text()) }
             .each { e ->
                Event {
                    EventCode(e.EventCode.text())
                    Name(e.Name.text())
                    StartDate(e.StartDate.text())
                }
            }
        }
    }
})

这篇关于如何使用Node(Date)的值使用Groovy对XML进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！