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

Problem with db:create and addraw
by Lizzi, Vincent 17 Sep '19

17 Sep '19

Greetings, I am seeing different behavior between XQuery db:create() and the command CREATE DB when trying to create a database from a zip file, which is causing a problem. I want to import a zip file that contains XML and binary files (images, ets.) into a new BaseX database using db:create() in a web app. The command "CREATE DB" works as expected. For example, after running this script all contents of the zip file, including XML and binary files, are stored in a new database named "test". SET ADDRAW true SET ADDARCHIVES true SET ARCHIVENAME false CREATE DB test C:\path\to\file.zip The XQuery function db:create() is not working correctly. The following query should be equivalent to the above command script, however binary files get placed in a new folder that is created in the folder where BaseX was launch, and the binary files cannot be accessed through BaseX. The binary files should be placed in a "raw" folder within the folder for the database within BaseX' s data directory the same as what CREATE DB produces. db:create('test', ' C:\path\to\file.zip ', (), map{ 'addraw': 'true', 'addarchives': 'true', 'archivename': 'false' }) I've tried this in BaseX versions 9.0.2 and 9.2.4, both produce the same results. Is there a way to resolve this problem? Thanks, Vincent Vincent M. Lizzi - Digital Production Manager Taylor & Francis Group 530 Walnut St., Suite 850, Philadelphia, PA 19106 E-Mail: vincent.lizzi(a)taylorandfrancis.com<mailto:vincent.lizzi@taylorandfrancis.com> Phone: 215-606-4221 Web: http://www.tandfonline.com/ Taylor & Francis is a trading name of Informa UK Limited, registered in England under no. 1072954 "Everything should be made as simple as possible, but not simpler." Information Classification: General

2 5

Re: [basex-talk] binding-types?
by Bridger Dyson-Smith 16 Sep '19

16 Sep '19

Hi Ben - Does something like: ``` declare variable $name external; for $i as xs:integer in 1 to 5 return element { $name } { $i } ``` work any differently? Best, Bridger On Thu, Sep 12, 2019 at 10:49 AM ben.engbers(a)be-logical.nl < ben.engbers(a)be-logical.nl> wrote: > xs:string is neither accepted and says that no namespace is defined for > 002xs:string > > Ben > > > -------- Oorspronkelijk bericht -------- > Onderwerp: [basex-talk] binding-types? > Van: Ben Engbers > Aan: Basex Mail-lijst > Cc: > > > Hi, > > While creating a R-package, based on my R client-implementation, I found > that the binding function was malfunctioning. > > After rewriting that function, the following is accepted: > query_txt <- "declare variable $name external; for $i in 1 to 5 return > element { $name } { $i }" > query_obj_1 <- Query(Sess, query_txt) > success <- query_obj_1$queryObject$Bind("name", "number") > print(query_obj_1$queryObject$ExecuteQuery()) > > results in: > "1" "2" "3" > "4" "5" > > When I change the line > 'success <- query_obj_1$queryObject$Bind("name", "number")' in > success <- query_obj_1$queryObject$Bind("name", "number", "xs:integer") > the following error is produced: > "[XPST0081] No namespace declared for '\002xs:integer'." > > What types are accepted? > > Ben > >

2 1

XQuery Update and Namespace Manipulation
by Andreas Mixich 14 Sep '19

14 Sep '19

Hi, copy $c := <lorem>ipsum dolor sit amet</lorem> modify insert node namespace {"lipsum"} {"lorem-ipsum"} into $c return $c Expected result: <lipsum:lorem xmlns:lipsum="lorem-ipsum">ipsum dolor sit amet</lipsum:lorem> but I get <lorem>ipsum dolor sit amet</lorem> copy $c := <lorem>ipsum dolor sit amet</lorem> modify replace node $c/namespace-node() with namespace {"lipsum"} {"lorem-ipsum"} return $c Here I get an error: [XQST0134] Namespace axis is not supported. How can I change namespaces for nodes with the simple update expressions? For background: I try to implement a function: declare function local:add-namespaces-to-nodes( $nodes as element()*, $namespaces as array(*)*) as element()* { for $namespace in $namespaces for $node in $nodes return copy $c := $node modify insert node (namespace {$namespace(1)} {$namespace(2)}) into $c return $c }; Thanks! -- Minden jót, all the best, Alles Gute, Andreas Mixich

3 7

Re: [basex-talk] binding-types?
by ben.engbers＠be-logical.nl 12 Sep '19

12 Sep '19

1 0

binding-types?
by Ben Engbers 12 Sep '19

12 Sep '19

Hi, While creating a R-package, based on my R client-implementation, I found that the binding function was malfunctioning. After rewriting that function, the following is accepted: query_txt <- "declare variable $name external; for $i in 1 to 5 return element { $name } { $i }" query_obj_1 <- Query(Sess, query_txt) success <- query_obj_1$queryObject$Bind("name", "number") print(query_obj_1$queryObject$ExecuteQuery()) results in: "<number>1</number>" "<number>2</number>" "<number>3</number>" "<number>4</number>" "<number>5</number>" When I change the line 'success <- query_obj_1$queryObject$Bind("name", "number")' in success <- query_obj_1$queryObject$Bind("name", "number", "xs:integer") the following error is produced: "[XPST0081] No namespace declared for '\002xs:integer'." What types are accepted? Ben

1 0

Stack overflow instead of syntax error
by Buddy Kresge 11 Sep '19

11 Sep '19

We have some code generation and it produced a syntax error. However, running 9.2.4 in production, the server gave a stack overflow tail recursion instead of "Cannot convert xs:integer to xs:date: 1970." (like the GUI did). Here was the error reported: java.lang.RuntimeException: org.basex.core.BaseXException: Stack Overflow: Try tail recursion? Here is the snippet of code that originally cause the 'stack overflow'. The issue is the date is not in quotes. function($endDate as xs:date?) as xs:Boolean { let $intervalBeginDate := xs:date(2019-09-30) let $intervalEndDate := xs:date(2019-09-30) return ($endDate ge $intervalBeginDate) and ($endDate le $intervalEndDate) }; However, when I fix the code generation, everything is fine (see new code below). Just seems "strange" that this would cause the server to throw a 'stack overflow' error. function($endDate as xs:date?) as xs:Boolean { let $intervalBeginDate := xs:date('2019-09-30') let $intervalEndDate := xs:date('2019-09-30') return ($endDate ge $intervalBeginDate) and ($endDate le $intervalEndDate) }; Buddy

2 2

Re: [basex-talk] GUI, visualization panels
by Giuseppe G. A. Celano 10 Sep '19

10 Sep '19

Hi, no, I just open the GUI and then an XML document. Thanks. > On Sep 9, 2019, at 2:52 PM, Alexander Holupirek <alex(a)holupirek.de> wrote: > > Hi Giuseppe, > > just gave it a try using basex 9.2.4 with java version "1.8.0_121" on macOS 10.14.6. > I was not able to reproduce the issue so far. > > One thing, did you open a database first? Visualization are only available on (opened) databases (not in-memory documents, such as XML read from filesystem, http, ...) > > Kind regards, > Alex > >> On 7. Sep 2019, at 15:56, Giuseppe G. A. Celano <celano(a)informatik.uni-leipzig.de> wrote: >> >> 1.8.0_171 >> >> Thanks. >> >> >> >>> On Sep 7, 2019, at 1:43 PM, Alexander Holupirek <alex(a)holupirek.de> wrote: >>> >>> Hi Giuseppe, >>> >>> what java version do you use? >>> >>> Kind regards, >>> Alex >>> >>>> Am 07.09.2019 um 11:42 schrieb Giuseppe G. A. Celano <celano(a)informatik.uni-leipzig.de>: >>>> >>>> Hi, >>>> >>>> Apparently, I cannot access the visualization panels in the GUI on my Mac (10.13.6) (they cannot be selected): am I missing anything? Thanks. >>>> >>>> Best, >>>> Giuseppe >>> >> > >

1 0

Passing through entities unchanged when serializing
by Andreas Mixich 09 Sep '19

09 Sep '19

Hi, when serializing a string, that contains literal XML with entities, how do I pass through those entities unchanged? Example: let $input := "<p>Lorem ipsum ' dolor sit amet </p>" return serialize($input) results in: <p>Lorem ipsum dolor sit amet, ' consectetur adipisicing elit.</p> but I want: <p>Lorem ipsum dolor sit amet, ' consectetur adipisicing elit.</p> -- Minden jót, all the best, Alles Gute, Andreas Mixich

3 7

GUI, visualization panels
by Giuseppe G. A. Celano 07 Sep '19

07 Sep '19

Hi, Apparently, I cannot access the visualization panels in the GUI on my Mac (10.13.6) (they cannot be selected): am I missing anything? Thanks. Best, Giuseppe

1 0

Keeping access to .logs after Docker crash.
by France Baril 03 Sep '19

03 Sep '19

Hi, we are experimenting with Docker and get a lot of system crash, However, since we need to recreate the container each time, we can't get access to error messages. I'm not sure if our issue is from the lack of Docker experience, but we'd be open to ideas on tracking issues when using containers. Thanks -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

1 0

Test if basexserver is running?
by Ben Engbers 02 Sep '19

02 Sep '19

Hi, Last year I have written a R-client for basex (https://github.com/BaseXdb/basex/tree/master/basex-api/src/main/r/RbaseXCli…). The present version uses no exception handling and you have to include the source-file in your R-code. A much cleaner solution would be catch all the errors and to pack the sources in a package. At this moment, I am working on such a R-package. The first test that should be executed in the package, is to test if a basexserver is available. How can I test on Linux, Apple and Windows if a baseserver is running? Ben

2 2

BaseX Docker logs
by Marie Starck 31 Aug '19

31 Aug '19

Hello, I am currently running a BaseX server with Docker and for the past week, it has exited twice with this message: /usr/local/bin/basexhttp: line 20: 25 Killed java -cp "$CP" $BASEX_JVM org.basex.BaseXHTTP "$@" I want to debug more but I haven't been able to find the basex .logs in my docker container. I am using basexhttp:8.6.4. Any ideas where it could be? Thank you very much, Marie

2 2

xs:string("<")
by Giuseppe G. A. Celano 25 Aug '19

25 Aug '19

Hi, I am wondering why xs:string("&") is not possible, but xs:string("<") is (although XML does not allow both ). Is there any reason? Thanks. Best, Giuseppe

2 2

Reg : Runtime error
by chandra Sekhar 24 Aug '19

24 Aug '19

Dear Basex Team, We are getting below error while adding xml's to collection.Please let us know any solution for this error Exception ::org.basex.core.BaseXException: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.9 Java: Oracle Corporation, 1.7.0_79 OS: Linux, amd64 Stack Trace: java.lang.RuntimeException: Insertion at beginning of populated table. at org.basex.util.Util.notExpected(Util.java:53) at org.basex.io.random.TableDiskAccess.insert(TableDiskAccess.java:371) at org.basex.data.Data.insert(Data.java:901) at org.basex.data.Data.insert(Data.java:710) at org.basex.core.cmd.Add.run(Add.java:103) at org.basex.core.Command.run(Command.java:329) at org.basex.core.Command.execute(Command.java:94) at org.basex.core.Command.execute(Command.java:117) at org.basex.server.ClientListener.execute(ClientListener.java:384) at org.basex.server.ClientListener.add(ClientListener.java:355) at org.basex.server.ClientListener.run(ClientListener.java:100) Regards, Chandrasekhar

2 10

Processing instruction constructors: problem with output
by Tim Thompson 22 Aug '19

22 Aug '19

Hello, I'm trying to output an XForms (XSLTForms) document from a RESTXQ endpoint, but the necessary processing instructions are being serialized in XML comments in the output, e.g.:  Am I missing something? XQuery: xquery version "3.1"; module namespace test = "test"; declare %rest:path("/test") %rest:GET %output:method("xhtml") function test:home() as document-node() { document { processing-instruction { "xml-stylesheet" } { 'type="text/xsl" href="static/xphoneforms/build/xsl/xsltforms.xsl"' }, processing-instruction { "xsltforms-options" } { 'debug="no"' }, processing-instruction { "css-conversion" } { 'no' } , <html xmlns="http://www.w3.org/1999/xhtml" xmlns:xforms=" http://www.w3.org/2002/xforms" xmlns:ev="http://www.w3.org/2001/xml-events" xmlns:my="test" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd=" http://www.w3.org/2001/XMLSchema"> <head> <title>Test</title> </head> <body> <h1>Placeholder</h1> </body> </html> } }; -- Tim A. Thompson Discovery Metadata Librarian Yale University Library

4 8

ePub zips via REST and functional XQuery
by Majewski, Steven Dennis (sdm7g) 22 Aug '19

22 Aug '19

BTW: I was pleasantly surprised to discover that when I made a BaseX database with an ePub zip file, and selected the appropriate options ( Parse files in archives, add other files as raw files ) I was able to serve and view the ePub files thru the rest interface, and links from the TOC to other document parts, as well as images in the ePUB all worked. I’m also enjoying learning to use some of the higher order function capabilities of XQuery 3.1 . The arrow syntax and the partial function application seem to be a great way to build a pipelines of transforms that can mix xslt:transform with XQuery functions . The results here aren’t very useful — I was just learning and testing the syntax, but this uses the partial application ‘?’ Syntax to convert functions of N-args to functions of 1 arg, and build a list of 1-arg functions to feed to fold-left. The use case would be to create a map of lists of pipeline functions to be applied for different targets. Not sure if maintaining pipeline lists is a better way to manage this than just building pipelines using arrow => operator, but I was just trying to explore some of the possible methods. let $docid := 'SIB/sibv060.xml' let $t1 := xslt:transform( ?, "/projects/SIB/add_id_bov.xsl" ) let $t2 := xslt:transform( ?, "/projects/XTF/xtf.lib/style/dynaXML/docFormatter/tei/teiDocFormatter.xsl", map{ 'docId' : $docid }) let $t3 := function($in) { $in//* } let $pipe := ( $t1, $t2, $t3, function($x) { $x ! name(.) }, distinct-values#1 ) let $chain := function( $a, $b ) { $b($a) } return fold-left( $pipe, doc($docid) , $chain )

2 2

Db:list-details()/@modified-date
by Majewski, Steven Dennis (sdm7g) 21 Aug '19

21 Aug '19

I thought I could use db:list-details($db)/@modified-date to select the resources that have most recently been updated ( to generate an OAI or RSS feed ) however, on doing a db:replace of one of the resources, I’m either not seeing the date change at all, or I’m seeing the modified-date of all of the resources update together. I find an explanation in the archives: https://www.mail-archive.com/basex-talk@mailman.uni-konstanz.de/msg09668.ht… > Exactly: Nothing will be replaced in BaseX if your source and target > XML node is identical (this holds true for both documents as well as > any other node in a document). > > Please note that XML documents have no individual timestamps in BaseX. > Instead the timestamp of the database will be changed if nodes are > changed. > Do I parse that correctly in saying that when I try to replace a document with an identical document, it doesn’t register as an update, but when I do change and update the document, it changes the timestamp for the whole database, and there is no timestamp for individual resources ? So I assume that if I want to track updated resources, I would have to either add timestamps to the documents themselves, or else track this info somewhere else, maybe in SQL and use sql: functions from within BaseX. Maybe best method is to add timestamp as a processing instruction or comment to avoid any changes to the body of the document: insert node processing-instruction modifiedDateTime { current-dateTime()} as first into $D That would work if doing the updates from an XQuery script and calling db:replace and then adding the timestamp, However, not very reliable if the resource can be updated by another method ( WEBDAV for example ) unless there is a way to trigger xquery function on update. I find from searching the mailing list archives a link to an issue discussing adding database triggers, but it appears to be on hold: https://github.com/BaseXdb/basex/issues/1082 Any news on this or suggestions of alternatives ? — Steve Majewski

2 2

read file permissions
by Ветошкин Владимир 21 Aug '19

21 Aug '19

2 2

BaseX GUI just spins?
by Buddy Kresge 21 Aug '19

21 Aug '19

I have a situation that I don't know if others are experiencing - but it has happened quite a bit over the last week with 9.2.4 I have the below function. declare function base:employeeIdMostRecentInstancesBetweenMap ($rangeBeginDate as xs:date, $rangeEndDate as xs:date, $employee as element()?, $query as function(xs:date, xs:date, item()*) as item()*) as map(xs:string, item()*) { let $allInstances := $query($rangeBeginDate, $rangeEndDate, $employee ) let $resultsMap := base:instancesBetweenMap($allInstances, $rangeBeginDate, $rangeEndDate) return $resultsMap }; I then wanted to put in a statement that would throw an error and return some information so that I could debug a situation. Basically I just added one statement to throw the error. Now when I run, BaseX Gui just spins and spins and spins. No value is returned. Never gets to this statement. I take out the let statement and it all works again. declare function base:employeeIdMostRecentInstancesBetweenMap ($rangeBeginDate as xs:date, $rangeEndDate as xs:date, $employee as element()?, $query as function(xs:date, xs:date, item()*) as item()*) as map(xs:string, item()*) { let $foo := error(xs:QName("err"), concat("val: ", "here - this is where I would put the info I wanted to display." )) let $allInstances := $query($rangeBeginDate, $rangeEndDate, $employee ) let $resultsMap := base:instancesBetweenMap($allInstances, $rangeBeginDate, $rangeEndDate) return $resultsMap }; Any insights you can provide would be greatly appreciated. Buddy

3 5

Best methods for improving query speed with large joins
by Marko Niinimaki 21 Aug '19

21 Aug '19

Dear all, I have a database with suppliers/parts/orders/customers/listitems and I'm trying to gain performance for queries like "sum up all orders where customers are in Japan". This results to many joins of documents representing each type of entity. With a relational database I'd use foreign keys. It looks like BaseX supports DTD's. Would creating DTD's improve the query speed? In the mailing list I saw only one reference to this https://www.mail-archive.com/basex-talk@mailman.uni-konstanz.de/msg02586.ht…. In the response "a DTD-aware XQuery processor can supply the id() and idref() XPath functions. However, these do not work across documents, and the values must be legal XML identifiers. Having said that, most XML databases make indexes, so joins using FLWOR and values will work based on values." Based on that, I'd need to create a DTD for a structure that has id's and idref's and the corresponding document would be 1 GB large (to contain all the suppliers/parts/orders/customers/listitems). Would this make sense? Mark

2 1

Built-in collations
by Zimmel, Daniel 21 Aug '19

21 Aug '19

Hi, I found out that after adding the third-party jar to the classpath as described here (http://docs.basex.org/wiki/XQuery_3.1#Collations), I can finally alphanumeric-sort my map:keys: map:keys($map_ev) => sort('http://www.w3.org/2013/collation/UCA?lang=de;numeric=yes') Which I like a lot. Are there any plans on having this already shipped with BaseX in future releases? Thanks, Daniel

2 1

Map serialization
by Giuseppe G. A. Celano 19 Aug '19

19 Aug '19

Hi When maps are serialized, the text nodes of an element (e.g., <g>r</g>/text()) are serialized without quotes and tests with "instance-of" show that they actually are text nodes: Couldn't they be serialized with quotes? I see that with data(), the text is serialized with quotes although it is xs:untypedAtomic. Is there a reason why the text node is kept as such and, for example, no casting/atomization happens when it becomes a value in a map? Thanks. Best, Giuseppe

2 2

Binary module
by Giuseppe G. A. Celano 14 Aug '19

14 Aug '19

Hi I am playing around with the binary module. I have two simple questions: 1) convert:string-to-base64("sàà") returns sàà : what does it mean? I see in the documentation that I need to use string() to see the value of xs:base64Binary (c8Ogw6A=), but shouldn't xs:base64Binary already be outputted as c8Ogw6A= ? (This is actually displayed in the Info Panel). 2) bin:length(convert:integers-to-base64(x)) always returns one number, no matter how big the number is. In the documentation I read that the output of bin:length should be the size of binary data in octects: how is that possible? Thanks, Giuseppe

3 6

Declaring namespaces in xquery:eval call
by Buddy Kresge 13 Aug '19

13 Aug '19

I am trying to do something like xquery:eval("some:function()"), and when I go to execute I get "[XPST0081] No namespace declared for 'some:function' I did read the reference that was sited in your documentation for how to declare a namespace binding (http://www.jclark.com/xml/xmlns.htm), but am still having no luck Can you help me with what the map should look like given the following attempt: like xquery:eval("some:function()", map { ????? } ) Thanks in advance. Buddy Kresge

5 8

console.log ?
by Majewski, Steven Dennis (sdm7g) 10 Aug '19

10 Aug '19

Is there an equivalent to console.log or xsl:message in XQuery or BaseX ? I know I could use the basex file: module to write to a file, but is there anything that works with the logging system to direct output according to the context ? — Steve Majewski

2 3

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk