问如何在MarkLogic文档上创建XML
EN

Stack Overflow用户

提问于 2017-08-19 16:16:09

回答 1查看 194关注 0票数 1

我想学习如何创建Marklogic TDE。我有Marklogic 9.0-1.1，并在下面的热门歌曲数据库中插入了一个文档。

 xdmp:document-insert("/songs/Akon-featuring-Snoop-Dogg-I-Wanna-Love-
       You.xml", 
<top-song xmlns="http://marklogic.com/MLU/top-songs">
    <title href="http://en.wikipedia.org/wiki/I_Wanna_Love_You" 
             xmlns:ts="http://marklogic.com/MLU/top-songs">I Wanna Love You</title>
    <artist href="http://en.wikipedia.org/wiki/Akon" 
              xmlns:ts="http://marklogic.com/MLU/top-songs">Akon featuring 
                        Snoop Dogg</artist>
   <weeks last="2006-12-09">
       <week>2006-12-02</week>
       <week>2006-12-09</week>
   </weeks>

   <album>Jade to the Max</album>

   <formats>
       <format>CD single</format>
       <format>Cassette single</format>
       <format>7" vinyl</format>
    </formats>

    <genres>
        <genre>R&amp;B</genre>
    </genres>

   <label>Giant Records</label>

   <descr>
       <p>&ldquo;I Wanna Love You&rdquo; is the title of a top-ten R&amp;B 
        single by Jade. It was the groups debut single, it was featured on 
        the Class Act soundtrack.&rdquo;</p> 
    </descr>
</top-song>
)

现在我在热门歌曲数据库中创建了Marklogic模板视图。但是我得到了错误" TDE -INVALIDTEMPLATE：(err:FOER0000) Invalid tde template: TDE-INVALIDTEMPLATENODE: Invalid extraction template node: /tde:template/tde:context2“。我错过了什么？

xquery version "1.0-ml"; 
import module namespace tde = "http://marklogic.com/xdmp/tde"
                              at "/MarkLogic/tde.xqy";

let $top-songs :=
  <template xmlns="http://marklogic.com/xdmp/tde">
    <context>/songs</context>
    <rows>
      <row>
        <schema-name>top-songs</schema-name>
        <view-name>songs</view-name>
        <columns>

          <column> 
            <name>title</name>
            <scalar>string</scalar>
            <val>title</val>
          </column>

          <column> 
            <name>artist</name>
            <scalar>string</scalar>
            <val>artist</val>
          </column>

          <column> 
            <name>weeks</name>
            <scalar>string</scalar>
            <val>weeks</val>
          </column>

          <column> 
            <name>week</name>
            <scalar>string</scalar>
            <val>week</val>
          </column>

          <column> 
            <name>album</name>
            <scalar>string</scalar>
            <val>album</val>
          </column>

          <column> 
            <name>format</name>
            <scalar>string</scalar>
            <val>format</val>
          </column>

          <column> 
            <name>genres</name>
            <scalar>string</scalar>
            <val>genres</val>
          </column>

          <column> 
            <name>label</name>
            <scalar>string</scalar>
            <val>label</val>
          </column>

          <column> 
            <name>descr</name>
            <scalar>string</scalar>
            <val>descr</val>
          </column>

        </columns>

      </row>
    </rows>

  </template> 
return tde:template-insert("/top-songs.xml",$top-songs)

marklogic

回答 1

Stack Overflow用户

发布于 2017-11-10 03:54:59

模板中的context节点应该是ML必须在您插入的文档中查找的节点。您的上下文文档将<top-song>作为根节点，并且没有名称为<songs>的节点。因此，您的上下文节点应该是：<context>/top-song</context>，或者您的上下文文档应该将<songs>作为节点(在该节点下，您具有列和行元素)。
查看您的架构名称是唯一的，并且不包含范围视图。