BaseX-Talk June 2018

basex-talk@mailman.uni-konstanz.de

28 participants
26 discussions

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

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk June 2018