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

Documentation
by Thomas Daly 24 Aug '13

24 Aug '13

Hello, Thank you for this system, which looks promising. I would like to request better documentation to show how to do the most basic things. I am trying to create a new database and add a single new record to it. I don't want to start with a pre-written XML document. So using the command line client tool: > CREATE DB users Database 'users' created in 214.89 ms. Then I refer to the ADD command http://docs.basex.org/wiki/Commands#ADD which suggests an XML string can be added. So I try: > ADD <record>hello</record> Name '' is invalid. All the examples of ADD involve adding existing XML files. A path to the database is referred to, but having just created the database I have no idea what the path is. Referring to tutorials and slides on page http://docs.basex.org/wiki/Getting_Started, the link to XMLPrague 2013 is broken. BaseX adventures starts at an advanced level of querying a host of XML files. W3Schools XQuery seems all about querying existing databases, I can't find anything on how to add or update a single record. I'm sure with enough trial and error I'll work out how to do it. My point is that I feel it ought to be more obvious how to carry out the most basic CRUD operations. Best regards, Thomas

2 1

BaseX Gui import (Add) doesn't replace items
by France Baril 20 Aug '13

20 Aug '13

Hi, Context: DB name A Collection B File C.xml with Hello In BaseX Gui, DB A is opened. In the Properties window, browse to the file C.xml, say you want to add in under B and click Add. Repeat the operation (to replace C.xml, with a new update C.xml) In BaseX Gui, try: for $x in /*[@id='i1'] return $x You'll get this: Hello Hello If you try this: for $x in /*[@id='i1'] return $x/base-uri() You'll get A/B/C.xml A/B/C.xml Applying db:optimize won't change anything. Basically, it looks like the content of the file is appended to the existing file. Expectation is that it should replace it. Side effect: When we open the file in XML Oxygen through WebDAV, the file appears to be empty. -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 1

XQuery changes from 7.6 to 7.7
by Gerald de Jong 18 Aug '13

18 Aug '13

I am finding strange problems when I try using 7.7 which didn't appear before. I was building queries with XQUERY followed by \n and then the query, which worked in 7.6. XQUERY <Documents> { for $doc in collection('oscrtest/documents/Photograph')/Document order by $doc/Header/TimeStamp descending return $doc } </Documents> Now it warns me about the syntax of my query: "Syntax: XQUERY [query]" So then I take away the \n so that the query begins after "XQUERY " and my query becomes: XQUERY <Documents> { for $doc in collection('oscrtest/documents/Photograph')/Document order by $doc/Header/TimeStamp descending return $doc } </Documents> upon which it reports: "[XPST0003] Expecting closing tag </Documents>." Puzzling about why this happens, I adjust the query to: XQUERY <Documents>{ for $doc in collection('oscrtest/documents/Photograph')/Document order by $doc/Header/TimeStamp descending return $doc }</Documents> but then it reports: "[XPST0003] Expecting expression." I will have to stick to 7.6 until I understand what to do about these problems. What am I missing? -- Delving BV, Vasteland 8, Rotterdam http://www.delving.eu http://twitter.com/fluxe skype: beautifulcode +31629339805

2 2

Losing non-breakable spaces ( )
by France Baril 18 Aug '13

18 Aug '13

Hi, We are using a BaseX HTTP server (still on version 7.6), accessing files via WebDAV for authoring in XML Oxygen. At some point in the process, we lose our non-breakable spaces. If Isave a file with this content in BaseX: Test this It appears that files are saved correctly, because this query returns the p element: for $x in //text()[contains(., ' ')] return $x/parent::*. However, when we reopen the file in BaseX, the   has been replaced by a space. We tried the same experiment saving and opening the file on the file system to make sure the issue wasn't with XML Oxygen. The file reopens with the correct   character. -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 1

xquery hangs in 7.7 release version (used to work fine in 7.7 beta)
by Srinivasan Muthu 18 Aug '13

18 Aug '13

Hi, We have been using basex 7.7 snapshot from June 20 and wanted to upgrade to the release version but looks like I have hit a bug with BaseX 7.7 release version while running a set of xqueries in sequence. I am able to reproduce this in BaseX 7.7 running in client-server mode on two different machines. Here are the steps to reproduce: - Launch BaseX 7.7 server (with defaults) - Launch BaseX command line client (run the file under bin/basexclient.bat that comes in zip) and run the following commands (also attached a screenshot): ---------------------------------------------------------- Username: admin Password: BaseX 7.7 [Client] Try help to get more information. *> create db d1 <hello/>* Database 'd1' created in 103.22 ms. *> xquery delete node doc('d1')//oops* Query executed in 25.03 ms. *> xquery let $doc := 'd1' return doc($doc)* ---------------------------------------------------------- At this point BaseX 7.7 server cannot be stopped using the stop batch file and I have to kill all processes using Task Manager. These set of commands works fine on BaseX 7.7 snapshot from June 20th. Let me know if this is a bug or am I missing something here. Thanks, Srini

2 1

BaseX77 db:optimize exception
by Freihalter Thomas 17 Aug '13

17 Aug '13

Hi all, After migration to BaseX77, db:optimize is running into an exception: java.io.IOException: Stopped at ., 8/20: [java] [FOUP0002] Database 'xxx' is currently opened by another process. Before migration, I used BaseX761-20130303.204518, and this version worked well. I have an additional question: My task is to read objects from a file and replace (if already exists) or insert (if new) the objects in the database. The key is a specific attribute (@n). Parallel threads could exist. Could you suggest a better solution? Here is the log with the exception: 21:32:37.860 127.0.0.1:48933 admin OK Database 'stock_stock_work__DOM' was opened in 74.98 ms. 78.19 ms 21:32:37.865 127.0.0.1:48933 admin REQUEST SET BINDINGS 'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':db=stock_stock_work__DOM,'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':destination=/tmp/basex/82e63b48-978d-4498-97bc-e90c8a3cd357/stock_stock_work__DOM,'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':uuid=82e63b48-978d-4498-97bc-e90c8a3cd357 21:32:37.866 127.0.0.1:48933 admin OK BINDINGS: 'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':db=stock_stock_work__DOM,'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':destination=/tmp/basex/82e63b48-978d-4498-97bc-e90c8a3cd357/stock_stock_work__DOM,'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':uuid=82e63b48-978d-4498-97bc-e90c8a3cd357 6.11 ms 21:32:37.869 127.0.0.1:48933 admin REQUEST SET AUTOFLUSH FALSE 21:32:37.869 127.0.0.1:48933 admin OK AUTOFLUSH: OFF 1.36 ms 21:32:37.915 127.0.0.1:48933 admin OK QUERY[0] xquery version '3.0'; declare namespace uuid='b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13'; declare variable $uuid:db as xs:string external; declare variable $uuid:destination as xs:string external; let $step := ( 1 ) return db:add($uuid:db, $uuid:destination) 44.64 ms 21:32:38.208 127.0.0.1:48933 admin OK RESULTS[0] 291.49 ms 21:32:38.208 127.0.0.1:48933 admin OK INFO[0] 0.19 ms 21:32:38.249 127.0.0.1:48933 admin OK QUERY[1] xquery version '3.0'; declare namespace uuid='b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13'; declare variable $uuid:db as xs:string external; declare variable $uuid:uuid as xs:string external; let $step := ( 1 ) let $prefix := concat($uuid:uuid, '/') let $suffix := concat('.', $uuid:uuid, '.xml') let $new := distinct-values( for $i in db:list($uuid:db) let $n := data(db:open($uuid:db,$i)/*/@n) where ends-with($i,$suffix) return $n ) for $i in db:list($uuid:db) let $old := concat($prefix, $i) where (index-of($new, data(db:open($uuid:db, $i)/*/@n))) and not(ends-with($i,$suffix)) return db:rename($uuid:db, $i, $old) 42.09 ms 21:32:38.359 127.0.0.1:48933 admin OK RESULTS[1] 108.12 ms 21:32:38.360 127.0.0.1:48933 admin OK INFO[1] 0.2 ms 21:32:38.400 127.0.0.1:48933 admin OK QUERY[2] xquery version '3.0'; declare namespace uuid='b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13'; declare variable $uuid:db as xs:string external; declare variable $uuid:uuid as xs:string external; let $prefix := concat($uuid:uuid, '/') return db:delete($uuid:db,$prefix) 40.65 ms 21:32:38.444 127.0.0.1:48933 admin OK RESULTS[2] 43.14 ms 21:32:38.484 127.0.0.1:48933 admin OK INFO[2] 39.64 ms 21:32:38.525 127.0.0.1:48933 admin OK QUERY[3] xquery version '3.0'; declare namespace uuid='b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13'; declare variable $uuid:db as xs:string external; declare variable $uuid:uuid as xs:string external; let $suffix := concat('.', $uuid:uuid, '.xml') for $i in db:list($uuid:db) let $new := substring-before($i,$suffix) where ends-with($i,$suffix) return db:rename($uuid:db, $i, $new) 41.45 ms 21:32:38.576 127.0.0.1:48933 admin OK RESULTS[3] 49.48 ms 21:32:38.616 127.0.0.1:48933 admin OK INFO[3] 39.85 ms 21:32:38.657 127.0.0.1:48933 admin OK QUERY[4] xquery version '3.0'; declare namespace uuid='b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13'; declare option db:queryinfo 'true'; declare variable $uuid:db as xs:string external; declare variable $uuid:uuid as xs:string external; let $step := ( 1 ) return db:optimize($uuid:db, true()) 41.18 ms 21:32:38.727 127.0.0.1:48933 admin REQUEST RESULTS[4] 21:32:38.727 127.0.0.1:48933 admin ERROR Stopped at ., 8/20: [FOUP0002] Database 'stock_stock_work__DOM' is currently opened by another process. 69.73 ms 21:32:38.731 127.0.0.1:48933 admin REQUEST EXIT 21:32:38.739 127.0.0.1:48933 admin OK 8.69 ms And yet another question: Is it possible to store the backup-files (CREATE BACKUP) in another location than the database-directory (e.g. backup-directory)? Thank's in advance for help Thomas

2 1

Inserts into root nodes within if statements
by Marcel Hanser 15 Aug '13

15 Aug '13

Hi there, i'm confused about following behavior. Consider the query: "insert node <c/> into /" it evaluates perfectly if a DB is opened within the BaseX Gui (7.7). But if i put it into an if statement like: "if(true())then insert node <c/> into / else()" i got the error message that the if statement is not complete. Adding a dot behind the slash solves the problem. "if(true())then insert node <c/> into /. else()" Is there a specific reason behind that? Regards and thanks in advanced, Marcel

3 3

Disable locking capability of BaseX
by Marcel Hanser 15 Aug '13

15 Aug '13

Hi there, is there the possibility to disable the locking of databases in BaseX? I would like to see changes performed concurrently from another process on my database on the fly using the GUI for debugging issues. Best Regards, Marcel

2 2

Re: [basex-talk] Partnering with basex.org for software monetization
by Victor Vlad 15 Aug '13

15 Aug '13

RE: Partnering with basex.org for software monetization Hi, I just wanted to make sure you got my email below. I look forward to hearing from you. Best, Victor http://click.m.conduit.com/?qs=bf1055b1294b1ee92114349482724b073184d9aa794d… Victor Vlad mailto:victorv@conduit.com victorv(a)conduit.com Team Leader, Qualification Management | Global Business p. +972.8.946.1713 ext. +771 | w. http://click.m.conduit.com/?qs=bf1055b1294b1ee92114349482724b073184d9aa794d… www.conduit.com From: Victor Vlad mailto:victor@conduit.com [mailto:victor@conduit.com] To: basex-talk(a)mailman.uni-konstanz.de Subject: Partnering with basex.org for software monetization Hi, My name is Victor Vlad and I'm part of the Business Development team at Conduit. I'm contacting you to discuss possible partnership between Conduit and basex.org. Conduit offers a free software monetization platform, including browser extensions, a download manager, and more. Our platform has already been adopted by thousands of software publishers like you, including http://click.m.conduit.com/?qs=bf1055b1294b1ee967ee0181521467c91a7ba0b732da… Brothersoft.com , http://click.m.conduit.com/?qs=bf1055b1294b1ee955937ae86dbc6bd28a48df7d3445… 4shared.com , and many others. Conduit's tools are 100% Google-compliant, and certified by eTrust and MacAfee. Our platform is fully customizable to your target audience, market, and brand. And we offer free support and service. I'd like to discuss our possible partnership via phone or Skype at your earliest convenience. When would be the best time for you to speak? Best, Victor http://click.m.conduit.com/?qs=bf1055b1294b1ee92114349482724b073184d9aa794d… Victor Vlad mailto:victorv@conduit.com victorv(a)conduit.com Team Leader, Qualification Management | Global Business p. +972.8.946.1713 ext. +771|w. http://click.m.conduit.com/?qs=bf1055b1294b1ee92114349482724b073184d9aa794d… www.conduit.com This message may contain confidential and/or privileged information. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any uses, copy, disclose or distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please notify the sender by reply email or by telephone and delete or destroy any copy of this message. Thank you. (c)2013 Conduit.com. All rights reserved. 950 Tower Lane, Suite 1788, Foster City, CA, 94404 If you can't see my email below, click http://click.m.conduit.com/?qs=bf1055b1294b1ee9c0f74d0e66ef2a2ef018d2b36876… here to view it on the web.

1 0

We have to talk....
by Dong-Mei Feng 14 Aug '13

14 Aug '13

- This mail is in HTML. Some elements may be ommited in plain text. - Hello, We have to finish this. Mei

1 0