c# - Using linq to merge multiple XML files with the same structure and removing duplicates based on a key -

-

i have multiple xml files i'm trying merge single file. linq xml best option i'm open ideas (xslt seems @ merging 2 files clumsy n > 2 or n = big).

from reading other questions here, sort of join looks good.

file1.xml:

<first>   <second>     <third id="id1">       <values>         <value a="1" b="one"/>         <value a="2" b="two"/>         <value a="3" b="three"/>       </values>     </third>     <third id="id2">       <values>         <value a="f" b="foo"/>         <value a="b" b="bar"/>         <value a="w" b="wibble"/>       </values>     </third>   </second> </first>

file2.xml:

<first>   <second>     <third id="id1">       <values>         <value a="2" b="two"/>         <value a="3" b="three"/>         <value a="6" b="six"/>       </values>     </third>     <third id="id3">       <values>         <value a="x" b="ex"/>         <value a="y" b="why"/>         <value a="z" b="zed"/>       </values>     </third>   </second> </first>

merged.xml:

<first>   <second>     <third id="id1">       <values>         <value a="1" b="one"/>         <value a="2" b="two"/>         <value a="3" b="three"/>         <value a="6" b="six"/>       </values>     </third>     <third id="id2">       <values>         <value a="f" b="foo"/>         <value a="b" b="bar"/>         <value a="w" b="wibble"/>       </values>     </third>     <third id="id3">       <values>         <value a="x" b="ex"/>         <value a="y" b="why"/>         <value a="z" b="zed"/>       </values>     </third>   </second> </first>

i.e. merges values based on third/@id attribute.

how do elegantly linq?

the below still quite ugly, , sure brought more streamlined shape bit of work, seems job:

public static void mergexml() {     var xdoc1 = xdocument.load(@"c:\temp\test.xml");     var xdoc2 = xdocument.load(@"c:\temp\test2.xml");     var d1targets = xdoc1.descendants("third");     var d2selection = xdoc2.descendants("third").tolist();      func<xelement, xelement, string, bool> attributematches = (x, y, a) =>         x.attribute(a).value == y.attribute(a).value;      func<ienumerable<xelement>, xelement, bool> hasmatchingvalue = (ys, x) =>         // remove && if matching "a" should cause replacement.         ys.any(d => attributematches(d, x, "a") && attributematches(d, x, "b"));      foreach (var e in d1targets)     {         var fromd2 = d2selection.find(x => attributematches(x, e, "id"));         if (fromd2 != null)         {             d2selection.remove(fromd2);             var dest = e.descendants("value");             dest.lastordefault()                 .addafterself(fromd2.descendants("value").where(x => !hasmatchingvalue(dest, x)));         }     };     if (d2selection.count > 0)         d1targets.lastordefault().addafterself(d2selection);      xdoc1.save(@"c:\temp\merged.xml"); }

this produces following output file 2 example input files in ops question:

<?xml version="1.0" encoding="utf-8"?> <first>   <second>     <third id="id1">       <values>         <value a="1" b="one" />         <value a="2" b="two" />         <value a="3" b="three" />         <value a="6" b="six" />       </values>     </third>     <third id="id2">       <values>         <value a="f" b="foo" />         <value a="b" b="bar" />         <value a="w" b="wibble" />       </values>     </third>     <third id="id3">       <values>         <value a="x" b="ex" />         <value a="y" b="why" />         <value a="z" b="zed" />       </values>     </third>   </second> </first>

Comments

Post a Comment

Popular posts from this blog

c++ - No viable overloaded operator for references a map -

-
i trying use map can make tag names reference number. when try , use it, in code error (6 in total every time reference map): src/main.cpp:25:45: error: no viable overloaded operator[] type 'std::map<std::string, std::string>' const char* idcs = node.child_value(tagmap[3]); this code: #include "pugi/pugixml.hpp" #include <iostream> #include <string> #include <map> int main() { pugi::xml_document doca, docb; std::map<std::string, pugi::xml_node> mapa, mapb; std::map<std::string, std::string> tagmap {{"1", "data"}, {"2", "entry"}, {"3", "id"}, {"4", "content"}}; if (!doca.load_file("a.xml") || !docb.load_file("b.xml")) { std::cout << "can't find input files"; return 1; } (auto& node: doca.child(tagmap[1]).children(tagmap[2])) { co
Read more

java - Custom OutputStreamAppender not run: LOGBACK: No context given for <MYAPPENDER> -

-
i wish write custom appender on basis of outputstreamappender . wrote following class package tests; import java.io.ioexception; import java.io.outputstream; import ch.qos.logback.core.outputstreamappender; public class myappender<e> extends outputstreamappender<e> { public myappender() { system.out.println("myappender created"); setoutputstream(new outputstream() { @override public void write(int b) throws ioexception { throw new unsupportedoperationexception(); } }); } } then wrote following runner: package tests; import org.slf4j.loggerfactory; import ch.qos.logback.classic.logger; public class runner { private static final logger log = (logger) loggerfactory.getlogger(runner.class); public static void main(string[] args) { //log.addappender(new myappender<iloggingevent>()); log.info("hello world"); } } finall
Read more

java - Cannot secure connection using TLS -

-
i'm trying establish secure socket connection between java client applet (built jdk 1.7.0_75-b13) , vc++ server application. as test vehicle, used vc++ client/server sample found in msdn forums, modified use schannel , able establish socket using cipher suite tls_rsa_with_aes_128_cbc_sha. works of tls 1.0/1.1/1.2. when try opening socket java applet same server application, connection rejected server reporting following: tls 1.0 acceptsecuritycontext failed: 0x80090327 tls 1.1 acceptsecuritycontext failed: 0x80090331 tls 1.2 acceptsecuritycontext failed: 0x80090331 this java code used create socket: debugprint("setting secure connection"); sslsocketfactory sslsocketfactory = (sslsocketfactory) sslsocketfactory.getdefault(); sslsocket sslsocket = (sslsocket) sslsocketfactory.createsocket("127.0.0.1", socketnumber); debugprint("starting handshake"); sslsocket.settcpnodelay(true); sslsocket.setsolinger(false, 0); sslsocket.s
Read more