Examples of XQuery

nux.xom.xquery.XQuery
the atom named 'Zinc' in the periodic table: Node result = XQueryUtil.xquery(doc, "/PERIODIC_TABLE/ATOM[NAME = 'Zinc']").get(0); System.out.println("result=" + result.toXML()); // equivalent via the more powerful underlying API: XQuery xquery = new XQuery("/PERIODIC_TABLE/ATOM[NAME = 'Zinc']", null); Node result = xquery.execute(doc).next(); // count the numer of elements in a document tree: int count = XQueryUtil.xquery(doc, "//*").size(); System.out.println("count=" + count); // equivalent via the XPath count() function: int count = Integer.parseInt(XQueryUtil.xquery(doc, "count(//*)").get(0).getValue()); System.out.println("count=" + count); A query to find the links of all images (or all JPG images) in a XHTML-like document:
```
 Document doc = new Builder().build(new File("/tmp/test.xml")); Nodes results = XQueryUtil.xquery(doc, "//*:img/@src"); // Nodes results = XQueryUtil.xquery(doc, "//*:img/@src[matches(., '.jpg')]"); for (int i=0; i < results.size(); i++) { System.out.println("node "+i+": "+results.get(i).toXML()); //System.out.println("node "+i+": "+ XOMUtil.toPrettyXML(results.get(i))); } 
```
Namespaces
A query can use namespaces. Here is an example that lists the titles of Tim Bray's blog articles via the Atom feed:
```
 declare namespace atom = "http://www.w3.org/2005/Atom";  declare namespace xsd = "http://www.w3.org/2001/XMLSchema"; doc("http://www.tbray.org/ongoing/ongoing.atom")/atom:feed/atom:entry/atom:title 
```
Namespace declarations can be defined inline within the query prolog via declare namespace, and declare default element namespace directives, as described above. They can also be defined via the declareNamespace() methods and setDefaultElementNamespace() method of a {@link StaticQueryContext}.
Passing variables to a query
A query can declare local variables, for example:
```
 declare variable $i := 7; declare variable $j as xs:integer := 7; declare variable $math:pi as xs:double := 3.14159E0; declare variable $bookName := 'War and Peace'; 
```
A query can access variable values via the standard $varName syntax, as in return ($x, $math:pi) or /books/book[@name = $bookName]/author[@name = $authorName].
A query can declare external global variables, for example:
```
 declare variable $foo     as xs:string external;  declare variable $size    as xs:integer external;  declare variable $myuri   as xs:anyURI external; declare variable $mydoc   as document-node() external; declare variable $myelem  as element() external; declare variable $mynodes as node()* external; 
```
External global variables can be bound and passed to the query as follows:
```
 Map vars = new HashMap(); vars.put("foo", "hello world"); vars.put("size", new Integer(99)); vars.put("myuri", "http://www.w3.org/2001/XMLSchema"); vars.put("mydoc", new Document(new Element("xyz"))); vars.put("myelem", new Element("abc")); vars.put("mynodes", new Node[] {new Document(new Element("elem1")), new Element("elem2"))}); vars.put("mydocs", new Node[] { new Builder().build(new File("samples/data/articles.xml")),  new Builder().build(new File("samples/data/p2pio.xml")) }); String query = "for $d in $mydocs return $size * count($d)"; Nodes results = new XQuery(query, null).execute(doc, null, vars).toNodes(); new ResultSequenceSerializer().write(results, System.out); 
```
Standard functions, user defined functions and extension functions
The Standard XQuery functions can be used directly. Also note that XPath 2.0 supports regular expressions via the standard fn:matches, fn:replace, and fn:tokenize functions. For example:
```
 string-length('hello world'); 
```
A query can employ user defined functions, for example:
```
 declare namespace ipo = "http://www.example.com/IPO"; declare function local:total-price( $i as element(item)* ) as xs:double { let $subtotals := for $s in $i return $s/quantity * $s/USPrice return sum($subtotals) };  for $p in doc("ipo.xml")/ipo:purchaseOrder where $p/shipTo/name="Helen Zoe" and $p/@orderDate = xs:date("1999-12-01") return local:total-price($p//item)  
```
Custom extension functions written in Java can be defined and used as explained in the Saxon Extensibility Functions documentation. For example, here is query that outputs the square root of a number via a method in java.lang.Math, as well as calls static methods and constructors of java.lang.String, java.util.Date as well as other extension functions.
```
 declare namespace exslt-math = "http://exslt.org/math"; declare namespace math   = "java:java.lang.Math"; declare namespace date   = "java:java.util.Date";  declare namespace string = "java:java.lang.String";  declare namespace saxon  = "http://saxon.sf.net/"; declare variable $query := string(doc("query.xml")/queries/query[1]); ( exslt-math:sin(3.14) math:sqrt(16), math:pow(2,16), string:toUpperCase("hello"), date:new(),                    (: print current date :) date:getTime(date:new())       (: print current date in milliseconds :) saxon:eval(saxon:expression($query))  (: run a dynamically constructed query :) ) 
```
Modules
An XQuery module is a file containing a set of variable and function declarations. For decomposition and reuse of functionality a module can import declarations from other modules. Here are two example modules generating the factorial of a number:
```
 (: file modules/factorial.xq :) module namespace factorial = "http://example.com/factorial"; declare function factorial:fact($i as xs:integer) as xs:integer { if ($i <= 1) then 1 else $i * factorial:fact($i - 1) }; (: file main.xq :) import module namespace factorial = "http://example.com/factorial" at "modules/factorial.xq"; factorial:fact(4) [hoschek /Users/hoschek/unix/devel/nux] fire-xquery main.xq <atomic-value xsi:type="xs:integer" xmlns="http://dsd.lbl.gov/nux"  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">24</atomic-value> 
```
Customizing the doc() function
A custom document URI resolver for the XQuery/XPath doc() function can be defined in the constructor of this class. Other miscellaneous options can be made available to the query by calling configuration methods on a {@link DynamicQueryContext} (per execution),or on the configuration object of a {@link StaticQueryContext} (per query).
Performance
For simple XPath expressions you can get a throughput of up to 1000-20000 (100000) executions/sec over 200 (0.5) KB input documents, served from memory (commodity PC 2004, JDK 1.5, server VM). Be aware that this is an example ballpark figure at best, because use cases, documents and the complexity of queries vary wildly in practise. In any case, it is safe to assume that this XQuery/XPath implementation is one of the fastest available. For details, see {@link nux.xom.sandbox.XQueryBenchmark}. @author whoschek.AT.lbl.DOT.gov @author $Author: hoschek3 $ @version $Revision: 1.125 $, $Date: 2006/06/18 20:42:25 $
org.exist.xquery.XQuery
@author wolf
org.zorbaxquery.api.XQuery

