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

REPLACE fails when root has attributes
by Charles Duffy 16 Mar '12

16 Mar '12

> REPLACE inventory <root foo="bar">test</root> Stopped at line 1, column 24: Syntax: REPLACE [path] [input] Replace documents in database. Replaces documents in the current database.

1 1

ADD:REPLACE :: STORE:?
by Charles Duffy 15 Mar '12

15 Mar '12

Restated: "ADD is to REPLACE as STORE is to... what?" REPLACE, like ADD, expects the content given to be parsed rather than raw. ADDing the same content twice can result in two documents with the same name in the database; I'm presuming that duplicate STORE commands have similar peril attached. What is the appropriate mechanism to use when replacing one version of raw content with another?

2 1

nesting queries
by Cerstin Mahlow 15 Mar '12

15 Mar '12

Hi, I would like to have a nested xquery, but I am not sure if this is possible at all: When a user searches the corpus, he can save the hits he likes most. The result for the query is a form with checkboxes. The node IDs together with the query and a time stamp are saved in a second collection. This collections looks like this: <collection> <entry time="2012-03-04T17:24:53"> <node>1434455</node> <query>[text() contains text ('Daumen' ftand 'Auge' ftand 'halten') using stemming using language "de" distance at most 10 words ordered]</query> <person>xyz</person> <phraseme>Ad0024</phraseme> <selected>yes</selected> </entry> <entry time="2012-03-04T17:24:53"> <node>1475764</node> <query>[text() contains text ('Daumen' ftand 'Auge' ftand 'halten') using stemming using language "de" distance at most 10 words ordered]</query> <person>abc</person> <phraseme>Ad0024</phraseme> <selected>no</selected> </entry> </collection> When the user searches again with a different query, he will see the results as for the first search and is able to save only those that are not in the hit-collection. This is controlled by this part in the "return" part of the xquery in my perl client: { if (not (db:open("collect")//node[text() = \$node and ../phraseme[text() = "$phraseme"] and ../selected[text() = "yes"]])) then <input type="checkbox" name="NODE" value="{\node}"/> else "X" } Already saved hits get an "X" and new hits get the checkbox. For documentation, I would like to collect all queries a node could be found with. Thus, instead of printing "X", I would like to add an additional query-element to the entry-element, i.e., something like insert node <query>$query</query> after /collection/entry/node[text() = "\$node" and ../phraseme[text() = "$phraseme" and ../selected[text() = "yes"]]] to get: <collection> <entry time="2012-03-04T17:24:53"> <node>1434455</node> <query>[text() contains text ('Daumen' ftand 'Auge' ftand 'halten') using stemming using language "de" distance at most 10 words ordered]</query> <query>[text() contains text ('Daumen' ftand 'Auge') using stemming using language "de" distance at most 10 words ordered]</query> <query>[text() contains text ('Daumen' ftand 'Auge') distance at most 10 words ordered]</query> <person>xyz</person> <phraseme>Ad0024</phraseme> <selected>yes</selected> </entry> <entry time="2012-03-04T17:24:53"> <node>1475764</node> <query>[text() contains text ('Daumen' ftand 'Auge' ftand 'halten') using stemming using language "de" distance at most 10 words ordered]</query> <person>abc</person> <phraseme>Ad0024</phraseme> <selected>no</selected> </entry> </collection> However, I am not sure if it is possible at all to mix displaying (in the "then" part) and updating (in the "else" part) -- although I would like to update a different collection than I am searching. If it is possible, I guess I have to include the name of the collection for insertion by using db:open? Is it necessary to specify the exact place for insertion (as in my example) as this should be already determined by the condition? Best regards Cerstin -- Dr. phil. Cerstin Mahlow Universität Basel Deutsches Seminar Nadelberg 4 4051 Basel Schweiz Tel: +41 61 267 07 65 Fax: +41 61 267 34 40 Mail: cerstin.mahlow(a)unibas.ch Web: http://www.oldphras.net

2 2

Position information on errors for queries submitted via REST
by Charles Duffy 14 Mar '12

14 Mar '12

Howdy -- The GUI's feedback on errors, including line number and position, is an extremely useful feature. Is this information also available via the REST interface? If so, how is it enabled? Thanks!

2 5

BaseX: New XQuery 3.0 Features
by Christian Grün 14 Mar '12

14 Mar '12

Dear all, we have now added documentation to function items [1] and higher order functions [2] in our Wiki. These features are being introduced with XQuery 3.0, and they provide much more powerful ways to write real functional code with XQuery. We dare say that BaseX currently offers the most complete and up-to-date support for these new features! Thanks to our team member Leo, we will soon be able to offer the last pending 3.0 features, such as general flwor expressions, which allow an arbitrary order of FLWOR clauses (fot, let, order, group by, count, etc.) [3] By the way: BaseX 7.2 will be released in about 10 days. Stay tuned.. Christian [1] http://docs.basex.org/wiki/XQuery_3.0#Function_Items [2] http://docs.basex.org/wiki/Higher-Order_Functions [3] http://www.w3.org/TR/xquery-30/ ___________________________ BaseX Team Christian Grün Uni KN, Box 188 D-78457 Konstanz http://www.basex.org

3 5

Bind optional variables and/or bind node
by Ronny Möbius 14 Mar '12

14 Mar '12

Hello, I want to query a BaseX XML Database via Python (BaseXClient.py). Therefore I write a XQuery script, which executes a FLOWR expression combined with a few self-written functions. A bunch of options, which are generated within my Python script, have to externally bind to this query. For convenience it would be appropriate to have optional external variables which I do not have necessarily to bind, but which will have default values specified in the XQuery script. Is there a possibility to do this? I thought about an alternative, that is to declare the options with the help of a XML snippet. But then I could not figure out how to bind this snippet as a node instead of a string, because XQuery itself does not have a function to convert a String containing a XML document to a node. Of course I could create before each request a new options document in the database, but this seems to be a bit unhandy. All in all I have the impression, that those are quite easy problems, but for some reason I could not find any solution on the web, so I were glad about reading a solution to one of those problems. All the best, Ronny

3 3

full-text search with wildcard
by Shakila Shayan 13 Mar '12

13 Mar '12

Hello all, We are using Basex 7.0.2 and using wildcard for full-text search we ran into some problems when it comes to tokenization related issues. Our database contains these entries: bb (aa)bb bb(cc) (aa)bb(cc) We ran a test as following with the given results shown in each case: 1- .//value[text() contains text {'.*(bb)'} using wildcards] returned (aa)bb and (aa)bb(cc) 2- .//value[text() contains text {'.(bb).*'} using wildcards] returned bb(cc) and (aa)bb(cc) 3- .//value[text() contains text {'(bb)'} using wildcards] returned (aa)bb and (aa)bb(cc) and bb(cc) and bb so far so good, but the following case is the weird case: 4- .//value[text() contains text {'.*(bb).*'} using wildcards] returning only (aa)bb(cc) Can anyone explain why is the behavior of the last case different? Whereas it should be the most general case , it turns out to be the most exclusive one ? Are we missing something or is it a bug?

2 1

BaseX 7.1.1 WAR problems: Permissions and other issues
by pw＠themail.co.uk 13 Mar '12

13 Mar '12

Hello I am having the same problems with the WAR version of 7.1.1 as described for 7.0 earlier { https://mailman.uni-konstanz.de/pipermail/basex-talk/2011-October/0020 28.html } There is duplication of the servlet.jar that prevents it from starting. Then after deletion of the servlet.jar, there are problems with permissions (I don't know the reason for this) I would appreciate help in getting the WAR version working both with Tomcat and with Oxygen. Can anyone provide details of how to remedy the situation with BaseX711.war and also an 'idiots guide' on how to sort out permissions, connect Oxygen to the database, and access via webDAV and rest interfaces.? Many thanks Peter

3 2

say how to get "newline" working
by jidanni＠jidanni.org 12 Mar '12

12 Mar '12

On http://docs.basex.org/wiki/Serialization we see newline. But we have no idea how to make it work. Please add an example to that page! declare option output:method "text"; declare option output:newline "\n"; for $m in (1,2,3) return $m Nope no idea. basex: Installed: 7.1.1-2

7 20

Performance and the capital of Albania
by Andy Bunce 09 Mar '12

09 Mar '12

Using the factbook.xml database and a recent 7.1.2 beta, I am hitting some performance problems. To debug I have been trying some expressions in the GUI window. The goal is given a country id, get the capital. The examples use Albania ="f0_136" let $id:="f0_136" let $cap:=//country[@id=$id]/@capital return //city[@id=$cap] ------result------------ <city id="f0_1461" country="f0_136" longitude="10.7" latitude="46.2"> <name>Tirane</name> <population year="87">192000</population> </city> *Time: 0.7ms * Very nice. Sadly my code is not doing it like this! ( the xpath is being generated from some data description xml I have created) If I try in the GUI some Xpath variations they produce wildly different execution times let $id:="f0_136" return //city[@id=(//country[@id=$id]/@capital)] *26144ms* let $id:="f0_136" return //city[@id=//country[@id=$id]/@capital] *25157ms* let $id:="f0_136" return (//city)[@id=(//country[@id=$id]/@capital)] *550ms* let $id:="f0_136" return (//city)[@id=((//country)[@id=$id]/@capital)] *6087ms* I was expecting all these to perform about the same. They all produce the same result. /Andy

2 3