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

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

File module path encodings
by Andy Bunce 12 Apr '13

12 Apr '13

Hi, The following two expressions create a file called "d d.txt" (Windows, BaseX 7.6) file:write("c:\temp\d d.txt","what") file:write("c:\temp\d%20d.txt","what") I wonder if it would not be better if the second would create a file "d%20d.txt"? My use case is creating a file name that encodes a path e.g. "lib%5Cfile.txt". The currently gives an error, as it is looking for a folder lib. I read http://expath.org/spec/file#d3e112 as meaning url encoded file names must start file:/// and if no file:/// the name should be used as is. /Andy

2 1

(no subject)
by John Best 12 Apr '13

12 Apr '13

Dear Team, Following is my query - for $x in db:fulltext('Doc', 'Molecular Biology')/ancestor::*:Doc return $x/ArticleNo This query will return all the ArticleNo having the words "Molecular Biology" The output of this query is like a PHRASE... where the phrase is "Molecular Biology" Now I want to list all the ArticleNo which might have word "Molecular" OR/AND "Biology" How can I get this using the above query... ?? -- Have a nice day JBest

2 1

Java Exception:insertion at beginning of populated table
by Nicholas OR Rita Stevens 12 Apr '13

12 Apr '13

Via a python client, I am looping through a set of 600 xml files and issuing REPLACE commands to store them in my BaseX db. All was well until I reached file #364, at which point the program crashed with Java.lang.RuntimeException: "insertion at beginning of populated table." I am using BaseX 7.7 beta. I guess I shouldn't be using beta?

2 1

Unable to use Query class
by Anantha tejas 12 Apr '13

12 Apr '13

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

2 1

Re: [basex-talk] How to get list as result instead of a String
by Alexander Holupirek 12 Apr '13

12 Apr '13

Hi Elango, you may have a look at [1], this might help you setting options? HTH, Alex [1] http://docs.basex.org/wiki/Options On 08.04.2013, at 09:07, elangovan MuthuSwamy <elangovan.h(a)gmail.com> wrote: > Thanks Alex, > > Where can I change the serialization parameters? > > I have set SERIALIZER property in .basex file, but I got the following error in server log. > > /.basex: "SERIALIZER" not found. > > Am I missing anything basically? > > Regards, > Elango. > > > On Fri, Apr 5, 2013 at 12:43 PM, Alexander Holupirek <alexander.holupirek(a)uni-konstanz.de> wrote: > Hi Elango, > > changing the serialization parameters, here: output:separator option, [1] could do the trick. > > declare option output:separator "\n"; > > let $s := > <interfaces> > <interface> > <name>intf0</name> > </interface> > <interface> > <name>intf1</name> > </interface> > <interface> > <name>intf2</name> > </interface> > <interface> > <name>intf3</name> > </interface> > </interfaces> > return > $s/interface/name/text() > > ==> > > intf0 > intf1 > intf2 > intf3 > > Hope this helps, > Alex > > [1] http://docs.basex.org/wiki/Serialization > > On 04.04.2013, at 11:47, elangovan MuthuSwamy <elangovan.h(a)gmail.com> wrote: > >> Hi All, >> >> I am using XQuery to evaluate an xpath. My code is as follows, >> >> /*Example xml I am using >> <interface> >> <name>intf0</name> >> </interface> >> <interface> >> <name>intf1</name> >> </interface> >> <interface> >> <name>intf2</name> >> </interface> >> <interface> >> <name>intf3</name> >> </interface> >> */ >> XQuery query = new XQuery("/interfaces/interface/name/text()"); >> String str = query.execute(ctx); >> >> // Result string is - intf0intf1intf2intf3 >> >> I want the result such as >> intf0 >> intf1 >> intf2 >> intf3 >> >> I could not get the result list and I could not differentiate whether the result has multiple values or a single value. >> >> Please advice me if there is any other way to identify the result list. >> >> Thanks in Advance. >> >> -- >> Regards, >> Elango.

3 2

Letting users WRITE comments, but not READ them.
by France Baril 10 Apr '13

10 Apr '13

Hi, I am trying to secure access to some of our content. Case: 1. User reads our content and completes the feedback form. 2. A file is saved in our "Feedback" database for each form that is submitted. Security: - Let anonymous users WRITE to the DB using the web form - Do not allow unauthenticated users to READ comments. Solution so far to avoid making user/password known: 1. Save feedback in an unsecured DB. 2. Redirect to function that moves the feedback file to a secured DB. Issue: - Security seems to limit access to files when they are addressed as db:open(DB, path). - All functions that grab data, crunch the data and display it in an HTML table seem to remain available to everyone. Questions: - Instead of securing the DB, we were thinking of securing the functions: Open access to 'submit-comment' for all users, require authentication for all other functions. Is this possible, if so can you point me to useful documentation? - Do you have any other suggestion? -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 2

quick dereferencing of elements found earlier
by C. M. Sperberg-McQueen 06 Apr '13

06 Apr '13

I'm experimenting with the construction of secondary documents which contain information about my primary documents. I won't go into details, but it would not be too far off to think of them as user-created indices -- my goal is to pre-calculate some information I expect to want often in queries, to see if using such secondary documents produces faster responses than running the original queries on the original documents. It would be handy to be able to point from my secondary documents to specific nodes (in my case, always elements, at least at the moment) of the primary documents. The same desire arises when I try to build text search interfaces that return hits with a small amount of context; I want to be able to provide links that point to an appropriate ancestor element, so the user can see more context if desired. One way to handle this desire would be to take the base URI of the node, and the path from the root to the element and point to elements using XPointer element() expressions of the form collection/docname.xml#element(1/2/4/1/1) (A function for fast resolution of XPointer element() expressions would be a nice thing to have, by the way.) In some XQuery implementations, I believe there are functions which return some sort of internal identifier for element nodes, and other functions which take that identifier as an argument and quickly return that node. (Or perhaps I am just remembering a facility from the first SGML database I used intensively.) Such functions, if they exist, seem likely to be faster than resolution of element() expressions. Is there anything like that in BaseX? Thanks! -- **************************************************************** * C. M. Sperberg-McQueen, Black Mesa Technologies LLC * http://www.blackmesatech.com * http://cmsmcq.com/mib * http://balisage.net ****************************************************************

2 1