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

GUI feature request "Add as import"
by Andy Bunce 03 Jan '16

03 Jan '16

Hi, I often find myself adding module imports in the GUI and I wonder if the following suggestion might speed up that process. Add a new menu item to the filelist right click context menu "Add as import" when the file selection is a XQuery module. The action would be to add a line to the current edit window source with import module namespace {$prefix} = '{$namespace}' at {$path}; Where $prefix and $namespace} are read from the source of the selected file, and $path is calculated from the relative path from the edit file source to the selected filelist source. The line would be inserted at a suitable place in the prologue or at the current location if that is too tricky. /Andy

2 4

Slow query
by Menashè Eliezer 03 Aug '15

03 Aug '15

Hello, I wonder if the attached query can be optimised. I'm attaching all relevant information. Basex 7.9, Debian, powerful server. This is just an example. The queries will be built based on a compilation of a search form. So reordering the conditions for having smaller subset right from the begging isn't relevant. Any help would be appreciated. 40 seconds are not acceptable. -- With kind regards, Menashè

2 45

validate:xsd
by France Baril 02 Jun '15

02 Jun '15

Hi, The function returns incomplete error messages on 8.2. It makes it difficult to figure out what the problem is. *validate:xsd*(*$node*, *$staged-xsd*) returns: Stopped at /Users/archie/BX-Acc/webapp/Accounting_ValidationSchemas.xqm, 13/41: [bxerr:BXVA0001] Validation failed. "Fatal:The version is required i... I'd really like to see what ... stands for. Is it possible to get more complete messages? Regards, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 2

Catch a user event/work with triggers
by France Baril 02 Jun '15

02 Jun '15

Hi, I couldn't find documentation about catching events that occur on a db from an xquery module. What I am trying to achieve: Context: Writers create content in XML Oxygen and are connected through the data source which uses WebDAV. 1. A writer modifies an .xml file and saves the changes. An event that can be caught by an xquery function is triggered. 2. My xquery function adds an @id to all elements that don't have one and saves the document again. There is a way to differenciate users 'replace' from query 'replace' so that if an event is triggered again here, we will not loop indefinitely. I know you are working on triggers, but I'm not sure it applies to this use case. Can this currently be done? Thanks! -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 2

rest:resource vs db:list-details resource
by James Ball 01 Jun '15

01 Jun '15

Hello, If I use the REST interface to get details of the resources in a database (http://localhost:8984/rest/TEST-DATABASE for example) the result is rest:resource elements that include size. <rest:resource type="xml" content-type="application/xml" size="46”> I assumed that db:list-details was the XQuery equivalent but the resource elements it returns do not include size. <resource raw="false" content-type="application/xml" modified-date="2015-05-31T17:12:32.907Z”> I’m sure it is staring me in the face but I can’t work out how to get the size value from within XQuery. Can someone point me in the right direction? I’m trying to do some database pruning based on the size of the documents which would be very easy if I had rest:resource elements. Many thanks, James

2 2

[DELIVER]<output:indent value='no'/> fn:serialize
by Adam Law 30 May '15

30 May '15

I may be doing something wrong but <output:indent value='no'/> does not appear to work with fn:serialize Adam let $ve_collectlocations := <collections><collection>{$page:collection_main_private}</collection></col lections> let $parameters := <output:serialization-parameters> <output:method value='xml'/> <output:indent value='no'/> <output:omit-xml-declaration value='yes'/> <output:encoding value='utf-8'/> </output:serialization-parameters> let $vs_result:= <Items>{for $collectlocation in $ve_collectlocations//collection/text() for $collect in collection($collectlocation)/* for $deadline in $collect//Deadline/Open let $irn := ($collect//FIN)[1] let $xs_string:= string(fn:serialize($collect,$parameters)) let $md5 := <md5>{xs:hexBinary(hash:md5($xs_string))}</md5> let $vs_result := <Hit>{md5}</Hit> return $vs_result }</Items> return $vs_result };

2 1

Issues with new json xml function and copy clause
by James Wright 29 May '15

29 May '15

I am having issues with the new json-to-xm functions with a copy clause. I would expect the following query to work: *let $json := '{"age":23,"name":"Bob"}'return copy $out := json-to-xml($json) modify delete node $out//*[@key='age'] return xml-to-json($out)* Instead I get an error when calling xml-to-json: [FOJS0006] Element 'map' has invalid namespace: ''. It appears the copy clause is dropping the namespace on the map object. Is this something I must manually prevent or a bug? Thanks for all your time. - James

2 1

Multiple BaseX Tomcat webapps
by Kristian Kankainen 28 May '15

28 May '15

Hello! I previously had BaseX 8.1.1 working as a Tomcat webapp and it all worked fine. I know tried to simply put BaseX82.war as another webapp, but the second webapp seems to connect to the BaseX instance in the first webapp. For example: the address http://tomcat.myhost.ee/BaseX82/rest/ lists all the databases that are in http://tomcat.myhost.ee/BaseX811/ even though the new BaseX82 instance should be empty. I have problems understanding if this concerns BaseX configuration or Tomcat configuration... Which files should I check? Looking at the both's webapps' WEB-INF/web.xml they seem logically fine to me. Best regards Kristian K

2 4

Creating a batch BaseX program
by Noam Green 28 May '15

28 May '15

Hi, I'm new to BaseX, so apologize if this is a repetitive question. I have created an XQuery which currently runs on a specific XML file. What I'd like to do is to be able to create a batch command, which would receive as input a different XML source file, run the XQuery command, and save the results in a CSV file. Is there a way to do such a process? Thanks, Noam

2 17

SQL Module
by James Wright 27 May '15

27 May '15

Hey Everyone, I am having issues with using the Oracle 1.7 JDBC driver. I copied the ojdbc7.jar file into the lib directory Ran the basexgui.bat to add to class path Tried to run this script: let $conn := sql:init('jdbc:oracle:thin:pnm/pnm@orc1n.giants') return (sql:execute($conn, 'SELECT owner, table_name FROM dba_tables '), sql:close($conn)) It states that it cannot initialize the jdbc:oracle:thin driver. Any ideas why that would be? Am I missing something? - James

2 1