October 2014 - BaseX-Talk - mailman.uni-konstanz.de

What is the best way to implement an async REST method?
by Marc van Grootel 16 Dec '14

16 Dec '14

How would you implement an async REST pattern? I don't remember having seen anything that makes me do this using plain XQuery. Does this mean the only way to tackle this would be via Java and events maybe? I would post to a URL, this URL would accept the post and return a temporary URL where I can check the status of my request, then once it's ready this temp URL will redirect me to the location of the real resource. That's the gist of the async REST pattern that I would like to implement. What would be the best approach to experiment with this? --Marc

5 9

REST queries: "Read permissions needed"
by Jérôme Chauveau 25 Nov '14

25 Nov '14

Hi, i am using BaseX79 as a webapp - embedded in a tomcat7 server. I am working on a php application which runs REST xqueries to my BaseX server. I created a "mydb" database and a user "myuser". Then i granted READ permissions for "myuser". > *GRANT read TO myuser* > *GRAND read TO myuser ON mydb* > *show users* Username Read Write Create Admin ------------------------------------ admin X X X X myuser X > *show users on mydb* Username Read Write --------------------- myuser X All my REST xqueries returns a "READ permission needed." message with the user "myuser" when its works properly with the admin user account. Moreover, REST xqueries via a web browser (logged as 'myuser') works properly too. Did i miss something? Thank's for help. Jérôme. -- Jérôme Chauveau - SAIC-CERTIC - Campus 4 Université de Caen Basse-Normandie

2 8

Full text score with or
by Andy Bunce 23 Nov '14

23 Nov '14

Hi, I want to score searches with multiple conditions e.g. let $data:=( <r><a>red apple</a></r>, <r><a>blue lagoon</a></r>, <r><b>fish and chips</b></r>) for $hit score $s in $data[ a contains text("red") or b contains text("fish")] return $s In 7.8.2 it always returns scores of zero. In version 7.6 it returns numbers like 0.6201145069582775 0.4528324252639413 Is this bug? Regards /Andy

2 3

stream binary responses from http:module
by Johan Mörén 10 Nov '14

10 Nov '14

Hi I have built a small client in XQuery that fetches zip files from another remote service using the http-module and stores them on disk with the help of the file-module. Some of the returned zip files are really large and BaseX seems to need to materialize the files in memory before writing them to disk resulting in out of memory errors for some files. Is there some way read the response in a more streamable fashion when using the http-module? I tried using the fetch:binary function successfully but i really need the more extended functionality of the http-module. #results in out of memory if the zip file is too large file:write-binary("file.zip", http:sendrequest(...)[2]) #works all the time. file:write-binary("file.zip", fetch:binary(...)) Regards, Johan

3 7

Dynamic Evaluation of XQUERY
by Mansi Sheth 10 Nov '14

10 Nov '14

Hello, I want to devise a generic xquery script, which accepts actual XPATH to be run across all documents in all databases, from command line. Something like: curl -i " http://localhost:8984/rest?run=get_query_result.xq&n=/root/*//calls/@name/s… " Basically, parameter "n" would hold the query. I am trying this using xquery module eval method. But, am not succeeding in it. I have my script something as under: declare variable $n as xs:string external; declare option output:item-separator "
"; let $aList := for $db in db:list() let $vars := map {'db_name':$db , 'query' : $n} let $query_to_execute := "db:open($db_name)$query" return xquery:eval($query_to_execute,$vars) return distinct-values($aList) My questions are: 1. Can we assign dynamic values as a value to a map's key ? 2. Can I map have more than one key, in query:eval ? Please point me in right direction, or explain what am I doing wrong in above code .. - Mansi

3 9

Import a large XML file and add an attribute on all children
by Mallika Jimmy 31 Oct '14

31 Oct '14

Hello, We have a requirement to create a database by importing a large XML file. During this process, we also want to insert a particular attribute on all child nodes. Which is the efficient method to do the same? The file size is nearly 1GB. Thanks in advance, Mallika Jacob

3 5

NFS mount point query execution
by Sateesh 31 Oct '14

31 Oct '14

