Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are two immediate solutions:</p> <p><strong>Solution 1</strong>.</p> <p>You can first apply a simple transform to the two documents that will delete the elements that should not be compared. Then, compare the results ing two documents -- exactly with your current code. Here is the transformation:</p> <pre><code>&lt;xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt; &lt;xsl:output omit-xml-declaration="yes" indent="yes"/&gt; &lt;xsl:strip-space elements="*"/&gt; &lt;xsl:template match="node()|@*"&gt; &lt;xsl:copy&gt; &lt;xsl:apply-templates select="node()|@*"/&gt; &lt;/xsl:copy&gt; &lt;/xsl:template&gt; &lt;xsl:template match="Name|Team|Pos"/&gt; &lt;/xsl:stylesheet&gt; </code></pre> <p><strong>When this transformation is applied to the provided XML document</strong>:</p> <pre><code>&lt;Stats Date="2011-01-01"&gt; &lt;Player Rank="1"&gt; &lt;Name&gt;Sidney Crosby&lt;/Name&gt; &lt;Team&gt;PIT&lt;/Team&gt; &lt;Pos&gt;C&lt;/Pos&gt; &lt;GP&gt;39&lt;/GP&gt; &lt;G&gt;32&lt;/G&gt; &lt;A&gt;33&lt;/A&gt; &lt;PlusMinus&gt;20&lt;/PlusMinus&gt; &lt;PIM&gt;29&lt;/PIM&gt; &lt;PP&gt;10&lt;/PP&gt; &lt;SH&gt;1&lt;/SH&gt; &lt;GW&gt;3&lt;/GW&gt; &lt;Shots&gt;0&lt;/Shots&gt; &lt;ShotPctg&gt;154&lt;/ShotPctg&gt; &lt;TOIPerGame&gt;20.8&lt;/TOIPerGame&gt; &lt;ShiftsPerGame&gt;21:54&lt;/ShiftsPerGame&gt; &lt;FOWinPctg&gt;22.6&lt;/FOWinPctg&gt; &lt;/Player&gt; &lt;/Stats&gt; </code></pre> <p><strong>the wanted resulting document is produced</strong>:</p> <pre><code>&lt;Stats Date="2011-01-01"&gt; &lt;Player Rank="1"&gt; &lt;GP&gt;39&lt;/GP&gt; &lt;G&gt;32&lt;/G&gt; &lt;A&gt;33&lt;/A&gt; &lt;PlusMinus&gt;20&lt;/PlusMinus&gt; &lt;PIM&gt;29&lt;/PIM&gt; &lt;PP&gt;10&lt;/PP&gt; &lt;SH&gt;1&lt;/SH&gt; &lt;GW&gt;3&lt;/GW&gt; &lt;Shots&gt;0&lt;/Shots&gt; &lt;ShotPctg&gt;154&lt;/ShotPctg&gt; &lt;TOIPerGame&gt;20.8&lt;/TOIPerGame&gt; &lt;ShiftsPerGame&gt;21:54&lt;/ShiftsPerGame&gt; &lt;FOWinPctg&gt;22.6&lt;/FOWinPctg&gt; &lt;/Player&gt; &lt;/Stats&gt; </code></pre> <p><strong>Solution 2.</strong></p> <p><strong>This is a complete XSLT 1.0 solution</strong> (for convenience only, the second XML document is embedded in the transformation code):</p> <pre><code>&lt;xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt; &lt;xsl:output omit-xml-declaration="yes" indent="yes"/&gt; &lt;xsl:strip-space elements="*"/&gt; &lt;xsl:variable name="vrtfDoc2"&gt; &lt;Stats Date="2011-01-01"&gt; &lt;Player Rank="2"&gt; &lt;Name&gt;John Smith&lt;/Name&gt; &lt;Team&gt;NY&lt;/Team&gt; &lt;Pos&gt;D&lt;/Pos&gt; &lt;GP&gt;38&lt;/GP&gt; &lt;G&gt;32&lt;/G&gt; &lt;A&gt;33&lt;/A&gt; &lt;PlusMinus&gt;15&lt;/PlusMinus&gt; &lt;PIM&gt;29&lt;/PIM&gt; &lt;PP&gt;10&lt;/PP&gt; &lt;SH&gt;1&lt;/SH&gt; &lt;GW&gt;4&lt;/GW&gt; &lt;Shots&gt;0&lt;/Shots&gt; &lt;ShotPctg&gt;158&lt;/ShotPctg&gt; &lt;TOIPerGame&gt;20.8&lt;/TOIPerGame&gt; &lt;ShiftsPerGame&gt;21:54&lt;/ShiftsPerGame&gt; &lt;FOWinPctg&gt;22.6&lt;/FOWinPctg&gt; &lt;/Player&gt; &lt;/Stats&gt; &lt;/xsl:variable&gt; &lt;xsl:variable name="vDoc2" select= "document('')/*/xsl:variable[@name='vrtfDoc2']/*"/&gt; &lt;xsl:template match="node()|@*" name="identity"&gt; &lt;xsl:param name="pDoc2"/&gt; &lt;xsl:copy&gt; &lt;xsl:apply-templates select="node()|@*"&gt; &lt;xsl:with-param name="pDoc2" select="$pDoc2"/&gt; &lt;/xsl:apply-templates&gt; &lt;/xsl:copy&gt; &lt;/xsl:template&gt; &lt;xsl:template match="/"&gt; &lt;xsl:apply-templates select="*"&gt; &lt;xsl:with-param name="pDoc2" select="$vDoc2"/&gt; &lt;/xsl:apply-templates&gt; ----------------------- &lt;xsl:apply-templates select="$vDoc2"&gt; &lt;xsl:with-param name="pDoc2" select="/*"/&gt; &lt;/xsl:apply-templates&gt; &lt;/xsl:template&gt; &lt;xsl:template match="Player/*"&gt; &lt;xsl:param name="pDoc2"/&gt; &lt;xsl:if test= "not(. = $pDoc2/*/*[name()=name(current())])"&gt; &lt;xsl:call-template name="identity"/&gt; &lt;/xsl:if&gt; &lt;/xsl:template&gt; &lt;xsl:template match="Name|Team|Pos" priority="20"/&gt; &lt;/xsl:stylesheet&gt; </code></pre> <p><strong>when this transformation is applied on the same first document as above, the correct diffgrams are produced</strong>:</p> <pre><code>&lt;Stats Date="2011-01-01"&gt; &lt;Player Rank="1"&gt; &lt;GP&gt;39&lt;/GP&gt; &lt;PlusMinus&gt;20&lt;/PlusMinus&gt; &lt;GW&gt;3&lt;/GW&gt; &lt;ShotPctg&gt;154&lt;/ShotPctg&gt; &lt;/Player&gt; &lt;/Stats&gt; ----------------------- &lt;Stats xmlns:xsl="http://www.w3.org/1999/XSL/Transform" Date="2011-01-01"&gt; &lt;Player Rank="2"&gt; &lt;GP&gt;38&lt;/GP&gt; &lt;PlusMinus&gt;15&lt;/PlusMinus&gt; &lt;GW&gt;4&lt;/GW&gt; &lt;ShotPctg&gt;158&lt;/ShotPctg&gt; &lt;/Player&gt; &lt;/Stats&gt; </code></pre> <p><strong>How this works</strong>:</p> <ol> <li><p><strong>The transformation is applied on the first document</strong>, passing the second document as parameter.</p></li> <li><p><strong>This produces an XML document whose only leaf element nodes are the ones that have different value</strong> than the corresponding leaf element nodes in the second document.</p></li> <li><p><strong>The same processing is performed as in 1. above, but this time on the second document</strong>, passing the first document as parameter.</p></li> <li><p><strong>This produces a second diffgram</strong>: an XML document whose only leaf element nodes are the ones that have different value** than the corresponding leaf element nodes in the first document</p></li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POComparing two XML files & generating a third with XMLDiff in C#
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USDimitre Novatchev
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1. Really like second solution.
      singulars
      1. PO
      1. USFlack
    2. COGreat solution... How would I go by passing the second document as a parameter without embedding it in the xsl transformation code?
      singulars
      1. PO
      1. USJF Beaulieu
    3. COP.S.: I have modified my initial post with a more in detail look at what the product Xml file needs to be in function of the two first ones. I Have never experimented with Xsl, but I have succeeded in applying a first transform to the two XML documents. I can still keep track of which player I am manipulating because of the "Rank" attribute in the "Player" node. Now, I can't figure out how to implement solution 2. using XSL and C#...
      singulars
      1. PO
      1. USJF Beaulieu
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload