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

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

HTTPS:PATCH - Request using http:send-request()
by Wissemann, Bodo 07 Nov '17

07 Nov '17

1 0

Issue with Full Text Retrieval
by Ron Katriel 06 Nov '17

06 Nov '17

Hi, I am seeing strange behavior with Full Text retrieval. The following query fails for a number of words that are in the XML document (see attached): for $trial in db:open('CTGovDebug') (: [clinical_study/id_info/nct_id='NCT00473512'] :) return $trial contains text { 'neoplasms' } It fails on a good number of words including neoplasms, cougar, industry, yes, completed, november, 2005, interventional, single, male, female, assignment, none, research, principal, primary, secondary, age, years, gender, etc. But it matches most of the words in the file. Observation: The words that fail are located at the beginning and/or end of the text *and* do not occur anywhere else in the middle of any text. The document is the only one in the database. It does not make a difference whether full text indexing is on or off. My BaseX version is 8.6.4. Thanks, Ron Ron Katriel, Ph.D. | Principal Data Scientist | Medidata Solutions <http://www.mdsol.com/> 350 Hudson Street, 7th Floor, New York, NY 10014 rkatriel(a)mdsol.com <tbrophy(a)mdsol.com> | direct: +1 201 337 3622 <//201 337 3622> | mobile: +1 201 675 5598 <//+1 201 675 5598> | main: +1 212 918 1800 <//+1 212 918 1800>

4 9