Main Page » Mailing List » September 2020

Best way to re-create existing root element with all attributes

Sunday, 13 September 2020 · 4 messages · last reply 15 Sep 2020
CG
Christian Grünin reply to Yitzhak Khabinsky, 13 Sep 2020, 23:4613 Sep 2020 22:13 #

Hi Yitzhak,

Try this:

  declare context item := document { ... };
  * update {
    delete node employee
  }

See [1] for more information on updating expressions.

Best, Christian

[1] https://docs.basex.org/wiki/XQuery_Update

Quoted text · Yitzhak Khabinsky · 124 lines
On 9/13/20, Yitzhak Khabinsky <ykhabins at bellsouth.net> wrote: > Hello, > > > > This is input XML: > > <employee emp="1" dept="55"> > <name>Peter</name> > <job>Director</job> > <employee emp="12" dept="26"> > <name>John</name> > <job>Animator</job> > <employee emp="123" dept="27"> > <name>James</name> > <job>Assistant</job> > </employee> > </employee> > </employee> > > > > Desired output XML: > > <employee emp="1" dept="55"> > <name>Peter</name> > <job>Director</job> > </employee> > > > > Overall, it is a so called 'modified identity transformation' in XSLT > parlance. > > Output XML shall be the same, except the child <employee> element and its > children. > > > > Question: > > What is the best way to re-create existing root element with all its > attributes? > > > > My implementation: > > xquery version "3.1"; > > > > declare context item := document { > > <employee emp="1" dept="55"> > > <name>Peter</name> > > <job>Director</job> > > <employee emp="12" dept="26"> > > <name>John</name> > > <job>Animator</job> > > <employee emp="123" dept="27"> > > <name>James</name> > > <job>Assistant</job> > > </employee> > > </employee> > > </employee> > > }; > > > > (: working version :) > > element {fn:node-name(/*)} > > { > > let $y := ./*/@* > > return $y, (: copy all attributes :) > > for $x in ./*/(* except employee) > > return $x > > } > > > > (: NOT working version, trying to make it more concise :) > > element {fn:node-name(/*)} {/*/@*} > > { > > return for $x in ./*/(* except employee) > > return $x > > } > > > > > > Regards, > Yitzhak Khabinsky > > > > > >
MH
Martin Honnenin reply to Yitzhak Khabinsky, 13 Sep 2020, 23:4613 Sep 2020 22:14 #
Quoted text · Yitzhak Khabinsky · 87 lines
On 13.09.2020 21:46, Yitzhak Khabinsky wrote: > Hello, > > This is input XML: > > <employee emp="1"dept="55"> > <name>Peter</name> > <job>Director</job> > <employee emp="12"dept="26"> > <name>John</name> > <job>Animator</job> > <employee emp="123"dept="27"> > <name>James</name> > <job>Assistant</job> > </employee> > </employee> > </employee> > > Desired output XML: > > <employee emp="1"dept="55"> > <name>Peter</name> > <job>Director</job> > </employee> > > Overall, it is a so called ‘modified identity transformation’ in XSLT > parlance. > > Output XML shall be the same, except the child <employee> element and > its children. > > ** > > Question: > > *What is the best way to re-create existing root element with all its > attributes?* > > My implementation: > > xquery version "3.1"; > > declare context item := document { > > <employee emp="1" dept="55"> > > <name>Peter</name> > > <job>Director</job> > > <employee emp="12" dept="26"> > > <name>John</name> > > <job>Animator</job> > > <employee emp="123" dept="27"> > > <name>James</name> > > <job>Assistant</job> > > </employee> > > </employee> > > </employee> > > }; > > (: working version :) > > element {fn:node-name(/*)} > > { > > let $y := ./*/@* > > return $y, (: copy all attributes :) > > for $x in ./*/(* except employee) > > return $x > > } > > (: NOT working version, trying to make it more concise :)

I would write

/*/element { node-name() } { @*, * except employee }

YK
Yitzhak Khabinsky13 Sep 2020 23:46 #

Hello,

This is input XML:

<employee emp="1" dept="55">
    <name>Peter</name>
    <job>Director</job>
    <employee emp="12" dept="26">
        <name>John</name>
        <job>Animator</job>
        <employee emp="123" dept="27">
            <name>James</name>
            <job>Assistant</job>
        </employee>
    </employee>
</employee>

Desired output XML:

<employee emp="1" dept="55">
    <name>Peter</name>
    <job>Director</job>
</employee>

Overall, it is a so called 'modified identity transformation' in XSLT parlance.

Output XML shall be the same, except the child <employee> element and its children.

Question:

What is the best way to re-create existing root element with all its attributes?

My implementation:

xquery version "3.1";

declare context item := document {

<employee emp="1" dept="55">

        <name>Peter</name>

        <job>Director</job>

        <employee emp="12" dept="26">

                <name>John</name>

                <job>Animator</job>

                <employee emp="123" dept="27">

                        <name>James</name>

                        <job>Assistant</job>

                </employee>

        </employee>

</employee>

};

(: working version :)

element {fn:node-name(/*)}

{

let $y :=  ./*/@*

return $y, (: copy all attributes :)

for $x in ./*/(* except employee)

return $x

}

(: NOT working version, trying to make it more concise :)

element {fn:node-name(/*)} {/*/@*}

{

return for $x in ./*/(* except employee)

return $x

}

Regards, Yitzhak Khabinsky

YK
Yitzhak Khabinsky15 Sep 2020 23:26 #

Hi Martin,

Thanks for the answer.

That's exactly what I was looking for.

Regards, Yitzhak Khabinsky

Written for BaseX 9.4. BaseX may have changed since: please check the current documentation.

⚡Generated with XQuery