How to store xml file in database using groovy script

Step1:



Here I'm using mysql dababase
Creating one database schema like "xmldb", in this xmldb schema create a one  table like 'persons'

For this table having field names like: id,firstname,lastname,email,address

Step 2: Write one xml file like 'MyxmlP.xml

MyxmlP.xml
<?xml version="1.0" encoding="UTF-8"?>
<persons>
    <person age="3">
        <id>36 </id>
        <firstname>Rama</firstname>
        <lastname>Krishna </lastname>
        <email>rama@krishna.com</email>
        <address>CA</address>
    </person>
    <person age="4">
        <id> 63</id>
        <firstname>krishna</firstname>
        <lastname>rama</lastname>
        <email>krishna@rama</email>
        <address>AC</address>
    </person>
</persons>


Step 3:
Write one scripting file for the database connection and storing xml file into database:

Step 4:
The filename like:
Xml2DB.groovy


/*
 *Stores xml data into mysql database 
 *
 */
class Xml2DB{
    static void main(args){


        def sql = Sql.newInstance("jdbc:mysql://localhost:3306/xmldb", "root",
                "root", "com.mysql.jdbc.Driver")
      
          def Employee  = new XmlParser().parse('MyxmlP.xml')
        //set the database table name here.
        def set1 = sql.dataSet("persons")

        Employee.person.each {
            def empId = it.id.text()
            def firstName = it.firstname.text()
            def lastName = it.lastname.text()
            def email  = it.email.text()
            def empAddress = it.address.text()
           
                  

            set1.add(id:empId,firstname:firstName,lastname:lastName,email:email,address:empAddress)
        }
    }
}

Developing Scripts to convert Csv file into xml using Groovy

Developing Scripts to convert  Csv file into xml using Groovy

Step1: Create a sample groovy file 

File name : Csv2xml.groovy

/*

* Here the Code 

*/

//Csv2xml.groovy

package com.groovy.sample

import groovy.xml.StreamingMarkupBuilder

import groovy.xml.XmlUtil

//csvfile to xml 

class Csv2xml  {

static void main(args){

def csvdata = []

new File("csv2xml.csv").eachLine { line ->

csvdata << line.split(',')

}

def headers = csvdata[0]

def dataRows = csvdata[1..-1]

def xml = new groovy.xml.MarkupBuilder()

// write 'root' element

xml.root {

dataRows.eachWithIndex { dataRow, index ->

// write 'entry' element with 'id' attribute

entry(id:index+1) {

headers.eachWithIndex { heading, i ->

// write each heading with associated content

"${heading}"(dataRow[i])

}

}

}

}

}

}

Step2:

After above .groovy code then we need to create  one csv file. The file name it seems like what we have mentioned in groovy code like "csv2xml.csv"

create csv file :

Job,Type,Cntr Number,Date,Booking Ref,Commodity,Weight,Special Instructions

JOB0001,Circle,12,31/09/2013,Book0001,1,100,Carry

software engine ,new ,36,31/09/2013,Book0002,5,68,nan

After creating csv file then execute the  Csv2xml.groovy class file 

output: 

<root>

  <entry id='1'>

    <Job>JOB0001</Job>

    <Type>Circle</Type>

    <Cntr Number>12</Cntr Number>

    <Date>31/09/2013</Date>

    <Booking Ref>Book0001</Booking Ref>

    <Commodity>1</Commodity>

    <Weight>100</Weight>

    <Special Instructions>Carry</Special Instructions>

  </entry>

  <entry id='2'>

    <Job>software engine </Job>

    <Type>new </Type>

    <Cntr Number>36</Cntr Number>

    <Date>31/09/2013</Date>

    <Booking Ref>Book0002</Booking Ref>

    <Commodity>5</Commodity>

    <Weight>68</Weight>

    <Special Instructions>nan</Special Instructions>

  </entry>

</root>