BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

Re: [basex-talk] 3 steps
by Simon Knuijver 21 Nov '12

21 Nov '12

Hi Christian, I see but there you put the entire xslt in one place, Simon -----Original Message----- From: Christian Grün [mailto:christian.gruen@gmail.com] Sent: woensdag 21 november 2012 14:38 To: Simon Knuijver Cc: BaseX Subject: Re: [basex-talk] 3 steps >> The current way to do this is transform your request via XQuery and the XSLT module. We may add a parameter for XSLT transformations to our REST API [4]; details would first have to be specified, though. Yes, it can also be done in Java. The most compact solution I get in mind is: 1. Create a database X with your XML and XSLT file (called "example" in the following) 2. Go to your browser and visit http://localhost:8984/rest/X/example.xml?query=xslt:transform(.,db:open(.,'example.xslt'))" If we added an additional xslt parameter, the URL could look as follows: http://localhost:8984/rest/X/example.xml?xslt=example.xslt C.

2 1

Re: [basex-talk] 3 steps
by Simon Knuijver 21 Nov '12

21 Nov '12

Hi Christian, thanks for your swift reply. I'll get on it right away and I would be interested in that extra parameter :) To dumb this one down a little: >> 3. Connect to that database and query for the templates within another >> XSL file? You said: > The current way to do this is transform your request via XQuery and the XSLT module. We may add a parameter for XSLT transformations to our REST API [4]; details would first have to be specified, though. What would that look like, something like this (in Java)?: package org.basex.examples.rest; import java.io.*; import java.net.*; import org.basex.*; /** * This class is a simple example to demonstrate applying stored templates from the REST API. * * @author BaseX Mailing list, BSD License */ public final class RESTGet { /** * Runs the example. * @throws IOException I/O exception */ static void run() throws IOException { System.out.println("=== GET: execute a query ==="); // The java URL connection to the resource String base = "http://localhost:8984/rest/"; URL url = new URL(base + "templates?query=(//tag/styleVersion) "); System.out.println("\n* URL: " + url); // Establish the connection to the URL HttpURLConnection conn = (HttpURLConnection) url.openConnection(); // Print the HTTP response code int code = conn.getResponseCode(); System.out.println("\n* HTTP response: " + code + " (" + conn.getResponseMessage() + ')'); // Check if request was successful if(code == HttpURLConnection.HTTP_OK) { // Print the received result to standard output System.out.println("\n* Result:"); // Get and cache input as UTF-8 encoded stream BufferedReader br = new BufferedReader(new InputStreamReader( conn.getInputStream(), "UTF-8")); // Print all lines of the result for(String line; (line = br.readLine()) != null;) { System.out.println(line); } br.close(); } // Close connection conn.disconnect(); } /** * Main method. * @param args (ignored) command-line arguments * @throws Exception exception */ import javax.xml.transform.*; import javax.xml.transform.stream.StreamResult; import javax.xml.transform.stream.StreamSource; import java.io.File; import java.io.IOException; import java.net.URISyntaxException; public static void main(final String... args) throws Exception{//, IOException, URISyntaxException, TransformerException { // Start servers final BaseXHTTP http = new BaseXHTTP("-Uadmin", "-Padmin"); TransformerFactory factory = TransformerFactory.newInstance(); // Run example //run();//How does this call the RESTGET class? //for now (You may not want to do make RESTGET instance for every template, instead, it may be easier to ask for a set of templates at once and apply them as a stylesheet here) //For(tags) //Get template and add to stylesheet Source xslt = theBuiltStyleSheet; Transformer transformer = factory.newTransformer(xslt); Source text = new StreamSource(new File("input.xml")); transformer.transform(text, new StreamResult(new File("output.xml"))); // Stop servers http.stop(); } } Best, Simon

2 1

Re: [basex-talk] db:list via basexclients doesn't show all databases
by Andreas Weiler 21 Nov '12

21 Nov '12

The server creates an index of all existing databases on startup. Afterwards only by client created databases are added to that index. So all databases created by other processes (GUI, Console) are not in the index. Restart the server and you will see all databases. I guess the db:list() function uses that index and the db:list("dbname") function does not. -- Andreas Am 21.11.2012 um 13:01 schrieb Stefan Koch: > Strange thing is: Our application has access to the db. > ... found out that db:list('dbname') has access to the database, while db:list() can't see it. > > > > Am 21.11.2012 12:51, schrieb Andreas Weiler: >> uh same problem for me... >> >> steps to reproduce: >> >> 1. start server >> 2. start GUI and create db "test", close GUI >> 3. run list...DB "test" is not there, but can be accessed with open test >> >> I guess just client connections can add new databases to a running server instance. >> >> -- Andreas >> >> Am 21.11.2012 um 12:48 schrieb Stefan Koch: >> >>> ... the user has all privileges. I tried to added R/W Access via Grant (though basex standalone). >>> But the client still can't see it. >>> >>> Stefan >>> >>> >>> Am 21.11.2012 12:15, schrieb Andreas Weiler: >>>> Hi Stefan, >>>> >>>> does the user have permission to see all databases? >>>> >>>> Regards, >>>> Andreas >>>> >>>> Am 21.11.2012 um 12:21 schrieb Stefan Koch: >>>> >>>>> Hi, >>>>> >>>>> I was wondering why our backupskript isn't exporting all databases, one is missing. >>>>> The I found out why - our backuptool connects via Java and uses db:list to get the names of all databases. >>>>> >>>>> If I connect via basexclient - there is one missing, if I check via basex (from the shell) the database is shown. >>>>> I added the database also via basex and not like the others via the client. >>>>> >>>>> Is this intended behaviour? How can I tell the client, that there is one more database? >>>>> >>>>> Regards, >>>>> >>>>> Stefan >>>>> _______________________________________________ >>>>> BaseX-Talk mailing list >>>>> BaseX-Talk(a)mailman.uni-konstanz.de >>>>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >>>> _______________________________________________ >>>> BaseX-Talk mailing list >>>> BaseX-Talk(a)mailman.uni-konstanz.de >>>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >

2 1

Re: [basex-talk] db:list via basexclients doesn't show all databases
by Andreas Weiler 21 Nov '12

21 Nov '12

uh same problem for me... steps to reproduce: 1. start server 2. start GUI and create db "test", close GUI 3. run list...DB "test" is not there, but can be accessed with open test I guess just client connections can add new databases to a running server instance. -- Andreas Am 21.11.2012 um 12:48 schrieb Stefan Koch: > ... the user has all privileges. I tried to added R/W Access via Grant (though basex standalone). > But the client still can't see it. > > Stefan > > > Am 21.11.2012 12:15, schrieb Andreas Weiler: >> Hi Stefan, >> >> does the user have permission to see all databases? >> >> Regards, >> Andreas >> >> Am 21.11.2012 um 12:21 schrieb Stefan Koch: >> >>> Hi, >>> >>> I was wondering why our backupskript isn't exporting all databases, one is missing. >>> The I found out why - our backuptool connects via Java and uses db:list to get the names of all databases. >>> >>> If I connect via basexclient - there is one missing, if I check via basex (from the shell) the database is shown. >>> I added the database also via basex and not like the others via the client. >>> >>> Is this intended behaviour? How can I tell the client, that there is one more database? >>> >>> Regards, >>> >>> Stefan >>> _______________________________________________ >>> BaseX-Talk mailing list >>> BaseX-Talk(a)mailman.uni-konstanz.de >>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >> _______________________________________________ >> BaseX-Talk mailing list >> BaseX-Talk(a)mailman.uni-konstanz.de >> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >

1 0

db:list via basexclients doesn't show all databases
by Stefan Koch 21 Nov '12

21 Nov '12

Hi, I was wondering why our backupskript isn't exporting all databases, one is missing. The I found out why - our backuptool connects via Java and uses db:list to get the names of alle databases. If I connect via basexclient - there is one missing, if I check via basex (from the shell) the database is shown. I added the database also via basex and not like the others via the client. Is this intended behaviour? How can I tell the client, that there is one more database? Regards, Stefan

2 1

3 steps
by Simon Knuijver 20 Nov '12

20 Nov '12

Hi, I have an xsl or xml file containing xsl templates: <xsl:template match="compcd" name="tata"> <compcd> <xsl:value-of select="string(ns0:LOCATIONSPEC[ns0:ASSETATTRID='VS_TYPE']/ns0:ALNVALUE) "></xsl:value-of> </compcd> </xsl:template> <xsl:template match="compcd" name="dada"> <equipnum> <xsl:value-of select="string(ns0:FXSTAMDATASet/ns0:LOCATIONS/ns0:FXCOMPANYNAME)"></xsl :value-of> </equipnum> </xsl:template> : Etc I have a noob question about this, in three quick steps, how do I: 1. Add these templates to a database 2. Put that db in a webservice/server 3. Connect to that database and query for the templates within another XSL file? Pointers to the proper manual would be fine, thanks! Best, Simon

2 1

slow query
by Mahlow Cerstin 20 Nov '12

20 Nov '12

