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

.
by Christian Grün 24 Feb '22

24 Feb '22

It’s a dire day. We wish safety and the rapid establishment of peace to our fellows and friends in Ukraine. BaseX 9.7 was scheduled for today, it will be postponed.

3 4

string-join with a newline separator?
by Ben Engbers 24 Feb '22

24 Feb '22

Hi, My xml has the structure <base> <element1> <al-group> <al>bla</al> </al-group> </element1> <element1> <al-group> <al>bla</al> </al-group> <al-group> <al>bla</al> </al-group> </element1> </base> The <al-group> element contains 1 to many <al> elements. let $tekst := fn:string-join(fn:data($par//al/text()), ".") concatenates this to: bla.bla.bla But I want it to return: bla bla bla Is it possible to add a newline item-separator to fn:string-join? Ben Engbers

4 4

How to call XQuery function from Java?
by Paul L. Merchant Jr. 23 Feb '22

23 Feb '22

Is it possible for a Java function called from XQuery in BaseX to call back to an XQuery function that's passed to it in BaseX? I haven't been able to find any documentation or examples of this. I got the following example to work, but it doesn't feel right. Is there a better way that might take advantage of the automatic type conversions BaseX performs and doesn't require calling something named "...Internal"? Thanks! ------------------- xquery ------------------- import module namspace java = 'java:my.Module; declare function local:hello($p as xs:string) as xs:string { concat("Hello ", $p) }; java:invoke(local:hello#1) ------------------- Java ------------------- package my; import java.io.UnsupportedEncodingException; import org.basex.query.QueryException; import org.basex.query.QueryModule; import org.basex.query.value.type.AtomType; import org.basex.query.value.item.FuncItem; import org.basex.query.value.item.Str; import org.basex.query.value.Value; import org.basex.util.InputInfo; public class Module extends QueryModule { public String invoke(final FuncItem func) throws UnsupportedEncodingException, QueryException { InputInfo ii = new InputInfo("my.Module.invoke", 0, 0); String s = "Java"; Str p1 = new Str(s.getBytes("UTF-8"), AtomType.STRING); Value[] args = new Value[] {p1}; String r = (String) func.invokeInternal(queryContext, ii, args).toJava(); return r; } }

2 1

Content is not allowed in prolog
by Ben Engbers 23 Feb '22

23 Feb '22

Hi, I have a directory with 12 testfiles. In the BaseX-GUI, the command: CREATE DB Parl_Test /home/bengbers/R/x86_64-redhat-linux-gnu-library/4.1/RBaseX/extdata/xml_files/ Creates database "Parl_Test" and loads the xml-files. In my R-client, Session$Create("Parl_Test") creates database "Parl_test"=> OK I want to create the same database with my client. I initialize the variable "XML_Files" with "/home/bengbers/R/x86_64-redhat-linux-gnu-library/4.1/RBaseX/extdata/xml_files". The client translates the command: Session$Create("Parl_Test", XML_Files) into a raw vector: '\bParl_Test\0/home/bengbers/R/x86_64-redhat-linux-gnu-library/4.1/RBaseX/extdata/xml_files' which is sent to the server. But the server responds with: "\"Parl_Test.xml\" (Regel 1): Content is not allowed in prolog." I didn't touch the xml-files. Where is the content inserted? Ben Engbers

3 13

feature request: opening database at arbitrary file path
by Eric Levy 22 Feb '22

22 Feb '22

I recently learned that BaseX offers no true support for access to a database given directly by its path. In contrast, opening a database by file path is a well-established pattern in embedded databases, seen for example in SQLite, which permits use of any database given by an arbitrary path, without any dependence on external configuration or other data elsewhere on the system. I wish to submit as a feature request the suggestion that BaseX include similar support.

6 23

Faster in the cloud?
by Jonathan Robie 22 Feb '22

22 Feb '22

If I am running my queries and updates on a typical laptop, would they run much faster if I ran them on a suitably configured instance in the cloud? I know this is a very general question, but I'm wondering what experiences y'all have had with this. Jonathan

6 8

How to produce multipart/mixed results with RESTXQ?
by Imsieke, Gerrit, le-tex 22 Feb '22

22 Feb '22

I was faintly hoping that a sequence will be magically output as multipart/mixed with appropriate part content types when I annotate it with %rest:produces("multipart/mixed"): declare %rest:GET %rest:path("/test") %rest:produces("multipart/mixed") function my:test-multipart() { (<ok/>, json:serialize(map{'some':'json'})) }; But the response header says "Content-Type: application/xml", and the result is <ok/> { "some": "json" } Are there some other functions or annotations or rest:response elements that I can use in order to get multipart/mixed correctly assembled? Bonus: With the possibility to add file names to each chunk? Gerrit

2 1

REST API
by Paul L. Merchant Jr. 22 Feb '22

22 Feb '22

Hi everyone, I have a couple of questions about BaseX's REST API and how it executes stored XQuery. I'm evaluating how much effort would be involved in porting an existing XQuery code base to BaseX. The existing code is a directory of XQuery scripts and modules that are called over a REST interface. They aren't RESTXQ aware, although with some work they could be converted if needed. (I'd prefer to do as little modification as possible initially, however.) I've installed BaseX 9.6.4 on Mac OS in a directory I'll call BASEX_HOME. In $BASEX_HOME/.basex, I have WEBPATH set to $BASEX_HOME/webapp (the default) and RESTPATH = "" (the default). I also set an appropriate user and password. I've placed the following two scripts in $BASEX_HOME/webapp: -------- t1.xq -------- import module namespace t2="t2" at "t2.xq"; t2:response() -------- t2.xq -------- module namespace t2="t2"; declare function t2:response() as xs:string { "Hello World!" }; -------- When I run the first script using curl, I get an error back that the second cannot be located in the $BASEX_HOME directory not $BASEX_HOME/webapp as I expected: $ curl http://localhost:8984/rest?run=t1.xq Stopped at ., 3/1: [XQST0059] Could not retrieve module: $BASEX_HOME/t2.xq. Is this the expected behavior, or is BaseX resolving the path to module t2 incorrectly? In any case given this behavior, if I want to point RESTPATH outside the BaseX installation to a much larger library of XQuery, how can I share modules within the library without having to use absolute paths for everything? My second question is simply, is it possible to set a cookie in response to a REST (not RESTXQ) response? Thanks! -- Paul

3 3

Adding lots of files in a defined order
by Jonathan Robie 22 Feb '22

22 Feb '22

I have 929 files with names like these: 01-Gen-001.xml 01-Gen-002.xml 01-Gen-003.xml 01-Gen-004.xml 01-Gen-005.xml 01-Gen-006.xml 01-Gen-007.xml 01-Gen-008.xml 01-Gen-009.xml 01-Gen-010.xml I would like to add them to a new database in the same order that I see if I do $ ls in that directory, without using XInclude to put them inside another node. Is there an easy way to do that? Jonathan

2 2

Using %unit:after to verify database creation
by Eliot Kimber 20 Feb '22

20 Feb '22

I’m working out my new-and-improved orchestration mechanism using the job-chaining approach and I’m not getting the unit test behavior I was expecting. My current unit test is: declare %unit:after("test:runMultipleJobs") function test:afterRunMultipleJobs() { ( for $database in $test:dbs return unit:assert(db:exists($database), 'Expected database ' || $database || ' to exist') ) }; declare %unit:test function test:runMultipleJobs() { let $jobs as xs:string* := ( for $database in $test:dbs return dbadmin:makeJob('dbadmin:createDatabase', $database) ) let $jobIds as xs:string* := orch:runJobs($jobs) return ( unit:assert-equals(count($jobIds), 3, 'Expected 3 job IDs') ) }; When I run this test I expect it to either pass (because my job-runner caused all the databases to be created) or fail on “db2” (because I can see that the first database db1 is created by inspecting the Databases via the DBA console after running the test, but the others are not). What I’m getting, however, is that the assert in the test:afterRunMultipleJobs() fails on db1, meaning it doesn’t see that that database has in fact been created. This must be an issue with when the test runner can actually see that the database exists or a timing issue with when the job runs relative to the unit test code. I did experiment with having both the base unit test and the after function sleep before doing the existence assertion but that seemed to have no effect, which suggests that the runner simply can’t see databases created by the tests it runs. Is the inability to see the newly-created databases simply a limitation in the test runner or am I doing something wrong? Thanks, E. _____________________________________________ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.com> LinkedIn<https://www.linkedin.com/company/servicenow> | Twitter<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Facebook<https://www.facebook.com/servicenow>

2 9