BaseX-Talk

basex-talk@mailman.uni-konstanz.de

9 participants
5241 discussions

BaseX bug report
by Veysel Karslı 23 Jan '23

23 Jan '23

Hello, We got an error about BaseX. We connect BaseX Java Server from our application developed with C#. Thank you for your support. Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 10.3 Java: Oracle Corporation, 19.0.1 OS: Windows Server 2019, amd64 Stack Trace: java.lang.ArrayIndexOutOfBoundsException: Index 4304 out of bounds for length 4096 at org.basex.io.random.TableDiskAccess.read1(TableDiskAccess.java:160) at org.basex.data.Data.kind(Data.java:312) at org.basex.query.up.atomic.AtomicUpdateCache.adjustDistances(AtomicUpdateCache.java:320) at org.basex.query.up.atomic.AtomicUpdateCache.execute(AtomicUpdateCache.java:276) at org.basex.query.up.DataUpdates.apply(DataUpdates.java:167) at org.basex.query.up.ContextModifier.apply(ContextModifier.java:120) at org.basex.query.up.Updates.apply(Updates.java:179) at org.basex.query.QueryContext.update(QueryContext.java:660) at org.basex.query.QueryContext.lambda$4(QueryContext.java:354) at org.basex.query.QueryContext.run(QueryContext.java:763) at org.basex.query.QueryContext.iter(QueryContext.java:354) at org.basex.query.QueryProcessor.iter(QueryProcessor.java:95) at org.basex.server.ServerQuery.execute(ServerQuery.java:125) at org.basex.server.ClientListener.query(ClientListener.java:397) at org.basex.server.ClientListener.run(ClientListener.java:104) -- Veysel Karslı Managing Partner & Co-founder M +90 543 238 8328 E veysel.karsli(a)codease.io CodEase Teknoloji Barbaros mh. Begonya sk. No:1/2 Ataşehir / İstanbul www.codease.io

2 2

Symlinks bug in webapp
by Jerome Chauveau 23 Jan '23

23 Jan '23

Hello, Symlinks seem to be not fonctional anymore since BaseX10 (Maybe before) in webapps. Is it due to a new version of Jetty ? I pushed a dummy example on that repository : [ https://git.unicaen.fr/chauveau/test-basex-symlinks | https://git.unicaen.fr/chauveau/test-basex-symlinks ] Thanks for your help ! Jérôme

2 4

Integrating BaseX With Server-Side Python
by Eliot Kimber 23 Jan '23

23 Jan '23

I’ve started implementing some sophisticated DITA data processing in Python, including using the Python xlsxwriter to easily generate Excel spreadsheets, something that would be more work to add to BaseX using Java and the Apache POI libraries. I’m also seeing that the Python streamlit tool, which provides sophisticated web pages for visualizing Python-based data (i.e., graphing from Pandas dataframes) would be a convenient way to generate graphs. I’m wondering: 1. Has anyone integrated streamlit with BaseX, for example, by running a streamlit server and using iframes from BaseX-served web pages to deliver graphs and whatnot. If so, are there any particular concerns or is it as simple running the server and creating the iframe? 2. What would be the best way to run or access Python scripts from BaseX server, for example, to run a script that will generate an Excel sheet from some data on the server (or provided by BaseX in some convenient form) and then serve the generated result back out? I think it should be as easy as using the process module to run Python commands from the command line, but again, wondering if there are any non-obvious considerations? Part of my new focus on Python is that my colleagues are Python-literate but not XQuery or XSLT literate, so it turns out to be best for us to do as much in Python as possible. But also the cost of doing really cool things in Python is just really low, streamlit being a good example. Thanks, E. _____________________________________________ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.com> LinkedIn<https://www.linkedin.com/company/servicenow> | Twitter<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Facebook<https://www.facebook.com/servicenow>

2 1

Socket specifications?
by Ben Engbers 21 Jan '23

21 Jan '23

Hi, When I developed the Basex client for R, I ran into problems with the socket for a long time. In the end it turned out that in R I had to configure the socket as a non-blocking socket. This solved all performance issues! I am now trying to develop a client for SWI-prolog. Because that low-level compiler doesn't support using sockets enough, I need to develop a library in C++ first. And in doing so, I again run into problems with the socket. The basex documentation just says to use a socket. But there is no information on how to configure the socket itself. My question is how do I configure the client side of the socket for optimal use? Ben Engbers

3 2

Minor issue: format-date?
by Alexander Witzigmann 20 Jan '23

20 Jan '23

Hi, The format-date has one minor issue using format-date(xs:date("2022-01-01"),"[D]. [Mn] [Y]","de",(),()) should return 1. Januar 2022 but currently (BaseX 10.4) returns 1. januar 2022 alex

2 2

RESTXQ advice?
by Hans-Jürgen Rennau 19 Jan '23

19 Jan '23

Hello, I encounter a problem with a RESTXQ application, perhaps someone can help me? *Goal:* Download a file with an encoding dependent on a user entry. The request contains *form parameters*. *Attempt:* I can control the encoding using the %output annotation. However, this annotation must be a literal string, I think. Therefore I tried *web:forward*, as well as *web:redirect*, thus triggering the execution of a function with the desired %output declaration. *Issue:* the form parameters get lost. How to achieve the goal? Thank you for your advice. With kind regards, Hans-Jürgen declare %output:method("text") %output:encoding("utf-8") %rest:path("*/util/download/text*") %rest:form-param("text", "{$text}", "") %rest:form-param("file-name", "{$fileName}", "text.txt") %rest:form-param("encoding", "{$encoding}", "utf-8") function *f:downloadText*( $text as xs:string, $fileName as xs:string, $encoding as xs:string) { if ($encoding eq 'cp1252') then *web:forward*(' */util/download/text-cp1252*') else ... declare %output:method("text") %output:encoding("cp1252") %rest:path("*/util/download/text-cp1252*") %rest:form-param("text", "{$text}", "") %rest:form-param("file-name", "{$fileName}", "text.txt") function *f:downloadTextCp1252*( $text as xs:string, $fileName as xs:string) { let $text := replace($text, '
', '
') return ( <rest:response> <http:response status="200"> <http:header name="Content-Disposition" value='attachment; filename="{$fileName}"'/> <http:header name="Content-Language" value="en"/> <http:header name="Content-Type" value="text/csv; charset=cp1252"/> </http:response> </rest:response>, $text ) }; PS: The <http:header> seems to be without effect - experiments seemd to show that I have to use the %output declaration.

4 4

Suggestion: db:delete-value(), db:delete-binary()
by Hans-Jürgen Rennau 12 Jan '23

12 Jan '23

Hello, I wonder if it wouldn't be worthwhile to complement the functions *db:put-value()* and *db:get-value()* by a third function *db:delete-value()?* And, similarly, to add a function *delete-binary()*. Kind regards, Hans-Jürgen

3 2

put-value() bug (?)
by Hans-Jürgen Rennau 12 Jan '23

12 Jan '23

Hello, after the following call basex "db:put-value('foofoo', doc('yogi.html')//@href/string(), 'hrefs')" I expect the resource "hrefs" to contain strings - but db:get-value('foofoo', 'hrefs') returns a sequence of attributes. Kind regards, Hans-Jürgen

2 1

REST documentation - bug?
by Hans-Jürgen Rennau 11 Jan '23

11 Jan '23

Hello, the documentation ( https://docs.basex.org/wiki/REST ) contains an example applying a query via REST to a complete database: http://localhost:8080/rest/database?query=count(.) (My understanding is that "database" should be replaced with the name of a database.) However, the URL yields an error ("Document is empty"). At any rate, the documentation should be explicit about the evaluation context of REST calls with parameter "query" or "run". If the resource identified by the URL is a single document, the context item is fairly obvious. However, in case of a database or a database collection, the evaluation context is not obvious. With kind regards Hans-Jürgen

2 2

Re: [basex-talk] Select proper database for Plot Widget
by Christian Grün 11 Jan '23

11 Jan '23

Hi Ben, Your query seems to be based on a different input ("GRCMAPLE-1" is not included in the example XML document), and… > CREATE DB bullion-2 /home/bpracht/java/basex-10.4/ …by running this command, you are creating a database with all XML documents found in the given filesystem path (that’s why your database is not empty). The attached query might give you a clue on how data can be prepared to get price/timestamp data displayed in the Plot visualization. After having run the query, you need to open the generated "test" database and enable the Plot visualization. Best, Christian On Tue, Jan 10, 2023 at 5:16 PM Ben Pracht <ben.pracht.news(a)gmail.com> wrote: > > I think any non-stock database would work to show this, but below is the > code I was using. This is the part of the dialog I'd like to get working: > > https://i.imgur.com/ocGXjlP.png > > I apologize for the bad markering, but it shows the drop downs that > refer only to items in some other un-selected database. > > To recreate: > > 1. Please create a database. I kept most of the defaults: > > CREATE DB bullion-2 /home/bpracht/java/basex-10.4/ > > 2. Add a document: > > let $item := <item> > <vendor>sdbullion</vendor> > <img-url>https://sdbullion.com/media/catalog/product/cache/092a78d23e77560f092c3f80d…</img-url> > <detail-url>https://sdbullion.com/2022-1-oz-canadian-gold-maple-leaf-coin</detail-url> > <detail-title>2022 1 oz Gold Maple Leaf Coin BU</detail-title> > <schedule skus="GRC22MAPLE-1" timestamp="1672932572402"> > <tier quantity="1 - 9" cash-price="1930.26" cc-price="2010.69" > paypal-price="2010.69"/> > <tier quantity="10 - 19" cash-price="1925.26" cc-price="2005.48" > paypal-price="2005.48"/> > <tier quantity="20 - 99" cash-price="1920.26" cc-price="2000.27" > paypal-price="2000.27"/> > <tier quantity="100+" cash-price="1915.26" cc-price="1995.06" > paypal-price="1995.06"/> > </schedule> > </item> > let $add := db:add('bullion-2',$item,"test-item") > return $item > > 3. Test code: > > declare function > local:get-price-for-quantity($schedule,$price-type,$quantity as > xs:integer) { > let $matching-tier := for $tier in $schedule/tier > let $range := $tier/@quantity/data() > let $minimum := number(if > (contains($range,'-')) then > substring-before($range,'-') > else > substring-before($range,'+')) > let $maximum:= number(if > (contains($range,'-')) then > substring-after($range,'-') > else > xs:double("INF")) > return if ($quantity >= $minimum and > $quantity <= $maximum) then > $tier > else > () > > return $matching-tier/(a)*[local-name(.) = $price-type]/data() > }; > > for $schedule in collection("bullion")/item/schedule > let $timestamp := $schedule/@timestamp/data() > let $price-type := "cash-price" > let $price := local:get-price-for-quantity($schedule,"cash-price",1) > order by $timestamp ascending > return if ($schedule/@skus/data() = 'GRCMAPLE-1') then > ($timestamp,$price) > else > () > > The test code above should show the timestamp and price of the item. I > was going to put the timestamp as the X and the price as the Y, but I > can't figure out how. > > > Bonus concern: For some reason, it didn't create an empty database, but > rather had these other documents too: > > repo/http-www.functx.com-1.0/cxan.xml > repo/http-www.functx.com-1.0/expath-pkg.xml > webapp/WEB-INF/jetty.xml > webapp/WEB-INF/web.xml > etc/factbook.xml > etc/w3-catalog.xml > > > Thanks for your help, > > Ben

2 2

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk