If you were using XmlParser you could use XmlNodePrinter
and if you were using XmlSlurper you could do as Tim suggests directly
but because you are using the DOM classes you would need something like:
mkp.yield new XmlSlurper().parseText(XmlUtil.serialize(root))
Which will do the round-tripping similar to what your Java version
does but with only one line of code.
Cheers, Paul.
On 31/03/2012 9:36 AM,
[hidden email] wrote:
> Okay, here is the code with your suggestion in place of what I had previously.
>
> import groovy.sql.Sql
> import groovy.xml.DOMBuilder
> import groovy.xml.dom.DOMCategory
>
> def sql = Sql.newInstance(...)
>
> sql.eachRow("""
> select xml_data from MyTable where xml_data like '%<PaymentArrangement>%'
> """.toString()) { row ->
> def dom = DOMBuilder.parse(row.xml_data.getCharacterStream())
> def root = dom.documentElement
> use(DOMCategory) {
> root.PaymentArrangement.each { pa ->
> println "${row.agent_id}-${row.account_id} before:"
> println pa
> pa.each { paElement ->
> if (['FirstPaymentSameAccount', 'RequestedFirstDraftDate', 'AmountPaidWithApp'].contains(paElement.nodeName)) {
> pa.removeChild(paElement)
> }
> }
> pa.OneTimeDraft.each { otd ->
> otd.each { otdElement ->
> if (['Amount'].contains(otdElement.nodeName)) {
> def otdAmount = otd.removeChild(otdElement)
> pa.appendNode('OneTimeDraftAmount', otdAmount.getFirstChild().data)
> }
> }
> }
> pa.RecurringDraft.each { rd ->
> rd.each { rdElement ->
> if (['Amount'].contains(rdElement.nodeName)) {
> rd.removeChild(rdElement)
> }
> }
> }
> println "${row.agent_id}-${row.account_id} ${row.id} after:"
> println pa
> }
>
> String xmlString = new groovy.xml.StreamingMarkupBuilder().bind {
> mkp.yield dom
> }
> assert xmlString.indexOf('FirstPaymentSameAccount') == -1
>
> println xmlString
> }
> }
>
> When I run it I get a pretty version of my XML with < and > in place of the "<" and ">". Of course my desire is to write the XML back to the database which I can do using the not-very-Groovy code I cited.
>
> -Andy
>
> > Not knowing what you're doing to modify the dom, here's an example
> > that does some modification:
> >
> > def prettyxml = '''<a>
> > | <b>c</b>
> > |</a>'''.stripMargin()
> >
> > dom = new XmlSlurper().parseText( prettyxml )
> > dom.appendNode {
> > groovy( 'cool' )
> > }
> > String uglyxml = new groovy.xml.StreamingMarkupBuilder().bind {
> > mkp.yield dom
> > }
> >
> > assert uglyxml == '<a><b>c</b><groovy>cool</groovy></a>'
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
Locked
