BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

Import a large XML file and add an attribute on all children
by Mallika Jimmy 31 Oct '14

31 Oct '14

Hello, We have a requirement to create a database by importing a large XML file. During this process, we also want to insert a particular attribute on all child nodes. Which is the efficient method to do the same? The file size is nearly 1GB. Thanks in advance, Mallika Jacob

3 5

NFS mount point query execution
by Sateesh 31 Oct '14

31 Oct '14

HI Basex, We have created collections on a machine and attached that collection location to our application server system as a mount point. Basex is running in standalone mode in that application server.When we execute queries by placing the collections on local system we are getting response in 2sec's but when the same query is executed on a collection which is on mount point it is taking 18sec's of time.Could you please help us by telling us the way to reduce the time even when running the query on a collection which is on mount point. Thanks & Regards SAteesh.A The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited.

3 4

Cast exception on recursion+map
by Marco Lettere 30 Oct '14

30 Oct '14

Hello all, I've stumbled upon an issue with the latest version and in particular the code I provide was working with 8.0 snapshot up to build 496C381 and with all previous official versions of course. Build 151df63 is the first build I'm aware of the difference. Shortly. In an input document I have a list of env nodes (sort of <env name="n">v</env>). They need to be parsed and "xquery:eval(uated)" in sequence because following env nodes may refer to preceding ones (i.e. <env name="n1">v1</env>, <env name="n2">{$n1}</env>). I've managed to do the job with the following code but now (as described in the preamble) I get the following cast exception in the xquery:eval: Stopped at [...]/file, 9/31: ---> (this points to the line with the xquery:eval call) [XPTY0117] Cannot cast xs:untypedAtomic to xs:QName. I've absolutely no idea why it started giving this error and even looking at the queryplan is too difficult in such a scenario for me. Anyone can help me out? Thanks, This is the smallest example of the code I was able to produce: declare function local:declarations($env as map(*)){ string-join( map:keys($env) ! ( "declare variable $" || . || " external;") ) }; declare function local:updateenv($envnode as node(), $env){ let $q := local:declarations($env) || serialize($envnode) let $dynnode := xquery:eval($q, $env) return map:new(( map:entry($envnode/data(@name), $dynnode/text()), $env )) }; declare function local:buildenv($envnodes as node()*, $env as map(*)) { if(empty($envnodes)) then $env else let $envnode := $envnodes[1] let $newenv := local:updateenv($envnode, $env) return map:new(( $newenv, local:buildenv($envnodes[position() > 1], $newenv))) }; map:serialize( local:buildenv((<env name="n1">v1</env>, <env name="n2">another {{$n1}}</env> ), map{}) )

2 3

Annoying behaviour of file:resolve-path
by Marc van Grootel 28 Oct '14

28 Oct '14

Hi, For a while I wasn't aware, then I noticed it and then I got annoyed by it. It's not a big issue but it does require extra code to work around this, in my opinion, annoying behaviour. When using file:resolve-path it depends if the file exists or not. The output is different. Say I have an existing directory F:\tmp then file:resolve-path('F:/tmp') => F:\tmp\ However, when I have a path that points to a non-existing directory (or file, we cannot know!) file:resolve-path('F:/tmp/not-exists') => F:/tmp/not-exists Notice the absence of a slash. I guess the assumption that is made is that in the future this will refer to a file and not a directory. The same behaviour occurs with file:path-to-uri(), and file:base-dir() also returns a path with a trailing slash. I think that this is annoying, or let's say at least, inconsistent behaviour and had me add code that defensively strips of trailing slash. I cannot rely on file:resolve-path results because if a directory doesn't exist it has no slash at the end, and if it does it has and sometimes I don't want to check for existence at that point. When combining paths I tend to use string-join($parts,'/') and having slash at the end of URL's and filesystem paths doesn't feel right so I always strip them off. Hope I didn't sound too grumpy ;-) Opinions? Guess, changing it would trip up a lot of existing path handling code. --Marc

