BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

Can't serialize entities to XML
by Andreas Mixich 18 Aug '20

18 Aug '20

Hi, a REST API returns data in JSON, which I have requested via the http-client's `http:send-request#1` function with the following code: 1. let $data := local:get-article($token, concat($local:ahost, $link))/json 2. let $response := json:serialize($data, map{'format':'xquery'}) 3. => json:parse(map{'format':'xquery'}) 4. let $child := $response(2)?data?children(1)?data 5. return $child?body_html BaseX returns the JSON XML-encoded (see line 1), so I serialize once into JSON (line 2), then to XQuery Map (line 3). In line 4 I return data, that can look like this: <div class="md"><p>Welcome everyone from <a href="/r/all">r/all</a>! Please remember:</p> In the further process I would like this to become proper XHTML. I tried all the different `fn:serialize#2` parameters. Either the data stays the same or it gets re-entitized. I also tried `html:parse#1` but get the error: [html:parse] Line 1: No text allowed before root element. I also tried casting to `xs:normalizedString` or using `fn:normalize-space#1` to no avail, before the `html:parse#1` As last I tried document { $child?body_html } which did not change anything in the output. If I do this, however: let $data := ' <div class="md"><p>Welcome everyone from <a href="/r/all">r/all</a>! Please remember:</p>' return $data I get this: <div class="md"><p>Welcome everyone from <a href="/r/all">r/all</a>! Please remember:</p> So my question is: How can I serialize this into XHTML (de-entitze it)? Thanks. -- Goody Bye, Minden jót, Mit freundlichen Grüßen, Andreas Mixich

2 4

Yaml serialization
by Marco Lettere 17 Aug '20

17 Aug '20

Dear BaseX team, just out of curiosity, could you imagine what kind of effort it would be to provide YAML as another serialization method for BaseX in addition to XML, HTML, JSON, CSV? The datamodel seems pretty close to the JSON one so maybe a very similar transformation to XML could be implemented ... Ciao, Marco.

6 11

Fuzzy is not applied in full-text search
by Lam Hong Thu 17 Aug '20

17 Aug '20

Hi all, I have a problem searching with "contains text" in content of a document using fuzzy. The results which are found with ft:search can not be found again using "contains text". After making some tests I found out 1. Query: 'Commission abc' contains text 'Commissioning' using fuzzy Result: true Optimized Query: "Commission abc" contains text "Commissioning" using fuzzy using language "English" 2. Query: let $query := 'Commissioning' return 'Commission abc' contains text {$query} using fuzzy Result: false Optimized Query: "Commission abc" contains text "Commissioning" Why the optimized query in the 2. case does not contain "using fuzzy" any more? What could I do so that "using fuzzy" is applied there? I use baseX-GUI of version 9.4.1 Thank you in advanced. Thu

2 1

Understanding PUL, seeing modified result
by Ben Pracht 17 Aug '20

17 Aug '20

Hi, I'm a bit more familiar with a SQL database like Oracle than BaseX, though I did cut my teeth on MarkLogic. MarkLogic from what I've read seems to handle updates differently than BaseX. I'm working through examples I found from the website, but wanted to adapt them for my own understanding. I believe every time I have the copy keyword, it's creating a copy of variable and applies one or more modfiications to that copy. Because the original isn't changed, it's called "non-updating". For instance copy $c := <peace/> modify ( insert node element german { 'Friede'} into $c, insert node attribute guid {'asdf'} into $c ) return $c the original node <peace/>, even if it were a variable would not be touched. However, insert node element german { 'Friede'} into <peace/> Takes the <peace/> element, modifies it and returns the modified form. Or at least it does not complain. I ran SET WRITEBACK on and set MIXEDUPDATES before starting these examples. Unfortunately, the insert above just returns an empty set. I *think* it puts it into some PUL list, not unlike a set of transactions to be applied. These modifications seem to be invisible to subsequent queries, even in the same session (unlike a SQL database wherein the same session would see the modifications). How can I get these changes flushed so I can see and use the modified result? Separately, if I do haver an insert or some other modification, what's the syntax if I wanted to add a for, let order by or other FLOWR keyword? Kind Regards, Ben Pracht 919.809.2439 ben.pracht(a)gmail.com

2 1

Basex huge performance hit in linux (Basex query execution is too slow in linux)
by Nikhil Sethi 17 Aug '20

17 Aug '20

Hi Basex Team, We are facing a huge performance hit in linux machine while using basex, its working smoothly in windows machine While executing any query : -> windows machine takes around 4 to 15 millisec -> On linux machine same query takes around 120 to 150 millisec During some application operation execution we are selecting/inserting the xml nodes in different docs in basex and there are around 13000 xml nodes which needs to be selected/imported in this operation. Linux => rhel or cents of Based on the logs of query execution we have analysed and found : Windows worst case(15 ms) query execution time => 13000 x 15ms => 65000ms => 65 sec = around 1 min Linux average case(130 ms(120+150)/2) query execution time => 13000 x 130ms => 1690000ms => 1690 sec = around 28 min to execute same operation we are using BaseX941.zip ZIP Package eg queries : for $alias in collection(mydbname)//* where (($alias/@id="4249f0807da81000a734525400c54430018") and ($alias/@deleted="false") and ($alias/object-type/@uid="com.MyObjectName")) return $alias or insert node <myxmlNode>…….</myxmlNode> into (for $alias in doc('MyDoc') return $alias) I am using basex with java code to get the result System.setProperty("user.home", db_dir); BaseXXQDataSource ds = new BaseXXQDataSource(); ds.setProperty("serverName", "localhost"); ds.setProperty("port", "1984"); ds.setProperty("databaseName", "mydbname"); XQConnection2 connection = (XQConnection2) ds.getConnection("admin", "myDbPassword"); XQStaticContext xqsc = connection.getStaticContext(); xqsc.setScrollability(XQConstants.SCROLLTYPE_SCROLLABLE); connection.setStaticContext(xqsc); XQPreparedExpression expr = connection.prepareExpression(query); XQResultSequence result = expr.executeQuery(); XQSequence scrollableCopy = connection.createSequence(result); getting result from the xqsequnce for 13000 queries is taking another 10 mins Node node = scrollableCopy.getNode() we have tried to increase xms and xmx in basexserver but it didn't help, Can you please suggest any solution/configuration required for linux machine to increase the performance. Thanks, Nikhil

2 5

In search for "basexgui.vbs"
by Andreas Mixich 12 Aug '20

12 Aug '20

Hi, I had a file "basexgui.vbs", which would start the BaseX GUI without opening a console, but upon last installation it got overwritten. I do not find it, neither here, in the list, nor with Google, overall. Does anybody have this? Thanks! -- Minden jót, all the best, Alles Gute, Andreas Mixich

2 2

RESTXQ path resolution
by Ben Pracht 31 Jul '20

31 Jul '20

Hi, I'm trying to resolve a 404 with a RESTXQ service, and got to wondering if it's possible to show the directories it's looking for things, ideally fully qualified paths. Is it possible to turn on logging so much that it shows all the XQ files it found, then show the ones it actually matched? In my case, I put the hello-world service in the main project directory, in the modules directory where the RESTXQPATH and in the RESTPATH. I've tried renaming the hello-world to .xq, .xqm and .xqy. In all cases, it does not find the .xq file. Best Regards, Ben Pracht 919.809.2439 ben.pracht(a)gmail.com

2 3

Feature Request: Save untitled, open scripts when exiting GUI
by Andreas Mixich 30 Jul '20

30 Jul '20

SublimeText has this nifty feature, that it saves all open tabs, even if the have no representation on the filesystem, so one can continue exactly, where one has left off. I find myself often to have several, unnamed, XQueries open, to test this concept, to compose that function, etc. It would be nice, if one could simply shut off and have them reopened next time without naming a file and saving each item in question. -- Minden jót, all the best, Alles Gute, Andreas Mixich

2 6

BaseX 9.4 - XQuery locks - documentation query
by James Ball 30 Jul '20

30 Jul '20

Hello, I was just looking at the changes to locking for 9.4 and I think the documentation has got ‘garbled’ in an update. https://docs.basex.org/wiki/Transaction_Management#XQuery_Locks <https://docs.basex.org/wiki/Transaction_Management#XQuery_Locks> " The lock may be transformed to a write lock by cominthe operations as Similar to the internal database locks, write locks block all other operations while read locks allow parallel access. “ I think this line should be two bullets but I’m not sure what ‘cominthe operations’ should be? Combining? The lock may be transformed to a write lock by combining operations Similar to the internal database locks, write locks block all other operations while read locks allow parallel access. I’m happy to update the wiki but I wasn't confident enough that I’ve understood the 9.4 change to do it without first checking on the list. Regards, James

3 5

Testing if a database exists and if some files exist
by Ramzi Hammouda 29 Jul '20

29 Jul '20

Hello BaseX team, I'm building a C# application, I'm using Rest APIs, how can I test if a database exists or not when I launch my application, and create necessary db/files when they are missing ? Thanks, Ramzi P Respectons ensemble l'environnement. N'imprimez ce message que si n?cessaire. Let's respect the environment together. Only print this message if necessary.

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk