如何在XSLT中按三层节点值对XML节点进行分组1

Question

我是XSLT的新手。我一直在这里阅读XSLT文档和其他文章。我被困了一段时间，不知道下一步该做什么。原始XML:

<?xml version="1.0" encoding="UTF-8"?>
<COVERAGE>
    <FILE>
        <RUNDATE>2014-04-16</RUNDATE>
        <RUNTIME>20:11:20</RUNTIME>
        <GROUPID1>GROUP ID1</GROUPID1>
        <GROUPID2>GROUP ID2</GROUPID2>
        <USERID>ABC</USERID>
        <MODULE>
            <NAME>Module1</NAME>
            <UNIT>
                <UNITDATE>2014-03-14</UNITDATE>
                <UNITTIME>15:15:00</UNITTIME>
                <TYPE>1</TYPE>
                <CSECT>
                    <EXTNAME>UNITA</EXTNAME>
                    <OV>N</OV>
                    <EXECUTED>43.1 46.1 47.1 50.1 51.1 52.1 56.1 58.1 63.1 65.1</EXECUTED>
                    <EXECUTED>73.1 74.1 75.1 78.1 79.1</EXECUTED>
                    <UNEXECUTED>60.1 70.1</UNEXECUTED>
                </CSECT>
            </UNIT>
            <UNIT>
                <UNITDATE>2014-03-14</UNITDATE>
                <UNITTIME>15:15:00</UNITTIME>
                <TYPE>1</TYPE>
                <CSECT>
                    <EXTNAME>UNITC</EXTNAME>
                    <OV>N</OV>
                    <EXECUTED>32.1 36.1 37.1 38.1 44.1 50.1 56.1 57.1 58.1</EXECUTED>
                    <UNEXECUTED>40.1</UNEXECUTED>
                </CSECT>
            </UNIT>
            <UNIT>
                <UNITDATE>2014-03-14</UNITDATE>
                <UNITTIME>15:15:00</UNITTIME>
                <TYPE>1</TYPE>
                <CSECT>
                    <EXTNAME>UNITB</EXTNAME>
                    <OV>N</OV>
                    <EXECUTED>32.1 34.1 35.1 38.1 39.1 43.1 44.1 51.1 52.1 53.1</EXECUTED>
                    <EXECUTED>59.1 60.1</EXECUTED>
                    <UNEXECUTED>46.1 55.1</UNEXECUTED>
                </CSECT>
            </UNIT>
        </MODULE>
    </FILE>
    <FILE>
        <RUNDATE>2014-04-16</RUNDATE>
        <RUNTIME>20:12:16</RUNTIME>
        <GROUPID1>GROUP ID3</GROUPID1>
        <GROUPID2>GROUP ID4</GROUPID2>
        <USERID>BDF</USERID>
        <MODULE>
            <NAME>Module1</NAME>
            <UNIT>
                <UNITDATE>2014-03-14</UNITDATE>
                <UNITTIME>15:15:00</UNITTIME>
                <TYPE>1</TYPE>
                <CSECT>
                    <EXTNAME>UNITA</EXTNAME>
                    <OV>Y</OV>GOV>
                    <EXECUTED>43.1 46.1 47.1 50.1 51.1 52.1 56.1 58.1 63.1 65.1</EXECUTED>
                    <EXECUTED>73.1 74.1 75.1 78.1 79.1</EXECUTED>
                    <UNEXECUTED>60.1 70.1</UNEXECUTED>
                </CSECT>
            </UNIT>
            <UNIT>
                <UNITDATE>2014-03-14</UNITDATE>
                <UNITTIME>15:15:00</UNITTIME>
                <TYPE>1</TYPE>
                <CSECT>
                    <EXTNAME>UNITB</EXTNAME>
                    <OV>N</OV>GOV>
                    <EXECUTED>32.1 36.1 37.1 38.1 44.1 50.1 56.1 57.1 58.1</EXECUTED>
                    <UNEXECUTED>40.1</UNEXECUTED>
                </CSECT>
            </UNIT>
            <UNIT>
                <UNITDATE>2014-03-14</UNITDATE>
                <UNITTIME>15:15:00</UNITTIME>
                <TYPE>1</TYPE>
                <CSECT>
                    <EXTNAME>UNITC</EXTNAME>
                    <OV>N</OV>GOV>
                    <EXECUTED>32.1 34.1 35.1 38.1 39.1 43.1 44.1 51.1 52.1 53.1</EXECUTED>
                    <EXECUTED>59.1 60.1</EXECUTED>
                    <UNEXECUTED>46.1 55.1</UNEXECUTED>
                </CSECT>
            </UNIT>
        </MODULE>
    </FILE>
    <FILE>
        <RUNDATE>2014-04-16</RUNDATE>
        <RUNTIME>20:12:16</RUNTIME>
        <GROUPID1>GROUP ID3</GROUPID1>
        <GROUPID2>GROUP ID4</GROUPID2>
        <USERID>BDF</USERID>
        <MODULE>
            <NAME>Module2</NAME>
            <UNIT>
                <UNITDATE>2014-03-14</UNITDATE>
                <UNITTIME>15:15:00</UNITTIME>
                <TYPE>1</TYPE>
                <CSECT>
                    <EXTNAME>UNITA</EXTNAME>
                    <OV>Y</OV>GOV>
                    <EXECUTED>43.1 46.1 47.1 50.1 51.1 52.1 56.1 58.1 63.1 65.1</EXECUTED>
                    <EXECUTED>73.1 74.1 75.1 78.1 79.1</EXECUTED>
                    <UNEXECUTED>60.1 70.1</UNEXECUTED>
                </CSECT>
            </UNIT>
            <UNIT>
                <UNITDATE>2014-03-14</UNITDATE>
                <UNITTIME>15:15:00</UNITTIME>
                <TYPE>1</TYPE>
                <CSECT>
                    <EXTNAME>UNITB</EXTNAME>
                    <OV>N</OV>GOV>
                    <EXECUTED>32.1 36.1 37.1 38.1 44.1 50.1 56.1 57.1 58.1</EXECUTED>
                    <UNEXECUTED>40.1</UNEXECUTED>
                </CSECT>
            </UNIT>
            <UNIT>
                <UNITDATE>2014-03-14</UNITDATE>
                <UNITTIME>15:15:00</UNITTIME>
                <TYPE>1</TYPE>
                <CSECT>
                    <EXTNAME>UNITC</EXTNAME>
                    <OV>N</OV>GOV>
                    <EXECUTED>32.1 34.1 35.1 38.1 39.1 43.1 44.1 51.1 52.1 53.1</EXECUTED>
                    <EXECUTED>59.1 60.1</EXECUTED>
                    <UNEXECUTED>46.1 55.1</UNEXECUTED>
                </CSECT>
            </UNIT>
        </MODULE>
    </FILE>