Hi, I have a problem with slow queries. I'm not sure if it is due to the construction of the query or if there is something else going on. I'm querying two databases: "collect" which is opened at the beginning and contains several thousands entries like these two: <entry time="2012-05-22T11:27:09"> <node>40177618</node> <query>[text() contains text ('den' ftand 'Hals' ftand 'brachen') distance at most 10 words]</query> <person>britta</person> <phraseme>Ad0194</phraseme> <selected>yes</selected> </entry> <entry time="2012-05-22T11:27:09"> <node>40672561</node> <query>[text() contains text ('den' ftand 'Hals' ftand 'brachen') distance at most 10 words]</query> <person>britta</person> <phraseme>Ad0194</phraseme> <selected>no</selected> </entry> The node-ids refer to a second database: "TG-DTA-GerManC-stemming-ws". The queries contain the xquery the node was found with. For a particular phraseme, I display the original node using ft:mark to highlight the query terms. Additionally, I display some of the metadata for this node. The user will be able to "delete" some of the entries -- i.e., setting the value of "selected" from "yes" to "no". Therefore I render everything as a form element with a checkbox. The query is this one: for $i at $p in //entry[phraseme[text() = "Ad0194"] and selected[text() = "yes"]] let $query := $i/query let $node := $i/node let $prefix := fn:in-scope-prefixes($i) let $title := db:open-id('TG-DTA-GerManC-stemming-ws', $node) /ancestor::*:TEI[1]//*:fileDesc[1]//*:titleStmt[1]//*:title[1] let $author := db:open-id('TG-DTA-GerManC-stemming-ws', $node) /ancestor::*:TEI[1]//*:sourceDesc[1]//*:bibl[1]//*:author[1] let $note := db:open-id('TG-DTA-GerManC-stemming-ws', $node) /ancestor::*:TEI[1]//*:notesStmt//*:note let $expr := concat("ft:mark(db:open-id('TG-DTA-GerManC-stemming-ws', ", $node, ") ", $query, ")") let $time := data($i/@time) return <div> <hit count="{ $p}"> <input type="checkbox" name="NODE" value="{$node}"/> {$p} ({ if($prefix = "dta") then "DTA" else "TG"})Knoten: {$i/node} {xquery:eval($expr)} </hit> <bib> {$time} Bibliographie { data($author)}: { data($title)} Anmerkung: { data ($note) } Korpus: { if($prefix = "dta") then "Deutsches Textarchiv" else "TextGrid Digitale Bibliothek"} </bib> </div> However, for this particular phraseme ("Ad0194"), there will be 676 hits to be displayed (out of around 1000 stored) which takes around 15 seconds in the GUI. In the actual web application, the full site is shown after more than 20 seconds (there is some HTML to be displayed and another short xquery for displaying distinct queries for all entries in question), which is too slow, I think. Is there anything I can do to speed up the query? Can I somehow rewrite it to make execution faster? I think opening the second DB four times costs a lot of time. Both DBs have an optimized index already. Thanks in advance Cerstin -- Dr. phil. Cerstin Mahlow Universität Basel Deutsches Seminar Nadelberg 4 4051 Basel Schweiz Tel: +41 61 267 07 65 Fax: +41 61 267 34 40 Mail: cerstin.mahlow(a)unibas.ch Web: http://www.oldphras.net

3 6

RESTXQ: What to use for page layout / view templating?
by Daniel Kvasnička 19 Nov '12

19 Nov '12

Hi folks, another thing I'm trying to solve while working on a XQuery web app. What kind of templating system do you use to separate HTML templates from the rest of your code? - XSLT - the only problem I have with this is performance. I tested the XSLT Module with Saxon 9 and a primitive page and it was more than 3x slower compared to pure XQuery templates (XQuery fn taking $model). Other than that I think it's the best built-in option. I actually don't have any users-per-second expectations and those templates will be quite small... do I overemphasize the perf. question? - pure XQuery - not aimed at templating at all and it shows I'm afraid... just can't come up with a solution that would be clean enough (plus HTML, JS & CSS highlighting withing xq files is not good at all, at least in Vim) - I looked at Mustache.xq and quite liked it - depends on MarkLogic though :( - Any hidden gem I haven't googled yet? Leaning towards XSLT right now... Daniel -- danielkvasnicka.net

5 8

Saving xquery output to a file
by Alex Muir 19 Nov '12

19 Nov '12

Hi, I've create a standalone script which creates a database and run's an xquery although I'm not clear on how to save the result of the xquery to file. generally I would like to create a database and run a series of xqueries each going to file rather than to the console output. <?xml version="1.0" encoding="UTF-8"?> <commands> <show-databases/> <drop-db name="1997-i4enrich-10k"/> <create-db name="1997-i4enrich-10k"/> <add path="1997-i4enrich-10k">/mnt/xslt_volume/i4ContentOutput/DebugSet/10k-GHU-2009/MDAFalse/Completed/</add> <info-db/> <run file='../xquery/section-10k-metrics.xq'/> <close/> </commands> I saw this on the documentation however I couldn't get it to work Q{java:java.io.FileOutputStream}new("output.txt") btw.. It might be nice to be able to say <run file='../xquery/section-10k-metrics.xq' outputFile="filename.xml" /> Thanks -- - Alex G. Muir Software Engineering Consultant Linkedin Profile : http://ca.linkedin.com/pub/alex-muir/36/ab7/125 Love African Kora Music? Take a moment to listen to Gambia's - Amadu Diabarte & Jali Bakary Konteh www.bafila.bandcamp.com Your support keeps Africa's griot tradition alive... Cheers!

2 1

Re: [basex-talk] BUG# Multiple Thread try to execute some Query
by Samuel Lacmene 19 Nov '12

19 Nov '12

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk