Marklogic - how to execute insert and node replace in single xquery

Question

I have provided sample Xquery for insert and node replace Query.

My problem is If I am going to Execute the Query , its only insert the XML first.

even though i am going to execute second time the node will be replaced.

But I want the single execution it will be processed insert and update as well.

sample query :

xquery version "1.0-ml";
declare namespace html = "http://www.w3.org/1999/xhtml";
 let $a := xdmp:document-insert("/fo.xml", <a>1</a>)

let $b := xdmp:node-replace(fn:doc("/fo.xml")/a, <b>1</b>)

return ($a,$b)

grtjn · Accepted Answer · 2017-05-30 13:15:10Z

1

You cannot do that in a single statement. You either need to:

use a multi-statement call (main statements separated by a semi-colon)
do the update in-memory, and passing the updated content to the insert

Regarding 1:

The Application Developers Guide has a section about Semi-Colon as a Statement Separator, but in short it comes down to writing your query as follows:

xquery version "1.0-ml";
xdmp:document-insert("/fo.xml", <a>1</a>)
;
xquery version "1.0-ml";
xdmp:node-replace(fn:doc("/fo.xml")/a, <b>1</b>)

Regarding 2:

There are libraries that provide methods that operate very similar to the xdmp:node-* ones, but operate on content that has not yet been persisted to the database instead. You will need to download those first, and upload them to your modules database in order to use them. The best version I am aware of is https://github.com/ryanjdew/XQuery-XML-Memory-Operations. You can download and install that using MLPM. With that library you could write something like:

import module namespace mem = "http://maxdewpoint.blogspot.com/memory-operations" at "/ext/mlpm_modules/XQuery-XML-Memory-Operations/memory-operations.xqy";

let $a := <a>1</a>
let $b := <b>1</b>
let $updated-a := mem:copy($a) ! (
  mem:replace(., $a, $b),
  mem:execute(.)
)
return xdmp:document-insert("/foo.xml", $updated-a)

HTH!

edited May 30, 2017 at 13:15

answered May 30, 2017 at 12:41

grtjn

20.4k1 gold badge27 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Antony Over a year ago

Thanks for updating...How ? I have provided just sample query only , I have stuck with this query for last 2 days, can you please provide me sample or alter the above one.

Antony Over a year ago

Yes , But I am using for loop , So I can't store memory if I am store memory the duplicate content will be inserted in same XML.

grtjn Over a year ago

Please update the question to reflect this, so that we can answer appropriately..

Antony Over a year ago

I have added my full Xquery , could you please help?

Antony Over a year ago

yes , I have spitted to the my query.Now its working fine , like (regarding 1).

Tamas · Accepted Answer · 2017-05-30 12:53:42Z

1

Based on grtjn's answer you can do the following:

xdmp:document-insert("/fo.xml", <a>1</a>);
xdmp:node-replace(fn:doc("/fo.xml")/a, <b>1</b>);

Notice the semi-colon at the end of the lines. Those are statement separators. To understand more about statement separators (and transcations in general) you can refer to the following resource: https://docs.marklogic.com/guide/app-dev/transactions#id_11899.

answered May 30, 2017 at 12:53

Tamas

11.3k15 gold badges53 silver badges80 bronze badges

1 Comment

Antony Over a year ago

But I have frame uri and using lot of logic inside the query . so any other alternate way?

Collectives™ on Stack Overflow

Marklogic - how to execute insert and node replace in single xquery

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related