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

Update/Delete JSON
by E. Wray Johnson 15 Nov '17

15 Nov '17

What is the best way to update JSON objects (only some object values) by unique id? What is the best way to delete JSON objects by unique id? Wray Johnson (m) 704-293-9008

5 8

BaseX gui, windows 10 and java
by Arto Viitanen 15 Nov '17

15 Nov '17

I have BaseX 8.6.7 on 32 bit Windows 10. When I tried to load an XML file yesterday to editor, the program crashed. I tried several times, and then reinstalled BaseX from net. This did not help. The program crashes on file dialog. If I open the file with double click, the file opens. Then I reinstalled java, but this did not help either.When I used cmd window, and run "java -cp BaseX.jar org.basex.BasexGUI", it worked. So it seems problem is on Java version embedded. Windows is 10.0.16299.19, and Java that works is 1.8.0_144-b01 Arto Viitanen Microteam Oy Haarlankatu 4B 33230 Tampere

2 4

updating inside map:for-each
by E. Wray Johnson 14 Nov '17

14 Nov '17

How can database updating be done inside map:for-each ?

3 2

DB locking
by Navin Rawat 14 Nov '17

14 Nov '17

Hi There, I have created an script which will setup a job by job:eval() function of BaseX to perform multiple actions on the inputs before ingesting them into the database. I have to create a report on each and every success/failure steps on each job. For this I have created per job XML file within the database under '/job/' directory, it is an update function. Everything is working fine, except user is unable to perform any other action within the database at the time of job execution. It seems, our running job is blocking whole database. Our job may take 20 minute to 2 hour to finish. Is this the correct behavior of BaseX to block whole database (even for reading)? or I am doing something wrong? Please suggest. Regards, Navin

3 6

Spatial Reference not working
by E. Wray Johnson 14 Nov '17

14 Nov '17

I can’t get the geo:srid() to work. I have tried many combinations of @srsName values. Can anyone provide examples? E. Wray Johnson

2 2

Update operations on JSON objects are not working
by E. Wray Johnson 13 Nov '17

13 Nov '17

I have tried many ways of updating JSON objects and none seem to work. Using the BaseX GUI, the Result window seems to show the correct outcom, but the database is not modified. What am I missing? Do I need to explicitly start/stop a transaction? XQUERY: db:open('db','country')/json[countryId = 1] update { replace value of node countryName with 'Aldorria', insert node <population type="number">1000</population> into . } Result: <json type="object"> <countryId type="number">1</countryId > <countryName>Aldorria</countryName> <population type="number">1234</population> <planetName>Zeldon</planetName> </json>

2 2

XSD 1.1 support? Unknown function: xs:dateTimeStamp
by Bridger Dyson-Smith 13 Nov '17

13 Nov '17

Hi Christian, et al, I was wondering if I'm seeing a bug or an oversight on my part. I was trying to type a $date as xs:dateTimeStamp but getting an error using the BaseX GUI, v8.6.7. let $date := '2017-12-15T23:45:00-5:00' return xs:dateTimeStamp($date) I've read in Walmsley's that XSD v1.1 data type support is required for xs:dateTimeStamp. Is this a bug or maybe user/operator error? Many thanks. Best, Bridger

2 1

Can't update or delete JSON objects
by E. Wray Johnson 13 Nov '17

13 Nov '17

I have tried XQUERY updates that should work but they don't work. My technique of storing JSON documents is perhaps not traditional. I have reduced my example to this simple example. FRIST CREATE DATABASE WITH ONE DOCUMENT: db:create('geography', json:parse('{ "code": "USA", "name": "United States of America", "birth": 1776 }'), '/country') THEN ADD ANOTHER DOCUMENT: db:add('geography', json:parse('{ "code": "CAN", "name": "Canada", "birth": 1867 }'), '/country') 1. How can I update either of these documents using 'code' as the unique identifier? 1. How can I change the 'name' or 'birth'? 2. How can I add a 'population' number? 2. How can I delete either of these documents using 'code' as the unique identifier?

2 1

GEO module not found with BaseX GUI
by E. Wray Johnson 12 Nov '17

12 Nov '17

Error: Stopped at D:/projects/xquery/geo test.xq, 1/57: [XQST0059] Module not found: http://expath.org/ns/geo. Query: import module namespace geo = "http://expath.org/ns/geo"; declare namespace gml='http://www.opengis.net/gml'; for $x in db:open('geonames2','country') where index-of(['US'], $x/json/countryCode)>0 return geo:envelope( <gml:LinearRing> <gml:coordinates>($x/west, $x/south), ($x/east, $x/south), ($x/east, $x/north), ($x/west, $x/north), ($x/west, $x/south)</gml:coordinates> </gml:LinearRing> ) OS: Windows 7 Installation Method: Windows installer Launch: basexgui.bat I had this problem long ago. https://www.mail-archive.com/search?l=basex-talk@mailman.uni-konstanz.de&q=…

3 12

repo install
by Kendall Shaw 10 Nov '17

10 Nov '17

I have been updating packages by modifying the files in REPOPATH instead of creating a xar file and using repo install. Is it safe to expect that to continue to work for the foreseeable future? Kendall

2 1