Re: How to compare numeric values between two xml files?
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