Examples of org.exist.xquery.XQuery

        DBBroker broker = null;
        try {
            broker = pool.get(pool.getSecurityManager().getSystemSubject());
            assertNotNull(broker);


            XQuery xquery = broker.getXQueryService();
            assertNotNull(xquery);
            Sequence seq = xquery.execute("for $a in ft:query((//b|//c), 'AAA') " +
                    "order by ft:score($a) descending return $a/local-name(.)", null, AccessContext.TEST);
            assertNotNull(seq);
            assertEquals(3, seq.getItemCount());
            assertEquals("c", seq.getStringValue());
        } catch (Exception e) {

View Full Code Here

Examples of org.exist.xquery.XQuery

        DBBroker broker = null;
        try {
            broker = pool.get(pool.getSecurityManager().getSystemSubject());
            assertNotNull(broker);


            XQuery xquery = broker.getXQueryService();
            assertNotNull(xquery);


            XQueryContext context = new XQueryContext(broker.getBrokerPool(), AccessContext.TEST);
            CompiledXQuery compiled = xquery.compile(context, "declare variable $q external; " +
                    "ft:query(//p, util:parse($q)/query)");


            context.declareVariable("q", "<query><term>heiterkeit</term></query>");
            Sequence seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            context.declareVariable("q",
                "<query>" +
                "   <bool>" +
                "       <term>heiterkeit</term><term>blablabla</term>" +
                "   </bool>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            context.declareVariable("q",
                "<query>" +
                "   <bool>" +
                "       <term occur='should'>heiterkeit</term><term occur='should'>blablabla</term>" +
                "   </bool>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            context.declareVariable("q",
                "<query>" +
                "   <bool>" +
                "       <term occur='must'>heiterkeit</term><term occur='must'>blablabla</term>" +
                "   </bool>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(0, seq.getItemCount());


            context.declareVariable("q",
                "<query>" +
                "   <bool>" +
                "       <term occur='must'>heiterkeit</term><term occur='not'>herzen</term>" +
                "   </bool>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(0, seq.getItemCount());


            context.declareVariable("q",
                "<query>" +
                "   <bool>" +
                "       <phrase occur='must'>wunderbare heiterkeit</phrase><term occur='must'>herzen</term>" +
                "   </bool>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            context.declareVariable("q",
                    "<query>" +
                    "   <phrase slop='5'>heiterkeit seele eingenommen</phrase>" +
                    "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            // phrase with wildcards
            context.declareVariable("q",
                "<query>" +
                "   <phrase slop='5'><term>heiter*</term><term>se?nnnle*</term></phrase>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            context.declareVariable("q",
                "<query>" +
                "   <wildcard>?eiter*</wildcard>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            context.declareVariable("q",
                "<query>" +
                "   <fuzzy max-edits='2'>selee</fuzzy>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            context.declareVariable("q",
                "<query>" +
                "   <bool>" +
                "       <fuzzy occur='must' max-edits='2'>selee</fuzzy>" +
                "       <wildcard occur='should'>bla*</wildcard>" +
                "   </bool>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            context.declareVariable("q",
                "<query>" +
                "   <regex>heit.*keit</regex>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            context.declareVariable("q",
                "<query>" +
                "   <phrase><term>wunderbare</term><regex>heit.*keit</regex></phrase>" +
                "</query>");
            seq = xquery.execute(compiled, null);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());
        } catch (Exception e) {
            e.printStackTrace();
            fail(e.getMessage());

View Full Code Here

Examples of org.exist.xquery.XQuery

        DBBroker broker = null;
        try {
            pool = BrokerPool.getInstance();
            assertNotNull(pool);
            broker = pool.get(pool.getSecurityManager().getSystemSubject());
            XQuery xquery = broker.getXQueryService();
            assertNotNull(xquery);
            String query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:transform((//gml:Polygon)[1], 'EPSG:4326')";
            Sequence seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:getWKT((//gml:Polygon)[1])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:buffer((//gml:Polygon)[1], 100)";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:buffer((//gml:Polygon)[1], 100, 1)";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:getBbox((//gml:Polygon)[1])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:convexHull((//gml:Polygon)[1])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:boundary((//gml:Polygon)[1])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:intersection((//gml:Polygon)[1], (//gml:Polygon)[2])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:union((//gml:Polygon)[1], (//gml:Polygon)[2])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:difference((//gml:Polygon)[1], (//gml:Polygon)[2])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:symetricDifference((//gml:Polygon)[1], (//gml:Polygon)[2])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            
            //Tests with empty sequences
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:transform((), 'EPSG:4326')";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:getWKT(())";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:buffer((), 100)";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:buffer((), 100, 1)";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:getBbox(())";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:convexHull(())";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:boundary(())";  
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:union((), ())";  
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:union((//gml:Polygon)[1], ())";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 1);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:union((), (//gml:Polygon)[1])";  
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 1);


            //In-memory tests
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:transform(" + IN_MEMORY_GML + ", 'EPSG:4326')";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:buffer(" + IN_MEMORY_GML + ", 100)";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:buffer(" + IN_MEMORY_GML + ", 100, 1)";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:getBbox(" + IN_MEMORY_GML + ")";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:convexHull(" + IN_MEMORY_GML + ")";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:boundary(" + IN_MEMORY_GML + ")";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:intersection(" + IN_MEMORY_GML + ", (//gml:Polygon)[2])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:union(" + IN_MEMORY_GML + ", (//gml:Polygon)[2])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:difference(" + IN_MEMORY_GML + ", (//gml:Polygon)[2])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:symetricDifference(" + IN_MEMORY_GML + ", (//gml:Polygon)[2])";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:intersection((//gml:Polygon)[1]," + IN_MEMORY_GML + ")";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:union((//gml:Polygon)[1]," + IN_MEMORY_GML + ")";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:difference((//gml:Polygon)[1]," + IN_MEMORY_GML + ")";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "spatial:symetricDifference((//gml:Polygon)[1]," + IN_MEMORY_GML + ")";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() > 0);
            
        } catch (Exception e) {
            e.printStackTrace();

View Full Code Here

Examples of org.exist.xquery.XQuery

        DBBroker broker = null;
        try {
            pool = BrokerPool.getInstance();
            assertNotNull(pool);
            broker = pool.get(pool.getSecurityManager().getSystemSubject());
            XQuery xquery = broker.getXQueryService();
            assertNotNull(xquery);
            String query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "(# exist:force-index-use #) { " +
                "spatial:getArea((//gml:Polygon)[1]) " +
                "}";
            Sequence seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);    
            assertTrue(seq.getItemCount() == 1);
            String area1 = seq.toString();
            query =  "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "update value (//gml:Polygon)[1]/gml:outerBoundaryIs/gml:LinearRing/gml:coordinates " +
                "(: strip decimals :) " +
                "with fn:replace((//gml:Polygon)[1], '(\\d+).(\\d+)', '$1')";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 0);
            query = "import module namespace spatial='http://exist-db.org/xquery/spatial' " +
                "at 'java:org.exist.examples.indexing.spatial.module.SpatialModule'; " +
                "declare namespace gml = 'http://www.opengis.net/gml'; " +
                "(# exist:force-index-use #) { " +
                "spatial:getArea((//gml:Polygon)[1])" +
                "}";
            seq = xquery.execute(query, null, AccessContext.TEST);
            assertNotNull(seq);
            assertTrue(seq.getItemCount() == 1);
            String area2 = seq.toString();
            assertFalse(area1.equals(area2));
        } catch (Exception e) {

View Full Code Here

Examples of org.exist.xquery.XQuery

                LOG.info("pathURI " + pathUri );
                return true;
            }




            XQuery xquery = broker.getXQueryService();


            if (xquery == null) {
                LOG.error("broker unable to retrieve XQueryService");
                return false;
            }


            XQueryContext context = xquery.newContext(AccessContext.REST);


            CompiledXQuery compiled = xquery.compile(context, source);


            Properties outputProperties = new Properties();


            Sequence result = xquery.execute(compiled, null, outputProperties);
            LOG.info("XQuery execution results: " + result.toString());


        } catch (Exception e) {
            LOG.error("Exception while executing OpenID registration script for " + principal.getMetadataValue(AXSchemaType.ALIAS_USERNAME), e);
            return false;

View Full Code Here

Examples of org.exist.xquery.XQuery

            assertNotNull(broker);


            checkIndex(docs, broker, new QName[] { new QName("head", "") }, "TITLE", 1);
            checkIndex(docs, broker, new QName[] { new QName("p", "") }, "uppercase", 1);


            XQuery xquery = broker.getXQueryService();
            assertNotNull(xquery);
            Sequence seq = xquery.execute("/section[ft:query(p, 'UPPERCASE')]", null, AccessContext.TEST);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            seq = xquery.execute("/section[ft:query(head, 'TITLE')]", null, AccessContext.TEST);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            seq = xquery.execute("/section[ft:query(head, 'title')]", null, AccessContext.TEST);
            assertNotNull(seq);
            assertEquals(0, seq.getItemCount());
        } catch (Exception e) {
            e.printStackTrace();
            fail(e.getMessage());

View Full Code Here

Examples of org.exist.xquery.XQuery

            transact = pool.getTransactionManager();
            assertNotNull(transact);
            transaction = transact.beginTransaction();
            assertNotNull(transaction);


            XQuery xquery = broker.getXQueryService();
            assertNotNull(xquery);
            Sequence seq = xquery.execute("//LINE[ft:query(., 'bark')]", null, AccessContext.TEST);
            assertNotNull(seq);
            assertEquals(6, seq.getItemCount());


            System.out.println("Removing document r_and_j.xml");
            root.removeXMLResource(transaction, broker, XmldbURI.create("r_and_j.xml"));
            transact.commit(transaction);


            seq = xquery.execute("//LINE[ft:query(., 'bark')]", null, AccessContext.TEST);
            assertNotNull(seq);
            assertEquals(3, seq.getItemCount());


            transaction = transact.beginTransaction();
            assertNotNull(transaction);
            System.out.println("Removing document hamlet.xml");
            root.removeXMLResource(transaction, broker, XmldbURI.create("hamlet.xml"));
            transact.commit(transaction);


            seq = xquery.execute("//LINE[ft:query(., 'bark')]", null, AccessContext.TEST);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            System.out.println("Test PASSED.");
        } catch (Exception e) {

View Full Code Here

Examples of org.exist.xquery.XQuery

            transact = pool.getTransactionManager();
            assertNotNull(transact);
            transaction = transact.beginTransaction();
            assertNotNull(transaction);


            XQuery xquery = broker.getXQueryService();
            assertNotNull(xquery);
            Sequence seq = xquery.execute("//SPEECH[ft:query(LINE, 'love')]", null, AccessContext.TEST);
            assertNotNull(seq);
            System.out.println("Found: " + seq.getItemCount());
            assertEquals(166, seq.getItemCount());


            System.out.println("Removing collection");

View Full Code Here

Examples of org.exist.xquery.XQuery


            checkIndex(docs, broker, new QName[] { new QName("description", "") }, "chair", 1);
            checkIndex(docs, broker, new QName[] { new QName("item", "") }, null, 5);
            checkIndex(docs, broker, new QName[] { new QName("condition", "") }, null, 2);


            XQuery xquery = broker.getXQueryService();
            assertNotNull(xquery);
            Sequence seq = xquery.execute("//item[ft:query(description, 'chair')]", null, AccessContext.TEST);
            assertNotNull(seq);
            assertEquals(1, seq.getItemCount());


            XUpdateProcessor proc = new XUpdateProcessor(broker, docs, AccessContext.TEST);
            assertNotNull(proc);

View Full Code Here

Examples of org.zorbaxquery.api.XQuery

   * @param args
   */
  public static void main(String[] args) {
    Store store = InMemoryStore.getInstance();
    Zorba zorba = Zorba.getInstance(store);
    XQuery xquery = zorba.compileQuery("declare variable $input external; for $x in $input//b return $x");
    xquery.setVariableAsDocument("input", "test.xml", "<a><b>Hallo</b><b>Lukas</b><b>1</b></a>");
    Iterator iter = xquery.iterator();
    iter.open();
    Item item = new Item();
    while(iter.next(item)){
      String test = item.getStringValue();
      System.out.println(test);
    }
    iter.close();
    iter.destroy();
    xquery.destroy();
    zorba.shutdown();
  }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of XQuery

Namespaces

Passing variables to a query

Standard functions, user defined functions and extension functions

Modules

Customizing the doc() function

Performance

Examples of org.exist.xquery.XQuery

Examples of org.exist.xquery.XQuery

Examples of org.exist.xquery.XQuery

Examples of org.exist.xquery.XQuery

Examples of org.exist.xquery.XQuery

Examples of org.exist.xquery.XQuery

Examples of org.exist.xquery.XQuery

Examples of org.exist.xquery.XQuery

Examples of org.exist.xquery.XQuery

Examples of org.zorbaxquery.api.XQuery