February 2015 - BaseX-Talk - mailman.uni-konstanz.de

GUI feature request "Add as import"
by Andy Bunce 03 Jan '16

03 Jan '16

Hi, I often find myself adding module imports in the GUI and I wonder if the following suggestion might speed up that process. Add a new menu item to the filelist right click context menu "Add as import" when the file selection is a XQuery module. The action would be to add a line to the current edit window source with import module namespace {$prefix} = '{$namespace}' at {$path}; Where $prefix and $namespace} are read from the source of the selected file, and $path is calculated from the relative path from the edit file source to the selected filelist source. The line would be inserted at a suitable place in the prologue or at the current location if that is too tricky. /Andy

2 4

Slow query
by Menashè Eliezer 03 Aug '15

03 Aug '15

Hello, I wonder if the attached query can be optimised. I'm attaching all relevant information. Basex 7.9, Debian, powerful server. This is just an example. The queries will be built based on a compilation of a search form. So reordering the conditions for having smaller subset right from the begging isn't relevant. Any help would be appreciated. 40 seconds are not acceptable. -- With kind regards, Menashè

2 45

Position of matched tokens in a full-text query
by Javier Couto 22 May '15

22 May '15

Hi, Sorry if this is too basic, but I’m trying to get the positions of the matched tokens in a full-text query, and I can’t find the way to do it. I imagine something like: for $sentence in //sentence where $sentence[text() contains text { ‘DNA', ‘oxidation' }] return <positions>ft:SOME-FUNCTION-FOR-TOKENS-POSITIONS($sentence[text() contains text { ‘DNA', ‘oxidation' }])</positions> Is this possible? Thank you in advance, Javier

3 10

Bug in declare base-uri
by Hans-Juergen Rennau 18 May '15

18 May '15

Dear BaseX team, I think there is a bug in the determination of the static base URI in the special case that a base URI declaration contains a relative URI equal to or starting with "..". Consider this declaration:declare base-uri ".."; The effect should be that relative URIs are resolved against the PARENT directory of the directory containing the query. If the query is located at, say, file:///a/b/c/query.xq, I would expect the static base-uri to be /a/b/, so that a URI like "abc.xml" would be resolved to file:///a/b/abc.xml. However, the static base URI as determined by BaseX in this case misses the trailing /, it is: file:///a/bThe effect is that a URI like "abc.xml" would be resolved to file:///a/abc.xmlIn other words: URIs are resolved against the "GRAND-PARENT" directory of the query. Final remark: the effect of resolving URIs against the parent directory of the query is achieved by the surprising base URI declaration: declare base-uri "."; which is not what I would expect. Conclusion: the way to achieve a resolving of relative URIs against the parent directory of the query should be achieved by the base URI declaration ".." - and no other value. Kind regards,Hans-Juergen Full example:Query ( file file:///projects/infospace/pcol/test.xq); declare base-uri ".."; declare variable $uri external; string-join(( 'query-file: file:///projects/infospace/pcol/test.xq', concat('static-base-uri: ', static-base-uri()), concat('resolve-uri("try.xml")=', resolve-uri("try.xml")) ), '
') Output:query-file: file:///projects/infospace/pcol/test.xq static-base-uri: file:///C:/projects/infospace resolve-uri("try.xml")=file:/C:/projects/try.xml

2 4

Issues posting/putting JSON content with markup in it via http module.
by James Wright 24 Mar '15

24 Mar '15

Hello everyone, First, I want to say that I really like the JSON improvements in BaseX 8.0. Great job. I am however having an issue when posting JSON with markup in it. For example: let $out := map { name: 'myView', markup: "<div name='value'>Some other stuff</div>" } http:send-request(<http:request method="POST" />, uri, $out) The issue is that the resulting JSON body being posted has the 'markup' property xml escaped. IE: { "name": "myView", "markup": "<div name='value'>Some other ..... " } I had a similar issue with file:write but resolved that by using file:write-string. I have tried calling json:serialize on $out manually as well as declaring the option output:method to 'json'. I even tried changing the request object by inserting a http:body. IE: <http:request method="GET"> <http:body content-type="application/json"> {json:serialize($out)} </http> </http> Lastly, I have tried declaring the cdata-section option: declare option output:cdata-section-elements 'http:body'; Still no go... Is this not possible? One option would be to serialize the content using file:write and then call curl. This is a workaround I have used in the past however I was hoping I was behind that now with the latest improvements to XQuery 3.1. Maybe I need to send the http:request object as a map instead of an xml node? Thanks again for your time on all of this. - James

2 2

Comparing NxDs
by Mansi 03 Mar '15

03 Mar '15

Hello, I am a happy BaseX user. Currently I am trying to help other teams to find right solution to their data mining from huge xml data store. They are going after postgre and probably even db2. Nor that I have any influence over their decision, but I would like to alert them about something obvious. I just wanted to have some comments from experts here, to give me guidance on what is a major different between these relational DBs supporting native xml storages as compared to BaseX or whatever. I know postgre doesn't support xquery, but db2 does. As you all are aware, our queries won't be complicated probably even xpath might work, just amount of data would be huge. We won't even care hugely about the time taken to return results as long as it's not days. Please advice, - Mansi

5 4

Index for multiple dbs
by Marco Lettere 01 Mar '15

01 Mar '15

Hi all, here a question for the weekend ... ;-) The following query performs perfectly exploiting the attribute index: for $d in collection("db") where $d//*:item/@id = '2015000000016940' return $d Why does this not? ("db") ! (for $d in collection(.) where $d//*:item/@id = '2015000000016940' return $d ) In our use case we'd like to have a list of dbs to query on and the list can grow over time so we would not like to change the code by replicating the queries every time a db is added. What is the way out? Thanks, Marco.

2 3

Basex query with huge volume collection
by Chandrasekhar 28 Feb '15

28 Feb '15

Dear Basex, We have written a query to read nodes from collection which are in volumes of crores.Sample xml is as attached to this mail.In the xml there are crores of nodes with the tag "R",now i need to fetch all the tags with "R", i have used the below query to fetch it but the amount of time it is taking to do is going above 5 minutes and taking a memory of >1 GB. for $PSTNCallData in (collection("52_DATA_AUGUST-14_Billed_HugeDataTesting")/SUBCUSTBRK/ITEMIZED/TRANSACTION[data(@Type)=('PSTN')]/CALL_TYPES/DATA/R) return <R><bill_no>{$PSTNCallData/C1}</bill_no></R> Could you please help us in optimizing this query.Thank you in advance. Thanks & Regards ChandraShekar The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited.

2 1

LocalSession delete document - No database opened
by Ketill Fenne 27 Feb '15

27 Feb '15

Hi! I am trying to delete a specific document from a database called Users, but get the error "org.basex.core.BaseXException; No database opened" The code is (input name is the document name): Context context = new Context(); LocalSession session = new LocalSession(context); try { new Open("Users").execute(context); session.execute("delete " + name); } catch (Exception e) { e.printStackTrace(); // let the caller handle exception throw e; } Do I need to open the database through the session? Haven't found out how.... BR Ketill Fenne

2 1

Re: [basex-talk] Executing Xquery update from java - hangs
by Christian Grün 26 Feb '15

26 Feb '15

Hi Ketill, I'm cc'ing this back to the mailing list, as it may also be of interest for other users. > Would you advice against mixing different "connection methods" to the > database(s) in the same application? (Queries through XQJ, updates via > QueryProcessor) Using a single API will usually cause you less headache in the middle or long term, but it may be fine to simply try out things. If you create QueryProcessor instances, no problems are to be expected as long as you dont't need to run concurrent queries. You could also work with LocalSession instances, which will be more stable in the long run. The (Local|Client)Session API could be further extended to meet more requirements, depending on the feedback we get. Hope this helps, Christian > On Wed, Feb 25, 2015 at 5:23 PM, Christian Grün <christian.gruen(a)gmail.com> > wrote: >> >> Hi Ketill, >> >> Welcome to our list. >> >> XQJ was written to be compliant with XQuery 1.0, so it may well be >> that the db:output extension cannot be used with our (well, Charles >> Foster's) implementation of XQJ (yet). Have you tried to set the >> MIXUPDATES flag to true instead? >> >> All the best, >> Christian >> >> >> On Wed, Feb 25, 2015 at 5:02 PM, Ketill Fenne <ketill.fenne(a)gmail.com> >> wrote: >> > Hi! >> > >> > I am executing all Xqueries through the same runQuery method in Java, >> > and I >> > am running the latest jar-files (8.0.1): >> > >> > XQDataSource ds = new BaseXXQDataSource(); >> > xqc = ds.getConnection(); >> > XQExpression xqe = xqc.createExpression(); >> > rs = xqe.executeQuery(query); >> > >> > The query is (in this case): >> > for $doc in (collection('Users/customer_1'))/* >> > return (replace value of node $doc/@name with ("My new customer name")) >> > >> > The update works fine in BaseX Gui, and I suspect the problem is that it >> > does not return anything, and my code expects XQResultSequence. I have >> > tried >> > adding db:output to return part of the query with no luck. >> > Do you have any suggestions? >> > >> > Kind regards >> > Ketill Fenne > >

1 0