BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5245 discussions

replacing text nodes
by Graydon Saunders 09 Jan '19

09 Jan '19

Hello! I'm using BaseX 9.1.1 on Linux. So I need to go through a whole bunch of documents and emit them in an obfusticated form so the folks doing publication development can have them without the client's security people becoming upset. I don't want to obfusticate the db contents; I just want to be able to write out an obfusticated version. Minimal example: declare function local:gib($in as text()) as text() { text { 'ABCD' } }; declare function local:obfusc($in as document-node()) as document-node() { copy $c := $in modify ( for $x in $c/descendant::text()[normalize-space] return replace node $x with local:gib($x) ) return $c }; for $doc in db:open('out')[contains(document-uri(),'/scr_')][1] let $blurred := local:obfusc($doc) return $blurred If I run this, I get $doc back unaltered. If I look at the optimized query, it looks like it ought to be changing things. What am I doing wrong? Thanks! Graydon

2 2

[DELIVER]JETTY SSL & Cheeky Reload
by Adam Law 07 Jan '19

07 Jan '19

Is it possible to configure BASEX's jetty to respond over HTTPS using a keystore (eg port 8985). I have tried editing jetty.xml to no avail and have read https://stackoverflow.com/questions/32734920/using-jetty-9-and-jetty-xml-w ith-basex. Ideally it would be great if the keystore could be uploaded without having to restart baseX - (possibly with a script) I know this is cheeky. Adam

2 1

Java XQuery
by thufir 07 Jan '19

07 Jan '19

After creating and populating a database: try { new DropDB(databaseName).execute(context); } catch (BaseXException ex) { Logger.getLogger(Database.class.getName()).log(Level.SEVERE, null, ex); LOG.fine("no databases to drop"); } how would I query it? The query: db:open("note")//note thanks, Thufir

2 4

console versus gui
by thufir 03 Jan '19

03 Jan '19

Are the console and GUI in "sync"? By which I mean, can a database in the GUI not list from the console, and vice versa? I'm wondering if this perhaps relates to using BaseX as db server. I notice that my Java application can create and delete databases fine, but, it seems that that only the GUI can view those databases. Perhaps there's a way to migrate them from the GUI to the console? I'd like it consistent across access through the Java hooks, GUI and console. Or, perhaps I'm just writing bad code. I asked on SO: https://stackoverflow.com/q/54028203/262852 thanks, Thufir

2 3

Setting modification timestamp (for content migrated over WebDAV) over REST?
by Andreas Jung 03 Jan '19

03 Jan '19

As part of a migration we move data into BaseX over WebDAV. It would be neat if we could preserver the original timestamp. I am aware that it is not possible to set the timestamp over WebDAV. Would it be possible to set the modified timestamp for particular resource over the resource API or is this timestamp tied to storage internals of BaseX? Andreas

2 1

XQuery from Java
by thufir 03 Jan '19

03 Jan '19

I'm a tad more proficient with BaseX, but, how do I actually build an XQuery? Yes, I can write an XQuery and save it in a text file, then use BaseX for execution. But it would be far more flexible to write the actual XQuery from within Java itself. But how? Oracle gives an example: OXQDataSource ds = new OXQDataSource(); XQConnection con = ds.getConnection(); String query = "<hello-world>{1 + 1}</hello-world>"; XQPreparedExpression expr = con.prepareExpression(query); XQSequence result = expr.executeQuery(); using their datasource. Cannot BaseX do something similar? see also: https://stackoverflow.com/q/53996575/262852 thanks, Thufir

2 1

upper limits on storage; database admin
by thufir 03 Jan '19

03 Jan '19

What are the upper bounds to basex in size? Assuming it's just text xml, gigabytes is quite a bit to my thinking. At a certain, it's "big data" -- but how do you know when you're approaching that point? Or, is the bottleneck more read/write and consistency problems? What little I know of RDBMS is that master/slave can alleviate some bottlenecks. To put this another way: I'm so enthusiastic about basex that I'm having trouble finding a place it doesn't fit. As you approach terabytes and beyond what dbadmin approaches are employed? -Thufir

2 1

Bulk import (moving from eXist to BaseX)
by Andreas Jung 03 Jan '19

03 Jan '19

Hi there, consider moving my XML stuff for a particular project from eXist to BaseX. I have a full dump from eXist with all related content and I want to import it 1:1 into BaseX…is there a bulk loader or what is the preferred way to import an existing folder structure? Of course I can create my own script what would import the data through WebDAV but the dump has about 50.000 files. Andreas

3 4

console usage
by thufir 02 Jan '19

02 Jan '19

How can I run this script? thufir@dur:~/basex$ thufir@dur:~/basex$ basex [warning] /usr/bin/basex: Unable to locate /usr/share/java/jing.jar in /usr/share/java BaseX 9.0.1 [Standalone] Try 'help' to get more information. > > RUN fetch.note.text.xq Resource "/home/thufir/fetch.note.text.xq" not found. > > exit Have fun. thufir@dur:~/basex$ thufir@dur:~/basex$ cat fetch.note.text.xq fetch:xml("https://www.w3schools.com/xml/note.xml", map { 'chop': true() }) thufir@dur:~/basex$ The script seems to work fine from the GUI. thanks, Thufir

2 4

JSON serialization/compatibility with exist-db JSON?
by Andreas Jung 02 Jan '19

02 Jan '19

Hi there, I have an issue with the migration of an XQuery script from eXist to Basex: The link https://gist.github.com/zopyx/467a01264d53bdaa48ad27cd553cfda8 shows the script and the expected (status quo) output for XML and JSON. Calling the script using /rest/foo/?run=foo.xql&method=json generates an HTTP response with Content-Type: application/json;charset=utf-8 but the output is a quoted XML string like: "<item><uri>\/foo\/de\/ayapedia\/addendums\/ernaehrung_9861fc6a-ba68-11e8-a8a1-001c4210b7a0\/current-20180920-111838.bak\/xml\/index.xml<\/uri><title>Ernährung<\/title><description\/><language>de<\/language><status>current<\/status><area>ayapedia<\/area><path\/><date>2018-09<\/date><url\/><atc_code\/><guideline_id>bef53078-2d8d-42d1-af8c-b3d387dfa52e<\/guideline_id><plone_uuid>464520ec154a42839b9f5d2635caccaf<\/plone_uuid><old_authors_additional\/><authors_additional>für den Arbeitskreis Ernährung, Stoffwechsel und Bewegung der DGHO<\/authors_additional><documenttype>ayapedia<\/documenttype><societies xmlns:json=\"http:\/\/basex.org\/modules\/json\" json:array=\"true\">dgho<\/societies><guideline_topics xmlns:json=\"http:\/\/basex.org\/modules\/json\" json:array=\"true\">183<\/guideline_topics><authors xmlns:json=\"http:\/\/ basex.org\/modules\/json\" json:array=\"true\">9211<\/authors><authors xmlns:json=\"http:\/\/basex.org\/modules\/json\" json:array=\"true\">5577<\/authors><authors xmlns:json=\"http:\/\/basex.org\/modules\/json\" json:array=\"true\">13728<\/authors><authors xmlns:json=\"http:\/\/basex.org\/modules\/json\" json:array=\"true\">373215<\/authors><\/item>" Calling /rest/foo/?run=foo.xql&method=json&json=format=jsonml" finally generates JSON but not in the related format. Isn't the JSON serialization supposed being standardized and compatible? Or how can I generate a JSON result that is compatible with the existing JSON response from eXist-dB? Andreas

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk