Re: [basex-talk] DBA - display the number of results from a query

2015-07-14 Thread Christian Grün
Hi James, I’m finding the web DBA functionality of BaseX more and more useful but one thing I really miss from the GUI is the display of the number of results in the top right corner. Many times when I’m running a quick query I want to know how many results there are and see at least an

Re: [basex-talk] Behaviour of doc() changed?

2015-07-14 Thread Christian Grün
Hi Marco, when using doc() we used to pass into it a relative (to the static base uri) filesystem path to an xml file. This was parsed without any problems. Now (basex 8.2.2) the parsing works but we get on the standard output stating that the database (named as the first path element) does

Re: [basex-talk] Reporting function for a subset

2015-07-14 Thread Christian Grün
Hi Menashè, Is it possible? Yes, it should be, because you can do nearly everything in XQuery.. However, I must confess I have no idea how to help you right now.. What about the reporting function, does it already exist? What is a subset: Is it a sequence of XML nodes resulting from a path

Re: [basex-talk] Reporting function for a subset

2015-07-14 Thread Menashè Eliezer
Hi, The initial of the code should be modified, so here is only the essence of one of the pivoting reports: for $singleDataType in $dataType for $singleDevice in $device for $singleAvailability in $availability for $singleCountry in $country for $singleParameter in $parameter group by

Re: [basex-talk] Slow query

2015-07-14 Thread Christian Grün
Should geo:within of http://docs.basex.org/wiki/Geo_Module help? The functions of the Geo Module don't use any index structures, so I am afraid they won't speed up the query. One more idea: you could convert all latitudes and longitudes to strings with a fixed number of digits

Re: [basex-talk] Reporting function for a subset

2015-07-14 Thread Menashè Eliezer
I'm sorry, but it's not clear how $nodes can include the result of my main query: xquery version 3.0; declare option output:item-separator ,; let $db := db:open(CDI) for $x in $db let $beginPosition := $x//startTime let $lon := xs:float($x//longitudine) let $lat :=

Re: [basex-talk] Reporting function for a subset

2015-07-14 Thread Menashè Eliezer
Thank you, but would you please show me how to pass (only once) for each function the xml sequence which results from my main query, instead of simple numbers as in your example? With kind regards, Menashè On 07/14/2015 12:30 PM, Christian Grün wrote: I hope it's clear. Sorry, I'm still

Re: [basex-talk] Behaviour of doc() changed?

2015-07-14 Thread Marco Lettere
Hi Christian, you're right usual mistake of sending emails in the evening. :-D This morning I setup an example that reproduced the strange issue. Added this function to restxq.xqm: declare %rest:path(/doc/{$dir}) %rest:GET function page:getdoc($dir as xs:string) { doc($dir || /doc.xml)

Re: [basex-talk] Slow query

2015-07-14 Thread Christian Grün
oops, I'm sorry. It's attached. There are text and attribute indexes. It may be slightly faster if you remove the explicit string() conversion: for $x in db:open(CDI) let $beginPosition := $x//startTime where $beginPosition = 1889-01-01 and $beginPosition = 2015-07-10 return

Re: [basex-talk] Reporting function for a subset

2015-07-14 Thread Christian Grün
E.g. like that: let $count := function($nodes) { count($nodes) } let $nodes := (a/, b/) return $count($nodes) On Tue, Jul 14, 2015 at 12:41 PM, Menashè Eliezer melie...@ogs.trieste.it wrote: Thank you, but would you please show me how to pass (only once) for each function the xml

Re: [basex-talk] Reporting function for a subset

2015-07-14 Thread Christian Grün
What about this? let $nodes := let $db := db:open(CDI) for $x in $db let $beginPosition := $x//startTime let $lon := xs:float($x//longitudine) let $lat := xs:float($x//latitudine) where $beginPosition=1889-01-01 and $beginPosition=2015-07-10 and $lat=46.733 and $lat=-67.81

Re: [basex-talk] Behaviour of doc() changed?

2015-07-14 Thread Christian Grün
Hi Marco, thanks for the details. Do you possibly have debug set to true? In that case, there is no need to worry. Best, Christian On Tue, Jul 14, 2015 at 10:22 AM, Marco Lettere marco.lett...@dedalus.eu wrote: Hi Christian, you're right usual mistake of sending emails in the evening. :-D

Re: [basex-talk] Reporting function for a subset

2015-07-14 Thread Menashè Eliezer
Hi Christian, On 07/14/2015 09:30 AM, Christian Grün wrote: What about the reporting function, does it already exist? What is a subset: Is it a sequence of XML nodes resulting from a path expression? Could you possibly provide us with some code you have written so far? Christian I mean a

[basex-talk] BaseX 8.2.3

2015-07-14 Thread Christian Grün
Dear all, Just one week passed, and a new version of BaseX is available. It provides a fix for a minor problem with the DBA code and some namespace issues. All the best, Christian

Re: [basex-talk] Slow query

2015-07-14 Thread Menashè Eliezer
Hi, It sounds like a great idea and I can also implement it to the date comparisons, but unfortunately the new query is much slower. Please see the attached log. With kind regards, Menashè On 07/14/2015 12:50 PM, Christian Grün wrote: Should geo:within of

Re: [basex-talk] Reporting function for a subset

2015-07-14 Thread Menashè Eliezer
Thank you for the helpful ideas! With kind regards, Menashè On 07/14/2015 12:56 PM, Christian Grün wrote: What about this? let $nodes := let $db := db:open(CDI) for $x in $db let $beginPosition := $x//startTime let $lon := xs:float($x//longitudine) let $lat :=

Re: [basex-talk] Slow query

2015-07-14 Thread Christian Grün
...it only makes sense if you store the data in its normalized representation. On Tue, Jul 14, 2015 at 2:42 PM, Menashè Eliezer melie...@ogs.trieste.it wrote: Hi, It sounds like a great idea and I can also implement it to the date comparisons, but unfortunately the new query is much slower.

Re: [basex-talk] Slow query

2015-07-14 Thread Menashè Eliezer
:) I've thought to do it as a second step, but I should do it earlier. Thank you. With kind regards, Menashè On 07/14/2015 03:22 PM, Christian Grün wrote: ...it only makes sense if you store the data in its normalized representation. On Tue, Jul 14, 2015 at 2:42 PM, Menashè Eliezer

Re: [basex-talk] HTTP module and cookies

2015-07-14 Thread Andy Bunce
In my experience the case that causes the most problem is the authentication redirect. I have never tried this with BaseX but I have been very grateful in the past that XMLCalabash implements this: The exception arises in the case of redirection. If a redirect response includes cookies, those

Re: [basex-talk] Slow query

2015-07-14 Thread Christian Grün
Hi Menashè, The attached log file is empty. Maybe it's sufficient if you provide us with the query and give us information on the query compilation (are any indexes used?). C. On Mon, Jul 13, 2015 at 3:32 PM, Menashè Eliezer melie...@ogs.trieste.it wrote: Hello, Creating a database of

Re: [basex-talk] HTTP module and cookies

2015-07-14 Thread Lizzi, Vincent
The EXPath HTTP Client does seem to provide low level HTTP access. I am hoping to find an XQuery library that implements some common things such as cookies and authentication on top of HTTP Client, but haven’t come across such a library yet. There are a few OATH implementations for

[basex-talk] Whitespace

2015-07-14 Thread meumapple
Hi, When I use the file:write function, the whitespaces before an element are deleted (and also the initial whitespace of a string in an element). This is a problem for elements containing text and elements. Is there a way to avoid this? Thanks. J.

Re: [basex-talk] Whitespace

2015-07-14 Thread Marc
Hi You can use the serialisation parameter with no indent option. Marc On July 14, 2015 8:13:09 PM CEST, meumapple meumap...@gmail.com wrote: Hi, When I use the file:write function, the whitespaces before an element are deleted (and also the initial whitespace of a string in an element). This