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

Global locks
by Andy Bunce 11 Feb '19

11 Feb '19

Running the following in the GUI (8.6.5) ``` let $db:="BEP" return count(collection($db)) ``` The info windows shows $db is inlined Compiling: - inline $db_0 - pre-evaluate collection("BEP") to document-node() sequence - pre-evaluate count((db:open-pre("BEP",0), ...)) to xs:integer - simplify gflwor Optimized Query: 9193 All good. Submitting a job ``` let $q:='let $db:="BEP" return count(collection($db))' return jobs:eval($q,(),map{"cache":true()})!(jobs:wait(.),jobs:list-details(.)) ``` returns: <job id="job90" type="ScheduledXQuery" state="cached" user="admin" duration="PT0.007S" reads="(global)" writes="(none)">let $db:="BEP" return count(collection($db))</job> Note @reads="(global)" But ``` let $q:='count(collection("BEP"))' return jobs:eval($q,(),map{"cache":true()})!(jobs:wait(.),jobs:list-details(.)) ``` <job id="job92" type="ScheduledXQuery" state="cached" user="admin" duration="PT0.006S" reads="BEP" writes="(none)">count(collection("BEP"))</job> Note @reads="BEP" Is this correct and/or of any consequence? /Andy

2 8

oXygen XML, content negotiation and #1220
by Omar Siam 20 Feb '18

20 Feb '18

Hi list! I like my oXygen editor to request raw XML data from my RESTxq endpoints to test XSL stylesheets. When I do this with RESTxq paths that have different %rest:produces it fails with the BASX0003 multiple functions error. Turns out oXygen sends application/xml, */* as Accept header without any quality. I understand that as documented in https://github.com/BaseXdb/basex/issues/1220 this is known not to work. My/our workaround is to branch in a single XQuery function using sth. like: if (some $a in tokenize(request:header("ACCEPT"), ',') satisfies $a = ('text/xml', 'application/xml')) then $xml else $xhtml I hope this is still on the agenda for 8.7. Best regards Omar Siam

3 7

Preparing BaseX 8.5.4 (please don't forget Issue #1341)
by Jan Dölle 20 Feb '18

20 Feb '18

Hi, we noticed you prepare release 8.5.4. Please don't forget to fix issue: SQL with BaseX 8.5.3 #1341 Thx Jan -- Jan Dölle E-Mail: basex-list(a)id1.de Telefon +49-69-244502-0 Home: www.id1.de Information Design One AG, Baseler Straße 10, 60329 Frankfurt am Main Registereintrag: Amtsgericht Frankfurt am Main, HRB 52596 Vorstand: Robert Peters, Aufsichtsrat: Christian Hecht (Vorsitz)

4 5

Issue with Full Text Retrieval
by Ron Katriel 06 Nov '17

06 Nov '17

Hi, I am seeing strange behavior with Full Text retrieval. The following query fails for a number of words that are in the XML document (see attached): for $trial in db:open('CTGovDebug') (: [clinical_study/id_info/nct_id='NCT00473512'] :) return $trial contains text { 'neoplasms' } It fails on a good number of words including neoplasms, cougar, industry, yes, completed, november, 2005, interventional, single, male, female, assignment, none, research, principal, primary, secondary, age, years, gender, etc. But it matches most of the words in the file. Observation: The words that fail are located at the beginning and/or end of the text *and* do not occur anywhere else in the middle of any text. The document is the only one in the database. It does not make a difference whether full text indexing is on or off. My BaseX version is 8.6.4. Thanks, Ron Ron Katriel, Ph.D. | Principal Data Scientist | Medidata Solutions <http://www.mdsol.com/> 350 Hudson Street, 7th Floor, New York, NY 10014 rkatriel(a)mdsol.com <tbrophy(a)mdsol.com> | direct: +1 201 337 3622 <//201 337 3622> | mobile: +1 201 675 5598 <//+1 201 675 5598> | main: +1 212 918 1800 <//+1 212 918 1800>

4 9

Flexible update via function
by michael4you＠arcor.de 01 Nov '17

01 Nov '17

Hello, How to add/replace a complete node in a node tree, with done by a function and by according function parameters. That means with flexible instructions. Such as: declare function local:NodeAdd($XML, $XMLPath, $XMLValue) { ?? }; let $XML := <root><xml>text</xml></root> let $XMLAdd := <B>BBB</B> let $XMLPath := $XML/xml return local:NodeAdd($XML, $XMLPath , $XMLAdd) Problem: Following examples didn't work, because an internal reference to copy-XML-structure is needed/forced. example 1: copy / modify declare function local:NodeAdd($XML, $XMLPath, $XMLValue) { copy $XML2 := $XML modify ( insert node $XMLValue into $XML2/xml ) return $XML2 }; But: Instead of into $XML2/xml, into $XML/xml is needed, respectively into $XMLPath Thanks a lot Michael

3 3

UnaryLookup expression failure
by Gunther Rademacher 01 Nov '17

01 Nov '17

While testing some XQuery lookup expressions on BaseX 8.6.7, I got a wrong result for this one: (map{'a':(1,3)},map{'a':(2,4)})!?a[2] It should have returned the second item of the 'a' entry for each of the maps, i.e. 3 4 but it returns just 3 Apparently the predicate is applied as if everything before it was in parentheses, i.e. as if it were ((map{'a':(1,3)},map{'a':(2,4)})!?a)[2] The (simplified) parse tree for the original expression and the XQuery 3.1 grammar however indicates that the predicate is part of the mapping target expression: <SimpleMapExpr> <ParenthesizedExpr> ... </ParenthesizedExpr> <TOKEN>!</TOKEN> <PostfixExpr> <UnaryLookup> <TOKEN>?</TOKEN> <NCName>a</NCName> </UnaryLookup> <Predicate> <TOKEN>[</TOKEN> <IntegerLiteral>2</IntegerLiteral> <TOKEN>]</TOKEN> </Predicate> </PostfixExpr> </SimpleMapExpr> Best regards Gunther

2 1

Re: [basex-talk] Peculiar External Binding and Casting Behaviour
by Shaun Flynn 31 Oct '17

31 Oct '17

Hello there, I found the problem! My code added a trailing space to the values of the variables when binding. After tokenizing in the XQuery, this creates a zero length string which when cast to xs:integer then becomes an xs:double according to the error message. Is this intended behaviour? Shaun On 31 Oct 2017 06:20, "Shaun Flynn" <scfy12(a)googlemail.com> wrote: > Hello there, > > I found the problem! My code added a trailing space to the values of the > variables when binding. > > After tokenizing in the XQuery, this creates a zero length string which > when cast to xs:integer then becomes an xs:double according to the error > message. > > Is this intended behaviour? > > Shaun > > On 30 Oct 2017 17:39, "Shaun Flynn" <scfy12(a)googlemail.com> wrote: > >> Hello there, >> >> I created a simple example using the BaseX Java API, and that worked >> fine, also using my code to create the query and submit it to a >> ClientSession worked ok too :( >> >> This was the query I ran: >> >> declare variable $items external := "123 NIL"; >> declare variable $tokenizedItems:= tokenize($items," "); >> >> for $item in $tokenizedItems >> return >> if($item = "NIL") then ("Nil") else (xs:integer($item)) >> >> Unable to reproduce the earlier result from today using my code as well :( >> >> So I can understand the error better: "[FORG0001] Cannot cast to >> xs:double: ." >> >> The full stop after xs:double , does that relate to a decimal point or >> the current item (xquery .) >> >> Shaun >> >> On 30 October 2017 at 10:31, Christian Grün <christian.gruen(a)gmail.com> >> wrote: >> >>> Thanks. Some few lines of Java Code might already be sufficient >>> (provided that the problem can be reproduced with the XQuery snippet >>> that you sent in your last mail). >>> >>> On Mon, Oct 30, 2017 at 11:24 AM, Shaun Flynn <scfy12(a)googlemail.com> >>> wrote: >>> > Hello there, >>> > >>> > I will put something together for you later on today in a .zip file. >>> > >>> > Shaun >>> > >>> > On 30 October 2017 at 10:22, Christian Grün <christian.gruen(a)gmail.com >>> > >>> > wrote: >>> >> >>> >> > However, when I bind variables externally in Java, still getting the >>> >> > same >>> >> > problem, and I definitely not putting quotes around them there. >>> >> >>> >> Do you have an example that might help me to reproduce it? >>> >> >>> >> >>> >> > $depotConstraint: PM >>> >> > $resourceConstraint: 143/6 >>> >> > $lowerDiagConstraint: 251 >>> >> > $upperDiagConstraint: 258 >>> >> > Oct 30, 2017 9:05:33 AM units.forms.UnitDiagramsController >>> >> > fetchSelectedDiagrams >>> >> > SEVERE: null >>> >> > org.basex.core.BaseXException: Stopped at ., 29/61: >>> >> > [FORG0001] Cannot cast to xs:double: . >>> >> > >>> >> > >>> >> > >>> >> > On 30 October 2017 at 09:57, Christian Grün < >>> christian.gruen(a)gmail.com> >>> >> > wrote: >>> >> >> >>> >> >> HiShaun, >>> >> >> >>> >> >> > I do not understand why that should be as there is clearly no >>> mention >>> >> >> > of >>> >> >> > xs:double in this query! >>> >> >> >>> >> >> I agree that the error message is misleading. You already get it >>> when >>> >> >> invoking the following expression: >>> >> >> >>> >> >> 'a' cast as xs:integer >>> >> >> >>> >> >> I need to check the code, but I assume that an additional double >>> >> >> conversion check takes place in the background in order to ensure >>> that >>> >> >> the value can actually be converted to a non-fractional number. >>> >> >> >>> >> >> For more information on your query, it would be great if you could >>> >> >> reduce it to a self-contained example that runs out of the box (I >>> >> >> tried to invoke it, but your code seems to rely on an opened >>> >> >> database). >>> >> >> >>> >> >> Best, >>> >> >> Christian >>> >> > >>> >> > >>> > >>> > >>> >> >>

1 0

Peculiar External Binding and Casting Behaviour
by Shaun Flynn 30 Oct '17

30 Oct '17

Hello there, I am having issues with the following query: declare default element namespace "http://www.tracsis.com/TTVP_Interface"; declare variable $date := "2017-07-10"; declare variable $daysRun := 3; declare variable $diagrams := diagramExchange/unitDiagramList/unitDiagram[@startdate<=$date][@enddate>=$date][substring(@daysrun,$daysRun,1)="Y"]; *declare variable $depotConstraint external;* *declare variable $resConstraint external;* *declare variable $lowerDiagNoConstraint external;* *declare variable $upperDiagNoConstraint external;* *declare variable $depots := tokenize($depotConstraint," ");* *declare variable $resources := tokenize($resConstraint," ");* *declare variable $lowerDiagNo := tokenize($lowerDiagNoConstraint," ");* *declare variable $upperDiagNo := tokenize($upperDiagNoConstraint," ");* declare function local:begin($diagrams, $index) { local:applyDiagStartFilter($diagrams,$index) }; (: Chain of responsibility pattern used here : once one function exits, passes to the next:) declare function local:applyDiagStartFilter($diagrams, $index) { let $diagNo := $lowerDiagNo[$index] return if($diagNo = "NIL") then (local:applyDiagEndFilter($diagrams, $index)) else *(local:applyDiagEndFilter($diagrams[@id >= $diagNo cast as xs:integer]*, $index)) }; declare function local:applyDiagEndFilter($diagrams, $index) { let $diagNo := $upperDiagNo[$index] return if($diagNo= "NIL") then (local:applyResFilter($diagrams, $index)) else (local:applyResFilter($diagrams[@id <= $diagNo cast as xs:integer], $index)) }; declare function local:applyResFilter($diagrams, $index) { let $res := $resources[$index] return if($res = "NIL") then (local:applyDepotFilter($diagrams, $index)) else (local:applyDepotFilter($diagrams[res/@id = $res], $index)) }; declare function local:applyDepotFilter($diagrams, $index) { let $depot := $depots[$index] return if($depot = "NIL") then ($diagrams) else ($diagrams[depot/@id = $depot]) }; for $depot in $depots count $count return local:begin($diagrams, $count) The underlined sections are the ones giving an issue. When I set the following like so: *declare variable $depotConstraint := "PM OC";* *declare variable $resConstraint := "NIL 180/1";* *declare variable $lowerDiagNoConstraint := "NIL NIL";* *declare variable $upperDiagNoConstraint := "NIL NIL";* The query runs fine. When I try and set these externally, I get error "FORG0001 : Cannot cast to xs:double" at the following underlined location: declare function local:applyDiagStartFilter($diagrams, $index) { let $diagNo := $lowerDiagNo[$index] return if($diagNo = "NIL") then (local:applyDiagEndFilter($diagrams, $index)) else *(local:applyDiagEndFilter($diagrams[@id >= $diagNo cast as xs:integer]*, $index)) }; I do not understand why that should be as there is clearly no mention of xs:double in this query! Also, this happens when $diagNo is "NIL" which is even more perplexing as that would suggest it fails the "if" test somehow. The $xxxxConstraint variables are all supplied as strings. What am I doing wrong? I am using BaseX 8.6.7 in Java 8. Shaun

2 1

Using Basex-GUI in Java
by Tushar Deshmukh 29 Oct '17

29 Oct '17

Namaste All, I wants to use Tableview of basex for reporting purpose in my java application. But unable to instantiate. Please help. Bellow is the tried code. public static void main(String[] args) { TableView t = new TableView( ) ; } Can I use this for RDBMS applications also. Regards, Tushar

2 1

Architecture question
by Dave Day 27 Oct '17

27 Oct '17

Greetings list, I have an idea of how I want to use Basex, and would like to know if what I am wanting to do will work. My background is IBM mainframe, so the terminology I use is influenced by that. I have a server running in an address space on a mainframe. Within that address space are multiple tasks active. I believe the term task is equivalent to a thread in the distributed world. I would like to have a task initialize when my server comes up and establish a connection to an instance of a Basex server. This task would be responsible for processing requests that come in from the Basex server. On a browser, I want to have a user connect to an instance of the Basex HTTP server. From the manual, it states that if the HTTP server is started, the client server is started as well. I don't know if this is all one instance of a Basex, or if there are actually two processes that get established. The HTTP server will need to know if the connection has been established between the mainframe and the client server. Is this possible, and if so, how would that be accomplished? Assuming that the user on the browser needs some information from my mainframe server, is there a mechanism in place to facilitate the HTTP server sending the request to the client server, and the client server sending the request to the mainframe. Would the mainframe have to do a poll of some kind to see if there was data, or can the client server push the request out across the connection? If the above works, that is, Basex acting as a message broker between a browser and the mainframe, I want to be able to create another connection from another task on the mainframe to the Basex client server as a result of a user request on a browser, have that 2nd task create a new database, and start pushing xml across that 2nd connection. While that new database is being updated from the mainframe, can the user on the browser query the new database to get the most current data? Regards, -- Dave Day

4 21