</COVERAGE>

我想首先，组执行，未执行的节点在一起，如果模块/名称，单位/UNITDATE，单位/UNITTIME, CSECT/EXTNAME是相同的。

转换后的XML应该是这样的:

<?xml version="1.0" encoding="UTF-8"?>
<COVERAGE>
    <FILE>
      <MODULE>
        <NAME>Module1</NAME>
            <UNIT>
                <CSECT>
                    <EXTNAME>UNITA</EXTNAME>
                    <EXECUTED>43.1 46.1 47.1 50.1 51.1 52.1 56.1 58.1 63.1 65.1</EXECUTED>
                    <EXECUTED>73.1 74.1 75.1 78.1 79.1</EXECUTED>
                    <EXECUTED>43.1 46.1 47.1 50.1 51.1 52.1 56.1 58.1 63.1 65.1</EXECUTED>
                    <EXECUTED>73.1 74.1 75.1 78.1 79.1</EXECUTED>
                    <EXECUTED>43.1 46.1 47.1 50.1 51.1 52.1 56.1 58.1 63.1 65.1</EXECUTED>
                    <EXECUTED>73.1 74.1 75.1 78.1 79.1</EXECUTED>
                    <UNEXECUTED>60.1 70.1</UNEXECUTED>
                    <UNEXECUTED>60.1 70.1</UNEXECUTED>
                    <UNEXECUTED>60.1 70.1</UNEXECUTED>
                </CSECT>
            </UNIT>
            <UNIT>
                <CSECT>
                    <EXTNAME>UNITC</EXTNAME>
                    <EXECUTED>32.1 36.1 37.1 38.1 44.1 50.1 56.1 57.1 58.1</EXECUTED>
                    <EXECUTED>32.1 34.1 35.1 38.1 39.1 43.1 44.1 51.1 52.1 53.1</EXECUTED>
                    <EXECUTED>59.1 60.1</EXECUTED><EXECUTED>32.1 34.1 35.1 38.1 39.1 43.1 44.1 51.1 52.1 53.1</EXECUTED>
                    <EXECUTED>59.1 60.1</EXECUTED>
                    <UNEXECUTED>40.1</UNEXECUTED>
                    <UNEXECUTED>46.1 55.1</UNEXECUTED>
                    <UNEXECUTED>46.1 55.1</UNEXECUTED>
                </CSECT>
            </UNIT>
            <UNIT>
                <CSECT>
                    <EXTNAME>UNITB</EXTNAME>
                    <EXECUTED>32.1 34.1 35.1 38.1 39.1 43.1 44.1 51.1 52.1 53.1</EXECUTED>
                    <EXECUTED>59.1 60.1</EXECUTED>
                    <EXECUTED>32.1 36.1 37.1 38.1 44.1 50.1 56.1 57.1 58.1</EXECUTED>
                    <EXECUTED>32.1 36.1 37.1 38.1 44.1 50.1 56.1 57.1 58.1</EXECUTED>
                    <UNEXECUTED>46.1 55.1</UNEXECUTED>
                    <UNEXECUTED>40.1</UNEXECUTED>
                    <UNEXECUTED>40.1</UNEXECUTED>
                </CSECT>
            </UNIT>
        </MODULE>
    </FILE>
    <FILE>
        <MODULE>
            <NAME>Module2</NAME>
                <UNIT>
                    <CSECT>
                        <EXTNAME>UNITA</EXTNAME>
                        <EXECUTED>43.1 46.1 47.1 50.1 51.1 52.1 56.1 58.1 63.1 65.1</EXECUTED>
                        <EXECUTED>73.1 74.1 75.1 78.1 79.1</EXECUTED>
                        <UNEXECUTED>60.1 70.1</UNEXECUTED>
                    </CSECT>
                </UNIT>
                <UNIT>
                    <CSECT>
                        <EXTNAME>UNITB</EXTNAME>
                        <EXECUTED>32.1 36.1 37.1 38.1 44.1 50.1 56.1 57.1 58.1</EXECUTED>
                        <UNEXECUTED>40.1</UNEXECUTED>
                    </CSECT>
                </UNIT>
                <UNIT>
                    <CSECT>
                        <EXTNAME>UNITC</EXTNAME>
                        <EXECUTED>32.1 34.1 35.1 38.1 39.1 43.1 44.1 51.1 52.1 53.1</EXECUTED>
                        <EXECUTED>59.1 60.1</EXECUTED>
                        <UNEXECUTED>46.1 55.1</UNEXECUTED>
                    </CSECT>
                </UNIT>
            </MODULE>
        </FILE>
    </COVERAGE>

