Re: [basex-talk] Mixing non-updating and updating expressions in a single query
@Christian and Lukas: Many thanks for helping me with the transform expression so far. However, I am not sure if we can use both non-updating and updating expressions in a single query ? Meaning, I am trying to modify one document and insert the modified document into the second document. *Example:* let $newchild := "This is a child node" copy $c := <entry><title>How to use updating and non-updating expressions together</title> <child>child 1<child> <child>child 2</child> </entry> modify ( for $child in $c//child return replace value of node $child with $newchild ) return insert node $c into doc('seconddocument') I also tried: let $newchild := "This is a child node" copy $c := <entry><title>How to use updating and non-updating expressions together</title> <child>child 1<child> <child>child 2</child> </entry> return modify ( for $child in $c//child return replace value of node $child with $newchild ) insert node $c into doc('seconddocument') Of course, I can achieve this when I use two xqueries (one to return the modified document and the other to insert it into a second document). But, it would be great if I could perform both actions in a single query. Thanks, Sony On Fri, Feb 25, 2011 at 2:54 AM, Christian Grün <christian.gruen@gmail.com>wrote:
I'm sure the somewhat unrelated syntax error message didn't help you to find this ... sorry for that.
I agree with Lukas. I've revised the misleading error feedback; feel free to check out the latest build:
http://files.basex.org/releases/latest/
C. ___________________________
On Fri, Feb 25, 2011 at 7:46 AM, Lukas Kircher <lukaskircher1@googlemail.com> wrote:
Hey Sony,
I found another small typo in your query - the keyword 'node' is missing in your replace statement. So if you execute the query below you should be fine.
for $childentry in $c//childentry return replace value of node $childentry/@id with concat('New Child: ', data($c//childentry/@id))
Regards, Lukas
On Thu, Feb 24, 2011 at 11:08 PM, Sony Vijay <sony.vibh@gmail.com> wrote:
.. I see the syntax error : [XPST0003] Expecting ")", found "v". when I try :
for $childentry in $c//childentry return replace value of $childentry/@id with concat('New Child: ', data($c//childentry/@id))
To modify the child entries like so: <childentry id="1"> ----- > <childentry id="New Child: 1">
On Thu, Feb 24, 2011 at 5:03 PM, Sony Vijay <sony.vibh@gmail.com>
wrote:
... Replacing the values of attribute nodes doesn't seem to work as expected when I use modify. Please see my previous post with correction
in
the typo.
On Thu, Feb 24, 2011 at 5:00 PM, Sony Vijay <sony.vibh@gmail.com> wrote:
Please ignore the typo. My sample xquery looks something like this:
for $childentry in $c//childentry return replace value of $childentry/@id with concat('New Child: ', data($c//childentry/@id))
To modify the child entries like so: <childentry id="1"> ----- > <childentry id="New Child: 1">
On Thu, Feb 24, 2011 at 4:50 PM, Sony Vijay <sony.vibh@gmail.com>
wrote:
Christian, Yes. I did realize that I must use a RETURN statement. I tried that with a slight change in the requirement. Say, my child entries look
like so
:
<childentry id="1" /> I tried: for $childentry in $c//childentry return replace value of $childentry/@id with concat('New Child: ', $c//childentry/text()) Does replace work differently for attributes ? Thanks, Sony
On Thu, Feb 24, 2011 at 3:27 PM, Christian Grün <christian.gruen@gmail.com> wrote: > > Sony, > > each FLWOR expression needs to be completed with a RETURN statement. > Please insert the following snippet (haven't tried it live): > > for $childentry in $c//childentry > return replace value of $childentry with > concat('New Child: ', $c//childentry/text()) > > Hope this helps, > Christian > ___________________________ > > Christian Grün > Uni KN, Box 188 > 78457 Konstanz, Germany > http://www.inf.uni-konstanz.de/~gruen > > > > On Thu, Feb 24, 2011 at 9:24 PM, Sony Vijay <sony.vibh@gmail.com> > wrote: > > Christian, > > Thank you very much for helping me with the query. However, I am not > > quite > > sure how the transform operation works if I have to use a for loop. > > Say, I > > twist around yesterday's question a bit like so: > > copy $c := > > <entry> > > <id>1</id> > > <title>How to use a transform expression</title> > > <updated>2011-02-23</updated> > > <author> > > <name>BaseX Team</name> > > <uri>http://basex.org</uri> > > </author> > > <childentry> 1 </childentry> > > <childentry> 2 </childentry> > > <childentry> 3 </childentry> > > <content type="html">Transform expression example created by BaseX > > Team</content> > > </entry> > > modify ( > > replace value of node $c//name with 'BaseX', > > replace value of node $c//content with concat('Copy of: ', > > $c//content), > > insert node <member>Joey</member> into $c//author > > for $childentry in $c//childentry > > replace value of $childentry with concat('New Child: ', > > $c//childentry/text()) > > ) > > return $c > > > > The expected output is: > > <entry> > > <id>1</id> > > <title>How to use a transform expression</title> > > <updated>2011-02-23</updated> > > <author> > > <name>BaseX</name> > > <uri>http://basex.org</uri> > > <member>Joey</member> > > </author> > > <childentry> New Child: 1 </childentry> > > <childentry> New Child: 2 </childentry> > > <childentry> New Child: 3 </childentry> > > <content type="html">Copy of: Transform expression example created > > by > > BaseX Team</content> > > </entry> > > The following exception is thrown when I tried my sample > > transformation > > query with the for loop: > > [XPST0003] Expecting 'where', 'order' or 'return' expression. > > Thanks, > > Sony > > PS: @Lukas: I did notice the update in the documentation. Thank you > > ! > > > > > > On Wed, Feb 23, 2011 at 2:32 AM, Lukas Kircher > > <lukaskircher1@googlemail.com> wrote: > >> > >> Hi Sony, > >> > >> to help others with the same question, I allowed myself to > >> add a modified version of your example to our > >> documentation [1]. > >> > >> Regards, > >> Lukas > >> > >> > >> [1] http://docs.basex.org/wiki/Update#transform > >> > >> > >> > >> On Wed, Feb 23, 2011 at 6:58 AM, Sony Vijay <sony.vibh@gmail.com
> >> wrote: > >>> > >>> Christian, > >>> Thank you for the quick and helpful reply. > >>> - Sony > >>> > >>> On Tue, Feb 22, 2011 at 5:56 PM, Christian Grün > >>> <christian.gruen@gmail.com> wrote: > >>>> > >>>> Sony, > >>>> > >>>> the following query might do what you want: > >>>> > >>>> copy $c := > >>>> <entry xmlns="http://www.w3.org/2005/Atom" > >>>> xmlns:libx="http://libx.org/xml/libx2"> > >>>> <id>1</id> > >>>> <title>Link Amazon By ISBN</title> > >>>> <updated>2010-09-29T18:37:48.592Z</updated> > >>>> <author> > >>>> <name>LibX Team</name> > >>>> <uri>http://libx.org</uri> > >>>> <email>libx.org@gmail.com</email> > >>>> </author> > >>>> <content type="html">Content created by LibX Libapp > >>>> Builder</content> > >>>> </entry> > >>>> modify ( > >>>> replace value of node $c//*:name with 'Sony', > >>>> replace value of node $c//*:content with > >>>> concat('Copy of: ', $c//*:content) > >>>> ) > >>>> return $c > >>>> > >>>> > >>>> Best, > >>>> Christian > >>>> ___________________________ > >>>> > >>>> On Tue, Feb 22, 2011 at 11:43 PM, Sony Vijay > >>>> <sony.vibh@gmail.com> > >>>> wrote: > >>>> > Hi, > >>>> > I am using BaseX 6.5. I am trying to transform a given node > >>>> > using an > >>>> > XQuery. > >>>> > > >>>> > Say, I have an node like so: > >>>> > <entry xmlns="http://www.w3.org/2005/Atom" > >>>> > xmlns:libx="http://libx.org/xml/libx2"> > >>>> > <id>1</id> > >>>> > <title>Link Amazon By ISBN</title> > >>>> > <updated>2010-09-29T18:37:48.592Z</updated> > >>>> > <author> > >>>> > <name>LibX Team</name> > >>>> > <uri>http://libx.org</uri> > >>>> > <email>libx.org@gmail.com</email> > >>>> > </author> > >>>> > <content type="html">Content created by LibX Libapp > >>>> > Builder</content> > >>>> > </entry> > >>>> > I am trying to send this node to an xquery which is expected to > >>>> > do the > >>>> > following actions: > >>>> > > >>>> > create a copy of this node (so that the actual node in the > >>>> > database > >>>> > does not > >>>> > change), > >>>> > transform/modify the duplicate copy of the given node > >>>> > return the modified duplicate copy of the given node > >>>> > > >>>> > I would expect the output to be like so: > >>>> > <entry xmlns="http://www.w3.org/2005/Atom" > >>>> > xmlns:libx="http://libx.org/xml/libx2"> > >>>> > <id>1</id> > >>>> > <title>Link Amazon By ISBN</title> > >>>> > <updated>2010-09-29T18:37:48.592Z</updated> > >>>> > <author> > >>>> > <name>Sony</name> > >>>> > <uri>http://libx.org</uri> > >>>> > <email>libx.org@gmail.com</email> > >>>> > </author> > >>>> > <content type="html">Copy of: Content created by LibX Libapp > >>>> > Builder</content> > >>>> > </entry> > >>>> > I tried to perform the non-updating functions using transform > >>>> > and also > >>>> > tried > >>>> > to use a pending update list > >>>> > (Reference: http://docs.basex.org/wiki/Update#transform). None > >>>> > of this > >>>> > works > >>>> > as expected. Could you refer me to a more detailed > >>>> > documentation for > >>>> > performing such transform operations on nodes ? > >>>> > Thanks, > >>>> > Sony > >>>> > > >>>> > _______________________________________________ > >>>> > BaseX-Talk mailing list > >>>> > BaseX-Talk@mailman.uni-konstanz.de > >>>> > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > >>>> > > >>>> > > >>> > >>> > >>> _______________________________________________ > >>> BaseX-Talk mailing list > >>> BaseX-Talk@mailman.uni-konstanz.de > >>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > >>> > >> > > > >
Sony, this query might do what you want: let $node := copy $c := <entry> <title>How to use updating and non-updating expressions together</title> <child>child 1</child> <child>child 2</child> </entry> modify ( for $child in $c//child return replace value of node $child with "This is a child node" ) return $c return insert node $node into doc('seconddocument') Due to the sometimes confusing flexibility of XQuery, this is just one way to do it. Note that you always need to specify complete FLWOR expressions; e.g., in your first query you forgot to add a "return" statement after the first "let" clause. The syntax would be simpler if Transform expressions (copy .. modify .. return) were part of the FLWOR expression, and it might be that future version of XQuery won't make a difference here anymore. Christian ___________________________ On Fri, Feb 25, 2011 at 5:07 PM, Sony Vijay <sony.vibh@gmail.com> wrote:
@Christian and Lukas: Many thanks for helping me with the transform expression so far. However, I am not sure if we can use both non-updating and updating expressions in a single query ? Meaning, I am trying to modify one document and insert the modified document into the second document. Example:
let $newchild := "This is a child node" copy $c := <entry><title>How to use updating and non-updating expressions together</title> <child>child 1<child> <child>child 2</child> </entry> modify ( for $child in $c//child return replace value of node $child with $newchild ) return insert node $c into doc('seconddocument')
I also tried:
let $newchild := "This is a child node" copy $c := <entry><title>How to use updating and non-updating expressions together</title> <child>child 1<child> <child>child 2</child> </entry> return modify ( for $child in $c//child return replace value of node $child with $newchild ) insert node $c into doc('seconddocument')
Of course, I can achieve this when I use two xqueries (one to return the modified document and the other to insert it into a second document). But, it would be great if I could perform both actions in a single query. Thanks, Sony
Christian, Wow. Thanks for the super fast reply. Sony On Fri, Feb 25, 2011 at 11:18 AM, Christian Grün <christian.gruen@gmail.com>wrote:
Sony,
this query might do what you want:
let $node := copy $c := <entry> <title>How to use updating and non-updating expressions together</title> <child>child 1</child> <child>child 2</child> </entry> modify ( for $child in $c//child return replace value of node $child with "This is a child node" ) return $c
return insert node $node into doc('seconddocument')
Due to the sometimes confusing flexibility of XQuery, this is just one way to do it. Note that you always need to specify complete FLWOR expressions; e.g., in your first query you forgot to add a "return" statement after the first "let" clause. The syntax would be simpler if Transform expressions (copy .. modify .. return) were part of the FLWOR expression, and it might be that future version of XQuery won't make a difference here anymore.
Christian ___________________________
On Fri, Feb 25, 2011 at 5:07 PM, Sony Vijay <sony.vibh@gmail.com> wrote:
@Christian and Lukas: Many thanks for helping me with the transform expression so far. However, I am not sure if we can use both non-updating and updating expressions in a single query ? Meaning, I am trying to modify one document and insert the modified document into the second document. Example:
let $newchild := "This is a child node" copy $c := <entry><title>How to use updating and non-updating expressions together</title> <child>child 1<child> <child>child 2</child> </entry> modify ( for $child in $c//child return replace value of node $child with $newchild ) return insert node $c into doc('seconddocument')
I also tried:
let $newchild := "This is a child node" copy $c := <entry><title>How to use updating and non-updating expressions together</title> <child>child 1<child> <child>child 2</child> </entry> return modify ( for $child in $c//child return replace value of node $child with $newchild ) insert node $c into doc('seconddocument')
Of course, I can achieve this when I use two xqueries (one to return the modified document and the other to insert it into a second document). But, it would be great if I could perform both actions in a single query. Thanks, Sony
participants (2)
-
Christian Grün -
Sony Vijay