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

Proposition. Execution feedback
by Alexander Shpack 15 Apr '13

15 Apr '13

Hi! It would be perfect to take execution feedback from GUI or server. Execution plan: N nodes Processed: K nodes It may help in script optimization and understanding complexity of xQuery task -- s0rr0w

2 1

Use xquery:eval in insert statement
by Lauener Jonas 15 Apr '13

15 Apr '13

I want to use xquery:eval in an insert statement: declare updating function local:insert($document as xs:string, $input as element()) { insert node $input after xquery:eval(fn:concat($document, '//', node-name($input), '[last()]')) }; let $input := <Customer CustomerID="IZZTT"><CompanyName>App</CompanyName><ContactName>Steve Jobs</ContactName><ContactTitle>CEO in Heaven</ContactTitle><Phone>(777) 7777777777</Phone><FullAddress><Address>Apple Road 3</Address><City>Cuppertino</City><Region>OR</Region><PostalCode>00000</PostalCode><Country>Heaven</Country></FullAddress></Customer> return local:insert("doc('CustomersOrders.xml')", $input) On the BaseX GUI it works fine, but if I want to use it with the Java Client, it fails. I use this code in Java: public final class InsertExample { /** Hidden default constructor. */ private InsertExample() {} /** Session reference. */ static ClientSession session; /** * Main method. * @param args command-line arguments */ public static void main(final String[] args) { try { // Create a client session with host name, port, user name and password session = new ClientSession("localhost", 1984, "admin", "admin"); String command = "declare updating function local:insert($document as xs:string, $input as element()) {\n insert node $input after xquery:eval(fn:concat($document, '//', node-name($input), '[last()]'))\n};\n\nlet $input := <Customer CustomerID=\"IZZTT\"><CompanyName>App</CompanyName><ContactName>Steve Jobs</ContactName><ContactTitle>CEO in Heaven</ContactTitle><Phone>(777) 7777777777</Phone><FullAddress><Address>Apple Road 3</Address><City>Cuppertino</City><Region>OR</Region><PostalCode>00000</PostalCode><Country>Heaven</Country></FullAddress></Customer>\n\nreturn local:insert(\"doc('CustomersOrders')\", $input)"; System.out.println(command); XQuery xquery = new XQuery(command); System.out.println(session.execute(xquery)); // close session session.close(); } catch(IOException e) { e.printStackTrace(); } } } When I run it, I get this exception: Version: BaseX 7.6 Java: Oracle Corporation, 1.7.0_11 OS: Windows 8, amd64 Stack Trace: java.lang.RuntimeException: Exclusive lock could not be acquired. org.basex.util.Util.notexpected(Util.java:53) org.basex.io.random.TableDiskAccess.lock(TableDiskAccess.java:151) org.basex.data.DiskData.startUpdate(DiskData.java:202) org.basex.query.up.DatabaseUpdates.startUpdate(DatabaseUpdates.java:158) org.basex.query.up.ContextModifier.apply(ContextModifier.java:86) org.basex.query.up.Updates.apply(Updates.java:120) org.basex.query.QueryContext.update(QueryContext.java:270) org.basex.query.QueryContext.value(QueryContext.java:255) org.basex.query.QueryContext.iter(QueryContext.java:240) org.basex.query.QueryProcessor.iter(QueryProcessor.java:76) org.basex.core.cmd.AQuery.query(AQuery.java:84) org.basex.core.cmd.XQuery.run(XQuery.java:22) org.basex.core.Command.run(Command.java:342) org.basex.core.Command.exec(Command.java:321) org.basex.core.Command.execute(Command.java:78) org.basex.server.ClientListener.run(ClientListener.java:145) at org.basex.server.ClientSession.receive(ClientSession.java:259) at org.basex.server.ClientSession.execute(ClientSession.java:162) at org.basex.server.ClientSession.execute(ClientSession.java:167) at org.basex.server.Session.execute(Session.java:37) at org.basex.examples.api.InsertExample.main(InsertExample.java:42) Is this a bug in BaseX? Or how can I solve this issue? Thanks, Jonas

2 2

NegativeArraySizeException
by Francis Avila 14 Apr '13

14 Apr '13

Received the following stack trace after running a .bxs script using basexclient from the command line: Version: BaseX 7.6 Java: Sun Microsystems Inc., 1.6.0_27 OS: Linux, amd64 Stack Trace: java.lang.NegativeArraySizeException org.basex.io.random.TableDiskAccess.insert(TableDiskAccess.java:390) org.basex.data.Data.insert(Data.java:931) org.basex.data.Data.insert(Data.java:820) org.basex.data.atomic.Insert.apply(Insert.java:31) org.basex.data.atomic.AtomicUpdateList.applyStructuralUpdates(AtomicUpdateList.java:297) org.basex.data.atomic.AtomicUpdateList.execute(AtomicUpdateList.java:285) org.basex.query.up.DatabaseUpdates.apply(DatabaseUpdates.java:183) org.basex.query.up.ContextModifier.apply(ContextModifier.java:90) org.basex.query.up.Updates.apply(Updates.java:120) org.basex.query.QueryContext.update(QueryContext.java:270) org.basex.query.QueryContext.value(QueryContext.java:255) org.basex.query.QueryContext.iter(QueryContext.java:240) org.basex.query.QueryProcessor.iter(QueryProcessor.java:76) org.basex.core.cmd.AQuery.query(AQuery.java:84) org.basex.core.cmd.XQuery.run(XQuery.java:22) org.basex.core.Command.run(Command.java:342) org.basex.core.Command.exec(Command.java:321) org.basex.core.Command.execute(Command.java:78) org.basex.server.ClientListener.run(ClientListener.java:145) What the script does is very complex (large xquery functions, db:node-pre() indexing and lookups, etc) so if you need it to isolate this issue we can discuss directly. However I get a similar stack trace when I attempt to OPTIMIZE ALL: > open deepbills Database 'deepbills' was opened in 114.99 ms. > optimize all Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.6 Java: Sun Microsystems Inc., 1.6.0_27 OS: Linux, amd64 Stack Trace: java.lang.ArrayIndexOutOfBoundsException: 65 org.basex.util.Compress.pull(Compress.java:156) org.basex.util.Compress.unpack(Compress.java:112) org.basex.data.DiskData.txt(DiskData.java:268) org.basex.data.DiskData.text(DiskData.java:235) org.basex.io.serial.Serializer.node(Serializer.java:343) org.basex.io.serial.Serializer.serialize(Serializer.java:99) org.basex.core.cmd.OptimizeAll$DBParser.parse(OptimizeAll.java:199) org.basex.build.Builder.parse(Builder.java:73) org.basex.build.DiskBuilder.build(DiskBuilder.java:90) org.basex.core.cmd.OptimizeAll.optimizeAll(OptimizeAll.java:124) org.basex.core.cmd.OptimizeAll.run(OptimizeAll.java:44) org.basex.core.Command.run(Command.java:342) org.basex.core.Command.exec(Command.java:321) org.basex.core.Command.execute(Command.java:78) org.basex.server.ClientListener.run(ClientListener.java:145) > info database Database Properties Name: deepbills Size: 901 MB Nodes: 25598080 Documents: 15528 Binaries: 0 Timestamp: 2013-04-08-15-02-07 Resource Properties Timestamp: 2013-04-08-15-02-07 Encoding: UTF-8 Whitespace Chopping: ON Indexes Up-to-date: false Text Index: OFF Attribute Index: OFF Full-Text Index: OFF UPDINDEX: OFF MAXCATS: 100 MAXLEN: 96 If I restore from a backup (taken after this issue appeared), I still can't "optimize all", but the stack trace appears truncated: > restore deepbills 'deepbills-2013-04-08-15-54-32.zip' was restored in 40918.34 ms. > optimize all No database opened. > open deepbills Database 'deepbills' was opened in 136.22 ms. > optimize all Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.6 Java: Sun Microsystems Inc., 1.6.0_27 OS: Linux, amd64 Stack Trace: java.lang.ArrayIndexOutOfBoundsException > If I restore a backup that is just a little bit older (a little over an hour), it seems fine: > restore deepbills-2013-04-08-14-22-22 'deepbills-2013-04-08-14-22-22.zip' was restored in 38982.91 ms. > optimize all Database 'deepbills' was optimized in 129658.46 ms. So I have two similar databases, one 363MB zip, one 372MB zip, one of which is fine and the other which seems to encounter this problem. Could I be looking at database corruption here? If so, how to fix? -- Francis Avila Senior Developer Dancing Mammoth, Inc. (Formerly PJ Doland Web Design, Inc.) P: 703.621.0990 E: favila(a)dancingmammoth.com http://dancingmammoth.com

3 5

Re: [basex-talk] Tokenize..
by Christian Grün 14 Apr '13

14 Apr '13

> With "Info Node", I mean that I want to have tokens for a specific node. !! Got it. You’ll have to retrieve the text of this node and call ft:tokenize(). An example: for $x in //text() return ft:tokenize($x) Please note that the tokenize function won’t aggregate the tokens. You could try the following XQuery code to get a similar output (note that this particular example only works with 7.7, which includes support for general FLWOR expressions): let $text := 'a b a' for $words in ft:tokenize($text) group by $w := $words let $count := count($words) order by $count descending return <entry count="{ $count }">{ $w }</entry> _____________________________________________ > On Sun, Apr 14, 2013 at 2:56 AM, Christian Grün <christian.gruen(a)gmail.com> > wrote: >> >> Hi John, >> >> to give you a somewhat satisfying answer, I’m afraid I need more details. >> >> > I want to create tokens, so I will be using ft:tokens('Docs'). >> > This will create tokens for all the available nodes. >> > I want to create tokens for the Info Node only... How to ,,? >> >> The result of ft:tokens() will contain all tokens that are stored in >> the full-text index of the addressed database. At this point I’m >> stuck, because I can’t guess what you mean with "Info Node"? >> >> Best, >> Christian > > > > > -- > Have a nice day > JBest > >

1 0

Tokenize..
by John Best 13 Apr '13

13 Apr '13

Hi there, The structure of my XML DB (Docs) is - <Docs> <Doc> <Info></Info> <Desc></Desc> </Doc> </Docs> I want to create tokens, so I will be using ft:tokens('Docs'). This will create tokens for all the available nodes. I want to create tokens for the Info Node only... How to ,,? -- Have a nice day JBest

2 1

Multiple queries in client API
by Michael CLEMENT 13 Apr '13

13 Apr '13

Hello, I am building a Django application using BaseX as its database, using a custom model layer with the Python API. Currently, I am using a single Session instance to connect to the BaseX server, but I am facing problems when multiple queries are sent at the same time. I didn't check how the client API works in details, but is it made in such a way that only one query at a time can be sent? Should I use a new Session instance for every single query sent to the server? Thanks in advance. Regards, Michael Clement

3 4

Proposition for the GUI features
by Alexander Shpack 13 Apr '13

13 Apr '13

Hi everyone! I have a nice idea, how to stop to crack the database, when user use GUI and server simultaneously. When GUI will found launched server, every updating functions should be executed through port, not directly. User may setup different connections (require list of connections), select the default connection, and choose method of connection: direct access or via saved one Sorry for my bad English. Alexander

2 1

Re: [basex-talk] Unable to use Query class
by Christian Grün 13 Apr '13

13 Apr '13

Hi Anantha, sorry for the delay. It looks as if the current version of the PHP client API provides no implementation for more() and next() functions, so you should probably call execute() instead. Maybe there are volunteers out there who are interested in complementing the PHP code? Best, Christian ___________________________ On Fri, Apr 12, 2013 at 10:30 AM, Anantha tejas <ananthatejas(a)gmail.com> wrote: > <?php > /* > * This example shows how results from a query can be received in an > iterative > * mode and illustrated in a table. > * > * (C) BaseX Team 2005-12, BSD License > */ > include("basexclient.php"); > > // commands to be performed > $cmd = '//mondial/country[@id="f0_136"]/name/text()'; > $cmd2 = '//mondial/country[@id="f0_136"]/city[@id="f0_1461"]/name/text()=="" > or 1=1'; > > try { > // create session > $session = new Session("localhost", 1984, "admin", "admin"); > > echo "<table border='0' cellspacing='2' cellpadding='4' > width='20%'><tbody><tr style='text-align:center;'>"; > echo "<td style='text-align:center;background-color:#D7D7D7;border:#ffffff > 1px solid;font-size:12pt;'></td>"; > echo "<td style='text-align:center;background-color:#D7D7D7;border:#ffffff > 1px solid;font-size:12pt;'>Country</td>"; > echo "<td style='text-align:center;background-color:#D7D7D7;border:#ffffff > 1px solid;font-size:12pt;'>Population</td>"; > try { > $query = $session->query($cmd); > $query2 = $session->query($cmd2); > $count = 0; > --------------->while($query->more()) { > $next = $query->next(); > $query2->more(); > $next2 = $query2->next(); > $count += 1; > if($count%2) { > echo "<tr style='text-align:center;'> > <td style='text-align:center;'>$count</td><td > style='text-align:center;'>$next</td> > <td style='text-align:center;'>$next2</td></tr>"; > } else { > echo "<tr style='text-align:center; background-color:#eeeeee;'> > <td style='text-align:center;'>$count</td><td > style='text-align:center;'>$next</td> > <td style='text-align:center;'>$next2</td></tr>"; > } > } > $query->close(); > $query2->close(); > } catch (Exception $e) { > // print exception > print $e->getMessage(); > } > echo "</tbody></table>"; > $query->close(); > // close session > $session->close(); > > } catch (Exception $e) { > // print exception > print $e->getMessage(); > } > ?> > > > > > > > > I have pasted the whole code I am using. As I have highlighted the > $query->more() function is being said to be undefined. > > > > > > > > > > > > On Fri, Apr 12, 2013 at 1:57 PM, Christian Grün <christian.gruen(a)gmail.com> > wrote: >> >> Could you provide me with a small PHP example code? >> ___________________________ >> >> On Fri, Apr 12, 2013 at 10:25 AM, Anantha tejas <ananthatejas(a)gmail.com> >> wrote: >> > In the documentation provided it just says the inner class Query is >> > being >> > used but where do I get it and how do I use it ? >> > >> > >> > On Fri, Apr 12, 2013 at 1:54 PM, Anantha tejas <ananthatejas(a)gmail.com> >> > wrote: >> >> >> >> Hi Christian, >> >> >> >> Yes. I was using the BaseXClient.php functions provided to query BaseX >> >> databases using PHP. There is a class defined called Query but the >> >> inner >> >> functions provided are not working. These are with respect to the >> >> examples >> >> provided for using BaseX with PHP. >> >> >> >> >> >> On Fri, Apr 12, 2013 at 1:51 PM, Christian Grün >> >> <christian.gruen(a)gmail.com> wrote: >> >>> >> >>> Dear Anantha, >> >>> >> >>> thanks for your mail. I guess we need more precise information to help >> >>> you. A Google search for your error string seems to indicate you are >> >>> using the PHP client? >> >>> >> >>> Christian >> >>> ___________________________ >> >>> >> >>> > Fatal error: Call to undefined method Query::more() >> >>> > >> >>> > Where do I get the inner class Query and its functions ? >> >>> > >> >>> > >> >>> > Regards, >> >>> > Ananthatejas Raghavan >> >>> > Final Year, Computer Engineering >> >>> > NITK Surathkal >> >>> > Contact : 9480114601 >> >>> > >> >>> > _______________________________________________ >> >>> > BaseX-Talk mailing list >> >>> > BaseX-Talk(a)mailman.uni-konstanz.de >> >>> > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >> >>> > >> >> >> >> >> >> >> >> >> >> -- >> >> Regards, >> >> Ananthatejas Raghavan >> >> Final Year, Computer Engineering >> >> NITK Surathkal >> >> Contact : 9480114601 >> > >> > >> > >> > >> > -- >> > Regards, >> > Ananthatejas Raghavan >> > Final Year, Computer Engineering >> > NITK Surathkal >> > Contact : 9480114601 > > > > > -- > Regards, > Ananthatejas Raghavan > Final Year, Computer Engineering > NITK Surathkal > Contact : 9480114601

1 0

whitespace around comments
by jidanni＠jidanni.org 13 Apr '13

13 Apr '13

Pardon me but basex 7.6 doc() function is out of control. $ more ib.xml z.xq|cat :::::::::::::: ib.xml :::::::::::::: <Z> There should be a space:  :here! There should be a space: :here! There should be a space: :here! There should be a space:  :here! There should be a space:  :here! There should be a space:  :here! There should be a space:   :here! There should be NO SPACE::here! There should be NO SPACE:::here! </Z> :::::::::::::: z.xq :::::::::::::: doc("ib.xml") $ basex z.xq <Z> There should be a space::here! There should be a space::here! There should be a space::here! There should be a space::here! There should be a space::here! There should be a space::here! There should be a space: :here! There should be NO SPACE: :here! There should be NO SPACE:::here! </Z>$ basex z.xq|w3m -dump -T text/html There should be a space::here! There should be a space::here! There should be a space::here! There should be a space::here! There should be a space::here! There should be a space::here! There should be a space: :here! There should be NO SPACE: :here! There should be NO SPACE:::here! So it failed all but two. The problem seems to lie in the doc() function. In fact if you just left what you found intact, you wouldn't wreck people's formatting too. You don't wreck things when processing let $k := <coordinates> 120.867029,24.167269,10  120.866931,24.167630,10  120.866832,24.167901,10  </coordinates> then why not do the same with doc()?

7 19

Pathname of the current XQuery?
by Graydon Saunders 12 Apr '13

12 Apr '13

I have the awful feeling that I'm missing something really obvious, but I want to be able to get the pathname of the current query, and I can't figure out how. The use case is that the query validates documents in the collection differently, based on the document element, and I want to refer to the different schema files (which sit, on the file system, right next to the file with the query in it) in a machine-independent way. So instead of let $decisionSchema := '/home/graydon/workspace/Content Standards/schemas/decisions_schema.xsd' I'd like to be able to say something like let $decisionSchema := concat(string-join(tokenize(get-query-path(),'/')[position() ne last()],'/'),'/decisions_schema.xsd') only I can't figure out what get-query-path() is. Thanks! Graydon

4 4