这是我阅读后得到的XSL:

<?xml version="1.0" encoding="UTF-8"?> 
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" indent="yes" />
     <xsl:key name="moduleKey" match="MODULE" use="NAME" />
    <xsl:key name="unitKey" match="UNIT" use="concat(CSECT/EXTNAME, '_', UNITDATE,'_',UNITTIME)" />
    <xsl:template match="COVERAGE">
        <COVERAGE>
            <xsl:for-each select="FILE">
            <FILE>
                <RUNDATE>
                    *
                </RUNDATE>
                <RUNTIME>
                    *
                </RUNTIME>
                <GROUPID1>
                    *
                </GROUPID1>
                <GROUPID2>
                    *
                </GROUPID2>
                <USERID>
                    *
                </USERID> 
                <xsl:for-each select="MODULE[count( . | key('moduleKey', NAME)[1]) = 1]">
                <MODULE>
                    <NAME>
                        <xsl:value-of select="NAME" />
                    </NAME>
                    <xsl:for-each select="UNIT[count( . | key('unitKey', concat(CSECT/EXTNAME, '_', UNITDATE,'_',UNITTIME))[1]) = 1]">
                        <UNIT>
                                <TYPE>
                                    <xsl:value-of select="TYPE" />
                                </TYPE>
                                <UNITDATE>
                                    <xsl:value-of select="COMPILEDATE" />
                                </UNITDATE>
                                <UNITTIME>
                                    <xsl:value-of select="COMPILETIME" />
                                </UNITTIME>
                                <CSECT>
                                <EXTNAME>
                                    <xsl:value-of select="CSECT/EXTNAME" />
                                </EXTNAME>
                                <OV>
                                    *
                                </OV>
                            <xsl:copy-of select="key('unitKey', concat(CSECT/EXTNAME, '_', UNITDATE,'_',UNITTIME))/CSECT/EXECUTED" />
                            <xsl:copy-of select="key('unitKey', concat(CSECT/EXTNAME, '_', UNITDATE,'_',UNITTIME))/CSECT/UNEXECUTED" />
                            </CSECT>
                        </UNIT>
                    </xsl:for-each>
                </MODULE>   
                </xsl:for-each>
                </FILE>
            </xsl:for-each>

        </COVERAGE>
    </xsl:template>
</xsl:stylesheet>

但是这个XSL不能产生我们想要的结果。非常感谢。

Answer 1

首先，将已执行的、未执行的节点分组在一起如果"MODULE/NAME"、"UNIT/UNITDATE"、"UNIT/UNITTIME"、"CSECT/EXTNAME"是相同。

我在你的输出中没有看到这一点——也许是因为它对SO问题来说太复杂了。在任何情况下，如果这是您想要的，您应该使用(单个)键来连接组的四个特征。

例如，以下样式表:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:key name="sect" match="CSECT" use="concat(../../NAME, '_', ../UNITDATE, '_', ../UNITTIME, '_', EXTNAME)"/>
<xsl:template match="/">
    <COVERAGE>
        <!-- FOR EACH DISTINCT GROUP -->
        <xsl:for-each select="COVERAGE/FILE/MODULE/UNIT/CSECT[count(. | key('sect', concat(../../NAME, '_', ../UNITDATE, '_', ../UNITTIME, '_', EXTNAME))[1]) = 1]">
            <MODULE>
                <NAME><xsl:value-of select="../../NAME"/></NAME>
                <UNIT>
                    <UNITDATE><xsl:value-of select="../UNITDATE"/></UNITDATE>
                    <UNITTIME><xsl:value-of select="../UNITTIME"/></UNITTIME>
                    <CSECT>
                        <EXTNAME><xsl:value-of select="EXTNAME"/></EXTNAME>
                        <!-- GET RECORDS IN CURRENT GROUP -->
                        <xsl:for-each select="key('sect', concat(../../NAME, '_', ../UNITDATE, '_', ../UNITTIME, '_', EXTNAME))">
                            <xsl:copy-of select="EXECUTED | UNEXECUTED"/>
                        </xsl:for-each>
                    </CSECT>
                </UNIT>
            </MODULE>
        </xsl:for-each>
    </COVERAGE>
</xsl:template>
</xsl:stylesheet>

当应用到你的输入时，将产生以下输出:

<?xml version="1.0" encoding="UTF-8"?>
<COVERAGE>
   <MODULE>
      <NAME>Module1</NAME>
      <UNIT>
         <UNITDATE>2014-03-14</UNITDATE>
         <UNITTIME>15:15:00</UNITTIME>
         <CSECT>
            <EXTNAME>UNITA</EXTNAME>
            <EXECUTED>43.1 46.1 47.1 50.1 51.1 52.1 56.1 58.1 63.1 65.1</EXECUTED>
            <EXECUTED>73.1 74.1 75.1 78.1 79.1</EXECUTED>
            <UNEXECUTED>60.1 70.1</UNEXECUTED>
            <EXECUTED>43.1 46.1 47.1 50.1 51.1 52.1 56.1 58.1 63.1 65.1</EXECUTED>
            <EXECUTED>73.1 74.1 75.1 78.1 79.1</EXECUTED>
            <UNEXECUTED>60.1 70.1</UNEXECUTED>
         </CSECT>
      </UNIT>
   </MODULE>
   <MODULE>
      <NAME>Module1</NAME>
      <UNIT>
         <UNITDATE>2014-03-14</UNITDATE>
         <UNITTIME>15:15:00</UNITTIME>
         <CSECT>
            <EXTNAME>UNITC</EXTNAME>
            <EXECUTED>32.1 36.1 37.1 38.1 44.1 50.1 56.1 57.1 58.1</EXECUTED>
            <UNEXECUTED>40.1</UNEXECUTED>
            <EXECUTED>32.1 34.1 35.1 38.1 39.1 43.1 44.1 51.1 52.1 53.1</EXECUTED>
            <EXECUTED>59.1 60.1</EXECUTED>
            <UNEXECUTED>46.1 55.1</UNEXECUTED>
         </CSECT>
      </UNIT>
   </MODULE>
   <MODULE>
      <NAME>Module1</NAME>
      <UNIT>
         <UNITDATE>2014-03-14</UNITDATE>
         <UNITTIME>15:15:00</UNITTIME>
         <CSECT>
            <EXTNAME>UNITB</EXTNAME>
            <EXECUTED>32.1 34.1 35.1 38.1 39.1 43.1 44.1 51.1 52.1 53.1</EXECUTED>
            <EXECUTED>59.1 60.1</EXECUTED>
            <UNEXECUTED>46.1 55.1</UNEXECUTED>
            <EXECUTED>32.1 36.1 37.1 38.1 44.1 50.1 56.1 57.1 58.1</EXECUTED>
            <UNEXECUTED>40.1</UNEXECUTED>
         </CSECT>
      </UNIT>
   </MODULE>
   <MODULE>
      <NAME>Module2</NAME>
      <UNIT>
         <UNITDATE>2014-03-14</UNITDATE>
         <UNITTIME>15:15:00</UNITTIME>
         <CSECT>
            <EXTNAME>UNITA</EXTNAME>
            <EXECUTED>43.1 46.1 47.1 50.1 51.1 52.1 56.1 58.1 63.1 65.1</EXECUTED>
            <EXECUTED>73.1 74.1 75.1 78.1 79.1</EXECUTED>
            <UNEXECUTED>60.1 70.1</UNEXECUTED>
         </CSECT>
      </UNIT>
   </MODULE>
   <MODULE>
      <NAME>Module2</NAME>
      <UNIT>
         <UNITDATE>2014-03-14</UNITDATE>
         <UNITTIME>15:15:00</UNITTIME>
         <CSECT>
            <EXTNAME>UNITB</EXTNAME>
            <EXECUTED>32.1 36.1 37.1 38.1 44.1 50.1 56.1 57.1 58.1</EXECUTED>
            <UNEXECUTED>40.1</UNEXECUTED>
         </CSECT>
      </UNIT>
   </MODULE>
   <MODULE>
      <NAME>Module2</NAME>
      <UNIT>
         <UNITDATE>2014-03-14</UNITDATE>
         <UNITTIME>15:15:00</UNITTIME>
         <CSECT>
            <EXTNAME>UNITC</EXTNAME>
            <EXECUTED>32.1 34.1 35.1 38.1 39.1 43.1 44.1 51.1 52.1 53.1</EXECUTED>
            <EXECUTED>59.1 60.1</EXECUTED>
            <UNEXECUTED>46.1 55.1</UNEXECUTED>
         </CSECT>
      </UNIT>
   </MODULE>
</COVERAGE>

---

编辑:

每个FILE节点有一个MODULE节点，一个MODULE节点有多个UNIT每个UNIT节点有一个CSNEXT节点，每个CSNEXT节点有多个已执行或未执行节点。

好吧，但是你没有告诉我们如何对它们进行分组。而且很难通过查看输出文件来判断——除非有人想花几个小时比较输入和输出。即使这样，答案也不完全清楚，因为您的输出肯定是错误的: this node:

<UNEXECUTED>60.1 70.1</UNEXECUTED>

在输出中出现四次，但在输入中只出现三次 !!

我猜你想要像下面这样的东西，它将按模块(即按文件/模块)分组，然后按CSECT(即按UNIT/CSECT)分组:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:key name="module" match="MODULE" use="NAME"/>
<xsl:key name="sect" match="CSECT" use="concat(../../NAME, '_', ../UNITDATE, '_', ../UNITTIME, '_', EXTNAME)"/>
<xsl:template match="/">
    <COVERAGE>
        <!-- FOR EACH DISTINCT MODULE -->
        <xsl:for-each select="COVERAGE/FILE/MODULE[count(. | key('module', NAME)[1]) = 1]">
            <FILE>
                <MODULE>
                    <NAME><xsl:value-of select="NAME"/></NAME>
                        <!-- FOR EACH DISTINCT CSECT -->
                        <xsl:for-each select="UNIT/CSECT[count(. | key('sect', concat(../../NAME, '_', ../UNITDATE, '_', ../UNITTIME, '_', EXTNAME))[1]) = 1]">
                            <UNIT>
                                <CSECT>
                                    <EXTNAME><xsl:value-of select="EXTNAME"/></EXTNAME>
                                    <!-- GET RECORDS IN CURRENT GROUP -->
                                    <xsl:for-each select="key('sect', concat(../../NAME, '_', ../UNITDATE, '_', ../UNITTIME, '_', EXTNAME))">
                                        <xsl:copy-of select="EXECUTED | UNEXECUTED"/>
                                    </xsl:for-each>
                                </CSECT>
                            </UNIT>
                        </xsl:for-each>
                    </MODULE>
                </FILE>
            </xsl:for-each>
    </COVERAGE>
</xsl:template>
</xsl:stylesheet>