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

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

REST documentation - bug?
by Hans-Juergen 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

1 0

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

10 Jan '23

> 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: Thanks. I’m confused, though: Are you struggling with the Plot or the Explorer visualization, or both?

1 0

Help with ‘Permission Denied’ error under MacOS
by Jim Salmons 09 Jan '23

09 Jan '23

2 2

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

09 Jan '23

Hi Ben, My recommended solution (albeit a bit static) is to generate a new XML document that contains attributes or elements with the relevant data, create a database from it, and open the plot for that database. Hope this helps, Christian On Sun, Jan 8, 2023 at 12:23 AM Ben Pracht <ben.pracht.news(a)gmail.com> wrote: > > Christian, > I like the chart type. I've got a separate database with gold prices over time. I want to put the price of 1oz on the Y axis and a timestamp on the X axis. > > I'd like to specify maybe the database and an xquery expression for the X and Y series. > > Thanks for your help, > Ben > > On Sat, Jan 7, 2023, 08:49 Christian Grün <christian.gruen(a)gmail.com> wrote: >> >> Hi Ben, >> >> Do you have some specific data that you would like to see reasonably >> visualized by the Plot View, or are you rather looking for arbitrary >> data that could be rendered by this visualization? >> >> Best, >> Christian >> >> >> On Fri, Jan 6, 2023 at 7:13 AM Ben Pracht <ben.pracht(a)gmail.com> wrote: >> > >> > I like having a convenient inline plotting for data, but I can't figure out how to select the right database to query from for the BaseX GUI plot widget. I can only select X and Y values from what I think is the country database. >> > >> > Best Regards, >> > Ben Pracht >> > 919.809.2439 >> > ben.pracht(a)gmail.com

2 2

DBA: upload of database backups
by Andy Bunce 09 Jan '23

09 Jan '23

Hi, Since around 9.7 the DBA has an option to upload backup zip files. However it appears the backups are uploaded to data/.dba rather than data/ so can not be restored via the DBA UI. Maybe the problem is here [1] /Andy [1] https://github.com/BaseXdb/basex/blob/main/basex-api/src/main/webapp/dba/da…

2 1