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

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

Gets name of collection
by Anh Thuấn 09 Mar '12

09 Mar '12

Hi BaseX team, I 've met a problem of getting the name of the collection when retrievingXQuery. I am looking for a node satisfying a certain condition on multiple collections (each collection is a database of BaseX), when it returns a result, I want to know the name of that collection. For example, here is my query: for $node in (Collection("Database1"),Collection(Database2"))/a[@attribute = "name"] return $node // I want to get of the name of the collection of the returned node here. I don't know if BaseX supports a certain function to get the name of the collection from a node or something similar. Or does it has a way to know the node belongs to which collection?

2 1

Hint for documentation of command: legal database names
by Andreas Rulle 06 Mar '12

06 Mar '12

Dear BaseX team, in this mail you receive a small suggestion for the command documentation http://docs.basex.org/wiki/Commands#CREATE_DATABASE The comment from the source code, see the class org.basex.core.Command and its method validName, "allows only letters, digits, the underscore, and dash." could be added as information about legal characters for database names to the page http://docs.basex.org/wiki/Commands#CREATE_DATABASE . Okay it is a wiki and therefore could be editited directly, but I want to inform the team about this suggetion first. Perhaps the page could have a paragraph "legal identifiers". With best regards Andreas

3 2

Query
by chausel＠arcor.de 06 Mar '12

06 Mar '12

Hallo! gibt es eine Möglichkeit in der GUI eine Query so zu formulieren, dass als Ergebnis *nicht* so was rauskommt: <xml>Das was ich will</xml> sondern so was: Das was ich will Viele Grüße Carsten

2 1

Importing two modules from the same package -> "Module is declared twice"
by Charles Duffy 05 Mar '12

05 Mar '12

Howdy -- please see the following example: === expath-pkg.xml <?xml version="1.0"?> <package xmlns="http://expath.org/ns/pkg" spec="1.0" name=" http://dyfis.net/example/ns-test" abbrev="ns-test" version="0.1.136892+build.20120224.105428"> <title>Namespace Trouble Test</title> <xquery> <namespace>http://dyfis.net/example/ns-test/foo</namespace> <file>foo.xq</file> </xquery> <xquery> <namespace>http://dyfis.net/example/ns-test/bar</namespace> <file>bar.xq</file> </xquery> </package> === ns-test/foo.xq module namespace foo = "http://dyfis.net/example/ns-test/foo"; declare function foo:test() { 1 + 1 }; === ns-test/bar.xq module namespace bar = "http://dyfis.net/example/ns-test/bar"; declare function bar:test() { 1 + 1 }; === ...in the basex-gui buffer... import module namespace foo="http://dyfis.net/example/ns-test/foo"; import module namespace bar="http://dyfis.net/example/ns-test/bar"; 1+1 === ...results in... Error: [XQST0047] Module is declared twice: ' http://dyfis.net/example/ns-test/bar'.

2 2

db:list-details() @modified-date not valid xs:dateTime?
by Charles Duffy 05 Mar '12

05 Mar '12

Howdy -- I note that the modified-date attribute given in db:list-details() is not a valid xs:dateTime value (being "DD.MM.YYYY HH:MM:SS" rather than "YYYY- MM-DDTHH:MM:SS"). Would a patch correcting this be accepted, or is its current form considered part of the public API? Thanks!

2 2