I'm using BaseXGUI to develop xqueries. The xqueries transform some data from the database into XML that will be rendered as a table. Will the table visualization view in BasexGUI work this way? My xqueries look something like this:
let $dbName := "foo" return <table> <columns> <column>Name</column> <column>Child name</column> </columns> <rows> { for $item in doc($dbname)/some/xpath return <row> <cell>{$item/name/text()}</cell> <cell>{$item/child/name/text()}</cell> </row> } </rows> </table>
The text view of the results look like I expect it to, and using the xqueries inside the application I'm developing works once I get them written and debugged. I'd like to preview the tables inside BaseXGUI if possible, before returning to the IDE and having to run the application, if possible. Thanks for any guidance.
Hello Rob,
I doubt that this is possible. The Table View (as the TreeView) displays the data in the currently opened database. The table view then marks nodes if they are within the result set of your XPath.
It is made for and therefore can not interpret your XQuery and the specific result there. In fact, the table view is the same as the TreeView, just in a tabular fashion. And it is also not possible in the TreeView to render arbitrary data. It really is just a tool to look at your documents in the database.
Cheers, Dirk
On Thu, Aug 16, 2012 at 12:02 AM, Rob Heiser rheiser@gmail.com wrote:
I'm using BaseXGUI to develop xqueries. The xqueries transform some data from the database into XML that will be rendered as a table. Will the table visualization view in BasexGUI work this way? My xqueries look something like this:
let $dbName := "foo" return <table> <columns> <column>Name</column> <column>Child name</column> </columns> <rows> { for $item in doc($dbname)/some/xpath return <row> <cell>{$item/name/text()}</cell> <cell>{$item/child/name/text()}</cell> </row> } </rows> </table>
The text view of the results look like I expect it to, and using the xqueries inside the application I'm developing works once I get them written and debugged. I'd like to preview the tables inside BaseXGUI if possible, before returning to the IDE and having to run the application, if possible. Thanks for any guidance.
-- Rob _______________________________________________ BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
Hi Rob,
this might be a little detour, but still worth a try: By using RestXQ [1] you could transform your data to an HTML table and display it in any browser. E.g. like so: https://gist.github.com/45cdb78b093fc3d91cac The htmlize() function will simply rename your elements to math their html counterparts.
You may then call this function from whithin RestXQ and see the results in any browser :)
Kind regards Michael
[1] http://docs.basex.org/wiki/RESTXQ Am 16.08.2012 um 00:02 schrieb Rob Heiser rheiser@gmail.com:
I'm using BaseXGUI to develop xqueries. The xqueries transform some data from the database into XML that will be rendered as a table. Will the table visualization view in BasexGUI work this way? My xqueries look something like this:
let $dbName := "foo" return <table> <columns> <column>Name</column> <column>Child name</column> </columns> <rows> { for $item in doc($dbname)/some/xpath return <row> <cell>{$item/name/text()}</cell> <cell>{$item/child/name/text()}</cell> </row> } </rows> </table>
The text view of the results look like I expect it to, and using the xqueries inside the application I'm developing works once I get them written and debugged. I'd like to preview the tables inside BaseXGUI if possible, before returning to the IDE and having to run the application, if possible. Thanks for any guidance.
-- Rob _______________________________________________ BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
Hi Rob,
one more cute workaround is the following one:
1) create an empty database and open it in the gui 2) write your query and store the result to this database
An example query is attached below (it requires the creation of a "visdb" database).
Hope this helps, Christian ___________________________
(: replaces database contents with new result :) declare %updating function local:visualize($result) { db:replace('visdb', 'visdb', document { $result }) };
local:visualize( (: open database let $db := doc("foo") :) (: alternative: main-memory fragment to make it self-contained :) let $db := document { <some> <xpath> <name>bla</name> <child><name>blu</name></child> </xpath> </some> } return <table> <columns> <column>Name</column> <column>Child name</column> </columns> <rows> { for $item in $db/some/xpath return <row> <cell>{$item/name/text()}</cell> <cell>{$item/child/name/text()}</cell> </row> } </rows> </table> ) ___________________________
I'm using BaseXGUI to develop xqueries. The xqueries transform some data from the database into XML that will be rendered as a table. Will the table visualization view in BasexGUI work this way? My xqueries look something like this:
let $dbName := "foo" return <table> <columns> <column>Name</column> <column>Child name</column> </columns> <rows> { for $item in doc($dbname)/some/xpath return <row> <cell>{$item/name/text()}</cell> <cell>{$item/child/name/text()}</cell> </row> } </rows> </table>
The text view of the results look like I expect it to, and using the xqueries inside the application I'm developing works once I get them written and debugged. I'd like to preview the tables inside BaseXGUI if possible, before returning to the IDE and having to run the application, if possible. Thanks for any guidance.
-- Rob _______________________________________________ BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
Thanks for the help, guys. Inserting into a sandbox database sounds interesting, I may try that. Otherwise, it's not too painful to just create the xquery file in the application and re-run. During quick iterations even small time savings add up, so it was worth asking the question. Thanks, again.
basex-talk@mailman.uni-konstanz.de