BaseX-Talk

basex-talk@mailman.uni-konstanz.de

5244 discussions

Start a nNew thread

x509
by Ветошкин Владимир 05 Jul '19

05 Jul '19

2 1

Adding a file to DB with automatically updated index disables attribute index
by France Baril 05 Jul '19

05 Jul '19

Hi, Here are the steps to reproduce: 1. In Oxygen XML, in the data explorer (webDAV connection), create and save a new xml file with content <test/> 2. Run a query with db:attribute System returns: [db:no-index] Database 'en-us' has no attribute index. The problem is resolved after a db:optimize(), but it's not practical in our case. -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 3

JS223 wrapper
by Marco Lettere 05 Jul '19

05 Jul '19

Hi all, is anyone on the list aware of a JS223 compliant wrapper for BaseX in order to include XQuery scripting "seamlessly" into scriptable applications? Thanks. Marco.

1 1

admin:write-log in updating query
by Markus Wittenberg 04 Jul '19

04 Jul '19

Hi BaseX team, I wonder why I can't use admin:write-log as output of an updating function Using ... return if(file:is-file($path)) then ( try { file:delete($path) } catch * { admin:write-log('Could not delete image file ' || $path) (: works with update:output('...'):) } , delete node $img ) else ( delete node $img ) I get the error *Expressions must all be updating or return an empty sequence.* Kind regards -- Markus Wittenberg Tel +49 (0)341 248 475 36 Mail wittenberg(a)axxepta.de ---- axxepta solutions GmbH Lehmgrubenweg 17, 88131 Lindau Amtsgericht Berlin HRB 97544B Geschäftsführer: Karsten Becke, Maximilian Gärber

2 2

Extracting a single attributes value
by Jordan Castillo 03 Jul '19

03 Jul '19