2 4

Latest build is empty ...
by Marco Lettere 28 Oct '14

28 Oct '14

Hi all, I have a chunk of code (focused on xquery:eval) that somehow broke between the builds 151df63 (not working) and 496C381 (working) of the latest snapshot. 7.9 worked. Since I don't remember when the two build were downloaded I'm not able to classify them according to time thus before signaling the different behaviour I wanted to test the code with the current latest snapshot. Unfortunately the download is not complete since the ZIP file doesn't contain BaseX.jar and neither of the files in the bin folder. Any clue on what happened? Thank you, Marco.

2 1

JSON results
by Thomas Daly 27 Oct '14

27 Oct '14

Hello, I'm trying to construct a query that will return the title and ID from a set of records, but instead of XML results I'd prefer JSON. I'd like the results to be in the following format: [ ['id': 'value1', 'title': 'Title1'], ['id': 'value2', 'title': 'Title2'], ['id': 'value3', 'title': 'Title3'] ] I understand I'd need to use the JSON module, but I'm having trouble getting the results into the right format. This is what I have so far: XQUERY for $poem in collection("lk") let $id := fn:string($poem/poem/@uuid) let $title := $poem/poem/title/text() order by $title return (<id>{$id}</id>, <title>{$title}</title>) This returns the XML, but does anyone know how to convert into the desired JSON format? Many thanks

2 1

Cursor keys
by Thomas Daly 27 Oct '14

27 Oct '14

Hello, I'm using the command line interface of BaseX 7.3. I notice the cursor keys don't behave in the normal way - instead of moving the cursor around they print strange characters. Is there something wrong with my terminal configuration or is this a shortcoming of the software?

2 1

Reg : Group by with the top Records
by Chandrasekhar 25 Oct '14

25 Oct '14

Dear Team I am using the group by for getting top n number of record like below mentioned query (for $areaData in collection('mycollection') let $areaName := $areaData/Contry group by $areaName return $areaData )[position() lt 100] In this case i am getting first top 100 records and then it is grouping on those records.Can you please suggest me how can we get the top 100 records based on the Country name Please find the attachment for the sample data.Please do the need full on this/ Thanks&Regards Chandra Sekhar The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited.

2 1

XML Oxygen search: 404 Not found when the file exists, or worse 500 error.
by France Baril 23 Oct '14

23 Oct '14

Hi, We've been having this persistent issue with our webDAV connection to XML Oxygen. How to reproduce: 1. Create a DB with 200/300 documents. 2. Create a webDAV connection to the DB within an XML Oxygen project. 3. Right click the DB from the project > Find/Replace in files, and type a keyword to search for for all files *.xml 4. Run the search 3 to 5 times. Until you notice the error. The error doesn't always occur, but I'd be surprised if you didn't see it after 3 to 5 try. Example 500 error: System ID: http://admin@localhost :8984/webdav/en-us/topics/widget-bookmark.xml Severity: error Description: 500 Internal Server Error for: http://localhost:8984/webdav/en-us/topics/widget-bookmark.xml In the case of a 500 error, you need to restart the server to be able to open or search files from the DB again. Can anything be done to improve the situation? Regards, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 5

Re: [basex-talk] serializing an xquery flwor in csv
by Dirk Kirsten 23 Oct '14

23 Oct '14

Hi Emmanuelle, please don't forget to include the mailing list in your mails, so others can also benefit from the questions (and other people might answer you faster or better than I can). The CSV serialization works just on the element name as far as I can remember. You could simply rename the node, e.g. let $destinataire := $creation/persName[@type='destinataire'] update rename node . as "pers1" For help with XQuery Update, oyu might also want to take a look at the docs: http://docs.basex.org/wiki/Update Cheers, Dirk On 10/23/2014 03:12 PM, Emmanuelle Morlock wrote: > Hi again > there's something strange happening with the csv serialization of my query > > Two of my variables have the same element but are distinguished by their > attribute > > declare option output:method "csv"; > declare option output:csv "header=yes, separator=semicolon"; > for $lettre in db:open('myBD')//TEI > where $lettre//opener//addrLine[not(contains(.,'Adresse ?'))] > let $creation := $lettre//profileDesc/creation > let $titre := $lettre//teiHeader//title > let $date := $lettre//profileDesc//date > let $destinataire := $creation/persName[@type='destinataire'] > let $expediteur := $creation/persName[@type='expediteur'] > return > <csv> > <record>data({$date}) data({$expediteur} data({$titre} > data({$destinataire}) </record> > </csv> > > the result creates one field 'persName' with two values (separated by a > comma), whereas I wanted 2 fields > > date;persName;title > 01/01/2000;Pierre Martin,Jean Dupond;Title > > what shoud I do to avoid that and get as a result something like : > > date;persName1;title:persName2 > 01/01/2000;Pierre Martin;Title;Jean Dupond > > > thanks > emmanuelle > > > Le 23/10/2014 14:31, Dirk Kirsten a écrit : > > Hello Emmanuelle, > > > > You're very welcome to ask, even if its basic (or looks basic to you). > > We all started with XQuery at one point in time... > > > > In this case, it is even simpler than you expected I guess. As you > > want to serialize the output as csv, you don't even need the > > serialize() function. You can simply set in the prolog of your XQuery > > > > |declare| |option| |output:method ||"csv"||; > > > > | > > and your output will be automatically converted from XML to CSV. There > > is an example for CSV at ||http://docs.basex.org/wiki/Serialization, > > you can also define options in the prolog. > > > > Also, I noticed that you do $lettre//profileDesc/creation quite often. > > // is > > a quite costly operation, so you might want to put this into a > > separate variable which you then use - The optimizer might do that for > > you, but it is also shorter and cleaner to write. > > > > Cheers, > > Dirk > > > > On Thu, Oct 23, 2014 at 12:24 PM, Emmanuelle Morlock > > <emmanuelle.morlock(a)mom.fr <mailto:emmanuelle.morlock@mom.fr>> wrote: > > > > Hi all, > > > > I'm trying to do some xquery with the GUI in a standalone install. > > As I'm beginning with xquery, I rely a lot on the examples given > > in the doc. > > But I don't manage to be successful with > > http://docs.basex.org/wiki/CSV_Module for what I need. > > > > I'd like to get a result formatted in csv (separator : ';' or > > whatever) so tha I can directly import in a spreadsheet the > > results exported file. > > > > Here's the begining of my query : > > > > for $lettre in db:open('myDB')//TEI > > where $lettre//opener//addrLine[not(contains(.,'Adresse ?'))] > > let $title := $lettre//teiHeader//title > > let $destinataire := > > $lettre//profileDesc/creation/persName[@type='destinataire'] > > let $expediteur := > > $lettre//profileDesc/creation/persName[@type='expediteur'] > > let $date := $lettre//profileDesc//date > > let $locName := > > $lettre//profileDesc/creation/location/placeName[@type='PlaceExp'] > > let $locGeo := $lettre//profileDesc/creation/location/geo > > > > then I guess I should have something like : > > - a variable for the option... is let $options := > > {'separator':';'} correct ? > > something to put all the variable as a result let $fields := ... ? > > then > > return csv:serialize ($fields, $options) > > > > ??? > > thanks for helping even if this sounds too basic ! > > > > best > > > > emmanuelle > > > > -- Emmanuelle Morlock > > IGE CNRS - soutien aux projets d'édition TEI - humanités numériques > > UMR 5189 HISoMA > > http://www.hisoma.mom.fr/ > > 04 72 71 58 40 > > 06 85 84 69 16 > > @emma_morlock > > > > > > > > > > -- > > Dirk Kirsten, BaseX GmbH, http://basex.org <http://basex.org/> > > |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz > > |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: > > | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle > > `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22 > > -- Dirk Kirsten, BaseX GmbH, http://basex.org |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk