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

XQUERY command and PHP
by Tsvetanka Georgieva-Trifonova 02 Dec '13

02 Dec '13

Hi Basex, My question is about the command XQUERY [query]. Does it work with any XQuery queries or only with XPath? I tried the following: <?php include("BaseXClient.php"); // create session $session = new Session("localhost", 1984, "admin", "admin"); $session->execute("open myfirstdatabase"); echo $session->execute("xquery for $n in //country[name = 'Switzerland'] return $n") ; // close session $session->close(); ?> This example causes the error: [XPST0003] Incomplete 'window' expression.' But the following example: <?php include("BaseXClient.php"); // create session $session = new Session("localhost", 1984, "admin", "admin"); $session->execute("open myfirstdatabase"); echo $session->execute("xquery //country[name = 'Switzerland']") ; // close session $session->close(); ?> is executed without error. The difference between the two examples is that one uses XQuery and another - XPath expression. Please, tell me whether the command XQUERY can be used with any XQuery queries and how exactly? Thanks & regards, Tsvetanka

2 1

Full text queries ok :)
by Ingarao Maud 02 Dec '13

02 Dec '13

Hello everybody Thanks to your help Christian, our full text queries yet work fine. I still don't understand exactly what the problem was and why we got 500 internal errors. Maybe a too heavy query and thus a memory problem ? Anyway now with this kind of writing, the queries are completed : declare function desanti:display-tags($collection, $dataType, $mode){ let $label := if($dataType = "subject") then "concepts" else "personnes" return <div class="{ $mode }"> <h6>{ $label }</h6> <span>{ for $term in $collection group by $term order by $term collation "?lang=fr" let $occurrences := count( ft:search('Desanti', $term)/..[local-name() = $dataType][ parent::*:controlaccess/ parent::*:c/ ancestor::*:dsc/ parent::*:archdesc/ parent::*:ead/ parent::document-node() ] ) return if($mode = "cloud") then ( <span><a style="font-size:{ $occurrences idiv 10 + 1 }em;padding:{ $occurrences idiv 10 }px;" title="{ $occurrences }" href="/restxq/desanti/{$label}/{$term}">{$term}</a></span> ) else ( <span class="{ $occurrences }"><a href="/restxq/desanti/{$label}/{$term}">{ $term }</a> ({ $occurrences }) </span> ) }</span> </div> }; Thanks a lot !!! Maud -- _« Ne travaillez jamais »_ MAUD INGARAO IHPC (UMR 5037) Institut d'histoire de la pensée classique, de l'Humanisme aux Lumières Ecole Normale Supérieure de Lyon - Site Descartes - Bureau R322 15 Parvis René Descartes - BP7000 - 69342 Lyon CEDEX 07 +33 4 37 37 65 79 - maud.ingarao(a)ens-lyon.fr _Je suis absente le vendredi | Out of office on Fridays_ http://pensee-classique.ens-lyon.fr [1] http://institutdesanti.ens-lyon.fr [2] http://ahn.ens-lyon.fr [3] http://www.mutec-shs.fr [4] http://www.projet-plume.org [5] http://www.cahier.paris-sorbonne.fr/ [6] Links: ------ [1] http://pensee-classique.ens-lyon.fr [2] http://institutdesanti.ens-lyon.fr [3] http://ahn.ens-lyon.fr [4] http://www.mutec-shs.fr [5] http://www.projet-plume.org [6] http://www.cahier.paris-sorbonne.fr/

1 0

Perf issue
by jean-marc Mercier 01 Dec '13

01 Dec '13

Hello, I am encountering a performance issue with BaseX interpreter, illustrated by the snippet code above. This code first creates a sequence of 100000 integers, taking more than a minute with my environment. Then it creates a BaseX map of 100000 integers, taking 0.1 sec. This issue seems to be due to a poor performance of the operator () (see function local:id below). This could be an issue for the BaseX interpreter, or a problem with my environment, but might be also a XQUERY 3.0 "leak". Have you any idea ? cheers Jean-Marc declare function local:id($el) as function() as item()* {function(){ $el }}; declare function local:new() {local:id(())}; declare function local:new($map,$item) {local:id(($map(),$item))}; let $nb := 100000 return let $testid := fn:fold-left(for $i in 1 to $nb return $i,local:new(), function($map,$entry){local:new( $map,$entry )}) let $basexmap := fn:fold-left(for $i in 1 to $nb return map:entry($i,$i),map:entry(0,0), function($entry,$map){map:new( ($map,$entry) )}) return (fn:count(prof:time( $testid )),fn:count(prof:time( $basexmap )))

2 3

default element namespace and restxq
by sechel＠math.tu-berlin.de 29 Nov '13

29 Nov '13

Hi, I'm experiencing problems using a default element namespace in a restxq module. Here is a working example taken from the default restxq module. All I addded is the namespace of the response element. module namespace page = 'http://basex.org/modules/web-page'; declare namespace test = 'http://test-namespace.org'; declare %rest:path("/ajax/hello/{$world}") %rest:GET function page:hello($world as xs:string) as element(test:response) { <test:response> <test:title>Hello { $world }!</test:title> <test:time>The current time is: { current-time() }</test:time> </test:response> }; If I now introduce a default element namespace just to simplify notation, I get a NullPointerException module namespace page = 'http://basex.org/modules/web-page'; declare default element namespace 'http://test-namespace.org'; declare %rest:path("/ajax/hello/{$world}") %rest:GET function page:hello($world as xs:string) as element(response) { <response> <title>Hello { $world }!</title> <time>The current time is: { current-time() }</time> </response> }; java.lang.NullPointerException at org.basex.query.expr.Arr.has(Arr.java:46) at org.basex.query.func.StaticFuncCall.has(StaticFuncCall.java:137) at org.basex.query.QueryContext.mainModule(QueryContext.java:203) at org.basex.http.restxq.RestXqResponse.create(RestXqResponse.java:66) at org.basex.http.restxq.RestXqModule.process(RestXqModule.java:108) at org.basex.http.restxq.RestXqFunction.process(RestXqFunction.java:100) at org.basex.http.restxq.RestXqServlet.run(RestXqServlet.java:31) at org.basex.http.BaseXServlet.service(BaseXServlet.java:58) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) Best regards Stefan -- Stefan Sechelmann DFG-Forschungszentrum Matheon Mathematik für Schlüsseltechnologien Technische Universität Berlin Sekretariat MA 8-3 Tel. 030/314 29 486 Straße des 17. Juni 136 Fax 030/314 79 282 10623 Berlin sechel(a)math.tu-berlin.de http://www.math.tu-berlin.de/~sechel

2 1

preprocessor instructions for BaseX XQUERY interpreters ?
by jean-marc Mercier 29 Nov '13

29 Nov '13

Hello, I have some questions about BaseX interpreter. 1) Is there a way to send preprocessor instructions to BaseX interpreter ? I am looking to a way to tell the interpreter to skip code based on external instructions, mainly to distinguish the behavior between debug / release modes. This is achieved in C++ with the macro set of instructions #define, #if, #endif etc... I was wondering whether there exists such a mechanism in XQUERY. Note : processor instructions might not be relevant for XQuery, since interpreters are heavily optimized. 2) Could you confirm that BaseX interpreter will not try to interpret "dead" code ? To emulate processor instructions with XQUERY, I am presently using dynamic local variable declarations as (declare function debug(){true()/false()}), and encapsulating my code with a lot of "if (debug()) then (.1.) else (.2.)". Can you confirm that BaseX interpreter skip looking at (.1.) or (.2.) accordingly to the debug function return value ? Cheers Jean-Marc

2 1

New user requiring help in population of database
by Ando Roy 28 Nov '13

28 Nov '13

Hi all, I'm a new user of BaseX and would like to get myself up to speed with development as quickly as possible.Hope to get some pointers from the experts here, as I'm still picking up the concepts required in the use of XML Databases. I am experimenting with porting over some content from an existing RDBMS project to BaseX and would like to know how to go about doing it. I have already designed a XML schema based on my RDBMS model and would like to know how I can quickly go about populating the database in BaseX. Just a few quick questions here: 1. How should I go about creating the tree structure and its nodes (i.e. elements with attributes)? I'm a little confused (perhaps because I'm trying to approach it from a RDBMS perspective). 2. Is there a quick way to populate the database from some existing data sets (i.e. CSV or text files)? Thanks! Regards, Roy

3 2

BaseX Interpreter / Eclipse integration issue ?
by jean-marc Mercier 28 Nov '13

28 Nov '13

Hi, Within my environment, I am experiencing some frustrating behavior of the Xquery Basex engine. I've done my best to single out the problem in the following XQUERY code : declare function local:wtf($x as item() ) {function() { $x}}; declare function local:dummy($f,$x) { if(fn:empty($f())) then local:wtf($x) else local:wtf(())}; declare variable $insert := local:dummy(function(){ () }, function() { (), ()} ); fn:count($insert()) The issues are : 1) executing this code yields an "Improper use? Potential bug?" exception (see details further on). 2) If I change the execution query to be fn:count(local:dummy(function(){ () }, function() { (), ()} )()) ( I just copy and pasted the value of $insert into the fn:count(..) ) then the query is executed normally, returning "1". 3) If I change the function declaration local:wtf as follow declare function local:wtf($x) {function() { $x}}; (I just removed "as item()"), then the query is executed normally, returning "1". Can you reproduce it with another environment ? Cheers, Jean-Marc Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.8 beta 6aeaebf Java: Oracle Corporation, 1.7.0_05 OS: Windows 7, amd64 Stack Trace: java.lang.NullPointerException at org.basex.query.value.item.FuncItem.inlineExpr(FuncItem.java:308) at org.basex.query.func.DynFuncCall.optimize(DynFuncCall.java:58) at org.basex.query.func.DynFuncCall.compile(DynFuncCall.java:39) at org.basex.query.expr.Arr.compile(Arr.java:40) at org.basex.query.func.StandardFunc.compile(StandardFunc.java:60) at org.basex.query.MainModule.compile(MainModule.java:63) at org.basex.query.QueryCompiler.compile(QueryCompiler.java:70) at org.basex.query.QueryCompiler.compile(QueryCompiler.java:61) at org.basex.query.QueryContext.analyze(QueryContext.java:270) at org.basex.query.QueryContext.compile(QueryContext.java:253) at org.basex.query.QueryProcessor.compile(QueryProcessor.java:71) at org.basex.core.cmd.AQuery.query(AQuery.java:81) at org.basex.core.cmd.XQuery.run(XQuery.java:22) at org.basex.core.Command.run(Command.java:323) at org.basex.core.Command.execute(Command.java:92) at org.basex.server.LocalSession.execute(LocalSession.java:121) at org.basex.server.Session.execute(Session.java:37) at org.basex.core.Main.execute(Main.java:146) at org.basex.BaseX.<init>(BaseX.java:119) at org.basex.BaseX.main(BaseX.java:38)

3 8

Reg : Group By Clause
by ChandraSekhar 28 Nov '13

28 Nov '13

Dear Team , I am following the below steps to execute my XQuery 1) I am Created collection with the MyFile.xml 2) I am running the query which is in attached file(query.txt) on the above collection 3) I am Grouping the C4 element for Grouping 4)I am running this query in java Java code : new XQuery(query).execute(context,fileoutstream); Query running properly when I am not using the group by clause Problem : If I use the group by ,exception is coming like out of main memory,can you please tell me Is their any alternate to reduce the memory when using group by Thanks & Regards Chandra Sekhar -- This message is for the intended recipient only. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of the information is strictly prohibited. __

2 1

HTML serialization error
by Lars Johnsen 28 Nov '13

28 Nov '13

When converting files from xml to html, there appeared a serialization error saying something to the effect that x84 was an illegal html character. The files were written using file:write with parameter $params defined as: let $params := <output:serialization-parameters><output:method value="html"/></ output:serialization-parameters> When sending the html directly to the browser (not writing to file and using the above declaration), the browser (chrome) appeared to be ok, and displayed the full html. Processing the text through normalize-unicode() didn't help. The error persisted. Is there a way to fix the text before submitting it to file:write()? All the best Lars G Johnsen National Library of Norway

2 2

how to develop our repository lib package?
by easy 28 Nov '13

28 Nov '13

hi,all, what's the extension package specifinition? can I install exist-db 's xar package into basex? -- 此致 easy 莫愁前路无知己，天下谁人不识君。

2 1