Hello BaseX Staff, I am trying to finish building a map of data I have been working on and am nearly complete, but am stuck on trying to retrieve an elements value, which should just be a single integer in string format. The function doing the work: declare function local:propGenerator($propList, $currID){ let $context := db:open($documentName) let $ret := for $x at $pos in 1 to (xs:integer(count($propList) div 3)) let $mult := ($pos - 1) * 3 return map:merge(($propsMap, map:entry(concat("prop", $pos), map{"xmi:type" : $propList[1 + $mult], "xmi:id" : $propList[2 + $mult], "name" : $propList[3 + $mult], "lowerValue" : 1, "upperValue" : ($context//packagedElement/[@xmi:id=$currID]/ownedAttribute/[@xmi:id=$propList[2 + $mult]]/upperValue/[@value]) }))) return $ret }; this function takes a list of strings, which come in triplets. The map is nearly built except for the "lowerValue" and "upperValue" and I'm getting an error I can't make sense of because of the line: "upperValue" : ($context//packagedElement/[@xmi:id=$currID]/ownedAttribute/[@xmi:id=$propList[2 + $mult]]/upperValue/[@value]) This search is going to be mirrored for the lowerValue once I get it working. The value in the "upperValue" element should always exist, and this should be unique because I am providing the IDs to narrow it down. The error message I am getting: [XPTY0019] ownedAttribute: node expected, array(*) found: [ false() ]. I tried wrapping the line in question with: if (exists($context//packagedElement/...restOfQuery...)) then 2 else () and I got the same error. If I omit the line in question, the query works so I am certain that line is the problem. For additional info, I tried the search using an absolute path earlier and I didn't have context so I am now using the context declaration. The snippet of the XML being used: <packagedElement xmi:type="uml:Class" xmi:id=" _18_5_2_4c1014b_1538502774996_709119_83315" name="Tape"> <ownedAttribute xmi:type="uml:Property" xmi:id=" _19_0_3e30194_1541527239959_149409_93200" name=" InformationAssuranceProperties" visibility="private"> <lowerValue xmi:type="uml:LiteralUnlimitedNatural" xmi:id=" _19_0_3e30194_1541527239960_849380_93202"/> <upperValue xmi:type="uml:LiteralUnlimitedNatural" xmi:id=" _19_0_3e30194_1541527239960_70368_93203" value="*"/> </ownedAttribute>  </packagedElement> Any advice here would be greatly appreciated, I am currently looking for other solutions but figured asking here would be the most helpful. Thank you, Jordan Castillo

2 1

XQuery: Subsequence of a sequence
by Jordan Castillo 03 Jul '19

03 Jul '19

Hello BaseX Staff, I am trying to access members of a sequence that I have created already, but it whenever I use the functions subsequence() it returns the entire sequence, and count() always returns 1. The code: xquery version "3.1"; declare namespace map="http://www.w3.org/2005/xpath-functions/map"; declare namespace xmi="http://www.omg.org/spec/XMI/20131001"; declare namespace uml="http://www.omg.org/spec/UML/20131001"; declare namespace MagicDraw_Profile=" http://www.omg.org/spec/UML/20131001/MagicDrawProfile"; declare namespace Extra_stereotypes=" http://www.magicdraw.com/schemas/Extra_stereotypes.xmi"; declare namespace UAF="http://www.omg.org/spec/UPDM/20121004/UPDM-Profile"; ( let $begin := db:open("CubeSatUML2.5XMIv3")/xmi:XMI/uml:Model/packagedElement let $modelContent := $begin//packagedElement[@xmi:type="uml:Class"] (: Combine the names of the elements with their ID's :) let $names := $modelContent/@name let $ids := $modelContent/@xmi:id (: Grab all stereotypes, properties:[attributes, comments] :) let $stereotypes := for $id in $ids let $stereo1 := /xmi:XMI/*[@base_Element=$id] let $stereo2 := /xmi:XMI/*[@base_Class=$id] let $attributes := $begin//*[@xmi:id=$id]/ownedAttribute/[@name | @xmi:type | @xmi:id] let $comments := $begin//*[@xmi:id=$id]/ownedComment/[@name | @xmi:type | @xmi:id | @body] let $combined := ($id, $stereo1/name(), $stereo2/name(), $comments, $attributes, "") return $combined let $final := for $seq in $stereotypes return subsequence($seq, 1, 1) (: ^ the part in question:) return $final ) I realize I am creating this in a very weird way, but I want to keep the data together and have not thought of another solution. I have tried 'for each'ing over the '$sequences' and tokenizing to get the elements out, but I get an error: let $finalMap := for $seq in $stereotypes return tokenize($seq, '\s') [XPTY0004] Item expected, sequence found: ("uml:Property", "_18_5_2_4c1014b_153850.... When I print '$stereotypes', I get what appears to be a sequence of sequences (which I don't think is a real thing, but it appears to be that) Ex output: xmi:id="_18_5_2_4c1014b_1538500371989_609286_80522" UAF:ResourceArtifact [(xmi:type="uml:Property", xmi:id="_18_5_2_4c1014b_1538500468390_289646_80939", name="flight")] [(xmi:type="uml:Property", xmi:id="_18_5_2_4c1014b_1538500488269_847951_81240", name="ground")] xmi:id="_18_5_2_4c1014b_1538500376501_394659_80590" UAF:ResourceArtifact [(xmi:type="uml:Comment", xmi:id="_18_5_2_4c1014b_1538501028725_896600_82978", body="The ground supporting equipment and operations that support the spacecraft mission.")] [(xmi:type="uml:Property", xmi:id="_18_5_2_4c1014b_1538500492755_533021_81326", name="ground Communications")] [(xmi:type="uml:Property", xmi:id="_18_5_2_4c1014b_1538500495333_439654_81369", name="ground Command and Control")] [(xmi:type="uml:Port", xmi:id="_18_5_2_4c1014b_1538582001724_435913_83660", name="Flight_Ground")] My end goal is to have a map of maps, where the root map has keys of element names (currently in $names) and the value is a map of all the properties of this element. To do this I have to deconstruct this monster I have created, and maybe I am on the wrong path entirely but some direction would be greatly appreciated. End goal format: map{ elementName : map { stereotypes: map{ stereotype_Name_1: stereotype_ID_1, stereotype_Name_2: stereotype_ID_2 }, attributeName: map{ 'id': actual_ID_here, 'lowerValue': someValue, 'upperValue': "*" }, comment: map{ 'id': actual_ID_here, 'xmi:type': 'uml:Comment', 'body': actual_Comment_Here }, 'id': actual_ID_here } } Thanks, Jordan Castillo </longWindedQuestion>

3 3

Memory mode in BaseX Gui
by France Baril 01 Jul '19

01 Jul '19

Hi, When we create a new DB and try to run a .xq script that adds new files to the DB we get an issue that says that we can't perform the operation in memory mode. We have to restart the server to be able to run our script. Can you tell why this is happening and if there is an easier way to get out of said memory mode without a server restart? Thanks -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 3

GUI not counting all updates?
by France Baril 26 Jun '19

26 Jun '19

Hi, I am running this query on my DB in BasexGui. The updates are performed, but the info window shows hit=0 and update=0. ( for $i in db:open('en-us')//p/node()[1] return if ($i instance of text() and normalize-space($i) = '') then replace node $i with '' else (), for $i in db:open('en-us')//p/node()[last()] return if ($i instance of text() and normalize-space($i) = '') then replace node $i with '' else () ) The DB has items like this one: <td id="j1359186"> <q id="j1213306">Turn off projector</q> <q id="j1158327">Switch off projector</q> <q id="j11037">Projector off</q> <q id="j147181">Turn projector off</q> <q id="j1277">Deactivate projector</q> <q id="j122584">Disable projector</q> </td> -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 2

Query Optimization Question
by Bridger Dyson-Smith 25 Jun '19

25 Jun '19

Hi all - An interesting XQuery question came up on reddit[1] over the weekend, and I'm curious about a couple of aspects of the problem. To recreate, the sample data is at timecenters[2] in the employeeTemporalDataset.zip download (specifically, the `departments.xml` and the three compressed directories of XML in `employees.tar.gz`). I created a database from employees.tar.gz (thanks for letting us parse XML in archives!), added the `departments.xml`, and then `Optimized All`. The initial query was ``` for $emp in /employees/employee[@tend = '9999-01-01'] let $curdept := $emp/deptno[@tend = '9999-01-01'] return $emp/lastname || " " || $curdept || " " || /departments/department[deptno = $curdept]/deptname ``` and it is slow (~100 minutes, 5999201.28 ms). The original poster came back later with a modified query that is significantly faster[3], but I was mostly wondering about the whys of the slowness. I think (but am not sure) that this is a join, and since the initial `for` binding ($emp) is pretty big (~240K), the processor has to parse through the $emp result sequence and match to values in the /departments part of the database; is that a correct assumption? Again, I'm assuming that in the second, faster, query, the processor has two sequences ($d and $e) and is able to pull the joined data together much more quickly? Thanks in advance for any light you can shed on these questions. Best, Bridger [1] https://www.reddit.com/r/xml/comments/c3mb86/simple_xquery_optimization/ [2] http://timecenter.cs.aau.dk/software.htm [3] improved query: ``` for $d in /departments/department for $e in /employees/employee[deptno[@tend='9999-01-01'] = $d/deptno] return $e/lastname || " " || $d/deptno || " " || $d/deptname ```

2 1

Re: [basex-talk] BaseX: Use and Error Questions
by Christian Grün 20 Jun '19

20 Jun '19

Hi Jordan, So that must have been the reason. If you use the GUI, you’ll need to avoid parallel requests on opened databases because there will be no synchronization between these instances (see [1] for more details). You can run your script inside the GUI; maybe that solves your problems. Cheers Christian [1] http://docs.basex.org/wiki/Startup#Concurrent_Operations Jordan Castillo <jordantcastillo1992(a)gmail.com> schrieb am Do., 20. Juni 2019, 18:36: > Hello Christian, > > First, thank you for the speedy reply. > > 1. This was the source of the problem. After closing the GUI I could run > the script that failed previously. > 2. The GUI can remain open if I instead use the CREATE DB or CHECK > commands rather than the OPEN command. > > Hope you have a great day. > > Jordan Castillo > > On Thu, Jun 20, 2019 at 6:28 AM Christian Grün <christian.gruen(a)gmail.com> > wrote: > >> Hi Jordan, >> >> The way you proceeded looks ok to me. Some questions: >> >> 1. Did you run any operations in parallel while the script was running >> (such as checking the progress of the script via the GUI or another >> CLI instance)? >> 2. Does the problem always occur after the same ADD operation in your >> script? >> 3. Does it work if you create a new database instead of opening an >> existing one?… >> >> CREATE DB exists >> ADD >> /Users/user/Desktop/O-Lab/Examples/cubesat/BINARIES/BINARY-03abaa7c-18fd-40a4-a26b-4be24089cfe4 >> ... >> >> Thanks in advance >> Christian >> >> >> >> >> On Thu, Jun 20, 2019 at 12:08 AM Jordan Castillo >> <jordantcastillo1992(a)gmail.com> wrote: >> > >> > Hello BaseX Staff, >> > >> > I am a developer who is new to BaseX and am getting stuck sending >> commands through the basex executable. >> > My goal is to either open the CLI executable and send a command >> (through a script), or send the command without the basex CLI opening, as >> long as the command is run. >> > In my recent attempt that I thought was close, I received the following >> error message: >> > >> > users-MacBook-Pro:Scripts user$ /Users/user/Downloads/basex/bin/basex >> -c/Users/user/Desktop/O-Lab/Examples/Scripts/commands.bsx >> > >> > Improper use? Potential bug? Your feedback is welcome: >> > >> > Contact: basex-talk(a)mailman.uni-konstanz.de >> > >> > Version: BaseX 9.2.2 >> > >> > Java: Oracle Corporation, 12.0.1 >> > >> > OS: Mac OS X, x86_64 >> > >> > Stack Trace: >> > >> > java.lang.RuntimeException: exists: lock file does not exist. >> > >> > at org.basex.util.Util.notExpected(Util.java:61) >> > >> > at org.basex.data.DiskData.finishUpdate(DiskData.java:246) >> > >> > at org.basex.core.cmd.ACreate.update(ACreate.java:97) >> > >> > at org.basex.core.cmd.Add.run(Add.java:56) >> > >> > at org.basex.core.Command.run(Command.java:257) >> > >> > at org.basex.core.Command.execute(Command.java:93) >> > >> > at org.basex.api.client.LocalSession.execute(LocalSession.java:132) >> > >> > at org.basex.api.client.Session.execute(Session.java:36) >> > >> > at org.basex.core.CLI.execute(CLI.java:92) >> > >> > at org.basex.core.CLI.execute(CLI.java:76) >> > >> > at org.basex.core.CLI.execute(CLI.java:63) >> > >> > at org.basex.BaseX.<init>(BaseX.java:80) >> > >> > at org.basex.BaseX.main(BaseX.java:42) >> > >> > >> > The command file I am trying to have basex accept looks like this: >> > >> > >> > >> > OPEN exists >> > >> > ADD >> /Users/user/Desktop/O-Lab/Examples/cubesat/BINARIES/BINARY-03abaa7c-18fd-40a4-a26b-4be24089cfe4 >> > >> > >> > With many more "ADD ..." commands to follow. >> > >> > >> > Any advice on how to perform this operation would be greatly >> appreciated. >> > >> > >> > Thanks, >> > >> > >> > Jordan Castillo >> >

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk