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

BaseX request from Saxon XSL transformation
by cmarchand＠oxiane.com 18 Nov '15

18 Nov '15

Hello, I have to query a BaseX database from a XSL transformation. Does someone has ever done this ? I have no idea where to look in... I use SaxonEE, so I can write an extension function, if needed... Best regards, Christophe

3 3

Upcoming: XMLPrague 2016
by Christian Grün 18 Nov '15

18 Nov '15

Dear all, In around three months, it will be the 5th time that we'd like to organize user meeting in Prague. This time, the XML Prague conference takes place from Thursday to Saturday, Feb 11-13, and our meeting will be onThursday. As you all do so many exciting things with BaseX, we would be more than interested to have some of you as speakers! We are very thankful to those of you who have already talked on one of our previous meetings; it has been your contributions that made the past event so awesome! Please don't hesitate and tell us if you are interested in presenting your work to the members of the community. If you have presented before, you are of course invited as well. More to come, Christian

1 0

zip:update-entries - unexpected results
by Hondros, Constantine (ELS-AMS) 18 Nov '15

18 Nov '15

Hi all, I'm attempting to create a modified copy a zipfile using zip:update-entries, but my output is a zip structure with zero-byte files. Am I missing a step? I've followed the example in: http://docs.basex.org/wiki/ZIP_Module#zip:update-entries Code snippet as follows: declare function util:clean-zip($zip as xs:string, $out as xs:string) { copy $doc := zip:entries($zip) modify delete node $doc//zip:entry[ends-with(lower-case(@name), '.pdf')] return zip:update-entries($doc, $out) }; Thanks for any pointers ;-) C. ________________________________ Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.

2 3

sending variables to xquery module via client api (python)
by Cholfin, Bryan 17 Nov '15

17 Nov '15

Hi- Hoping someone can help me with this. I'm trying to write a python script that calls an xquery module in the database. It seems to be pretty easy to use a line such as: session.execute("run gettext.xqm") and get back the response I want. What I want to do is pass a bound variable to the module. The client api has a provision to bind a variable to a query object, but I'm not making a query object. I'm simply executing the stored query. I don't find anything in the documentation to suggest that a variable can be added to the run command this way. Bryan Cholfin Associate Editor for Digital Projects and Metadata Harvard University Press 617.496.9116 79 Garden Street | Cambridge, MA 02138-1400 www.hup.harvard.edu<http://www.hup.harvard.edu/>

3 8

Restxq
by meumapple 16 Nov '15

16 Nov '15

Hi All, I am using restxq. I wrote a function which takes one variable (this should be a chunk of text, not a single word). The output is xml. I can have the function work if I pass the content of the variable with curl -X POST --data "variable=my text is long" http://address How can I get the same result of the curl command with an xquery function? More in general, is this a good way to write a function in restxq when the variable is not a single word but the content of a file? (I am not even sure if a file can be passed as such in restxq) Thanks, Joseph

3 4

Treating SQL Results
by Ana Victória Ladeira 16 Nov '15

16 Nov '15

Good morning. I have an XML file of the following format: <?xml version="1.0" encoding="UTF-8"?> <resultsets> <resultset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <row> <column name="TITULO">A Adequação de Sistemas Baseados em Casos no Sequenciamento Inteligente de Ações</column> <column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column> </row> <row> <column name="TITULO">Sistemas Distribuídos Inteligentes</column> <column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column> </row> <row> <column name="TITULO">Uma Arquitetura para Planejamento Inteligente</column> <column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column> </row> <row> <column name="TITULO">Navegação de robôs móveis com Lógica Paracpmsistente Anotada e método de Campos Potenciais</column> <column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column> </row> <row> <column name="TITULO">Adaptation in a Traffic Control System</column> <column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column> </row> ... The file contains titles for articles and their authors.. I was asked to develop a query that returns the author's name followed by the titles of all of its articles, so the result would be something like this: <Author1>:<Article1>, <Article2>, <Article3>... <Author2>:<Article1>, <Article2>... ... Any ideas on how can I do it? Thank you in advance.

2 1

database triggers
by Alexander Haus 16 Nov '15

16 Nov '15

Hello BaseX team, I've recently read, that you are currently working on a trigger mechanism for BaseX. Can you already tell, when you are planning to include it in a future release? Thanks a lot, Alex

2 1

Typo in docs?
by Marco Lettere 13 Nov '15

13 Nov '15

Hi all, Just one question. The documentation page related to the json module states: *Signatures* |*json:serialize*($input as node()) as xs:string| |*json:serialize*($input as node(), $options as map(xs:string, xs:string)) as xs:string| *Summary* Serializes the node specified by|$input|as JSON, and returns the result as|xs:string|instance. The node is expected to conform to the output created by thejson:parse() <http://docs.basex.org/wiki/JSON_Module#json:parse>function. All other items will be serialized as specified for thejson output method <http://docs.basex.org/wiki/XQuery_3.1#JSON_Serialization>of the official specification. Items can also be serialized as JSON if theSerialization Parameter <http://docs.basex.org/wiki/Serialization>|method|is set to|json|. The|$options|argument can be used to control the way the input is serialized. But I think the signature should be for item()? for the first parameter (since it allows also for maps) isn't it? In effect inspect:function(json:serialize#2) returns <function name="json:serialize" uri="http://basex.org/modules/json"> <argument type="item()" occurrence="?"/> <argument type="item()" occurrence="?"/> <return type="xs:string"/> </function> If it's confirmed I could proceed with fixing it. Regards, Marco.

2 1

Re: [basex-talk] Fwd: Bash command
by meumapple 10 Nov '15

10 Nov '15

I can add that if I use "cat file" on the bash I get the right Greek characters, while the same command via proc:execute returns gibberish characters (the optional argument "utf-8" in proc:execute has no effect). Thanks. Joseph Il giorno 09/nov/2015, alle ore 19:04, meumapple <meumapple(a)gmail.com> ha scritto: Hi, I do not have any LANG variable set. If I redirect into a file the output of the bash command, I get a message with "utf-8" when I analyze this file with the command "file". And indeed the characters are displayed correctly. So the problem arises only when I run everything through proc:execute. If I save the result of the xquery script and analyze them with "file" I get the message "output: ERROR : line 22 : regexec error 17, (illegal byte sequence). And of course the Greek characters are messed up (but not the ASCII ones for English) Hope this helps... Joseph Il giorno 09/nov/2015, alle ore 15:18, Jens Erat <jens.erat(a)uni-konstanz.de> ha scritto: Please report the encoding of your actual files. What is the output of `env | grep LANG` (when stored in your bash script)? If you pipe the output in another file, what will `file -i [output-file]` report (`file` applies some magic to discover file formats and encoding)? > Am 09.11.2015 um 14:06 schrieb meumapple: > Hi All, > > I have been able to run the command just putting it in a bash file and then running this file with proc:execute. It works. The problem now is with the encoding of the text returned by proc:execute. In my bash I can display Greek characters, but they are messed up if returned by the proc:execute function. I also added utf-8 as a parameter for the function but nothing changes. How can I solve this? Thanks. > > Joseph > > Il giorno 09/nov/2015, alle ore 10:41, Jens Erat <jens.erat(a)uni-konstanz.de> ha scritto: > > Hi Joseph, > > As far as I understand the documentation, BaseX `proc:system` does not > use a shell interpreter by default. `<` or also the pipe `|` are > features offered by your shell, not the operating system. > > Instead of passing a single parameter, pass the command as parameter to > `/usr/bin/env sh -c`, which will make BaseX run a shell that interpretes > I/O indirection: > > proc:system('/usr/bin/env', ('sh', '-c', 'opennlp postagger > model.bin < file.txt')) > > This might be a reasonable thing to provide as a built-in function, I'm > also not sure whether one can connect some kind of stream/strings to > STDIN, STDOUT and STDERR. > > Regards from Lake Constance, Germany, > Jens > > Am 09.11.2015 um 10:19 schrieb Christian Grün: >>> Any suggestions? >> >> Any example? ;) >> Christian >> >> >> >> Thanks. >>> >>> Joseph >>> >>> >>> Inizio messaggio inoltrato: >>> >>> Da: meumapple <meumapple(a)gmail.com> >>> Data: 06 novembre 2015 20:52:08 CET >>> A: BaseX <basex-talk(a)mailman.uni-konstanz.de> >>> Oggetto: Bash command >>> >>> Hi all, >>> >>> I am using proc:system for a bash command but I cannot run it. It looks like >>> opennlp postagger model.bin < file.txt. I suspect that the problem is the >>> less-than sign, which is converted into < Is there any way to keep the >>> less-than sign and pass it to the bash properly? Thanks. >>> >>> Joseph -- Jens Erat Universität Konstanz Kommunikations-, Infomations-, Medienzentrum (KIM) Abteilung Basisdienste D-78457 Konstanz Mail: jens.erat(a)uni-konstanz.de

1 0

Re :Collection DataBase Locking
by Adi Babu 10 Nov '15

10 Nov '15

While updating the Basex collection data base if it fails because of some unexpected reason the particular database cannot be opened anymore and the message shown in loggers is "*Database ... is being updated, or update was not completed*". I have found that this is because of *upd.basex*. My question is how can I found and remove this file through code to proceed further with a safe execution of the collection database creation process. Thanks & Regards, Adi

2 1