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

EXECUTE syntax
by Ben Engbers 08 Jun '18

08 Jun '18

Hi, I want to use my R-client to insert csv in a database. These lines works: csv_add_run <- 'RUN "./DataScience/RBaseX/CSVexample.xq"' Session$command(csv_add_run) When I take the content from CSVexample.xq and incorporate that into a EXECUTE command, I get this: csv_add_exe <- 'EXECUTE "let $root := '/home/bengbers/DataScience/RBaseX/Examples/Parse/;)'; for $path in file:children($root)[ends-with(., '.csv')] return db:add('CSV_test', $path, 'CSV_API', map { 'parser': 'csv', 'csvparser': map { 'header': 'yes', 'separator': ';' }) "' Session$command(csv_add_exe) Stopped at , 1/9: Unknown command: 'EXECUTE. Did you mean 'EXECUTE'? My question is how to define the input for the EXECUTE-command? Cheers, Ben

2 1

Re: [basex-talk] Long queries on big data timing out.
by Christian Grün 08 Jun '18

08 Jun '18

Dear Peter, 1. and 2. If you are working with the client/server architecture of BaseX, you can adjust the default timeout of 30 seconds by assigning another number of seconds to the TIMEOUT option [1]. This can e.g. be done by editing the .basex configuration file (please find more information in the top of the referenced Wiki document). 3. There is a CACHETIMEOUT option for caching the results of jobs:eval; see [2] for more details. 4. The jobs:list-details function will also list finalized jobs with enabled 'cache' option: <job id="job1" duration="PT1.32S" state="cached" type="QueryJob" ... By checking the @state attribute, you will see if the query is still "running", or if a "cached" result is available. Hope this helps, Christian PS: Your mail did not survive my spam check; maybe something is wrong with the mail configuration? [1] http://docs.basex.org/wiki/Options#TIMEOUT [2] http://docs.basex.org/wiki/Jobs_Module#jobs:eval > Hello, > > We have some complicated queries that are submitted to a database that is really, really big. The system will time out, just bringing back a message saying "Interrupted". > > 1. I know that you can provide a timeout parameter when using jobs:eval etc for batch jobs, but is there a setting that we can tweak to set the default for interactive (i.e. non jobs:eval) queries? > 2. What is the default value for the timeout value? > 3. How long will the server hang on to results from jobs:eval()? I think I remember reading that this is configurable, but how? Is it per job or globally for the server? > 4. Can you consider adding an API that tells how long the job has been running?

1 0

Long queries on big data timing out.
by Peter Villadsen 07 Jun '18

07 Jun '18

Hello, We have some complicated queries that are submitted to a database that is really, really big. The system will time out, just bringing back a message saying "Interrupted". 1. I know that you can provide a timeout parameter when using jobs:eval etc for batch jobs, but is there a setting that we can tweak to set the default for interactive (i.e. non jobs:eval) queries? 2. What is the default value for the timeout value? 3. How long will the server hang on to results from jobs:eval()? I think I remember reading that this is configurable, but how? Is it per job or globally for the server? 4. Can you consider adding an API that tells how long the job has been running? Best Regards Peter Villadsen Principal Architect Microsoft Business Applications Group

1 0

XML well-formed error
by DK Singh 06 Jun '18

06 Jun '18

Hi All, I have a XML file when i apply xslt using xslt:transform function it is giving well formed error, even i tried on BaseX UI using xslt:transform function [FODC0002] "" (Line 1): The markup in the document following the root element must be well-formed. but when the same file i transform on the oxygeng editor it getting transformed, can anyone suggest what going wrong. Regards Dharmendra Kumar Singh

4 8

Script tags
by Philip Spaelti 02 Jun '18

02 Jun '18

Hi, I'm using the GUI to generate html documents. The xquery includes a <script src="my_script.js"></script> tag which Basex simplifies to <script src="my_script.js"/> which causes problems in the browser. Am I doing something wrong, or is this a bug? best Philip --------------------------------------------------- Philip Spaelti Kobe Shoin Women's University, Graduate school ---------------------------------------------------

2 1

Insert CSV into database
by Ben Engbers 01 Jun '18

01 Jun '18

Hi, My goals is to use my R clientdriver to insert csv-files into a new databases. But before that, I'm experimenting with the GUI. >From the documentation for the CSV-parser, I have taken this code: for $file in file:list("/home/bengbers/DataScience/RBaseX/Examples/Parse", false(), "*.csv") return db:add("CSV_test", $file, "", map { 'parser': 'csv', 'csvparser': map { 'header': 'yes', 'separator': ';' } }) BaseX returns: Error: Stopped at /home/bengbers/DataScience/Eindopdracht/Data/file, 2/14: [FODC0002] Resource 'Test_Parse.csv' does not exist. I didn't enter this path. It was used yesterday when browsing to the datafiles that were inserted into another test-database. let $file := file:list("/home/bengbers/DataScience/RBaseX/Examples/Parse", false(), "*.csv") return $file BaseX returns: Test_Parse.csv Test_Parse (exemplaar).csv If I create a new database, it neatly adds the two csv-files. My questions are: - which query I have to use to insert csv-files? - obviously, BasexGUI uses the wrong path. How should I adjust this path? Cheers, Ben

2 3

BaseX 9.0.2: New Maintenance Release
by Christian Grün 31 May '18

31 May '18

Hi all, A new BaseX maintenance release is available! Please visit http://basex.org to download the latest version. These are the changes: Critical bug fixes: - XQuery: Node ordering of mixed database/fragment instances - XQuery: Index rewritings of paths with nested positional predicates Improvements: - WebDAV: Much faster locking of database resources - XQuery: Enable ENFORCEINDEX for variable predicate arguments - GUI: Larger interaction components, unified font sizes Minor Bug fixes: - DBA: Suppress menu on login page - Commands: Nested evaluation with variable bindings - XQuery: Static typing of lookup expressions Enjoy, Christian

1 0

Serialize csv xquery map
by Andy Bunce 29 May '18

29 May '18

The xqueryformat of CSV records as a sequence of arrays [1] is very useful when parsing but there seems to be no easy way to serialize from this format. Is this correct? map { "records": ["Huber", "Sepp", "Hauptstraße 13", "93547 Hintertupfing"], "names": ["Name", "First_Name", "Address", "City"] } =>csv:serialize() [SENR0001] Items of type map(xs:string, array(xs:string)) cannot be serialized. ... would be nice if it could. /Andy [1] http://docs.basex.org/wiki/CSV_Module#XQuery

2 2

IETF Date in If-Modified-Since header
by Marco Lettere 29 May '18

29 May '18

Hello all, need to use the If-Modified-Since header in one of my APIs. The format requested is the IETF date format: If-Modified-Since: Wed, 21 Oct 2015 07:28:00 GMT as explained in [1]. If I pass the header as prescribed to a restxq made like: declare %rest:path("config") %rest:header-param("If-Modified-Since", "{$modifiedsince-ietf}") %rest:HEAD function config:check($modifiedsince-ietf as xs:string?){ I get the following exception: Cannot convert xs:string+ to xs:string?: ("Wed", "21 Oct 2015 07:28:00 GMT"). Which somehow demonstrates that , is treated as a separator of values for the header. I patched by replacing ? with * and using a string-join on the $modifiedsince-ietf before passing it to the follwoing parse-ietf-date function. But this is hard to explain and probably subject to other issues in the future. Is there a way to pass HTTP headers verbatim to the RestXQ function? thanks! M. [1] https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/If-Modified-Since

2 2

no value assigned to external variables in xq when running bxs->bxs->xq
by Freihalter Thomas 29 May '18

29 May '18

Hello, I am using basex 9.0.1 and have this 3 files: test.xq: declare variable $test external; $test test.bxs: <commands> <set option="BINDINGS">test=foo</set> <run file="test.xq"/> </commands> run.bxs: <commands> <run file="test.bxs"/> </commands> Running test.bxs is okay basex -v test.bxs BINDINGS: test=foo foo Query "test.xq" executed in 5.4 ms. basex -v run.bxs BINDINGS: test=foo Stopped at test.xq, 1/18: [XPDY0002] No value assigned to $test. It look like the bindings in test.bxs get lost, when executing the superior run.bxs. Is there any solution solving this problem? 8.6.7 does not work as well. regard Thomas echo "declare variable \$test external; \$test" > test.xq; echo "<commands><set option=\"BINDINGS\">test=foo</set><run file=\"test.xq\"/></commands>" > test.bxs; echo "<commands><run file=\"test.bxs\"/></commands>" > run.bxs; basex -v test.bxs; basex -v run.bxs

2 2