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

Extracting namespace from xml
by Henning Phan 18 Jun '16

18 Jun '16

Hello, When using basexgui, after opening a database and go to properties and then information one can see all the namespaces in the document. When not using the gui how does one extract the same information? Been reading the wiki but I have not been able to find a module or a function that accomplish exactly that. Also Im trying to use the information from index:facets("db") to create a simple visual interface so users, without xquery knowledge, can click on nodes and add filters and those choices are then translated into xquery commands. Any information in this area would greatly appreciated. - Henning Virusfritt. www.avast.com

2 1

REPO INSTALL fails without error
by Felix Wolf 18 Jun '16

18 Jun '16

Hello everybody, i am trying to install the javamail's jar into the repo: -- terminal snip -- basex [gaia] [~/basex] > basexclient BaseX 8.4.1 [Client] Try 'help' to get more information. > repo install /home/basex/install/javamail-1.4.2/mail.jar Package '/home/basex/install/javamail-1.4.2/mail.jar' installed in 0.43 ms. > repo list Name Version Type Path -------------------------------------------------------------------- ij.ImageJ - Internal ij/ImageJ.jar -- terminal snap -- It looks like it succeeds but does not do anything!? Is there a good way to debug this issue? Are there plans to develope/release an office mail module? Thanks and regards Felix

2 1

Long time to execute XQuery
by Sam Eklund 18 Jun '16

18 Jun '16

I have a database where a couple of clients perform querys with a fairly rapid response, however sometimes the querys take EXTREMLY long time to execute, and I wonder why. Do you have any pointers for me on where to look, what to do? In this excercept from the log you'll see that the first query in the log was executed with a normal response time, however, when the same query is made later (at about 00.28.03 by Mediacollection) it times out. At around 00.28.03 there is also another query made by another machine(VentuzTV4A), and its response time ends up just below 10s. To me it seems the queryprocessor is not queuing up the querys in a good fashion, or do any of you have another view of the problem? Best regards, Sam Log below: ----------------------------------------------------------------------- 00:18:01.388 0:0:0:0:0:0:0:1:58557 MediaCollection REQUEST OPEN tv4 0.27 ms 00:18:01.388 0:0:0:0:0:0:0:1:58557 MediaCollection OK Database 'tv4' was opened in 0.05 ms. 0.4 ms 00:18:01.388 0:0:0:0:0:0:0:1:58557 MediaCollection REQUEST XQUERY (//EVENT[@IDdeko="106139482"]) [last()] 0.19 ms 00:18:01.575 0:0:0:0:0:0:0:1:58557 MediaCollection OK Query executed in 191.63 ms. 192.0 ms 00:18:01.575 0:0:0:0:0:0:0:1:58557 MediaCollection REQUEST EXIT 0.15 ms 00:18:01.575 0:0:0:0:0:0:0:1:58557 MediaCollection OK 0.36 ms 00:27:41.538 0:0:0:0:0:0:0:1:58625 MediaCollection OK Database 'tv4' was opened in 0.05 ms. 0.41 ms 00:27:41.538 0:0:0:0:0:0:0:1:58625 MediaCollection REQUEST XQUERY (//EVENT[@IDdeko="106139699"]) [last()] 0.19 ms 00:27:41.725 0:0:0:0:0:0:0:1:58625 MediaCollection OK Query executed in 193.58 ms. 193.94 ms 00:27:41.725 0:0:0:0:0:0:0:1:58625 MediaCollection REQUEST EXIT 0.15 ms 00:27:41.725 0:0:0:0:0:0:0:1:58625 MediaCollection OK 0.33 ms 00:27:49.026 0:0:0:0:0:0:0:1:58626 MediaCollection REQUEST OPEN tv4 0.29 ms 00:27:49.026 0:0:0:0:0:0:0:1:58626 MediaCollection OK Database 'tv4' was opened in 0.06 ms. 0.45 ms 00:27:49.026 0:0:0:0:0:0:0:1:58626 MediaCollection REQUEST XQUERY (//EVENT[@IDdeko="106139480"]) [last()] 0.22 ms 00:27:49.213 0:0:0:0:0:0:0:1:58626 MediaCollection OK Query executed in 188.08 ms. 188.45 ms 00:27:49.213 0:0:0:0:0:0:0:1:58626 MediaCollection REQUEST EXIT 0.38 ms 00:27:49.213 0:0:0:0:0:0:0:1:58626 MediaCollection OK 4.13 ms 00:28:03.721 10.0.29.134:55434 VentuzTV4A REQUEST OPEN tv4 203.11 ms 00:28:03.721 10.0.29.134:55434 VentuzTV4A OK Database 'tv4' was opened in 0.06 ms. 0.4 ms 00:28:03.861 0:0:0:0:0:0:0:1:58627 MediaCollection REQUEST OPEN tv4 0.23 ms 00:28:03.861 0:0:0:0:0:0:0:1:58627 MediaCollection OK Database 'tv4' was opened in 0.04 ms. 0.36 ms 00:28:03.861 0:0:0:0:0:0:0:1:58627 MediaCollection REQUEST XQUERY (//EVENT[@IDdeko="106139482"]) [last()] 0.19 ms 00:28:03.924 10.0.29.134:55434 VentuzTV4A REQUEST XQUERY (/DEKOEVENTS/EVENT[@IDdeko="106139846"]) [last()] 202.22 ms 00:28:13.876 0:0:0:0:0:0:0:1:58627 MediaCollection ERROR Timeout exceeded. 10008.52 ms 00:28:13.892 10.0.29.134:55434 VentuzTV4A OK Query executed in 9975.78 ms. 9976.17 ms 00:28:13.892 10.0.29.134:55434 VentuzTV4A REQUEST EXIT 0.14 ms 00:28:13.892 10.0.29.134:55434 VentuzTV4A OK 0.26 ms 00:28:14.922 0:0:0:0:0:0:0:1:58628 MediaCollection REQUEST OPEN tv4 0.23 ms 00:28:14.922 0:0:0:0:0:0:0:1:58628 MediaCollection OK Database 'tv4' was opened in 0.05 ms. 0.39 ms 00:28:14.922 0:0:0:0:0:0:0:1:58628 MediaCollection REQUEST XQUERY (//EVENT[@IDdeko="106139840"]) [last()] 0.19 ms 00:28:15.093 0:0:0:0:0:0:0:1:58628 MediaCollection OK Query executed in 171.06 ms. 171.41 ms 00:28:15.093 0:0:0:0:0:0:0:1:58628 MediaCollection REQUEST EXIT 0.14 ms 00:28:15.093 0:0:0:0:0:0:0:1:58628 MediaCollection OK 0.4 ms 00:28:22.332 0:0:0:0:0:0:0:1:58629 MediaCollection REQUEST OPEN tv4 0.27 ms 00:28:22.332 0:0:0:0:0:0:0:1:58629 MediaCollection OK Database 'tv4' was opened in 0.05 ms. 0.4 ms 00:28:22.332 0:0:0:0:0:0:0:1:58629 MediaCollection REQUEST XQUERY (//EVENT[@IDdeko="106139698"]) [last()] 0.19 ms

2 1

BaseX GUI doesn't show combining glyphs properly
by Kristian Kankainen 18 Jun '16

18 Jun '16

Hello I don't know if the problem is local on my computer or in BaseX's GUI code. It doesn't show Unicode Combining glyphs correctly in the Results window. The combining characters are somehow strangely spaced away together with their base character. If I copy and paste the text from the window, it is correctly formatted. In the attached picture the 12th row should show "iguumeń/ńa:" instead. Best regards Kristian K

2 2

Sorry…
by Christian Grün 16 Jun '16

16 Jun '16

…everyone for the delayed replies. I'll give some more feedback end of this week.

1 0

Geo Module Help
by George Sofianos 16 Jun '16

16 Jun '16

Sorry for the second email, I'm not familiar with BaseX, but it looks like the gml namespace is hardcoded in /basex-api/src/main/java/org/expath/ns/Geo.java I don't know if it is intentional for compatibility reasons or not.

1 0

How to make an email database
by Finney, Tim 16 Jun '16

16 Jun '16

Hi Everyone, I'm thinking about what might be involved in making a BaseX email database that would allow large numbers of emails to be searched on things like sender, recipient, subject, date, contents, as well as an existing hierarchical structure for organizing emails. (E.g. all emails relating to a particular project are placed in a corresponding project folder.) The emails would have to be periodically exported from an existing email archive, presumable going by way of a (very big) PST file. Has anyone here already tried to do this kind of thing using BaseX? Any tips would be much appreciated. Does anyone know of a good open source program for converting PST files to an XML structure? (I don't care about attachments at the moment, though it would be good to eventually include non-binary attachments in the search facility.) Best, Tim Finney

2 1

climbing around in maps
by Graydon Saunders 15 Jun '16

15 Jun '16

Hi -- I'm using 8.4.4. So I'm got a 15 MiB XML file . It consists of a bunch of definitions, which reference other definitions in the same file. It's not guaranteed to not be circular in the general case but I expect it isn't in my particular use case. (And I've stuck a "don't get too deep" check in anyway, which is currently sitting at 1 in the hopes that wouldn't blow up.) The idea is to find the paths to some particular values by started at those values and climbing up the references until a magic "this is the top of a chain of references" point is reached. (Which can be detected via a pattern in the name of the definition.) I stuffed the things I expect to care about into maps, since that way I process it once, and can hopefully reference it thereafter. The downside is that the stack dies instantly when I attempt to recurse up the (virtual, rather than XML-document-actual) tree. (I've never seen BaseX run the query plan along the bottom bar in lieu of an error message before.) I've attached the full query info. I can't attach the data because it's somebody else's. (entry has relationship children; an entry describes an XSD schema, and a relationship element describes (possibly through reference to another entry element than its ancestor) either a complex type or a simple type that goes in that schema. There's only one entry with a given @name but many relationship elements may reference it. As a result, the scope of what's being climbed expands rapidly; this first test "do one name" turns into 20 names on the first pass. ) The query looks like: declare function local:climb($relByType as map(*), $built as xs:string*, $name as xs:string) { for $path in $relByType($name) return if (matches($path,'^\p{Lu}{4}_IN') or count($path) gt 1) then ($name,$built) else local:climb($relByType,($name,$built),$path) }; let $relationships as element(relationship)+ := //relationship[@type] let $relByType as map(*) := map:merge(for $x in $relationships let $key := $x/@type group by $key return map:entry($key,$x/ancestor::entry[1]/@name)) let $fixedRelationships as element(relationship)+ := //relationship[@type][@fixedValue] let $fixed := map:merge(for $x in $fixedRelationships let $key := $x/string-join((@name,@type,@fixedValue),'|') group by $key return map:entry($key,$x/ancestor::entry[1])) (:trying a single fixed value as the start of the climb for testing:) let $eventNames := map:get($fixed,'moodCode|CS|EVN.CRT')/@name (: so we can get the relationship element, but we want its event ancestor's name :) return for $x in $eventNames return local:climb($relByType,'',$x) My suspicion is that passing a big map to the function is causing the problem. But I don't know, and I don't think there's a way to declare a function with an external variable. ("take this value from the function declaration's context and put it in scope for the function"). Any suggestions? -- Graydon

1 1

group explicitly for performance improvements
by Graydon Saunders 15 Jun '16

15 Jun '16

I'm wading about in several tens of megabytes of health care data, trying to figure out what connects to which, as it were. There are a few thousand relationship elements that define some of the connections, and often more than one such element per @type, so it's not enough to just group them by _this_ relationship elements type, I need all the relationship elements which have a particular type value. let $relationships as element(relationship)+ := //relationship[@type] let $relTypes as xs:string+ := distinct-values($relationships/@type/string()) let $relByType := map:merge(for $x in $relTypes return map:entry($x,$relationships[@type eq $x])) return $relByType 82895.5 ms let $relationships as element(relationship)+ := //relationship[@type] let $relByType := map:merge(for $x in $relationships let $key := $x/@type group by $key return map:entry($key,$x)) return $relByType 170.79ms Holy Wow. Offered just in case anyone else is wondering why their query is so slow. -- Graydon

1 0

How to use REST API to add xml document to database
by Adil Hasan 14 Jun '16

14 Jun '16

Hello, Thank you for your work in creating this database management system! I have a question. I have an XML document that is created in an script. I would like to store the xml document in the xml database. The xml file is created in memory and I'm using python and the REST API to store the data. I can't figure out how to add an xml document to an existing database. I tried a POST request with the data being: <command xmlns="http://basex.org/rest"> <text>open test2; add to test21.xml <![CDATA[<greeting>hello3</greeting>]]></text> </command> That fails telling me I cannot do multiple commands at one time. So, I thought I could add 2 command statements with the POST request: <command xmlns="http://basex.org/rest"> <text>open test2</text> </command> <command xmlns="http://basex.org/rest"> <text>add to test21.xml <![CDATA[<greeting>hello3</greeting>]]></text> </command> But, that also doesn't work. Does anyone have a suggestion as to how to add an xml document to an existing database (ideally the xml document is not in a file)? many thanks for your help, adil

2 2

Re: [basex-talk] Nonstandard CSV in RESTXQ
by Christian Grün 13 Jun '16

13 Jun '16

Did you specify "text/comma-separated-values" as Content-Type? Am 12.06.2016 8:05 nachm. schrieb "Alexander Shpack" <shadowkin(a)gmail.com>: > Thank you, Christian! > > But it doesn't work as expected > > declare > %rest:path("/upload") > %rest:POST("{$csv}") > %input:csv("header=false,encoding=CP1251,separator=semicolon") > %output:method("html") > function page:uploadFile($csv as document-node()) > { > $csv > }; > > > [XPTY0004] Cannot cast xs:string to document-node(): "?????????? ?.... > > > On Sun, Jun 12, 2016 at 6:48 PM, Christian Grün <christian.gruen(a)gmail.com > > wrote: > >> Hi Alex, >> >> The following annotation should do what you want: >> >> %input:csv("header=true,encoding=CP1252") >> >> You were completely right, the existing documentation was a bit >> scrappy. I have slightly rewritten it (see [1] and outgoing links). >> >> Hope thie helps, >> Christian >> >> [1] http://docs.basex.org/wiki/RESTXQ#Input_options >> >> >> >> >> On Sun, Jun 12, 2016 at 4:03 PM, Alexander Shpack <shadowkin(a)gmail.com> >> wrote: >> > Hi, >> > >> > I have nonstandard CSV file with semicolon instead of comma as a >> separator >> > and cp1251 encoded. Documentation is not clear in this case, and the >> sample >> > doesn't work properly >> > >> > declare >> > %rest:path("/store.csv") >> > %rest:POST("{$csv}") >> > %input:csv("header=true") >> > function page:store-csv($csv as document-node()) >> > { >> > "Number of rows: " || count($csv/csv/record) >> > }; >> > >> > Even if I changed the encoding manually the next code does nothing >> > %input:csv("separator=semicolon") >> > and returns text instead of document-node() >> > >> > Could you check it? >> > >> > It would be nice if you add additional encoding parameter to csv module. >> > >> > Thanks! >> > > > > -- > s0rr0w >

3 16

Nonstandard CSV in RESTXQ
by Alexander Shpack 12 Jun '16

12 Jun '16

Hi, I have nonstandard CSV file with semicolon instead of comma as a separator and cp1251 encoded. Documentation is not clear in this case, and the sample doesn't work properly declare %rest:path("/store.csv") %rest:POST("{$csv}") %input:csv("header=true") function page:store-csv($csv as document-node()) { "Number of rows: " || count($csv/csv/record) }; Even if I changed the encoding manually the next code does nothing %input:csv("separator=semicolon") and returns text instead of document-node() Could you check it? It would be nice if you add additional encoding parameter to csv module. Thanks!

2 1

Re: [basex-talk] remotely access
by Henning Phan 11 Jun '16

11 Jun '16

hi,I failed to include the mail list the ports you gave me are different 9884 != 8984, could that be the problem? Date: Sat, 11 Jun 2016 20:46:02 +0000 From: med_khr(a)yahoo.fr To: henningphan(a)hotmail.com Subject: Re: [basex-talk] remotely access yes i have added a "NAT" in my router with 9884 portand the ip of server B is accessible outside from anywhere In the php file in servers Ai have wrote: $session = new Session("The_public_IP", 8984, "admin", "admin"); I'm wondering why it shows me this error. De : Henning Phan <henningphan(a)hotmail.com> À : Mohamed kharrat <med_khr(a)yahoo.fr> Envoyé le : Samedi 11 juin 2016 21h42 Objet : RE: [basex-talk] remotely access Hi,A common thing people miss is to ensure that the server B is remotely accessible. Is server B behind a router then you might have to do port forwarding. Another issue is that the client uses the wrong port.Hope that helpsDate: Sat, 11 Jun 2016 20:29:06 +0000From: med_khr(a)yahoo.frTo: christian.gruen(a)gmail.comCC: basex-talk(a)mailman.uni-konstanz.deSubject: Re: [basex-talk] remotely accessI have made a BaseX php client in a server Aand running BaseX server in server B in the php file containing the xquery query and the connection stringwhen i execute it, the browser shows me: "cannot communicate with server"Any idea? De : Christian Grün <christian.gruen(a)gmail.com> À : Mohamed kharrat <med_khr(a)yahoo.fr> Cc : BaseX Talk <basex-talk(a)mailman.uni-konstanz.de> Envoyé le : Samedi 11 juin 2016 20h29 Objet : Re: [basex-talk] remotely access > to execute remotely xquery queries, we have to run BaseX server and> BaseXclient in the same time?The BaseX server needs to be run on your remote machine, and you’llaccess it via your local BaseX client instance. But I’m pretty sure Igot you wrong? If yes, please try a bit harder ;)

2 1

remotely access
by Mohamed kharrat 11 Jun '16

11 Jun '16

Hi,to execute remotely xquery queries, we have to run BaseX server and BaseXclient in the same time? Best regards

2 2

Self-knowledge in xquery
by France Baril 10 Jun '16

10 Jun '16

When I'm in xquery and I need to reference something through the rest interface. Can I know from xquery my host/port or domain, or do I have to leave that information for myself somewhere in a config file. Case: - I keep an indexable version my .xsd in a DB so I can query it to provide guidance to users in the GUI. - Validation won't work with my .xsd because it won't resolve the includes if I just open the main .xsd file. - I keep a binary copy of my .xsd in a different DB so I can reference it though rest and therefore validate content, but I need to know my base url. So far I've been leaving that information in a config file that I query, but as I have multiple BaseX instances in implies that I enter my host:port in .basex and then again in my indexable config file. I'm trying to reduce duplication here. Thanks, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

3 3

Optimal size for large databases
by Lizzi, Vincent 09 Jun '16

09 Jun '16

I am importing a large (~3 million) set of XML documents to BaseX and am running into some problems as the databases grow beyond a few gigabytes. I am using BaseX 8.4.4, and have increased the memory available to BaseX to 12288m (12 Gb) using -Xmx (the machine has 20 Gb total). The documents are being stored in several databases that range in size from 300 Mb up to 25 Gb. My question is: what is an optimal maximum database size (in gigabytes)? I am hoping for some general advice. I appreciate that the answer can vary depending various factors. The problems that I've encountered with the larger databases are: 1. Running OPTIMIZE or OPTIMIZE ALL on the larger databases results in an out of memory error. I have switched to running CREATE INDEX to separately create text, attribute, token, and fulltext indexes, and found that creating these indexes separately produces fewer out of memory errors. I would like to be able to use OPTIMIZE ALL because over time some documents will be removed from the databases and the documentation indicates that optimize all will remove stale information from the indexes. 2. The command scripts that run CREATE INDEX or OPTIMIZE (ALL) seem to tie up the machine for a long time, maybe due to heavy disk access. 3. As the database grows in size the rate at which documents are added slows down. I have been measuring the number of documents imported, and observed rates over 100 documents per minute, and typical rates are around 60 - 30 documents per minute. As the database grows over a few gigabytes the speed slows to around 20 documents per minute. This is not much of a problem because when I see the rate slow down I can start a new database. Unfortunately I have been recording the number of documents, not the database size. In case this information is useful, my project is structured as follows: * There is 1 central index database which records for each document the BaseX database name and path where a document is stored, and some metadata that we use to identify or locate documents. * There are multiple content databases to store the actual documents. These content databases are organized by DTD and time period. * Each insert is done using the BaseX REST API. A BaseX HTTP server instance is running to receive documents, and a basex instance is running from the command line to locate and provide documents. Each insert is done by a POST that includes data and an updating query which adds (using db:replace) to the central index database and a document database in one "transaction". This helps to make the import resilient to duplicate documents, and to any problem that can prevent a single from document being added, and allows the process to continue if interrupted. I will probably need to re-organize the content databases so that each database is only a few gigabytes in size. Does anyone have advice on what would be a good maximum size for each database? Thanks, Vincent Vincent M. Lizzi - Electronic Production Manager Taylor & Francis Group 530 Walnut St., Suite 850, Philadelphia, PA 19106 E-Mail: vincent.lizzi(a)taylorandfrancis.com<mailto:vincent.lizzi@taylorandfrancis.com> Phone: 215-606-4221 Fax: 215-207-0047 Web: http://www.tandfonline.com/ Taylor & Francis is a trading name of Informa UK Limited, registered in England under no. 1072954 "Everything should be made as simple as possible, but not simpler."

2 3

Balisage 2016
by C. M. Sperberg-McQueen 03 Jun '16

03 Jun '16

Readers of this list may be interested in the Balisage conference, which focuses on applications of markup. This year's program includes several talks on projects which use XQuery (often in the form of BaseX). I hope to see other XQuery enthusiasts at Balisage this year! Balisage: The Markup Conference 2016 Program Now Available http://www.balisage.net/2016/Program.html Balisage: where serious markup practitioners and theoreticians meet every August. The 2016 program includes papers discussing reducing ambiguity in linked-open-data annotations, the visualization of XSLT execution patterns, automatic recognition of grant- and funding-related information in scientific papers, construction of an interactive interface to assist cybersecurity analysts, rules for graceful extension and customization of standard vocabularies, case studies of agile schema development, a report on XML encoding of subtitles for video, an extension of XPath to file systems, handling soft hyphens in historical texts, an automated validity checker for formatted pages, one no-angle-brackets editing interface for scholars of German family names and another for scholars of Roman legal history, and a survey of non-XML markup such as Markdown. XML In, Web Out: A one-day Symposium on the sub rosa XML that powers an increasing number of websites will be held on Monday, August 1. http://balisage.net/XML-In-Web-Out/ If you are interested in open information, reusable documents, and vendor and application independence, then you need descriptive markup, and Balisage is the conference you should attend. Balisage brings together document architects, librarians, archivists, computer scientists, XML practitioners, XSLT and XQuery programmers, implementers of XSLT and XQuery engines and other markup-related software, Topic-Map enthusiasts, semantic-Web evangelists, standards developers, academics, industrial researchers, government and NGO staff, industrial developers, practitioners, consultants, and the world's greatest concentration of markup theorists. Some participants are busy designing replacements for XML while other still use SGML (and know why they do). Discussion is open, candid, and unashamedly technical. Balisage 2016 Program: http://www.balisage.net/2016/Program.html Symposium Program: http://balisage.net/XML-In-Web-Out/symposiumProgram.html ====================================================================== Balisage: The Markup Conference 2016 mailto:info@balisage.net August 2-5, 2016 http://www.balisage.net Preconference Symposium: August 1, 2016 +1 301 315 9631 ====================================================================== -- **************************************************************** * C. M. Sperberg-McQueen, Black Mesa Technologies LLC * http://www.blackmesatech.com * http://cmsmcq.com/mib * http://balisage.net ****************************************************************

1 0

Re: [basex-talk] Bug report in handling fn:format-number in basex 8.4.4
by Michael Stoop 03 Jun '16

03 Jun '16

Good morning, First of all thank you for your great work on basex. I've been phasing out Zorba in favour of BaseX for excellent large file support and all around better documentation and support. However, I'm running into some issues in formatting numbers in basex 8.4.4 using fn:format-number (using http://www.w3schools.com/xsl/func_formatnumber.asp) To describe this behavior I wrote a simple xquery: let $result := <rows> <row input="0.3576" format="0.##" expected="0.36">{fn:format-number(0.3576, "0.##")}</row> <row input="-0.3576" format="0.##" expected="-0.36">{fn:format-number(-0.3576, "0.##")}</row> <row input="-0.3576" format="0.###" expected="-0.358">{fn:format-number(-0.3576, "0.###")}</row> <row input="-0.3576" format="0.####" expected="-0.3576">{fn:format-number(-0.3576, "0.####")}</row> <row input="-0.3576" format="0.00" expected="-0.36">{fn:format-number(-0.3576, "0.00")}</row> <row input="0.000" format="0.##" expected="0.00">{fn:format-number(0.000, "0.##")}</row> <row input="0" format="0.00" expected="0.00">{fn:format-number(0, "0.00")}</row> <row input="0.3" format="0.####" expected="0.3">{fn:format-number(0.3, "0.####")}</row> <row input="0.3" format="0.0000" expected="0.3000">{fn:format-number(0.3, "0.0000")}</row> <row input="17" format="0.##" expected="17">{fn:format-number(17, "0.##")}</row> <row input="17" format="0.00" expected="17.00">{fn:format-number(17, "0.00")}</row> <row input="17.4555" format="0.##" expected="17.46">{fn:format-number(17.4555, "0.##")}</row> <row input="-17.4555" format="0.##" expected="-17.46">{fn:format-number(-17.4555, "0.##")}</row> </rows> return $result The result of this is as follows: <rows> <row input="0.3576" format="0.##" expected="0.36">.36</row> <row input="-0.3576" format="0.##" expected="-0.36">-.36</row> <row input="-0.3576" format="0.###" expected="-0.358">-.358</row> <row input="-0.3576" format="0.####" expected="-0.3576">-.3576</row> <row input="-0.3576" format="0.00" expected="-0.36">-.36</row> <row input="0.000" format="0.##" expected="0.00">0</row> <row input="0" format="0.00" expected="0.00">0.00</row> <row input="0.3" format="0.####" expected="0.3">.3</row> <row input="0.3" format="0.0000" expected="0.3000">.3000</row> <row input="17" format="0.##" expected="17">17</row> <row input="17" format="0.00" expected="17.00">17.00</row> <row input="17.4555" format="0.##" expected="17.46">17.46</row> <row input="-17.4555" format="0.##" expected="-17.46">-17.46</row> </rows> Unfortunately two things seem to go wrong here: · Zero in the picture string is ignored for negative numbers. · The zero before decimal is ignored for amounts between zero and one (but does occur for 0.0000 for example). I hope someone can take a look at this and provide a fix. I tried messing around with string replace functions where I would just replace -. with -0. and prefix the result for a decimal point with a zero, but this really isn't present and requires a workaround for something that is very common in my code. Using the latest basex (8.4.4) on Windows Server 2012 under Java 8 (64 bit, last update just now: update 91). Thanks in advance and best regards, Michaël Stoop

2 2

Replacing documents in remote database
by Asxetos 02 Jun '16

02 Jun '16

Hey all, I am trying to connect to a remote database and replace its files. I am using db:replace() inside client:query(), but I don't get how I am supposed to pass $input as the new data for the file in the database. Here a quick code snippet I put together: http://sprunge.us/jdaZ ( or http://sprunge.us/OZHj?xquery ) If there's a better method for doing what I am trying, I'm fine with replacing my whole method, even if that is using some sort of REST API and http requests. Just give me some pointers ;) Thanks!

2 4

Static files not accessed ?
by Maud Ingarao 31 May '16

31 May '16

Hello dear friends Since we upgraded to 8.3 or 8.4, we have strange behaviours with static files. For example, this file cannot be accessed when called from another xsl (include or import) as shown in the logs : [GET] http://rey.huma-num.fr/inventaire/Rey17470124; Stopped at /sites/papiersmmrey/resource/basex/basex.8.4.3/webapp/synopsx/mappings/htmlWrapping.xqm, 168/33: [bxerr:BXSL0001] Error on line 7 column 78 of tei2html-fiche.xsl: XTSE0165: I/O error reported by XML parser processing http://rey.huma-num.fr/synopsx/files/xsl/tei2html.xsl: Server returned HTTP response code: 502 for URL: http://rey.huma-num.fr/synopsx/files/xsl/tei2html.xsl Stack Trace: - /sites/papiersmmrey/resource/basex/basex.8.4.3/webapp/synopsx/mappings/htmlWrapping.xqm, 78/47 - /sites/papiersmmrey/resource/basex/basex.8.4.3/webapp/synopsx/models/synopsx.xqm, 168/49 - /sites/papiersmmrey/resource/basex/basex.8.4.3/webapp/synopsx/workspace/rey/_restxq/rey.xqm, 443/43 So is it called in the other xsl : <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="3.0" xmlns="http://www.w3.org/1999/xhtml" xmlns:xs="http://www.w3.org/2001/XMLSchema" exclude-result-prefixes="xs"> <xsl:output method="xml" encoding="UTF-8" indent="no" omit-xml-declaration="yes"/> <xsl:import href="http://rey.huma-num.fr/synopsx/files/xsl/tei2html.xsl"/> [...] And still it is available via a direct GET request : http://rey.huma-num.fr/synopsx/files/xsl/tei2html.xsl Notice that the error code is 502 and not 404. We changed our code as discussed in a previous mail (see below), it seemed to work a little, but now we have this new problem showing... Thanks ! Maud Coordonnées ------------------------------------------------------------------------ /« Ne travaillez jamais »/ Maud Ingarao IHRIM - UMR 5317 Institut d’histoire des représentations et des idées dans les modernités Ecole Normale Supérieure de Lyon - Site Descartes - Bureau R322 15 Parvis René Descartes - BP7000 - 69342 Lyon CEDEX 07 +33 4 37 37 65 79 - maud.ingarao(a)ens-lyon.fr /Je suis absente le vendredi - Out of office on Fridays/ http://ihrim.ens-lyon.fr/ http://institutdesanti.ens-lyon.fr/ http://ahn.ens-lyon.fr/ Hi Maud, Sorry for the delay, I’ll soon give you an answer on your other e-mails! > Response : > HTTP ERROR 400 > Problem accessing /synopsx/files/synopsx.js. Reason: > > Stopped at/resource/basex/webapp/synopsx/_restxq/files.xqm, 38/10: > [SEPM0017] Value of 'method' must be one of > (xml,xhtml,html,json,csv,text,adaptive,basex). With 8.4, the "raw" output method has become obsolete. Your code should work if you remove the following line: <output:method value='raw'/> Here is yet another solution for the synopsx.files:file() function, which is a bit more compact: function synopsx.files:file($file as xs:string) as item()+ { let $path := $G:FILES || $file return ( web:response-header(map { 'media-type': web:content-type($path) }), file:read-binary($path) ) }; Hope this helps, feel free to ask more questions, Christian

2 5

Replacing node sets in a large file
by Michael Sanborn 30 May '16

30 May '16

I need to perform a transformation that would be simple in XSLT, but the input is a file about 250 MBs in size. I'm wondering whether XQuery and BaseX in particular would be the most efficient way of doing it. I'm new to XQuery, and I've come up with a couple of ways to do this, but they turn out to be very time-consuming, so I'm sure I'm Doing It Wrong. Hoping to find out the proper way of doing this. The input consists of 2 sections. There are about 3600 page elements with this structure: <page> [misc page content...] <list> <unit> [misc unit content 1...] <partinfo> <number>54321</number> <manuf>A321</manuf> </partinfo> <partinfo> <number>12345</number> <manuf>B123</manuf> </partinfo> [misc unit content 2...] </unit> [multiple units...] </list> </page> Each unit can have 1 or 2 partinfo elements. The other section has about 82000 part elements like this: <part> <partinfo> <number>54321</number> <manuf>A321</manuf> </partinfo> [misc part content 1] </part> [...] <part> <partinfo> <number>12345</number> <manuf>B123</manuf> </partinfo> [misc part content 2] </part> I want to replace each unit/partinfo with the correpsonding part, like this: <page> [misc page content...] <list> <unit> [misc unit content 1...] <part> <partinfo> <number>54321</number> <manuf>A321</manuf> </partinfo> [misc part content 1] </part> <part> <partinfo> <number>12345</number> <manuf>B123</manuf> </partinfo> [misc part content 2] </part> [misc unit content 2...] </unit> [multiple units...] </list> </page> Is BaseX a good tool for this task? If so, how does one go about it? Finally, it would help to be able to output each page element in a separate file. Would it be better to have BaseX do this, or to output the whole database and chunk it with another tool? Thanks, Michael

3 15

HTML5 serialization and @required.
by France Baril 27 May '16

27 May '16

I created forms that use <input *id*=*"browse-to-zip"* *enctype*= *"multipart/form-data"* *name*=*"zip"* *required*=*"required"* *type*= *"file"*/> I was hoping that it would serialize to: <input id="browse-to-zip" enctype="multipart/form-data" name="zip" required type="file">, but I get <input id="browse-to-zip" enctype="multipart/form-data" name="zip" required="required" type="file">. Is it possible to get something well formed to serialize to @required? -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 2

Search algorithm used by BaseX
by Bram Vanroy | KU Leuven 27 May '16

27 May '16

Good afternoon all, It's me again While writing my paper, I was wondering how BaseX (and/or XQuery)'s search algorithm actually works. I imagine each XML-structure is search through one by one, but what technique is used in this search? I'm looking for some terminology such as A*, IDA, D*, depth-first, breadth-first, top down, bottom up, etc. but I cannot find anything in your documentation. Can you enlighten me on the subject? And is the algorithm used specified by BaseX, or is it implied by XQuery? Kind regards Bram Vanroy

2 1

Namespace scoping in direct element constructor
by Gunther Rademacher 26 May '16

26 May '16

The order of attributes, including namespace declaration attributes, in a direct element constructor is not significant. But while playing around I found that it makes a difference with BaseX for expressions that are embedded in an attribute. So these two constructors produce different results, but I think it should be the same: basex -q"<e xmlns='A'><e xmlns='B' a='{namespace-uri-for-prefix((), <e/>)}'/></e>" basex -q"<e xmlns='A'><e a='{namespace-uri-for-prefix((), <e/>)}' xmlns='B'/></e>" Tested on BaseX 8.4.1. Best regards Gunther

2 1

searching for the nearest ancestor
by Rob Stapper 26 May '16

26 May '16

Hi, While processing a XML-file with xquery I need to find the nearest ancestor that has a child-element with a certain ID-value( $refID). I found this solution [1] but I was wondering if also a solution is possible that makes use of the ancestor being a reverse-axis[ 2]. That way I could replace the [ last()]-predicate with a [1]-predicate, which I find more transparant. Also my gut-feeling tells me that would be a more efficient solution then the current one. [ 1] ( $element/ancestor::*/child::*[ @ID = $refID] ) [ last()] [ 2] https://www.w3.org/TR/xquery-30/#id-predicate TIA for your replies, Take care, Rob Stapper

2 3

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk