CODEWITHSUNDEEP
xmlgrails
Nimmy
Nimmy

Reputation: 5381

XML parsing in Grails

I am newbie to grails. I want to save some data using REST.

I will get the xml from the request.XML. It has child nodes and the child nodes also have the child node..

For ex:

<?xml version="1.0" encoding="UTF-8"?>

<contract id="1">

    <startDate>2011-09-11</startDate>

    <orderType />

    <charges>

        <charge id="3">

            <Code>MO-AV-SP-2008</Code>

            <position>1</position>

            <isPaid>false</isPaid>

            <isPenalty>false</isPenalty>

            <billerGroupCode />

            <pricings>

                <pricing id="7">

                    <unitsTo />

                    <percent />

                    <isOverage>false</isOverage>

                    <contractCharge id="2" />

                    <lastUpdated>2011-09-11</lastUpdated>

                    <currency id="USD" />

                    <price>100.00</price>

                    <dateCreated>2011-09-11</dateCreated>

                    <unitsFrom />

                </pricing >

            </pricings>

            <isProrated>false</isProrated>

            <unitOfMeasure />

            <priceCode>SNGL-SETUP</priceCode>

            <invoiceText>Setup fee</invoiceText>

            <pricingType>FixedPricing</pricingType>

            <lastUpdated>2011-09-11</lastUpdated>

            <standardQuantity />

            <isTax>false</isTax>

            <maxQuantity />

            <taxCodes />

            <isMandatory>false</isMandatory>

            <dateCreated>2011-09-11</dateCreated>

            <isSeparateInvoice>false</isSeparateInvoice>

            <chargeType>OneTimeCharge</chargeType>

            <notes>Setup Fee</notes>

            <minQuantity />

        </charge>

    </charges>

    <dueDateValue>1</dueDateValue>

    <invoiceText>Monthly</invoiceText>

    <lastUpdated>2011-10-10</lastUpdated>

    <endDate>2012-09-10</endDate>

    <interestRate />

    <fixedChargesReducePayoff />

    <billingPeriod>Monthly</billingPeriod>

    <name>Anti Virus</name>

    <isAutoRenew>false</isAutoRenew>

    <dateCreated>2011-09-11</dateCreated>

    <notes>Pay monthly for Anti Virus</notes>

    <numberOfInstallments />

    <product id="3" />

    <contractCode>B-Mo-AV-SP</contractCode>

    <dueDateUnits>Months</dueDateUnits>

    <billingAlignment>StartDate</billingAlignment>

</contract>

From the above xml I want to save all datas to database as a new data, not with the same id. I want to bind the the data to particular table.

Thanks in advance..

Nimmy

Upvotes: 0

Views: 7373

Answers (3)

D&#243;nal
D&#243;nal

Reputation: 187409

Use XMLparser or XMLSlurper. Here are examples showing how to use each. These classes will only help you to bind the XML data to objects, you'll have to deal with the persistence yourself.

If the data is bound to Grails domain objects, then persistence is probably not much more complicated than calling save() on each one.

Upvotes: 2

dbrin
dbrin

Reputation: 15673

You can use dot notation to traverse your object (if you don't care about attribute based selectors). So like this grandParentNode.parentNode.childNode makes sense?

Here is a great example: http://groovy.codehaus.org/Reading+XML+using+Groovy's+XmlSlurper

Upvotes: 1

erimerturk
erimerturk

Reputation: 4288

you can use this as a reference. You can parse your xml like this.

    def a = "YOUR XML DATA"
    def contract = new XmlSlurper().parseText(a)

    println contract.@'id'
    println contract.startDate

   contract.pricings.each(){
      println it.@'id'
      println it.isOverage
   }

Upvotes: 0

Related Questions