BaseX-Talk

basex-talk@mailman.uni-konstanz.de

4 participants
5268 discussions

Re: [basex-talk] Nothing gets printed after insert node
by Anupam Bakshi 06 Jun '12

06 Jun '12

Hello Maurice, Christian, I'm grateful to you for providing me help. This is exactly what I needed. Thanks a lot. Now I can move forward with the application development. Best regards, Anupam ________________________________ From: M. van Keulen <m.vankeulen(a)utwente.nl> To: Anupam Bakshi <bakshia(a)yahoo.com> Sent: Wednesday, June 6, 2012 3:37 AM Subject: Re: [basex-talk] Nothing gets printed after insert node Dear Anupam, You seem to misunderstand the term "update". An update modifies the document in the database. So if you ask for it after that (with doc(...)) you'll get the modified document. In your case: let $s := db:open("BaseX","sample1.xml") >let $r := db:open("BaseX","result1.xml") >for $m in $s//*:M >return > insert nodes $r//*:R[@id=$m/@id] into $m > modifies the sample1.xml in the database. A subsequent query db:open("BaseX","sample1.xml") would produce > <M id="1"> > <R id="1"/> > </M> > <M id="2"> > <R id="2"/> > </M> > <M id="3"/> > > If you don't want to store the document in the database and modify it, but simply want to generate a *new* intermediary document that is similar to sample1.xml but which includes the desired R-elements, then you don't update anything (the original file stays the same). You can do this with { >let $s := db:open("BaseX","sample1.xml") >let $r := db:open("BaseX","result1.xml") >for $m in $s//*:M >let $o := $r//*:R[@id=$m/@id] >return <M>{$m/@*,$m/*,$o}</M> >} > or by using the transform-expression let $s := db:open("BaseX","sample1.xml") >let $r := db:open("BaseX","result1.xml") >return >copy $new := $s >modify ( > for $m in $new//*:M > return > insert nodes $r//*:R[@id=$m/@id] into $m >) >return $new > Maurice On 06-06-12 08:12, Anupam Bakshi wrote: Hello Maurice, > Thanks for your response. > How do I communicate the intermediate result (modified document) between the two queries? > > Do I store the intermediate file back in the database? I tried to store the result of an update in a variable but it said that not allowed - "Let expression: No updating expression allowed". > So the question is how can I run the first query to update the document and the second query to retrieve the modified document? > > > If someone can point to an example, that will help too. >Best regards, >Anupam > > > > > >________________________________ > From: M. van Keulen <m.vankeulen(a)utwente.nl> >To: Anupam Bakshi <bakshia(a)yahoo.com> >Cc: basex-talk(a)mailman.uni-konstanz.de >Sent: Wednesday, June 6, 2012 1:38 AM >Subject: Re: [basex-talk] Nothing gets printed after insert node > > >Dear Anupam, > >One workaround would be to do it in two queries: one to update your document, and one to retrieve the modified nodes. > >The problem is not that you can't pick nodes from another resource, but that XQuery doesn't allow you to update and query inside the same query. In other words, within one query doing an update means you can't produce a (query) result, and having a query result means you can't do any update. > >Regards, >Maurice. > >On 06-06-12 05:53, Anupam Bakshi wrote: >Then how about option 'b' ? >>At this point any way forward, any work around will do. >>Please let me know if anyone has any suggestion. >> >>What I don't understand is, if I can add nodes why can't I pick those nodes from another resource? Why is this not possible? >> >>But I'm looking for some workaround. >> >>Thanks for your help. >>Anupam >> >> >> >>________________________________ >> From: Christian Grün <christian.gruen(a)gmail.com>; >>To: Anupam Bakshi <bakshia(a)yahoo.com>; >>Cc: <basex-talk(a)mailman.uni-konstanz.de>; >>Subject: Re: [basex-talk] Nothing gets printed after insert node >>Sent: Wed, Jun 6, 2012 12:24:18 AM >> >> >>> I'm interested in 'a'. >>> The two files are in basex, I need to write a query that will return the >>> modified nodes at run time. >> >>Due to the nature of the XQuery Update Specification, that's generally >>not possible. Sorry for that. >> >> >>> From: Christian Grün <christian.gruen(a)gmail.com>; >>> To: Anupam Bakshi <bakshia(a)yahoo.com>; >>> Cc: basex-talk(a)mailman.uni-konstanz.de >>> <basex-talk(a)mailman.uni-konstanz.de>; >>> Subject: Re: [basex-talk] Nothing gets printed after insert node >>> Sent: Tue, Jun 5, 2012 9:09:06 PM >>> >>> Are you mostly interested in >>> >>> a) updating your data, and returning the modified node(s) as query result, >>> or >>> b) finding the correct updating query to modify your data? >>> ___________________________ >>> >>> > Here is what I actually want to do. Maybe someone can suggest a >>> > straightforward way. >>> > >>> > File : sample1.xml >>> > >>> > <M id="1"/> >>> > <M id="2"/> >>> > <M id="3"/> >>> > >>> > >>> > File: result1.xml >>> > <Q> >>> > <R id="1"/> >>> > <R id="2"/> >>> > </Q> >>> > >>> > Desired output : >>> > >>> > <M id="1"> >>> > <R id="1"/> >>> > </M> >>> > <M id="2"> >>> > <R id="2"/> >>> > </M> >>> > <M id="3"/> >>> > >>> > >>> > So insert the node from 2nd file into 1st where the ids match. >>> > >>> > Thanks, >>> > Amupam >>> > >>> > ________________________________ >>> > From: Christian Grün <christian.gruen(a)gmail.com> >>> > To: Anupam Bakshi <bakshia(a)yahoo.com> >>> > Cc: basex-talk(a)mailman.uni-konstanz.de >>> > Sent: Tuesday, June 5, 2012 12:02 PM >>> > Subject: Re: [basex-talk] Nothing gets printed after insert node >>> > >>> >> Unfortunately I did not see how I can return the value into a variable >>> >> for >>> >> further processing. >>> >> Is there some other way to do it? >>> > >>> > Did you already try db:output()? >>> > >>> > >> > >-- ---------------------------------------------------------------------- Dr.Ir. M. van Keulen - Associate Professor, Data Management Technology Univ. of Twente, Dept of EEMCS, POBox 217, 7500 AE Enschede, Netherlands Email: m.vankeulen(a)utwente.nl, Phone: +31 534893688, Fax: +31 534892927 Room: ZI 3039, WWW: http://www.cs.utwente.nl/~keulen > > -- ---------------------------------------------------------------------- Dr.Ir. M. van Keulen - Associate Professor, Data Management Technology Univ. of Twente, Dept of EEMCS, POBox 217, 7500 AE Enschede, Netherlands Email: m.vankeulen(a)utwente.nl, Phone: +31 534893688, Fax: +31 534892927 Room: ZI 3039, WWW: http://www.cs.utwente.nl/~keulen

1 0

Re: [basex-talk] Nothing gets printed after insert node
by M. van Keulen 06 Jun '12

06 Jun '12

Forgot to send my response to the list: -------- Original Message -------- Subject: Re: [basex-talk] Nothing gets printed after insert node Date: Wed, 06 Jun 2012 09:37:25 +0200 From: M. van Keulen <m.vankeulen(a)utwente.nl> Organization: University of Twente To: Anupam Bakshi <bakshia(a)yahoo.com> Dear Anupam, You seem to misunderstand the term "update". An update modifies the document in the database. So if you ask for it after that (with doc(...)) you'll get the modified document. In your case: let $s := db:open("BaseX","sample1.xml") let $r := db:open("BaseX","result1.xml") for $m in $s//*:M return insert nodes $r//*:R[@id=$m/@id] into $m modifies the sample1.xml in the database. A subsequent query db:open("BaseX","sample1.xml") would produce <M id="1"> <R id="1"/> </M> <M id="2"> <R id="2"/> </M> <M id="3"/> If you don't want to store the document in the database and modify it, but simply want to generate a *new* intermediary document that is similar to sample1.xml but which includes the desired R-elements, then you don't update anything (the original file stays the same). You can do this with { let $s := db:open("BaseX","sample1.xml") let $r := db:open("BaseX","result1.xml") for $m in $s//*:M let $o := $r//*:R[@id=$m/@id] return <M>{$m/@*,$m/*,$o}</M> } or by using the transform-expression let $s := db:open("BaseX","sample1.xml") let $r := db:open("BaseX","result1.xml") return copy $new := $s modify ( for $m in $new//*:M return insert nodes $r//*:R[@id=$m/@id] into $m ) return $new Maurice On 06-06-12 08:12, Anupam Bakshi wrote: > Hello Maurice, > Thanks for your response. > How do I communicate the intermediate result (modified document) > between the two queries? > Do I store the intermediate file back in the database? I tried to > store the result of an update in a variable but it said that not > allowed - "Let expression: No updating expression allowed". > So the question is how can I run the first query to update the > document and the second query to retrieve the modified document? > > If someone can point to an example, that will help too. > Best regards, > Anupam > > > ------------------------------------------------------------------------ > *From:* M. van Keulen <m.vankeulen(a)utwente.nl> > *To:* Anupam Bakshi <bakshia(a)yahoo.com> > *Cc:* basex-talk(a)mailman.uni-konstanz.de > *Sent:* Wednesday, June 6, 2012 1:38 AM > *Subject:* Re: [basex-talk] Nothing gets printed after insert node > > Dear Anupam, > > One workaround would be to do it in two queries: one to update your > document, and one to retrieve the modified nodes. > > The problem is not that you can't pick nodes from another resource, > but that XQuery doesn't allow you to update and query inside the same > query. In other words, within one query doing an update means you > can't produce a (query) result, and having a query result means you > can't do any update. > > Regards, > Maurice. > > On 06-06-12 05:53, Anupam Bakshi wrote: >> Then how about option 'b' ? >> At this point any way forward, any work around will do. >> Please let me know if anyone has any suggestion. >> >> What I don't understand is, if I can add nodes why can't I pick those >> nodes from another resource? Why is this not possible? >> >> But I'm looking for some workaround. >> >> Thanks for your help. >> Anupam >> >> >> ------------------------------------------------------------------------ >> *From: * Christian Grün <christian.gruen(a)gmail.com> >> <mailto:christian.gruen@gmail.com>; >> *To: * Anupam Bakshi <bakshia(a)yahoo.com> <mailto:bakshia@yahoo.com>; >> *Cc: * <basex-talk(a)mailman.uni-konstanz.de> >> <mailto:basex-talk@mailman.uni-konstanz.de>; >> *Subject: * Re: [basex-talk] Nothing gets printed after insert node >> *Sent: * Wed, Jun 6, 2012 12:24:18 AM >> >> > I'm interested in 'a'. >> > The two files are in basex, I need to write a query that will >> return the >> > modified nodes at run time. >> >> Due to the nature of the XQuery Update Specification, that's generally >> not possible. Sorry for that. >> >> >> > From: Christian Grün <christian.gruen(a)gmail.com>; >> > To: Anupam Bakshi <bakshia(a)yahoo.com>; >> > Cc: basex-talk(a)mailman.uni-konstanz.de >> > <basex-talk(a)mailman.uni-konstanz.de>; >> > Subject: Re: [basex-talk] Nothing gets printed after insert node >> > Sent: Tue, Jun 5, 2012 9:09:06 PM >> > >> > Are you mostly interested in >> > >> > a) updating your data, and returning the modified node(s) as query >> result, >> > or >> > b) finding the correct updating query to modify your data? >> > ___________________________ >> > >> > > Here is what I actually want to do. Maybe someone can suggest a >> > > straightforward way. >> > > >> > > File : sample1.xml >> > > >> > > <M id="1"/> >> > > <M id="2"/> >> > > <M id="3"/> >> > > >> > > >> > > File: result1.xml >> > > <Q> >> > > <R id="1"/> >> > > <R id="2"/> >> > > </Q> >> > > >> > > Desired output : >> > > >> > > <M id="1"> >> > > <R id="1"/> >> > > </M> >> > > <M id="2"> >> > > <R id="2"/> >> > > </M> >> > > <M id="3"/> >> > > >> > > >> > > So insert the node from 2nd file into 1st where the ids match. >> > > >> > > Thanks, >> > > Amupam >> > > >> > > ________________________________ >> > > From: Christian Grün <christian.gruen(a)gmail.com> >> > > To: Anupam Bakshi <bakshia(a)yahoo.com> >> > > Cc: basex-talk(a)mailman.uni-konstanz.de >> > > Sent: Tuesday, June 5, 2012 12:02 PM >> > > Subject: Re: [basex-talk] Nothing gets printed after insert node >> > > >> > >> Unfortunately I did not see how I can return the value into a >> variable >> > >> for >> > >> further processing. >> > >> Is there some other way to do it? >> > > >> > > Did you already try db:output()? >> > > >> > > >> > > -- > ---------------------------------------------------------------------- > Dr.Ir. M. van Keulen - Associate Professor, Data Management Technology > Univ. of Twente, Dept of EEMCS, POBox 217, 7500 AE Enschede, Netherlands > Email:m.vankeulen@utwente.nl <mailto:m.vankeulen@utwente.nl>, Phone: +31 534893688, Fax: +31 534892927 > Room: ZI 3039, WWW:http://www.cs.utwente.nl/~keulen > > -- ---------------------------------------------------------------------- Dr.Ir. M. van Keulen - Associate Professor, Data Management Technology Univ. of Twente, Dept of EEMCS, POBox 217, 7500 AE Enschede, Netherlands Email:m.vankeulen@utwente.nl, Phone: +31 534893688, Fax: +31 534892927 Room: ZI 3039, WWW:http://www.cs.utwente.nl/~keulen -- ---------------------------------------------------------------------- Dr.Ir. M. van Keulen - Associate Professor, Data Management Technology Univ. of Twente, Dept of EEMCS, POBox 217, 7500 AE Enschede, Netherlands Email: m.vankeulen(a)utwente.nl, Phone: +31 534893688, Fax: +31 534892927 Room: ZI 3039, WWW: http://www.cs.utwente.nl/~keulen

1 0

Re: [basex-talk] Nothing gets printed after insert node
by Anupam Bakshi 06 Jun '12

06 Jun '12

Then how about option 'b' ? At this point any way forward, any work around will do. Please let me know if anyone has any suggestion. What I don't understand is, if I can add nodes why can't I pick those nodes from another resource? Why is this not possible? But I'm looking for some workaround. Thanks for your help. Anupam

2 1

Re: [basex-talk] Nothing gets printed after insert node
by Anupam Bakshi 05 Jun '12

05 Jun '12

I'm interested in 'a'. The two files are in basex, I need to write a query that will return the modified nodes at run time. Thanks, Anupam

2 1

Re: [basex-talk] Nothing gets printed after insert node
by Anupam Bakshi 05 Jun '12

05 Jun '12

Hello Christian, Unfortunately I did not see how I can return the value into a variable for further processing. Is there some other way to do it? Thanks, Anupam

2 4

Connection Pool
by Henrique Oliveira 05 Jun '12

05 Jun '12

Hi guys, Anyway to create a connection pool using BaseX? p.s.: Just ignore it if there is a post about that -- Henrique Oliveira

1 0

Nothing gets printed after insert node
by Anupam Bakshi 05 Jun '12

05 Jun '12

Hello, My XQuery file looks like this : for $metric in doc("C:\sample1.xml")//metric return ( delete node $metric, insert node <NID>{string($metric)}</NID> into $metric/.. ) The sample1.xml contains "metric" elements. Yet when I execute the query noting gets printed out. Following is the Query Info which shows 6 Updates. But where are the updates happening? I must be doing something wrong, but can't figure it out. Thanks for your help, Anupam Query: for $metric in doc("C:\sample1.xml")//metric return ( delete node $metric, insert node <MET>{string($metric)}</MET> into $metric/.. ) Compiling: - pre-evaluating fn:doc("C:\sample1.xml") - optimizing descendant-or-self step(s) - converting descendant::*:metric to child steps Result: for $metric in document-node { "sample1.xml" }/*:plan/*:metric return (delete nodes $metric, insert node element { "MET" } { fn:string($metric) } into $metric/..) Timing: - Parsing: 0.84 ms - Compiling: 2.21 ms - Evaluating: 3.37 ms - Printing: 0.14 ms - Total Time: 6.57 ms Result: - Hit(s): 0 Items - Updated: 6 Items - Printed: 0 Bytes Query plan: <QueryPlan> <FLWR> <For var="$metric"> <IterPath> <DBNode name="ivst3_plan_3" pre="0"/> <IterStep axis="child" test="*:plan"/> <IterStep axis="child" test="*:metric"/> </IterPath> </For> <Return> <List> <Delete> <VarRef> <Var name="$metric" id="0"/> </VarRef> </Delete> <Insert> <AxisPath> <VarRef> <Var name="$metric" id="0"/> </VarRef> <IterStep axis="parent" test="node()"/> </AxisPath> <CElem> <QNm value="MET" type="xs:QName"/> <FNAcc name="string([item])"> <VarRef> <Var name="$metric" id="0"/> </VarRef> </FNAcc> </CElem> </Insert> </List> </Return> </FLWR> </QueryPlan>

2 1

Apparant discrepancy in collection and db:list
by Anupam Bakshi 04 Jun '12

04 Jun '12

Hello all, Thanks for the wonderful support this group provides. Its great! With your help, I'm trying to make my way around the issues that I'm discovering, but unfortunately there still are some more issues. I noticed that collection() returns the nodes in the order in which they were added (which is good). However, db:list() returns them in alphabetical order. Any reason why that is the case? Can I somehow get the list of resources in the order in which they were added? Thanks, Anupam P.S. Jens, thanks for your suggestion, I'll try that if all else fails. Christian, I'll try the server feature in the latest source and send feedback a little later. Thanks for your help and suggestions.

2 5

Accessing basex from rest and from java api
by Henrique Oliveira 04 Jun '12

04 Jun '12

Hi All, Is possible to access BaseX from REST and Java API at the same time, same dbpath? I deployed BaseX.war in Jetty server, it is running on port 8080, I tried to connect using Java API without success. it seems is running on 1984 port too. INFO: General Information Version: 7.2.1 Used Memory: 2883 KB Main Options DBPATH: /private/var/folders/lb/_mgf_38n5nz05z_jbs3zkvbc0000gn/T/jetty-0.0.0.0-8080-BaseX721.war-_BaseX721-any-/webapp/data DEBUG: false EVENTPORT: 1985 HOST: localhost HTTPPATH: /private/var/folders/lb/_mgf_38n5nz05z_jbs3zkvbc0000gn/T/jetty-0.0.0.0-8080-BaseX721.war-_BaseX721-any-/webapp HTTPPORT: 8984 KEEPALIVE: 0 LANG: English LANGKEYS: false NONPROXYHOSTS: PARALLEL: 8 PORT: 1984 PROXYHOST: PROXYPORT: 80 REPOPATH: /private/var/folders/lb/_mgf_38n5nz05z_jbs3zkvbc0000gn/T/jetty-0.0.0.0-8080-BaseX721.war-_BaseX721-any-/webapp/repo SERVERHOST: SERVERPORT: 1984 STOPPORT: 8985 TIMEOUT: 0 Options ADDARCHIVES: true ADDRAW: false ATTRINDEX: true AUTOFLUSH: true BINDINGS: CACHEQUERY: false CASESENS: false CATFILE: CHOP: true COMPPLAN: true CREATEFILTER: *.xml DIACRITICS: false DOTCOMPACT: false DOTDISPLAY: true DOTPLAN: false DOTTY: dotty DTD: false EXPORTER: FORCECREATE: false FTINDEX: false HTMLOPT: html=false,omit-xml-declaration=false,method=xml,nons=false,nobogons=false,nodefaults=false,nocolons=false,norestart=false,ignorable=false,emptybogons=false,any=false,norootbogons=false,nocdata=false,lexical=false,encoding=utf-8 INTPARSE: true LANGUAGE: en LSERROR: 0 MAINMEM: false MAXCATS: 100 MAXHITS: -1 MAXLEN: 96 MAXSTAT: 30 PARSER: xml PARSEROPT: encoding=UTF-8,flat=false,format=verbose,header=false,jsonml=false,lines=true,separator=comma PATHINDEX: true QUERYINFO: false QUERYPATH: RUNS: 1 SCORING: 0 SERIALIZE: true SERIALIZER: SKIPCORRUPT: false STEMMING: false STOPWORDS: TAILCALLS: 42 TEXTINDEX: true UPDINDEX: false WILDCARDS: false WRITEBACK: false XMLPLAN: false XQUERY3: true -- Henrique Oliveira

2 3

Re: [basex-talk] Deleting one of many resources at the same path (sorry for hoging the email distribution list)
by Anupam Bakshi 01 Jun '12

01 Jun '12

Hi Dimitar, Since collections are sequences, can I use [1] or [last()] to specify which one to delete? As per my requirement, I need to be able to delete older resources after some processing (data consolidation). Thanks for your help. Best regards, Anupam

4 4

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk