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

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

Global locks
by Andy Bunce 11 Feb '19

11 Feb '19

Running the following in the GUI (8.6.5) ``` let $db:="BEP" return count(collection($db)) ``` The info windows shows $db is inlined Compiling: - inline $db_0 - pre-evaluate collection("BEP") to document-node() sequence - pre-evaluate count((db:open-pre("BEP",0), ...)) to xs:integer - simplify gflwor Optimized Query: 9193 All good. Submitting a job ``` let $q:='let $db:="BEP" return count(collection($db))' return jobs:eval($q,(),map{"cache":true()})!(jobs:wait(.),jobs:list-details(.)) ``` returns: <job id="job90" type="ScheduledXQuery" state="cached" user="admin" duration="PT0.007S" reads="(global)" writes="(none)">let $db:="BEP" return count(collection($db))</job> Note @reads="(global)" But ``` let $q:='count(collection("BEP"))' return jobs:eval($q,(),map{"cache":true()})!(jobs:wait(.),jobs:list-details(.)) ``` <job id="job92" type="ScheduledXQuery" state="cached" user="admin" duration="PT0.006S" reads="BEP" writes="(none)">count(collection("BEP"))</job> Note @reads="BEP" Is this correct and/or of any consequence? /Andy

2 8

Programmatically extracting function signatures
by Bridger Dyson-Smith 07 Nov '18

07 Nov '18

Hi all - I was curious if there was a way to extract function signatures from BaseX. I'm currently reading through the (excellent) wiki but was curious if there was a more automated process I might be able to use. I've been trying to think of something clever with function-lookup, but I can't seem to make it dynamic based on module namespace; e.g. ``` for $fun in function-lookup(xs:QName("archive:delete"), 1) return $fun ``` I may just grab the wiki and parse it :), but I'm also interested in changes between versions of the processor. Any thoughts or suggestions would be greatly appreciated! Best, Bridger

4 7

BaseX 9.0: The Spring Edition!
by Christian Grün 01 Nov '18

01 Nov '18

Dear BaseX aficionados, We are very happy to announce the release of BaseX 9.0! The new version of our XML database system and XQuery 3.1 processor includes some great new features and a vast number of minor improvements and optimizations. It’s both the usage of BaseX in productive environments as well as the valuable feedback of our open source users that make BaseX better and better, and that allow and motivate us to keep going. Thanks to all of you! Along with the new release, we invite you to visit our relaunched homepage: http://basex.org/. Java 8 is now required to run BaseX. The most prominent features of Version 9.0 are: XQUERY - Comprehensive extensions in the internal XQuery optimizer framework - Dynamic hash joins rewritings of general comparisons - Register query jobs as persistent services - Process very large CSV files via the new CSV 'xquery' format - Update Module: higher-order functions for performing updates - Unified static typing, including maps, arrays and function items - COPYNODE: Lightweight copying of XML fragments - ENFORCEINDEX: Enforce rewriting for index access STORAGE - Improved database compression (short strings, whitespaces) WEB APPLICATIONS - Permissions layer: Unified definition of RESTXQ access patterns - RESTXQ: Full support for client- and server-side quality factors - REST: Run BaseX command scripts - Web server upgrade to Jetty 9 REPOSITORIES - Combined packaging mechanism (XQuery and Java) - Java Packaging: Bundling of additional libraries DISTRIBUTIONS - Revised detection and configuration of BaseX home directory - Windows executable: better detection of Java libraries DBA: BASEX DATABASE ADMINISTRATION - Improved editing and evaluation of XQuery modules - Revised file, session and job management More details can be found on our homepage. We are looking forward to your feedback. Enjoy and have fun, Christian, BaseX Team

7 8

Database Updates
by Dave Kopecek 25 Oct '18

25 Oct '18

Hi All, Given a database created from catalog.xml below. What's the best way to update & add records received daily as in file daily-update.xml ? Coming from relational DBs & new to this. I ultimately need to script/automate this. Hoping there's some magic command I'm missing & looking for best way to approach the problem. Thanks, -Dave catalog.xml <?xml version="1.0" encoding="UTF-8"?> <CATALOG> <ENTRIES> <ENTRY> <SKU>1</SKU> <TITLE>Empire Burlesque</TITLE> <ARTIST>Dylan</ARTIST> <PRICE>10.90</PRICE> </ENTRY> <ENTRY> <SKU>2</SKU> <TITLE>Hide your heart</TITLE> <ARTIST>Bonnie Tyler</ARTIST> <PRICE>9.90</PRICE> </ENTRY> </ENTRIES> </CATALOG> daily-update.xml <?xml version="1.0" encoding="UTF-8"?> <CATALOG> <ENTRIES> <ENTRY> <SKU>1</SKU> <PRICE>19.90</PRICE> <NEWTHING>I wasn't here before the update</NEWTHING> </ENTRY> <ENTRY> <SKU>1971</SKU> <TITLE>Tupelo Honey</TITLE> <ARTIST>Van Morrison</ARTIST> <PRICE>8.20</PRICE> </ENTRY> </ENTRIES> </CATALOG>

3 5

REPLACE command issue in Basex version 8.6.6/9.0.2
by Stephan van Hugten 01 Oct '18

01 Oct '18

In our software we're using a Basex database and integrate with it via the Java library. We're currently using 8.0.3, but attempted to upgrade to the latest version (9.0.2) when we encountered a breaking issue. The REPLACE command class now interprets all XML with an attribute as a path. I can reproduce this in the basex command line client, but not the GUI. Reproducer case: BaseX 9.0.2 [Client] Try 'help' to get more information. > create db test Database 'test' created in 25.24 ms. > open db test Database 'db' was not found. > open test Database 'test' was opened in 1.57 ms. > REPLACE com.example.model.user.Account-2397 "<text version="draft"><title>Chapter</title></text>" Resource "C:/Java/basex902/bin/"<text version=draft><title>Chapter</title></text>"" not found. > REPLACE com.example.model.user.Account-2397 <text version="draft"><title>Chapter</title></text> Resource "C:/Java/basex902/bin/"<text version=draft><title>Chapter</title></text>"" not found. > REPLACE com.example.model.user.Account-2397 <text version='draft'><title>Chapter</title></text> Resource "C:/Java/basex902/bin/"<text version='draft'><title>Chapter</title></text>"" not found. > REPLACE "com.example.model.user.Account-2397" <text version='draft'><title>Chapter</title></text> Resource "C:/Java/basex902/bin/"<text version='draft'><title>Chapter</title></text>"" not found. > REPLACE "com.example.model.user.Account-2397" "<text version='draft'><title>Chapter</title></text>" Resource "C:/Java/basex902/bin/"<text version='draft'><title>Chapter</title></text>"" not found. > REPLACE top.xml "<text version='draft'><title>Chapter</title></text>" Resource "C:/Java/basex902/bin/"<text version='draft'><title>Chapter</title></text>"" not found. > REPLACE top.xml <xml/> 0 resource(s) replaced in 29.71 ms. > REPLACE top.xml <xml version='draft'/> Resource "C:/Java/basex902/bin/"<xml version='draft'/>"" not found. > Storing the XML in a file and replacing that works: > REPLACE com.example.model.user.Account-95 test.xml 1 resource(s) replaced in 5.03 ms. > xquery //account <account uuid="83ff82e4-01b1-4624-969e-2ba7e7deeb29" id="10095"><x/></account> Can you assist in solving this mystery? '************************************************************************************************** This E-mail and any files transmitted with it are private and confidential and are solely for the use of the addressee. It may contain material which is legally privileged. If you are not the addressee, be advised that you have received this E-mail in error and that any use of it is strictly prohibited. If you have received this E-mail in error, please notify APS on +44 (0)161 495 4500, or E-mail administrator(a)theapsgroup.com. Any opinions expressed in the E-mail are those of the individual writer of it and not necessarily the Company unless specifically stated otherwise. There is no intention to create any legally binding contract or other commitment through use of this E-mail We cannot accept any liability for any loss or damage sustained as a result of software viruses. It is your responsibility to carry out such virus checking as is necessary before downloading this E-mail and any attachments onto your computer system. Allied Publicity Services (Manchester) Ltd Registered Office: Allied Publicity Services (Manchester) Ltd, Chetham House, Bird Hall Lane, Cheadle Heath, Cheshire, SK3 0ZP Company Registration No: 681528 England APS Group Secure Solutions Limited. Registered Office: Chetham House, Bird Hall Lane, Stockport, Cheshire, SK3 0ZP Company Registration No: 07007434 England APS Group (Scotland) Ltd. Registered Office: APS Group (Scotland) Ltd, 21. Tennant Street, Edinburgh, EH6 5NA Company Registration No: SC369510 Scotland ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit https://www.symantec.com ______________________________________________________________________

2 3

JAVA xquery: accessing documents
by Jan Stapel 01 Oct '18

01 Oct '18

Hello, Normally (few basex-versions ago) I did: session.execute("open main"); session.execute("xquery doc("users.xml")//users"); But now, this results in basex interpreting the doc()-path as relative to it's home-directory thus cannot find the resource.. "xquery doc("main/users.xml")//users" gives the correct results. Do we no longer open a database but writing the full path of the document instead? Whats the performance of this if accessing multiple documents of the same database during runtime? -regards, jan

2 1

XML catalog with fetch:xml
by Andy Bunce 25 Sep '18

25 Sep '18

Hi, Using a recent 9.1 Beta on windows. I create an XML catalog at c:\tmp\mycatalog.xml <catalog prefer="system" xmlns="urn:oasis:names:tc: entity:xmlns:xml:catalog"> <uri name="http://nowhere.com/doc" uri="file:///c:/tmp/doc.xml" /> </catalog> Then in the GUI fetch:xml("http://nowhere.com/doc", map{"catfile": "C:\tmp\mycatalog.xml"} ) It goes to nowhere, I was hoping to get back c:/tmp/doc.xml Should this work? /Andy

2 3

Importing XML (DITA) validated with Relax NG schemas?
by Robert Crews 25 Sep '18

25 Sep '18

I'm trying to set up BaseX to manage a repository of DITA content. The DITA content has been specialized to validate against Relax NG schemas instead of DTDs. While importing content that validate against DTDs is straight forward, I have not yet figured out the best way to import Relax NG based content. So, I have a few questions: * I see there is the Validation module [1] and that's good because I think XQuery is my best option for managing the imports. However, I need to pass a specific schema to the functions. DITA content utilizes multiple schemas. Is there some way I can pass a directory to these functions instead of just a single file reference? * I currently have the CATFILE option set [2]. Does this help or hinder importing when choosing to validate against Relax NG? Is there some way I can set the global options to make validating against Relax NG easier? * I've seen multiple examples of people actually storing the schema(s) in the database. Is that necessary or help for using the validation module? Thanks for your help! [1] http://docs.basex.org/wiki/Validation_Module#RelaxNG_Validation [2] http://docs.basex.org/wiki/Catalog_Resolver http://docs.basex.org/wiki/Options#CATFILE For reference, here is how Oxygen handles catalog resolution<https://www.oxygenxml.com/doc/versions/20.1/ug-editor/topics/using-XML-Cata…>. See the bottom of Table 1. Catalog Mappings for a summary of how Relax NG is resolved.

3 4

BaseX GUI repo install shortcut
by Marco Lettere 25 Sep '18

25 Sep '18

Hi Christian et al, I'm not aware of any shortcut (keyboard, flag or any) for speeding up the reinstallation of a REPO module once the XQ file is being updated when working in the GUI. At the moment I always reinstall from the preference menu but when developing in continuous it's a bit tedious and often I forget it and have to switch back from my test environment to reinstall. Is there any way or could you think of any good shortcut to (at least partially) automate the reinstall procedure after updating the .xqm module in a GUI tab? Thanks, Marco.

2 5