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

Possible to Access Environment Variables from XQuery?
by Eliot Kimber 25 Mar '17

25 Mar '17

I’m running BaseX in a Docker container started via docker-compose. I need to communicate some local configuration details to BaseX. Can set these as environment variables (e.g., using .env with docker-compose) but I don’t see anything in the docs that would let me access environment variables from XQuery. Is there a built-in way to do this? Thanks, Eliot -- Eliot Kimber http://contrext.com

3 3

and operator in Multiple Predicates
by Tushar Deshmukh 23 Mar '17

23 Mar '17

Namaste , and operator in predicates seems tobe not working. my xquery is as below and xml is attached herewith. declare namespace UDF="TallyUDF"; let $fromdate:=20170228 let $todate:=20170228 let $pledger_code:=57 let $pledger_status:="P" for $allitems in db:open('10096',"Vouchers")/ENVELOPE/Voucher[./Date/text() >= $fromdate and ./Date/text() <= $todate and ./AllLedgerEntries.LIST/UDF:AsPerListAllocations.LIST/UDF:ColPartyCode.LIST/UDF:ColPartyCode/text()= $pledger_code and ./AllLedgerEntries.LIST/UDF:AsPerListAllocations.LIST/UDF:MaheshCIFlag.LIST/UDF:MaheshCIFlag/text()= $pledger_status] return $allitems/MasterId Expected 2 records/nodes instead 4. Tushar Deshmukh,

2 1

Calling the sort function with two arguments
by Martin Honnen 22 Mar '17

22 Mar '17

According to https://www.w3.org/TR/xpath-functions-31/#func-sort the sort function allows one or two or three arguments, however when doing sort((5, 3, 4, 1), default-collation()) in BaseX 8.6.2 I get an error java.lang.ArrayIndexOutOfBoundsException: 2 at org.basex.query.func.fn.FnSort.iter(FnSort.java:34) at org.basex.query.QueryContext.iter(QueryContext.java:394) at org.basex.query.scope.MainModule.iter(MainModule.java:117) at org.basex.query.QueryContext.iter(QueryContext.java:330) at org.basex.query.QueryContext.cache(QueryContext.java:609) at org.basex.query.QueryProcessor.cache(QueryProcessor.java:113) at org.basex.core.cmd.AQuery.query(AQuery.java:86) at org.basex.core.cmd.XQuery.run(XQuery.java:22) at org.basex.core.Command.run(Command.java:257) at org.basex.core.Command.execute(Command.java:93) at org.basex.gui.GUI.exec(GUI.java:471) at org.basex.gui.GUI.access$300(GUI.java:44) at org.basex.gui.GUI$6.run(GUI.java:413) A similar error occurs with sort((5, 3, 4, 1), ()) Is BaseX 8.6.2 not yet in line with the freshly published spec? Regards, Martin Honnen

2 2

BaseX Client for Erlang
by Christian Grün 22 Mar '17

22 Mar '17

Dear all, Zachary Dean has written an Erlang client binding for BaseX: https://github.com/zadean/basexerl Thanks, Zachary! I have just added the Erlang binding to our Wiki [1]. As a result, we now have 18 different client bindings for BaseX. All the best everyone, Christian [1] http://docs.basex.org/wiki/Clients

1 0

Multipart form-data submissions from RESTXQ
by Tim Thompson 20 Mar '17

20 Mar '17

Hello, I have been agonizing over a problem with a service I'm trying to call from RESTXQ. The service (www.tei-c.org/oxgarage/) only accepts multipart/form-data submissions. It provides a front-end client for uploading files from the browser, which calls a back-end RESTful service to do document conversion. I've installed a local instance of the service ( https://github.com/TEIC/oxgarage) and have it running on Tomcat 7, along with BaseX. The problem arises when I try to submit documents with non-ASCII characters from RESTXQ. Looking at the network traffic, I can see that if the document contains only ASCII characters, the multipart submission body is not base64 encoded. For example: Encapsulated multipart part: (text/xml) Content-Disposition: form-data; name='fileToConvert'; filename='homework.xml'\r\n Content-Type: text/xml\r\n\r\n eXtensible Markup Language <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta/> <title> Test </title> </head> <body> <math xmlns="http://www.w3.org/1998/Math/MathML"> <msub> <mi/> <mn> 2 </mn> </msub> </math> </body> </html> However, if the document does contain non-ASCII characters (such as β), BaseX sets the Content-Transfer-Encoding to "base64." This causes the OxGarage service to fail because it thinks it is receiving an image file rather than a textual document. For example: Content-Type: text/xml\r\n Content-Transfer-Encoding: base64\r\n\r\n eXtensible Markup Language [truncated] PGh0bWwgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkveGh0bWwiPjxoZWFkPjxtZXRhLz48\r\ndGl0bGU+VGVzdDwvdGl0bGU+PC9oZWFkPjxib2R5PjxtYXRoIHhtbG5zPSJodHRwOi8vd3d3Lncz\r\nLm9yZy8xOTk4L01hdGgvTWF0aE1MIj48bXN1Yj48bWk+zrI8L21pPjxtbj5Ud288L21 Attached here is a basic test case to replicate the problem: an HTML page with a form and the RESTXQ function that it calls. I've tried setting a new header to specify Content-Transfer-Encoding as "binary" instead of "base64," but it doesn't replace the default header. Is there any way that the encoding could be controlled from RESTXQ? Thanks in advance! Tim -- Tim A. Thompson Metadata Librarian (Spanish/Portuguese Specialty) Princeton University Library www.linkedin.com/in/timathompson tat2(a)princeton.edu

3 9

Index on specific node
by Tushar Deshmukh 20 Mar '17

20 Mar '17

Namaste All, Can we index the database only on one/few specific node. I am not able to find out the help or might be putting different text for search. Thanks Tushar Deshmukh

2 1

Re: [basex-talk] Angular(2) ToH with Basex backend
by Rob Stapper 18 Mar '17

18 Mar '17

Hi Christian, Works like a charm. %output:media-type("application/json") did the trick. Thanks, Rob -----Oorspronkelijk bericht----- Van: Christian Grün [mailto:christian.gruen@gmail.com] Verzonden: vrijdag 17 maart 2017 15:48 Aan: Rob Stapper Onderwerp: Re: [basex-talk] Angular(2) ToH with Basex backend Hi Rob, > because of the use of a map:entry function. Maps and arrays are function items; this is the reason why they are currently not cached (they can contain nested function items, which refers to code that will not be available after execution). To solve this, just serialize your result via db:output(json:serialize(...)) and use %output:media-type("application/json"). Cheers, Christian PS: Better write to the mailing list, so that everyone else can follow our conversation. > > It would be nice if updating REST-function also are able to output > maps and arrays (transformed to JSON, ofcourse) > > [ 1] > declare > %rest:path("/{$dataBase}/{$objectType}") > %rest:POST("{ $dataRec}") > %input:json("format=map") > > %output:method("json") > %output:indent("no") > %updating > function _:dataRecord.create > ( $dataBase as xs:string > , $objectType as xs:string > , $dataRec as map(*) > ) > { > let $objectTable := objectTable:add( dbx:objectTable( $dataBase, > $objectType) > , object:new( $dataRec) > ) > let $result := map:entry( 'objectID', objectTable:objectID( > $objectTable)) > return ( dbx:flush( $dataBase > , $objectType > , $objectTable > ) > , db:output( ( _:responseHeader( ) > , $result > ) ) > ) > } ; > > > Christian Grün schreef op 17.03.2017 13:23: > >>> [1] example: ( not muti-user proof) >>> let $step1 := db:open('db', 'doc.xml') (: $step1/data/@id => i :) >>> let $step2 := $step1 update { replace value of node ./@id with ( 1 >>> + >>> ./@id)}) >>> (: multi-user gap :) >>> return ( >>> db:replace('db', 'doc.xml', $step2) >>> db:output( $step2/@id) >>> ) >> >> >> There won’t be a multi-user gap, because our transaction management >> (see http://docs.basex.org/wiki/Transaction_Management) and the >> execution via the Pending Update List will ensure that no other user >> will interfere. >> >> If you NEED to give other users the chance to update the replaced >> document in between, there will be no other chance to split your >> query into two separate steps. But I think there will be no reason to >> do that?

1 0

Element constructors
by Joseph 17 Mar '17

17 Mar '17

Hi, I have an xml file consisting (only) of many elements similar to this <re> <de>something</de> <se>something</se> <id>something</id> something <s>something</s> <h>something</h> something <m>something</m> </re> and a simple query like this let $t := doc("file.xml") for $a in $t//re let $b := $a/de let $c := $a/se return (element r {attribute f {$b || "-" || $c}, {$a/id/data(.)}, <f>{$b/data(.)}</f>, {$a/p/data(.)}, <l>{$c/data(.)}</l>, <s>{$a/s/data(.)}</s> ,<h>{$a/h/data(.)}</h>, {$a/b/data(.)}, <m>{$a/m/data(.)}</m> }) I have noticed that while the preceding query works fine, if I substitute all the elements in it (e.g, <s>{$a/s/data(.)}</s>) with their contents ($a/s/) (i.e., I expect that the exact same element of the document is inserted), BaseX gets out of main memory. Any explanation? Thanks. Joseph

4 4

Fwd: Donation link does not work.
by Tomasz Kosiński 17 Mar '17

17 Mar '17

Hello, I wanted to show a sign of appreciation to the work you are doing with BaseX, which is in my opinion an exceptionally well done XML database which helped me dozen of times by doing data analysis on large XML data sets. But the donation link on your page leads to nowhere. -- Best regards *Tomasz Kosiński* TestLab Services Tomasz Kosiński P: +48 602247984 <+48%20602%20247%20984> S: maqmanahan NIP: 6721889805 -- Best regards *Tomasz Kosiński* TestLab Services Tomasz Kosiński P: +48 602247984 S: maqmanahan NIP: 6721889805

3 3

XQUERY UPDATE question
by mark bordelon 16 Mar '17

16 Mar '17

Guten Tag, die Herren! I have a question about how I can insert, replace a node with a DOM node, instead of the text of that node. Right now when I 1) execute from the basex shell this command: xquery replace value of node /text//sent[@id=15] with <sent id=15><clause><word/><word/><word/></clause></sent> 2) and then look at that node again with xquery /text//sent[@id=15]i see that the dom has been converted into a text node of <sent id=15><clause><word/><word/><word/></clause></sent> How can I replace with true DOM and not have it convert to text?

3 5

Potential bug when inlining?
by Clemens Müthing 14 Mar '17

14 Mar '17

Hello After some feedback from Christina I got the advice that I can use the %basex:inline annotation to force inlining. When I gave this a try everything was working fine, but after some more modifications to my code I know get this nice error message: Improper use? Potential bug? Your feedback is welcome This error does not appear any longer if I remove the %basex:inline annotation again. Let me know if you need some more information, in the meantime I’ll try to rearrange some code and see if this will make the problem disappear. Thanks Clemens ------------------------------------- So this is the complete output regarding the error etc: Error: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 8.6.1 Java: Oracle Corporation, 1.8.0_112 OS: Mac OS X, x86_64 Stack Trace: java.lang.RuntimeException: $year_183 index: 4, slot: 4 at org.basex.util.Util.notExpected(Util.java:62) at org.basex.query.var.QueryStack.pos(QueryStack.java:101) at org.basex.query.var.QueryStack.set(QueryStack.java:123) at org.basex.query.QueryContext.set(QueryContext.java:756) at org.basex.query.expr.gflwor.Let$LetEval.next(Let.java:184) at org.basex.query.expr.gflwor.GFLWOR.value(GFLWOR.java:71) at org.basex.query.expr.TypeCheck.value(TypeCheck.java:131) at org.basex.query.func.Closure.item(Closure.java:288) at org.basex.query.func.Closure.item(Closure.java:34) at org.basex.query.expr.ParseExpr.toItem(ParseExpr.java:488) at org.basex.query.expr.ParseExpr.toFunc(ParseExpr.java:628) at org.basex.query.func.StandardFunc.checkArity(StandardFunc.java:363) at org.basex.query.func.map.MapForEach.value(MapForEach.java:22) at org.basex.query.func.map.MapForEach.iter(MapForEach.java:17) at org.basex.query.QueryContext.iter(QueryContext.java:394) at org.basex.query.scope.MainModule.iter(MainModule.java:117) at org.basex.query.QueryContext.iter(QueryContext.java:330) at org.basex.query.QueryContext.cache(QueryContext.java:609) at org.basex.query.QueryProcessor.cache(QueryProcessor.java:113) at org.basex.core.cmd.AQuery.query(AQuery.java:86) at org.basex.core.cmd.XQuery.run(XQuery.java:22) at org.basex.core.Command.run(Command.java:257) at org.basex.core.Command.execute(Command.java:93) at org.basex.gui.GUI.exec(GUI.java:471) at org.basex.gui.GUI.access$300(GUI.java:44) at org.basex.gui.GUI$6.run(GUI.java:413) Compiling: - rewriting descendant-or-self step(s) - rewriting descendant-or-self step(s) - type check removed: xs:string - type check removed: xs:string - type check removed: xs:string - inlining Q{http://com.semfinder.code-utils}normalize-icd-10-code#1 - type check removed: $code_99 as xs:string - inlining $code_99 - simplifying flwor expression - inlining Q{http://com.semfinder.code-utils}normalize-morphological-code#1 - type check removed: $code_100 as xs:string - inlining $code_100 - simplifying flwor expression - inlining Q{http://com.semfinder.code-utils}normalize-pcs-code#1 - type check removed: $code_101 as xs:string - inlining $code_101 - simplifying flwor expression - type check removed: xs:string - inlining Q{http://com.semfinder.code-utils}normalize-code#2 - inlining $classification_103 as xs:string? - inlining $normalized_67 - inlining $codes-for-classification_68 - inlining $acc_69 - type check removed: map(*) - marking as tail call: Q{http://com.semfinder.proof.final-valid}get-codes-impl(map:put($map_63, $classification_66, (map:get($map_63, $classification_66), let $code_106 as xs:string := $code_65/Code return switch(((: xs:string?, true :) $classification_66)) case "es-dg-cm" return if(contains($code_106, ".")) then $code_106 else concat(substring($code_106, 1, 3), ".", substring($code_106, 4)) case "es-dg-morph" return if(contains($code_106, "/")) then $code_106 else concat(substring($code_106, 1, 4), "/", substring($code_106, 5)) case "es-op-pcs" return $code_106 default return $code_106)), tail($codes_64)) - rewriting descendant-or-self step(s) - rewriting descendant-or-self step(s) - pre-evaluating { } - inlining $dg_61 - inlining $op_62 - simplifying flwor expression - type check removed: map(*) - marking as tail call: Q{http://com.semfinder.proof.final-valid}get-codes-impl(map { }, ($json_60/descendant::Diagnoses/*, $json_60/descendant::Procedures/*)) - rewriting descendant-or-self step(s) - type check removed: xs:string - type check removed: xs:string - atomic evaluation of (name() = concat("condition.rule.", $name_21)) - inlining Q{http://com.semfinder.proof.shared}msg-or-missing-lang#2 - type check removed: $lang_108 as xs:string - inlining $lang_108 - atomic evaluation of (name() = concat("condition.message.", $name_21)) - inlining Q{http://com.semfinder.proof.shared}msg-or-missing-lang#2 - type check removed: $lang_110 as xs:string - inlining $lang_110 - pre-evaluating string($rule_22) - pre-evaluating string($rule_22) - pre-evaluating string($msg_23) - pre-evaluating string($msg_23) - inlining $rule_22 - atomic evaluation of (name() = concat("condition.rule.", $name_21)) - inlining $msg_23 - inlining $with-rule_24 - type check removed: map(*) - atomic evaluation of (name() = $lang_16) - rewriting descendant-or-self step(s) - inlining Q{http://com.semfinder.proof.shared}add-messages#3 - type check removed: $messages_114 as node()* - type check removed: $lang_116 as xs:string - inlining $messages_114 - atomic evaluation of (name() = concat("condition.rule.", $name_117)) - atomic evaluation of (name() = concat("condition.message.", $name_117)) - inlining $lang_116 - flattening nested GFLWOR expression: $name_117 - type check removed: (map(*))* - atomic evaluation of (@year = $year_81) - atomic evaluation of (@source = $classification_80) - rewriting ((@year = $year_81) and (@source = $classification_80)) to predicate(s) - pre-evaluating boolean((@year = $year_81)) - pre-evaluating boolean((@source = $classification_80)) - inlining $known-codes_83 - rewriting where clause(s) - type check removed: item()* - type check removed: xs:anyAtomicType* - pre-evaluating ((: (map(*))*, true :) ()) - type check removed: (map(*))* - type check removed: (map(*))* - inlining Q{http://com.semfinder.proof.final-valid}find-valid-codes#4 - type check removed: $db-name_120 as xs:string - type check removed: $codes_121 as xs:string* - type check removed: $classification_122 as xs:string - type check removed: $year_123 as xs:int - inlining $db-name_120 - inlining $codes_121 - inlining $classification_122 - atomic evaluation of (@source = $classification_72) - inlining $year_123 - atomic evaluation of (@year = $year_73) - simplifying flwor expression - inlining Q{http://com.semfinder.prelude}value-except#2 - type check removed: $a_125 as xs:anyAtomicType* - inlining $a_125 - pre-evaluating false() - pre-evaluating function($code_77) { ($code_77/final = false()) } - inlining Q{http://com.semfinder.proof.shared}store-forbidden-codes-for-json#2 - type check removed: $forbidden-codes_127 as xs:string* - type check removed: $name_128 as xs:string - inlining $forbidden-codes_127 - inlining $name_128 - simplifying flwor expression - inlining Q{http://com.semfinder.proof.shared}store-forbidden-codes-for-json#2 - type check removed: $name_130 as xs:string - inlining $name_130 - inlining $non-final_76 - type check removed: (map(*))* - inlining Q{http://com.semfinder.proof.shared}get-year#1 - type check removed: $json_131 as item() - inlining $json_131 - simplifying flwor expression - type check removed: item()? - inlining Q{http://com.semfinder.proof.shared}get-lang#1 - type check removed: $json_133 as item() - inlining $json_133 - simplifying flwor expression - type check removed: xs:string? - inlining Q{http://com.semfinder.proof.final-valid}get-codes#1 - type check removed: $json_134 as item() - inlining $json_134 - simplifying flwor expression - inlining Q{http://com.semfinder.proof.shared}get-country#1 - type check removed: $json_135 as item() - inlining $json_135 - simplifying flwor expression - type check removed: xs:string? - type check removed: $db-name_93 as xs:string - inlining Q{http://com.semfinder.proof.final-valid}check-codes#4 - type check removed: $db-name_136 as xs:string - inlining $db-name_136 - atomic evaluation of (@year = $year_139) - atomic evaluation of (@source = $classification_138) - flattening nested GFLWOR expression: $valid_140 - inlining Q{http://com.semfinder.proof.shared}enrich-messages#3 - type check removed: $db_145 as xs:string - type check removed: $results_146 as (map(*))* - inlining $db_145 - atomic evaluation of (name() = $lang_147) - inlining $results_146 - flattening nested GFLWOR expression: $messages_148 - inlining $year_87 as item()? - inlining $lang_88 as xs:string? - inlining $codes_89 - removing variable $country_90 as xs:string? - simplifying flwor expression - inlining Q{http://com.semfinder.proof.final-valid}execute#2 - type check removed: $json_162 as item() - type check removed: $db-name_163 as xs:string - inlining $json_162 - inlining $db-name_163 - simplifying flwor expression - inlining $text_96 - pre-evaluating json:parse("{
 ""Data"": {
 ""Client"": {
 ""Country"": ""test"",
 ""Lang"": ""test""
 },
 ""PatientData"": {
 ""Sex"": ""2"",
 ""AgeInYears"": 14,
 ""DischargeDate"": ""2016-10-31""
 },
 ""Diagnoses"": {
 ""P"": {
 ""Comment"": ""Exists and final"",
 ""Code"": ""I63.331"",
 ""Classification"": ""es-dg-cm""
 },
 ""1"": {
 ""Comment"": ""Exists, not final"",
 ""Code"": ""S90.929"",
 ""Classification"": ""es-dg-cm""
 },
 ""2"": {
 ""Comment"": ""Does not exist"",
 ""Code"": ""I10"",
 ""Classification"": ""es-dg-cm""
 }
 },
 ""Procedures"": {
 ""0"": {
 ""Comment"": ""Exists"",
 ""Code"": ""0D164Z4"",
 ""Classification"": ""es-op-pcs""
 },
 ""1"": {
 ""Comment"": ""Exists, but not complete"",
 ""Code"": ""0LBD4__"",
 ""Classification"": ""es-op-pcs""
 },
 ""2"": {
 ""Comment"": ""Does not exist"",
 ""Code"": ""0DJD8ZZ"",
 ""Classification"": ""es-op-pcs""
 }
 }

 
 }
}") - inlining $json_97 - inlining $db_98 - pre-evaluating db:open("basic-proof") - atomic evaluation of (name() = $lang_184) - converting descendant::*:messages to child steps - pre-evaluating db:open("basic-proof") - atomic evaluation of (@*:year = $year_188) - atomic evaluation of (@*:source = $classification_187) - applying text index for $code_190 - simplifying flwor expression Optimized Query: declare %private function fv:get-codes-impl($map_63 as map(*), $codes_64 as node()*) as map(*) { if(empty($codes_64)) then $map_63 else let $code_65 := head($codes_64) let $classification_66 := $code_65/Classification/text() return Q{http://com.semfinder.proof.final-valid}get-codes-impl(map:put($map_63, $classification_66, (map:get($map_63, $classification_66), let $code_106 as xs:string := $code_65/Code return switch(((: xs:string?, true :) $classification_66)) case "es-dg-cm" return if(contains($code_106, ".")) then $code_106 else concat(substring($code_106, 1, 3), ".", substring($code_106, 4)) case "es-dg-morph" return if(contains($code_106, "/")) then $code_106 else concat(substring($code_106, 1, 4), "/", substring($code_106, 5)) case "es-op-pcs" return $code_106 default return $code_106)), tail($codes_64)) }; map:for-each(Q{http://com.semfinder.proof.final-valid}get-codes-impl(map { }, (document { }/descendant::Diagnoses/*, document { }/descendant::Procedures/*)), ((: inline-closure :) let $year_167 := ((: item()?, true :) let $year_183 := document { }/descendant::PatientData/DischargeDate cast as xs:date? return if(empty($year_183)) then () else year-from-date($year_183) cast as xs:int?) let $lang_168 := ((: xs:string?, true :) document { }/descendant::Client/Lang) return function($key_164, $val_165) { let $lang_184 as xs:string := $lang_168 let $messages_185 := (db:open-pre("basic-proof",0), ...)/*:messages/*[(name() = $lang_184)] return (let $codes_186 as xs:string* := $val_165 let $classification_187 as xs:string := $key_164 let $year_188 as xs:int := $year_167 let $valid_189 := for $code_190 in $codes_186 return db:text("basic-proof", $code_190)/parent::*:value/parent::*:code[parent::*:classification/parent::document-node()][..[(@*:year = $year_188)][(@*:source = $classification_187)]] let $b_191 as xs:anyAtomicType* := ($valid_189 ! value/text()) let $invalid_192 := distinct-values(($codes_186)[not((. = $b_191))]) return ((: (map(*))*, true :) (if(empty($invalid_192)) then () else { "ForbiddenCodes":[($invalid_192)], "Rule":"invalid_code" }, let $forbidden-codes_193 as xs:string* := (filter($valid_189, function($code_77) as xs:boolean {...}) ! value/text()) return if(empty($forbidden-codes_193)) then () else { "ForbiddenCodes":[($forbidden-codes_193)], "Rule":"final_code" })) ! let $result_194 as map(*) := . let $name_195 := map:get($result_194, "Rule") return map:put(map:put($result_194, "Name", let $msg_196 as xs:string? := $messages_185/*[(name() = concat("condition.rule.", $name_195))]/text() return if(empty($msg_196)) then concat("No translations for lang: ", $lang_184) else ((: xs:string, true :) $msg_196)), "Msg", let $msg_197 as xs:string? := $messages_185/*[(name() = concat("condition.message.", $name_195))]/text() return if(empty($msg_197)) then concat("No translations for lang: ", $lang_184) else ((: xs:string, true :) $msg_197))) })) Query: import module namespace final-valid = 'http://com.semfinder.proof.final-valid'; let $text := '{ "Data": { "Client": { "Country": "test", "Lang": "test" }, "PatientData": { "Sex": "2", "AgeInYears": 14, "DischargeDate": "2016-10-31" }, "Diagnoses": { "P": { "Comment": "Exists and final", "Code": "I63.331", "Classification": "es-dg-cm" }, "1": { "Comment": "Exists, not final", "Code": "S90.929", "Classification": "es-dg-cm" }, "2": { "Comment": "Does not exist", "Code": "I10", "Classification": "es-dg-cm" } }, "Procedures": { "0": { "Comment": "Exists", "Code": "0D164Z4", "Classification": "es-op-pcs" }, "1": { "Comment": "Exists, but not complete", "Code": "0LBD4__", "Classification": "es-op-pcs" }, "2": { "Comment": "Does not exist", "Code": "0DJD8ZZ", "Classification": "es-op-pcs" } } } }' let $json := json:parse($text) let $db := 'basic-proof' return final-valid:execute($json, $db) Query plan: <QueryPlan compiled="true"> <StaticFunc name="fv:get-codes-impl" arg0="map" arg1="codes"> <If> <FnEmpty name="empty(items)"> <VarRef> <Var name="$codes" id="64" as="node()*"/> </VarRef> </FnEmpty> <VarRef> <Var name="$map" id="63" as="map(*)"/> </VarRef> <GFLWOR> <Let> <Var name="$code" id="65"/> <FnHead name="head(items)"> <VarRef> <Var name="$codes" id="64" as="node()*"/> </VarRef> </FnHead> </Let> <Let> <Var name="$classification" id="66"/> <IterPath> <VarRef> <Var name="$code" id="65"/> </VarRef> <IterStep axis="child" test="Classification"/> <IterStep axis="child" test="text()"/> </IterPath> </Let> <StaticFuncCall name="fv:get-codes-impl" tailCall="true"> <MapPut name="put(map,key,value)"> <VarRef> <Var name="$map" id="63" as="map(*)"/> </VarRef> <VarRef> <Var name="$classification" id="66"/> </VarRef> <List> <MapGet name="get(map,key)"> <VarRef> <Var name="$map" id="63" as="map(*)"/> </VarRef> <VarRef> <Var name="$classification" id="66"/> </VarRef> </MapGet> <GFLWOR> <Let> <Var name="$code" id="106" as="xs:string"/> <IterPath> <VarRef> <Var name="$code" id="65"/> </VarRef> <IterStep axis="child" test="Code"/> </IterPath> </Let> <Switch> <TypeCheck type="xs:string?" function="true"> <VarRef> <Var name="$classification" id="66"/> </VarRef> </TypeCheck> <SwitchCase> <If> <FnContains name="contains(string,sub[,collation])"> <VarRef> <Var name="$code" id="106" as="xs:string"/> </VarRef> <Str value="." type="xs:string"/> </FnContains> <VarRef> <Var name="$code" id="106" as="xs:string"/> </VarRef> <FnConcat name="concat(atom1,atom2[,...])"> <FnSubstring name="substring(string,start[,len])"> <VarRef> <Var name="$code" id="106" as="xs:string"/> </VarRef> <Int value="1" type="xs:integer"/> <Int value="3" type="xs:integer"/> </FnSubstring> <Str value="." type="xs:string"/> <FnSubstring name="substring(string,start[,len])"> <VarRef> <Var name="$code" id="106" as="xs:string"/> </VarRef> <Int value="4" type="xs:integer"/> </FnSubstring> </FnConcat> </If> <Str value="es-dg-cm" type="xs:string"/> </SwitchCase> <SwitchCase> <If> <FnContains name="contains(string,sub[,collation])"> <VarRef> <Var name="$code" id="106" as="xs:string"/> </VarRef> <Str value="/" type="xs:string"/> </FnContains> <VarRef> <Var name="$code" id="106" as="xs:string"/> </VarRef> <FnConcat name="concat(atom1,atom2[,...])"> <FnSubstring name="substring(string,start[,len])"> <VarRef> <Var name="$code" id="106" as="xs:string"/> </VarRef> <Int value="1" type="xs:integer"/> <Int value="4" type="xs:integer"/> </FnSubstring> <Str value="/" type="xs:string"/> <FnSubstring name="substring(string,start[,len])"> <VarRef> <Var name="$code" id="106" as="xs:string"/> </VarRef> <Int value="5" type="xs:integer"/> </FnSubstring> </FnConcat> </If> <Str value="es-dg-morph" type="xs:string"/> </SwitchCase> <SwitchCase> <VarRef> <Var name="$code" id="106" as="xs:string"/> </VarRef> <Str value="es-op-pcs" type="xs:string"/> </SwitchCase> <SwitchCase> <VarRef> <Var name="$code" id="106" as="xs:string"/> </VarRef> </SwitchCase> </Switch> </GFLWOR> </List> </MapPut> <FnTail name="tail(items)"> <VarRef> <Var name="$codes" id="64" as="node()*"/> </VarRef> </FnTail> </StaticFuncCall> </GFLWOR> </If> </StaticFunc> <MapForEach name="for-each(map,function)"> <StaticFuncCall name="fv:get-codes-impl" tailCall="false"> <Map size="0"/> <List> <CachedPath> <FDoc base=""/> <IterStep axis="descendant" test="Diagnoses"/> <IterStep axis="child" test="*"/> </CachedPath> <CachedPath> <FDoc base=""/> <IterStep axis="descendant" test="Procedures"/> <IterStep axis="child" test="*"/> </CachedPath> </List> </StaticFuncCall> <Closure arg0="key" arg1="val"> <Var name="$year" id="167"/> <TypeCheck type="item()?" function="true"> <GFLWOR> <Let> <Var name="$year" id="183"/> <Cast type="xs:date?"> <CachedPath> <FDoc base=""/> <IterStep axis="descendant" test="PatientData"/> <IterStep axis="child" test="DischargeDate"/> </CachedPath> </Cast> </Let> <If> <FnEmpty name="empty(items)"> <VarRef> <Var name="$year" id="183"/> </VarRef> </FnEmpty> <Empty size="0"/> <Cast type="xs:int?"> <FnYearFromDate name="year-from-date(date)"> <VarRef> <Var name="$year" id="183"/> </VarRef> </FnYearFromDate> </Cast> </If> </GFLWOR> </TypeCheck> <Var name="$lang" id="168"/> <TypeCheck type="xs:string?" function="true"> <CachedPath> <FDoc base=""/> <IterStep axis="descendant" test="Client"/> <IterStep axis="child" test="Lang"/> </CachedPath> </TypeCheck> <GFLWOR> <Let> <Var name="$lang" id="184" as="xs:string"/> <VarRef> <Var name="$lang" id="168"/> </VarRef> </Let> <Let> <Var name="$messages" id="185"/> <IterPath> <DBNodeSeq size="8"> <DBNode name="basic-proof" pre="0"/> <DBNode name="basic-proof" pre="84"/> <DBNode name="basic-proof" pre="43648"/> <DBNode name="basic-proof" pre="501117"/> <DBNode name="basic-proof" pre="958586"/> </DBNodeSeq> <IterStep axis="child" test="*:messages"/> <IterStep axis="child" test="*"> <CmpG op="="> <FnName name="name([node])"/> <VarRef> <Var name="$lang" id="184" as="xs:string"/> </VarRef> </CmpG> </IterStep> </IterPath> </Let> <IterMap> <GFLWOR> <Let> <Var name="$codes" id="186" as="xs:string*"/> <VarRef> <Var name="$val" id="165"/> </VarRef> </Let> <Let> <Var name="$classification" id="187" as="xs:string"/> <VarRef> <Var name="$key" id="164"/> </VarRef> </Let> <Let> <Var name="$year" id="188" as="xs:int"/> <VarRef> <Var name="$year" id="167"/> </VarRef> </Let> <Let> <Var name="$valid" id="189"/> <GFLWOR> <For> <Var name="$code" id="190"/> <VarRef> <Var name="$codes" id="186" as="xs:string*"/> </VarRef> </For> <CachedPath> <ValueAccess data="basic-proof" type="text" name="*:value"> <VarRef> <Var name="$code" id="190"/> </VarRef> </ValueAccess> <CachedStep axis="parent" test="*:code"> <CachedPath> <IterStep axis="parent" test="*:classification"/> <IterStep axis="parent" test="document-node()"/> </CachedPath> <CachedPath> <IterStep axis="parent" test="node()"> <CmpG op="="> <CachedPath> <IterStep axis="attribute" test="*:year"/> </CachedPath> <VarRef> <Var name="$year" id="188" as="xs:int"/> </VarRef> </CmpG> <CmpG op="="> <CachedPath> <IterStep axis="attribute" test="*:source"/> </CachedPath> <VarRef> <Var name="$classification" id="187" as="xs:string"/> </VarRef> </CmpG> </IterStep> </CachedPath> </CachedStep> </CachedPath> </GFLWOR> </Let> <Let> <Var name="$b" id="191" as="xs:anyAtomicType*"/> <IterMap> <VarRef> <Var name="$valid" id="189"/> </VarRef> <CachedPath> <IterStep axis="child" test="value"/> <IterStep axis="child" test="text()"/> </CachedPath> </IterMap> </Let> <Let> <Var name="$invalid" id="192"/> <FnDistinctValues name="distinct-values(items[,collation])"> <IterFilter> <VarRef> <Var name="$codes" id="186" as="xs:string*"/> </VarRef> <FnNot name="not(items)"> <CmpG op="="> <ContextValue/> <VarRef> <Var name="$b" id="191" as="xs:anyAtomicType*"/> </VarRef> </CmpG> </FnNot> </IterFilter> </FnDistinctValues> </Let> <TypeCheck type="(map(*))*" function="true"> <List> <If> <FnEmpty name="empty(items)"> <VarRef> <Var name="$invalid" id="192"/> </VarRef> </FnEmpty> <Empty size="0"/> <CMap> <Str value="ForbiddenCodes" type="xs:string"/> <CArray> <VarRef> <Var name="$invalid" id="192"/> </VarRef> </CArray> <Str value="Rule" type="xs:string"/> <Str value="invalid_code" type="xs:string"/> </CMap> </If> <GFLWOR> <Let> <Var name="$forbidden-codes" id="193" as="xs:string*"/> <IterMap> <FnFilter name="filter(items,function)"> <VarRef> <Var name="$valid" id="189"/> </VarRef> <FuncItem type="function(item()*) as xs:boolean"> <Var name="$code" id="77"/> <CmpG op="="> <CachedPath> <VarRef> <Var name="$code" id="77"/> </VarRef> <IterStep axis="child" test="final"/> </CachedPath> <Bln value="false" type="xs:boolean"/> </CmpG> </FuncItem> </FnFilter> <CachedPath> <IterStep axis="child" test="value"/> <IterStep axis="child" test="text()"/> </CachedPath> </IterMap> </Let> <If> <FnEmpty name="empty(items)"> <VarRef> <Var name="$forbidden-codes" id="193" as="xs:string*"/> </VarRef> </FnEmpty> <Empty size="0"/> <CMap> <Str value="ForbiddenCodes" type="xs:string"/> <CArray> <VarRef> <Var name="$forbidden-codes" id="193" as="xs:string*"/> </VarRef> </CArray> <Str value="Rule" type="xs:string"/> <Str value="final_code" type="xs:string"/> </CMap> </If> </GFLWOR> </List> </TypeCheck> </GFLWOR> <GFLWOR> <Let> <Var name="$result" id="194" as="map(*)"/> <ContextValue/> </Let> <Let> <Var name="$name" id="195"/> <MapGet name="get(map,key)"> <VarRef> <Var name="$result" id="194" as="map(*)"/> </VarRef> <Str value="Rule" type="xs:string"/> </MapGet> </Let> <MapPut name="put(map,key,value)"> <MapPut name="put(map,key,value)"> <VarRef> <Var name="$result" id="194" as="map(*)"/> </VarRef> <Str value="Name" type="xs:string"/> <GFLWOR> <Let> <Var name="$msg" id="196" as="xs:string?"/> <CachedPath> <VarRef> <Var name="$messages" id="185"/> </VarRef> <IterStep axis="child" test="*"> <CmpG op="="> <FnName name="name([node])"/> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="condition.rule." type="xs:string"/> <VarRef> <Var name="$name" id="195"/> </VarRef> </FnConcat> </CmpG> </IterStep> <IterStep axis="child" test="text()"/> </CachedPath> </Let> <If> <FnEmpty name="empty(items)"> <VarRef> <Var name="$msg" id="196" as="xs:string?"/> </VarRef> </FnEmpty> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="No translations for lang: " type="xs:string"/> <VarRef> <Var name="$lang" id="184" as="xs:string"/> </VarRef> </FnConcat> <TypeCheck type="xs:string" function="true"> <VarRef> <Var name="$msg" id="196" as="xs:string?"/> </VarRef> </TypeCheck> </If> </GFLWOR> </MapPut> <Str value="Msg" type="xs:string"/> <GFLWOR> <Let> <Var name="$msg" id="197" as="xs:string?"/> <CachedPath> <VarRef> <Var name="$messages" id="185"/> </VarRef> <IterStep axis="child" test="*"> <CmpG op="="> <FnName name="name([node])"/> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="condition.message." type="xs:string"/> <VarRef> <Var name="$name" id="195"/> </VarRef> </FnConcat> </CmpG> </IterStep> <IterStep axis="child" test="text()"/> </CachedPath> </Let> <If> <FnEmpty name="empty(items)"> <VarRef> <Var name="$msg" id="197" as="xs:string?"/> </VarRef> </FnEmpty> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="No translations for lang: " type="xs:string"/> <VarRef> <Var name="$lang" id="184" as="xs:string"/> </VarRef> </FnConcat> <TypeCheck type="xs:string" function="true"> <VarRef> <Var name="$msg" id="197" as="xs:string?"/> </VarRef> </TypeCheck> </If> </GFLWOR> </MapPut> </GFLWOR> </IterMap> </GFLWOR> </Closure> </MapForEach> </QueryPlan>

2 3

Nginx proxypass
by Trevor Sewell 13 Mar '17

13 Mar '17

How could i set up nginx as a proxy to expose the rest api to port 80? I have: server { listen 80; location / { proxy_pass http://212.71.232.36:8984/rest; proxy_set_header Authorization "Basic YWRtaW46YWRtaW4="; proxy_set_header X-Real-IP $remote_addr; proxy_set_header Host $http_host; } } which works correctly for root, but lets say i tried server { listen 80; location /hello/world { proxy_pass http://212.71.232.36:8984/rest/hello/world; proxy_set_header Authorization "Basic YWRtaW46YWRtaW4="; proxy_set_header X-Real-IP $remote_addr; proxy_set_header Host $http_host; } } I get: Database 'hello' was not found. Ideally I’d like a catch all so that the rest api works from this I.P.

2 1

Gzipped compression
by meumapple 13 Mar '17

13 Mar '17

Hi, I am trying to enable gzipped compression in RESTXQ. I have been modifying web.xml without success. Where should the filter element [1] be put? Thanks. Joseph [1] (http://www.srccodes.com/m/p/article/12/configure-gzip-filter-on-jetty-8-for…)

3 3

Basexhttp on ubuntu
by Trevor Sewell 12 Mar '17

12 Mar '17

I’ve Installed base via apt on ubuntu 16.10 I can run basex, basexserver but not basexhttp, the command is not found please advise

2 1

Re: [basex-talk] RETRIEVE
by Christian Grün 11 Mar '17

11 Mar '17

For returning specific XML documents of a database, you need to use the XQUERY command: XQUERY db:open('greek', 'PROSE~aristotle~Rhetoric1') All documents of the currently opened database can simply be addressed and returned via the context item (.): XQUERY . Hope this helps, Christian Am 11.03.2017 10:08 nachm. schrieb "mark bordelon" <markcbordelon(a)yahoo.com >: > In actuality, as you have surmised, no. > I wish to get the xml text of document. > So, for what I am attempting below ... > > *> list * > *Name Resources Size Input Path * > *------------------------------ ----------* > *greek 2 2942906 * > *latin 184 9942769 * > *semantic 785 257685 * > > *3 database(s).* > *> list greek* > *Input Path Type Content-Type Size * > *------------------------------ ------------------------------* > *PROSE~aristotle~Rhetoric1 xml application/xml 99387 * > *PROSE~CONVERSATION~ GreekPrimer xml application/xml 20260 * > > *> open greek* > *Database 'greek' was opened in 2.9 ms.* > *> retrieve PROSE~aristotle~Rhetoric1* > > .. my intention is to have the xml content: *<text><sent><clause> ...... > </text>* > > ------------------------------ > *From:* Christian Grün <christian.gruen(a)gmail.com> > *To:* mark bordelon <markcbordelon(a)yahoo.com> > *Cc:* BaseX <basex-talk(a)mailman.uni-konstanz.de> > *Sent:* Saturday, March 11, 2017 12:25 PM > *Subject:* Re: [basex-talk] RETRIEVE > > What are your intentions? Are you really interested in a raw > representation of your input? > > Am 11.03.2017 21:24 schrieb "mark bordelon" <markcbordelon(a)yahoo.com>: > > Christian, thank you. > Can you give me an example of the syntax (e.g. command + param) of the > RETRIEVE command in my case? > > > ------------------------------ > *From:* Christian Grün <christian.gruen(a)gmail.com> > *To:* mark bordelon <markcbordelon(a)yahoo.com> > *Cc:* BaseX <basex-talk(a)mailman.uni- konstanz.de > <basex-talk(a)mailman.uni-konstanz.de>> > *Sent:* Saturday, March 11, 2017 12:21 PM > *Subject:* Re: [basex-talk] RETRIEVE > > Hi Mark, > > Each resource is stored as either an XML document or a binary file (raw > data) [1]. You can only retrieve resources as raw data of they have been > stored as binaries. > > Hope this helps, > Christian > > [1] http://docs.basex.org/ wiki/Binary_Data > <http://docs.basex.org/wiki/Binary_Data> > > > > > Am 11.03.2017 21:16 schrieb "mark bordelon" <markcbordelon(a)yahoo.com>: > > I am trying to retreieve the raw xml from a document and think I should > use the RETRIEVE command, right? What is the ID that I pass as the argument? > Here is what I have tried with the error: > > > *list* > Name Resources Size Input Path > ------------------------------ ---------- > greek 2 2942906 > latin 184 9942769 > semantic 785 257685 > > 3 database(s). > > *list greek* > Input Path Type Content-Type Size > ------------------------------ ------------------------------ > PROSE~aristotle~Rhetoric1 xml application/xml 99387 > PROSE~CONVERSATION~ GreekPrimer xml application/xml 20260 > > > *open greek* > Database 'greek' was opened in 2.9 ms. > > *retrieve PROSE~aristotle~Rhetoric1* > *Resource "PROSE~aristotle~Rhetoric1" not found.* > > > > > > >

1 0

Re: [basex-talk] RETRIEVE
by Christian Grün 11 Mar '17

11 Mar '17

Hi Mark, Each resource is stored as either an XML document or a binary file (raw data) [1]. You can only retrieve resources as raw data of they have been stored as binaries. Hope this helps, Christian [1] http://docs.basex.org/wiki/Binary_Data Am 11.03.2017 21:16 schrieb "mark bordelon" <markcbordelon(a)yahoo.com>: I am trying to retreieve the raw xml from a document and think I should use the RETRIEVE command, right? What is the ID that I pass as the argument? Here is what I have tried with the error: > *list* Name Resources Size Input Path ---------------------------------------- greek 2 2942906 latin 184 9942769 semantic 785 257685 3 database(s). > *list greek* Input Path Type Content-Type Size ------------------------------------------------------------ PROSE~aristotle~Rhetoric1 xml application/xml 99387 PROSE~CONVERSATION~GreekPrimer xml application/xml 20260 > *open greek* Database 'greek' was opened in 2.9 ms. > *retrieve PROSE~aristotle~Rhetoric1* *Resource "PROSE~aristotle~Rhetoric1" not found.*

2 2

Simple query
by Aaron Weber 11 Mar '17

11 Mar '17

Newbie alert. I'm trying to get my feet wet with BaseX, and in doing so, am trying to understand XQuery and how to apply it to a database full of documents (not just a single document that is typically queried). I am using Java and can post my code, but with a LocalSession, and a query, the following produces 0 results. For $doc in collection() return $doc I realize there's no "where", and in the sql world that would match all. Maybe not in XQuery? Obviously just a test query, but I need to start somewhere. :-) Thanks for any help! -- AJ

7 15

Tail Recursion Error on startup
by buddyonweb-software＠yahoo.com 11 Mar '17

11 Mar '17

When we start up BaseX (whether the server or the GUI) and run a particular a query against a particular .xqm file, we always get a tail recursion error. Error:[bxerr:BASX0005] Stack Overflow: Try tail recursion? If we attempt to execute it again (sometimes twice, but have done so repeatedly up to 5 times), the error goes away and all is fine. Is there anything you can suggest or anything we can provide you to see how to eliminate this. This is particularly problematic on our server when we reboot our production application.Anything you can suggest or anyway we can help is much appreciated. Buddy

3 7

Angular(2) ToH with Basex backend
by Rob Stapper 11 Mar '17

11 Mar '17

Hi, So finally I got the Tour of Heroes from the Angular(2) tutorial [1] working with BaseX as database backend. Everything works pretty well except for one thing: When adding a new record, Angular expects the backend (BaseX) to create an unique ID for the record and send it, together with the original, back to the angular-frontend [2]. In BaseX however, it is not possible to retrieve updated data from within the same transaction as the update of the database took place. The work around is to fetch the updated record outside the updating-transaction by means of a web:redirect to the link that retrieves a record [3]. This work around has two major disadvantages: 1. one can never be a 100% sure that the fetched data is exactly the data as it was stored in the base because updating and fetching are two separate transactions. 2. this only works if the records have a unique set of key fields. This doesn't always have to be the case. I've reported this situation a while ago and I wouldn't come back on it if the Angular-way of working didn't come up with the same situation. In my opinion BaseX would even be better equipped as database backend as it is if it was possible to fetch the updated date in the database from within the same transaction as the update took place. Is this something that could be considered for a future release? Cheers, Rob Stapper PS. I got this far thanks to the suggestions on CORS. [1] https://angular.io/docs/ts/latest/tutorial [2] https://angular.io/docs/ts/latest/tutorial/toh-pt6.html chapter: "Add a hero". [3] declare %rest:path("/product/save") %rest:POST("{ $parameterSet}") %updating function _:product.save ( $parameterSet as array(*) ) { ( db:output( web:redirect( "/product/find" , map{ "code" : $parameterSet(2) } ) ) , dbx:save( $_:dataBase , $_:objectType , trace( $parameterSet(1), "objectID:" ) , product:new( $parameterSet(2) , $parameterSet(3) , $parameterSet(4) ) ) )

4 3

Flush command and data corruption
by Colin Delacroix 10 Mar '17

10 Mar '17

Hi everyone, (warning this is a long read) I'm using server version 8.6.1 and writing a Java client to move lots of documents from a SQL database to a BaseX database. The basic version works just fine. Tested up to 1M documents. Now I'm trying to do exactly the same but with AUTOFLUSH disabled + manually FLUSH every N documents and it fails after just a few inserts. Pseudo code: (set up client session, create and open new database) session.execute(new Set(MainOptions.AUTOFLUSH, false)); int i = 0; while(doc = nextDocs()) { session.add(doc.getKey(), doc.getInputStream()); if(i++ % 10 == 0) { /* value reduced to 10 for testing purposes */ session.execute(new Flush()); } } (tear down session) Remember tha After the first FLUSH has been issued, the ADD directive starts randomly throwing a org.basex.core.BaseXException (when using the BaseXClient implementation it was its inner ok() method that started returning false). I tracked the root cause in the server: the SAXParser complaining about the documents not being well-formed (the exact same documents are all imported fine with AUTOFLUSH on). In the server standard logs I can see why: parts of those documents are suddenly missing (usually the beginning + command part) at parse time! That is the symptom, now for the cause I'm also observing that the ADD and FLUSH directive in the logs are out of order, exactly like what would happen in the FLUSH commands were not properly queued. I was expecting something like : ADD ADD ADD (N times) FLUSH ADD ADD ADD (N times) FLUSH etc. Instead I'm observing ADD FLUSH ADD FLUSH ADD FLUSH (etc) then ADD ADD ADD (lots of them) ERROR So for now I'm keeping autoflush on :) but is there anything obvious I could try there? (server runs on linux openjdk 1.8.0_91, client runs in Tomcat on Windows Oracle JDK 1.8.0_121) Thanks, Colin

2 2

[XPTY0004] Item expected, sequence found
by Bram Vanroy 08 Mar '17

08 Mar '17

Hi BaseX peeps I'm running BaseX 8.6.1 on Windows, and I'm running into an issue I can't explain. I am using BaseX to run some benchmarks. As a benchmark I am running different XPath structures to match on the same database. In other words, in a file of a hundred lines each line is an XPath structure, and with Perl I query each line and measure the time it takes. Simple enough, right? The strange thing is that my script runs fine but it crashes on line 17, which is this XPath code: //node[@cat="pp" and node[@rel="hd" and @pt="vz" and number(@begin) < number(../node[@rel="obj1" and @cat="np"]/node[@rel="mod" and @cat="pp"]/node[@rel="hd" and @pt="vz"]/@begin)] and node[@rel="obj1" and @cat="np" and node[@rel="mod" and @cat="pp" and node[@rel="hd" and @pt="vz" and number(@begin) < number(../node[@rel="obj1" and @cat="np"]/node[@rel="mod" and @cat="pp"]/node[@rel="hd" and @pt="vz"]/@begin)] and node[@rel="obj1" and @cat="np" and node[@rel="mod" and @cat="pp" and node[@rel="hd" and @pt="vz"]]]]]] Admittedly, it's quite a long string, but I don't see anything wrong with it and I don't think the error lies in the XPath. The full trace is like follows: [XPTY0004] Item expected, sequence found: (attribute begin {"6"}, ...). at C:\xampp\htdocs\grinding\BaseXClient.pm line 213. at C:\xampp\htdocs\grinding\BaseXClient.pm line 213. Query::exc("\x{5}", 133) called at C:\xampp\htdocs\grinding\BaseXClient.pm line 177 Query::execute(Query=HASH(0x3adac40)) called at SonarBenchNew.pl line 249 main::query_sonar("for \$node in db:open(\"WRPEE0000000treebank\")/treebank//node[\@"...) called at SonarBenchNew.pl line 176 main::loop_databases(ARRAY(0x31a2ae0), "//node[\@cat=\"pp\" and node[\@rel=\"hd\" and \@pt=\"vz\" and number(\@"...) called at SonarBenchNew.pl line 140 main::regular_sonar("//node[\@cat=\"pp\" and node[\@rel=\"hd\" and \@pt=\"vz\" and number(\@"...) called at SonarBenchNew.pl line 110 I have found that the XPTY0004 error is often caused by an order-by clause in XQuery but I don't have that. The full XQuery for the XPath is as follows: for $node in db:open("WRPEE0000000treebank")/treebank//node[@cat="pp" and node[@rel="hd" and @pt="vz" and number(@begin) < number(../node[@rel="obj1" and @cat="np"]/node[@rel="mod" and @cat="pp"]/node[@rel="hd" and @pt="vz"]/@begin)] and node[@rel="obj1" and @cat="np" and node[@rel="mod" and @cat="pp" and node[@rel="hd" and @pt="vz" and number(@begin) < number(../node[@rel="obj1" and @cat="np"]/node[@rel="mod" and @cat="pp"]/node[@rel="hd" and @pt="vz"]/@begin)] and node[@rel="obj1" and @cat="np" and node[@rel="mod" and @cat="pp" and node[@rel="hd" and @pt="vz"]]]]]]let $sentid := ($node/ancestor::alpino_ds/@id)let $sentence := ($node/ancestor::alpino_ds/sentence)let $tb := \'WRPEE0000000treebank\' return <match>{data($sentid)}||{data($sentence)}||{data($tb)}</match> I don't know if you guys can give me directions solely based on this. But if you could point me to a likely cause, e.g. input OR database contents, that would be great. Thanks in advance! Bram Vanroy https://bramvanroy.be

3 7

Re: [basex-talk] starting and closing HTTP server giving errors
by kalibuk＠centrum.cz 08 Mar '17

08 Mar '17

Hi Marco, thanks for reply I tried your latest release (8.6.2.x) and it seems helped to get HTTP server stopped ok. Otherwise starting the server is still giving me the error. Automation is out of way as it may be reproduced manually in command line see: c:\>basexhttp.bat -S Connection failed (port: 8984). c:\>basexhttpstop.bat HTTP Server was stopped (port: 8984). c:\> Any idea why it hands back connection failed message while I can ping it like this while running? C:\windows\system32>netstat -anb | find "8984" TCP 0.0.0.0:8984 0.0.0.0:0 LISTENING TCP [::]:8984 [::]:0 LISTENING Thanks, Jan -------------------------------------------------------------------------------------------------------------------------------------------- Hallo, I'm trying to get strating and stopping of BaseX HTTP server automated. ? Whats wrong with starting: Once trying to run in command line "basexhttp.bat -S" I get "Connection failed (port: 8984)." But server is running (!?) and I can create socket to comunicate with. ? Whats wrong with stopping: Once trying to run in command line "basexhttpstop.bat" I get it hanged and need to terminate job or on another attempt I get back "Connection failed (port: 8985)." And I cannot communicate with server so it seems that it really got stopped. ? It's tricky to automate that if I get errors on every attempt to start/stop it. Could you advice? ? Third error what I ocasionally can get back after trying to run server is: "Error occurred during initialization of VM Could not reserve enough space for 1433600KB object heap" ? Behaviour is same for 8.6.0 and 8.6.1. I have just updated Java RT to latest. ? Regards,? Jan, Brno ? ? ?

2 1

starting and closing HTTP server giving errors
by kalibuk＠centrum.cz 07 Mar '17

07 Mar '17

Hallo, I'm trying to get strating and stopping of BaseX HTTP server automated. Whats wrong with starting: Once trying to run in command line "basexhttp.bat -S" I get "Connection failed (port: 8984)." But server is running (!?) and I can create socket to comunicate with. Whats wrong with stopping: Once trying to run in command line "basexhttpstop.bat" I get it hanged and need to terminate job or on another attempt I get back "Connection failed (port: 8985)." And I cannot communicate with server so it seems that it really got stopped. It's tricky to automate that if I get errors on every attempt to start/stop it. Could you advice? Third error what I ocasionally can get back after trying to run server is: "Error occurred during initialization of VM Could not reserve enough space for 1433600KB object heap" Behaviour is same for 8.6.0 and 8.6.1. I have just updated Java RT to latest. Regards, Jan, Brno

2 1

Java bindings
by meumapple 06 Mar '17

06 Mar '17

Hi, I have a java parser (opennlp-tools-1.7.2.jar) whose main class is "opennlp.tools.cmdline.CLI" At the command line I run it with opennlp POSTagger mymodel.bin (opennlp is a bash script running the abovementioned jar file). After that I am asked interactively for the text to parse. Is it possible to invoke the command from XQuery via java bindings? I have put the opennlp jar files in the repo folder and I have tried "import module namespace m = "java.opennlp.tools.cmdline.CLI;" but the I get the "module not found error" Thanks! Joseph

3 4

Re: [basex-talk] HTTP status codes
by Marco Lettere 06 Mar '17

06 Mar '17

Hi Christoph, it worked for me when putting the rest_errors.xqm in the webapp folder and rewrriting your import in this way: import module namespace err="error" at "rest_errors.xqm"; > curl -v http://localhost:9984/softwareberatung/rev/2017/12 Trying 127.0.0.1... * Connected to localhost (127.0.0.1) port 9984 (#0) > GET /softwareberatung/rev/2017/12 HTTP/1.1 > Host: localhost:9984 > User-Agent: curl/7.47.0 > Accept: */* > < HTTP/1.1 404 Not Found < Set-Cookie: JSESSIONID=6ylp1ounz561183u198394hjs;Path=/ < Expires: Thu, 01 Jan 1970 00:00:00 GMT < Content-Type: text/plain;charset=UTF-8 < Content-Length: 25 < Server: Jetty(8.1.18.v20150929) < * Connection #0 to host localhost left intact Revenue 12 does not exist Working with the repo is something that I never got right but probably I should just carefully re-read the docs at [1]. Regards, Marco. [1] http://docs.basex.org/wiki/Repository On 05/03/2017 13:45, Christoph Gaukel wrote: > Hi Marco, > > thank you for your reply. It works fine, when I put the declaration > direct into my rest-module: > > module namespace page = 'rev'; > > declare > %rest:error("*:notfound") > %rest:error-param("description", "{$description}") > function page:not-found-error($description as xs:string) > { > <rest:response> > <http:response status="404"> > <http:header name="Content-type" value="text/plain"/> > </http:response> > </rest:response>, $description > }; > > declare > %rest:path("softwareberatung/rev/{$year}/{$id}") > %rest:GET > %output:method("json") > function page:get-revenue( > $year, > $id > ) { > error(xs:QName('err:notfound'), 'Revenue ' || $id || ' does not exist') > }; > > but not if I put this code into module rest_errors.xqm: > > module namespace err = "error"; > declare namespace rest = "http://exquery.org/ns/restxq"; > declare namespace http = "http://expath.org/ns/http-client"; > > declare > %rest:error("*:notfound") > %rest:error-param("description", "{$description}") > function err:not-found-error($description as xs:string) > { > <rest:response> > <http:response status="404"> > <http:header name="Content-type" value="text/plain"/> > </http:response> > </rest:response>, $description > }; > > > and import the module: > > module namespace page = 'rev'; > import module namespace err="error" > at "../repo/rest_errors.xqm"; > > declare > %rest:path("softwareberatung/rev/{$year}/{$id}") > %rest:GET > %output:method("json") > function page:get-revenue( > $year, > $id > ) { > error(xs:QName('err:notfound'), 'Revenue ' || $id || ' does not exist') > }; > > > This returns status code 400 instead of 404! > > Regards > > Christoph > > > > Am 05.03.2017 um 12:31 schrieb Marco Lettere: >> Hi Chrostoph, >> the best way I've found out to organize error responses in a RestXQ >> context is to exploit BaseX built-in error interceptors. [1] >> What we usually do is write a module with interceptors (basically >> annotated functions ) like the following: >> >> module namespace e = "urn:myerr"; >> >> declare >> %rest:error("*:notfound") >> %rest:error-param("description", "{$description}") >> function e:login-error($description as xs:string) >> { >> <rest:response> >> <http:response status="404"> >> <http:header name="Content-type" value="text/plain"/> >> </http:response> >> </rest:response>, $description >> >> }; >> >> Here we just use <rest:response> to hand-craft the response we need >> when an exception with the annotated code (*:notfound) is generated >> (and not catched before). >> In your case rewriting your throwing like the following would then be >> catched by the above interceptor. >> >> fn:error(xs:QName('err:notfound'), 'Invoice ' || $id || ' does not >> exist'). >> >> You can intercept with the proper annotations all information you >> usually have in an exception handler (line number, value, stack >> trace, ...) and this can be exploited, for example, in order to make >> the status of the response dynamic. You could pass it into the error >> interceptor with the value field for instance. >> >> Hope you can move ahead with this info. >> Regards, >> Marco. >> >> [1] http://docs.basex.org/wiki/RESTXQ#Error_Handling >> >> >> On 05/03/2017 07:33, Christoph Gaukel wrote: >>> Hi, >>> >>> i tried to return http-status 404, but my service returns status 400: >>> >>> This is the code in my XQuery: >>> >>> fn:error(xs:QName('error'), 'Invoice ' || $id || ' does not exist', >>> 404) >>> >>> >>> This is what curl prints: >>> >>> * Trying 127.0.0.1... >>> * Connected to localhost (127.0.0.1) port 8984 (#0) >>> > GET /softwareberatung/revenues/2015/15-123 HTTP/1.1 >>> > Host: localhost:8984 >>> > User-Agent: curl/7.47.0 >>> > Accept: */* >>> > >>> < HTTP/1.1 400 Bad Request >>> < Set-Cookie: JSESSIONID=cfedc7x61od51p8o40uxm8dfe;Path=/ >>> < Expires: Thu, 01 Jan 1970 00:00:00 GMT >>> < Content-Type: text/plain;charset=UTF-8 >>> < Content-Length: 97 >>> < Server: Jetty(8.1.18.v20150929) >>> < >>> Stopped at /home/christoph/basex/restxq/Revenue.xqm, 64/19: >>> * Connection #0 to host localhost left intact >>> [error] Invoice 15-123 does not exist >>> >>> >>> Regards >>> >>> Christoph Gaukel >>> >>> >> >> >

1 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk