Re: [basex-talk] How do I create UNIX/Linux shell scripts that connect to BASEXCLIENT - BaseX-Talk - mailman.uni-konstanz.de

15 Feb 2014

      Hello,
Thank you all for help me.
My problems is solved by the code below:
basexclient -U admin -P admin -L -V -v -o result.xml -c consultas.bsx >> detail.txt
Regards,
Daiane
From: dairc_8@hotmail.com
To: alexander.holupirek@uni-konstanz.de
Subject: RE: [basex-talk] How do I create UNIX/Linux shell scripts that connect to BASEXCLIENT
Date: Sat, 15 Feb 2014 16:41:11 -0200
Hello Alexander,
Those  tips were very helpfull, thank you.
I was wondering if the content from V parameter could be saved into the result file instead just be in the screen.
It is fine like this but could be better if I have the execution time also into the result.xml
basexclient -U admin -P admin -L -V -o result.xml -c consultas.bsx
Regards,
Daiane
...
Subject: Re: [basex-talk] How do I create UNIX/Linux shell scripts that connect to BASEXCLIENT
From: alexander.holupirek@uni-konstanz.de
Date: Sat, 15 Feb 2014 18:40:13 +0100
To: dairc_8@hotmail.com
% cat test.xml
<test>
  <a/>
  <b/>
  <c/>
</test>
% cat query.xq 
db:create('test', '/Users/holu/Desktop/test.xml')
% basexserver&
% basexclient -U admin -P admin -L -V query.xq
Query:
db:create('test', '/Users/holu/Desktop/test.xml')
Parsing: 0.94 ms
Compiling: 0.04 ms
Evaluating: 16.31 ms
Printing: 0.87 ms
Total Time: 18.16 ms
Hit(s): 0 Items
Updated: 1 Item
Printed: 0 Bytes
Read Locking: none
Write Locking: local [test]
Query "query.xq" executed in 18.16 ms.
% cat query-1.xq 
doc('test')//b
% basexclient -U admin -P admin -L -V -o result.xml query-1.xq
Query:
doc('test')//b
Compiling:

pre-evaluating fn:doc("test")
simplifying descendant-or-self step(s)
converting descendant::*:b to child steps

Optimized Query:
db:open-pre("test",0)/*:test/*:b
Parsing: 0.37 ms
Compiling: 43.1 ms
Evaluating: 0.1 ms
Printing: 7.48 ms
Total Time: 51.04 ms
Hit(s): 1 Item
Updated: 0 Items
Printed: 4 Bytes
Read Locking: local [test]
Write Locking: none
Query "query-1.xq" executed in 51.04 ms.
% cat result.xml
<b/>
On 15.02.2014, at 18:29, DAIANE ROBERTA CANDIDA dairc_8@hotmail.com wrote:
...
Hello Alexander,
Thanks for answering.
I have to get the execution time  from some  queries.
It will take too much time because the dataset is very large so i need to automatize those task.
I tried get from the commands below:
arwen@arwen:~/daiane_oracle/BasexQuery$ basexclient -U admin -P admin consultas.bsx -o result.tx 1+1
Stopped at /home/arwen/daiane_oracle/BasexQuery/consultas.bsx, 1/14:
[XPST0003] Unexpected end of query: 'db_teste;
XQUER...'.
Dumping Java heap ... done.
The problem is that if i execute the query from the command line it is ok and when I execute from a file it returns error.
File: consultas.bsk
OPEN db_teste;
XQUERY db:open('db_teste')/books/book/metadata/title [. contains text "usability"]

What should I do?
Regards,
Daiane
...
Subject: Re: [basex-talk] How do I create UNIX/Linux shell scripts that connect to BASEXCLIENT
From: alexander.holupirek@uni-konstanz.de
Date: Sat, 15 Feb 2014 18:02:53 +0100
CC: basex-talk@mailman.uni-konstanz.de
To: dairc_8@hotmail.com
Hi Daiane,
Start server:
$ basexserver &
Use client to connect, execute query and store result in file:
$ basexclient -U admin -P admin -o result.tx 1+1
$ cat result.txt
2
Doing stuff like that from within a shell script should be no problem.
Are there any specific issues you are facing?
Alex
On 15.02.2014, at 17:57, DAIANE ROBERTA CANDIDA dairc_8@hotmail.com wrote:
...
Hello,
I want to create a Shell script to connect basexclient, running queries and put the output into a file.
How can I do that?
Regards,
Daiane

Dr. Alexander Holupirek
|-- Room E 221, 0049 7531 88 2188 (phone) 3577 (fax)
|-- Database & Information Systems Group, U Konstanz
`-- https://scikon.uni-konstanz.de/personen/alexander.holupirek/