HI Basex, We have created collections on a machine and attached that collection location to our application server system as a mount point. Basex is running in standalone mode in that application server.When we execute queries by placing the collections on local system we are getting response in 2sec's but when the same query is executed on a collection which is on mount point it is taking 18sec's of time.Could you please help us by telling us the way to reduce the time even when running the query on a collection which is on mount point. Thanks & Regards SAteesh.A 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.

3 4

Cast exception on recursion+map
by Marco Lettere 30 Oct '14

30 Oct '14

Hello all, I've stumbled upon an issue with the latest version and in particular the code I provide was working with 8.0 snapshot up to build 496C381 and with all previous official versions of course. Build 151df63 is the first build I'm aware of the difference. Shortly. In an input document I have a list of env nodes (sort of <env name="n">v</env>). They need to be parsed and "xquery:eval(uated)" in sequence because following env nodes may refer to preceding ones (i.e. <env name="n1">v1</env>, <env name="n2">{$n1}</env>). I've managed to do the job with the following code but now (as described in the preamble) I get the following cast exception in the xquery:eval: Stopped at [...]/file, 9/31: ---> (this points to the line with the xquery:eval call) [XPTY0117] Cannot cast xs:untypedAtomic to xs:QName. I've absolutely no idea why it started giving this error and even looking at the queryplan is too difficult in such a scenario for me. Anyone can help me out? Thanks, This is the smallest example of the code I was able to produce: declare function local:declarations($env as map(*)){ string-join( map:keys($env) ! ( "declare variable $" || . || " external;") ) }; declare function local:updateenv($envnode as node(), $env){ let $q := local:declarations($env) || serialize($envnode) let $dynnode := xquery:eval($q, $env) return map:new(( map:entry($envnode/data(@name), $dynnode/text()), $env )) }; declare function local:buildenv($envnodes as node()*, $env as map(*)) { if(empty($envnodes)) then $env else let $envnode := $envnodes[1] let $newenv := local:updateenv($envnode, $env) return map:new(( $newenv, local:buildenv($envnodes[position() > 1], $newenv))) }; map:serialize( local:buildenv((<env name="n1">v1</env>, <env name="n2">another {{$n1}}</env> ), map{}) )

2 3

Annoying behaviour of file:resolve-path
by Marc van Grootel 28 Oct '14

28 Oct '14

Hi, For a while I wasn't aware, then I noticed it and then I got annoyed by it. It's not a big issue but it does require extra code to work around this, in my opinion, annoying behaviour. When using file:resolve-path it depends if the file exists or not. The output is different. Say I have an existing directory F:\tmp then file:resolve-path('F:/tmp') => F:\tmp\ However, when I have a path that points to a non-existing directory (or file, we cannot know!) file:resolve-path('F:/tmp/not-exists') => F:/tmp/not-exists Notice the absence of a slash. I guess the assumption that is made is that in the future this will refer to a file and not a directory. The same behaviour occurs with file:path-to-uri(), and file:base-dir() also returns a path with a trailing slash. I think that this is annoying, or let's say at least, inconsistent behaviour and had me add code that defensively strips of trailing slash. I cannot rely on file:resolve-path results because if a directory doesn't exist it has no slash at the end, and if it does it has and sometimes I don't want to check for existence at that point. When combining paths I tend to use string-join($parts,'/') and having slash at the end of URL's and filesystem paths doesn't feel right so I always strip them off. Hope I didn't sound too grumpy ;-) Opinions? Guess, changing it would trip up a lot of existing path handling code. --Marc

2 4

Latest build is empty ...
by Marco Lettere 28 Oct '14

28 Oct '14

Hi all, I have a chunk of code (focused on xquery:eval) that somehow broke between the builds 151df63 (not working) and 496C381 (working) of the latest snapshot. 7.9 worked. Since I don't remember when the two build were downloaded I'm not able to classify them according to time thus before signaling the different behaviour I wanted to test the code with the current latest snapshot. Unfortunately the download is not complete since the ZIP file doesn't contain BaseX.jar and neither of the files in the bin folder. Any clue on what happened? Thank you, Marco.

2 1