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

multiple inserts/update/deletes in single transaction
by Wang, Genneva 11 Aug '16

11 Aug '16

Hi I’m trying to figure out whether batched transaction would work for basex, and I came across the RUN and EXECUTE command specified in http://files.basex.org/releases/8.4/BaseX84.pdf page 58-59. The document mentioned following in the summary section: RUN:Evaluates the contents of file as XQuery expression. If the file ends with the suffix .bxs, the file content will be evaluated as command script. This command can be used to run several commands in a single transaction EXECUTE: Evaluates the specified input as command script. This command can be used to run several commands in a single transaction. I’ve tried this myself For example, I’d like to know if I batch 2 inserts, if one fails, would both inserts get rollback. I’m using a simple .bxs (attached and also listed below for your convenience) and run the execute using GUI. OPEN test ADD TO embedded7.xml <root>embedded</root> ADD TO embedded8.xml <root>embedded CLOSE The second ADD (embedded8.xml) is not a valid xml format so I’m expecting it to fail, and rollback both files if any of them have already added. But after executing this script, I’m seeing embedded7.xml have been added. Would you be able to confirm if this is the expected behavior ? If so, is there anyway that I can batch multiple inserts and ensures that these batch of files can be committed at the same time, and rollback all together if any of the file has an error ? Thank you very much for your help.

4 17

Starting multiple sessions in BaseX with Perl: compilation failed at Carp.pm
by Bram Vanroy | KU Leuven 30 Jun '16

30 Jun '16

Hi there BaseX people! Original post on StackOverflow: http://stackoverflow.com/questions/38086358/starting-multiple-sessions-in-ba sex-with-perl-compilation-failed-at-carp-pm I wanted to see if I could start multiple BaseX sessions (on a single server) to try some things out, but I can't even get the sessions to launch - heck, I can't even get the Perl script to compile! This is odd to me, because the same code works perfectly without multiple sessions. Let's say I have a subroutine that creates sessions given an amount. E.g. the following code would create 3 sessions (variables for dbhost, user and password left out): CreateSessions(3); # For testing my $session = $sessions[0]; sub CreateSessions { my ($amountofsessions) = @_; our @sessions = (); for (my $i = 0; $i < $amountofsessions; $i++) { my $session = Session->new($dbhost, 1950, $usr, $pw); push(@sessions, $session); } } I also tried other approaches, e.g. creating each session individually and assigning it to a variable, and then building an array with these variables. The same problem occurs: Compilation failed in require at /usr/share/perl5/Carp.pm line 33. When I look up that file and that line, it states: eval { require Carp::Heavy }; Which, I guess, means that I don't have the Carp module installed? But I do not understand why I would need this, and why that the Perl script works when I only create one session. Is it possible to launch multiple sessions from Perl that can work simultaneously, and if so, how do you launch these sessions and access them? It's important to note that in PHP, for another project but the same database, having multiple sessions does work. In other words, there I can have multiple sessions that run in parallel. We're on BaseX 7.9 and Perl 5.10.1. (Old, I know, but I can't change it.) Thank you for your time! Bram

2 4

How to cite BaseX
by Kristian Kankainen 29 Jun '16

29 Jun '16

Hello! I'm writing an article about my work on retro-digitizing a dictionary. The work has been a very enjoyable process using BaseX and Xquery since an original XML of the printed dictionary could be retrieved from the print files. If some one else on this list has experience of similar work, I'd be glad to read about it. Now to my question: How should I cite BaseX? I can't find it in the wiki nor on the main publications page... Best regards Kristian

2 1

unexpected whitespace-handling behavior in BaseX 8.3.1
by C. M. Sperberg-McQueen 28 Jun '16

28 Jun '16

I am experiencing unexpected behavior with a database I am working with in BaseX 8.3.1. The database is a collection of information about trials in the late Roman Republic (see http://tlrr.blackmesatech.com/ for more information), and while the upper-level elements have only element content, most of the actual data values are mixed content. I reloaded the data the other day, having run some cleanup processes on it to regularize the whitespace and make the XML source more readable. In one trial record, for example, the information about the defendant looks like this: <defGrp> <defendant> <namelist> <person-entry> <person pid="pSulpicius58Ser.Galba" ix="2" form="Sulpicius (+58), Ser. Galba" >Ser. Sulpicius Galba (58)</person> cos. 144 spoke pro se (ORF 19.II, III)</person-entry> </namelist> </defendant> </defGrp> (This says that the defendant in the case was one Servius Sulpicius Galba, whose biography is given as the 58th entry under "Galba" in the Pauly/Wissowa Reallexikon, that this man was consul in 144 BC, that he spoke on his own behalf, and that the extant fragments of his speech are printed in the collection Oratorum Romanorum Fragmenta (ORF) as items 19.II and 19.III.) After a little research, I learned (I think) how to make the default settings for the database have the value CHOP = false (I call db:create($dbname,(),(), map{ "chop": false{}) to create the db), and also (redundantly, I hope) to specify CHOP = false as an option on the db:add() and db:replace() calls I am using to reload records in the database. When the web front end retrieves the individual trial record whose defendant information is shown above, I get a result that looks essentially like what is shown above. When a different query retrieves just portions of the trial record, using the expression <trial id="{$e/@id}" tlrr1="{$e/@tlrr1}" doc="{document-uri(root($e))}">{ $e/date, $e/ccGrp, $e/defGrp(: /defendant :), $e/ppGrp(: /prosecutor :), $e/partiesGrp, $e/advGrp }</trial> the defendant information looks like this, according to both Safari and Opera: <defGrp> <defendant> <namelist> <person-entry> <person pid="pSulpicius58Ser.Galba" ix="2" form="Sulpicius (+58), Ser. Galba">Ser. Sulpicius Galba (58)</person>cos. 144 spokepro se(ORF19.II, III)</person-entry> </namelist> </defendant> </defGrp> Note that within the person-entry element, the whitespace adjacent to the 'person' and 'i' elements has disappeared. It looks almost as if some queries were stripping whitespace as part of the query, or as part of returning a result. To confuse me even further, dynamic queries using the dba application on the server return data with the whitespace chopped. Is there something obvious I am overlooking or doing wrong? Actually, I guess i have two questions: first, I'd like to figure out why BaseX is currently behaving as it does. And then I'd like to make it behave differently. I realize now that the documents I just updated all had xml:space="preserve" on their root elements, because I couldn't make this work last time I tried, either. I would much much rather avoid resorting to that again, if I can, since it feels like a hack and it complicates processing of the data. I will try to construct a minimum repeatable example that illustrates the problem, but I have not done so yet. thanks for any help anyone on the list can provide, Michael -- **************************************************************** * C. M. Sperberg-McQueen, Black Mesa Technologies LLC * http://www.blackmesatech.com * http://cmsmcq.com/mib * http://balisage.net ****************************************************************

3 8

storing passwords ...
by C. M. Sperberg-McQueen 26 Jun '16

26 Jun '16

Can any readers of this list recommend some reasonably prudent technique for handling passwords that an XQuery module will need to retrieve things via http? I suppose there are two questions: (1) where do people store such userid/password pairs? and (2) what's the best way to use them? For storing, it has occurred to me that I can: - hard-code them in the XQuery source - store them in an admin-info document in the XQuery database and look them up when needed - don't store them at all but require the request to pass them in as parameters (which offloads the burden of storing these things onto the client) The simplest way to use them is of course to inject them into the URL, but I recall being warned that this means they can show up in logs, so it's not a recommended practice. Probably it is better to use http:send-request() with username and password specified as attributes on the http:request method; anyone who can confirm or deny this, please do. I will be grateful for any and all guidance. -- **************************************************************** * C. M. Sperberg-McQueen, Black Mesa Technologies LLC * http://www.blackmesatech.com * http://cmsmcq.com/mib * http://balisage.net ****************************************************************

3 2

xquery retrieval evaluation
by Mohamed kharrat 26 Jun '16

26 Jun '16

Hello everybody, is anyone have a system or solution which can be available for comparing result with another retrieval system based on xquery. Thanks for all.

2 4

Tagsoup on Web app
by Ben Mitchell 24 Jun '16

24 Jun '16

Hi, Do you know if there is a simple way to install the tagsoup parser in the basex web app servlet - If so, is there an instruction set? Also, are there any plans to update the Ubuntu repositories with the latest versions? Many thanks Ben

4 6

basex function on db:store
by Wang, Genneva 24 Jun '16

24 Jun '16

Hi Basex guru, I understand that db:store and db:replace would replace the file for if the path already exist, I’m wondering if there is any other functions that would do the check on the path and provides an error code if path exists instead of just replace it ? Or do we need to check this specifically with db:exist ? Thanks! Regards, -Genneva

2 1

BaseX performance issue
by Wang, Yvonne 22 Jun '16

22 Jun '16

Hi BaseX team, We currently encountered performance issue using BaseX. We noticed that when # of documents increased in BaseX database, it will double time to retrieve documents in database. Our test cases execution time double when # of documents increased from 200 to 400. And If number of document reach to 5000, The test case execution time increase much more. Is that any performance testing BaseX team can share with us to compare, or there is any documentation or suggestion for BaseX database turning that we should follow? Thanks Yvonne

2 5

about changing default port 1984
by Mohamed kharrat 21 Jun '16

21 Jun '16

Hi everybody,i would like to know how to change the default port 1984 i'm working on windows, i open from /bin the basex.bat, then in console, command "help" works but the command "-p" do not works (it's show stopped at....) basexhttp.bat works (it's show me that server and http server are running correctly) but i can not write anything when i openbasexclient.bat , i write admin admin but then commands -p do not works, only "help" command works

3 7