{"id":2044,"date":"2014-06-19T20:34:10","date_gmt":"2014-06-19T18:34:10","guid":{"rendered":"http:\/\/www.extradrm.com\/?p=2044"},"modified":"2014-06-19T21:03:24","modified_gmt":"2014-06-19T19:03:24","slug":"xquery-namespaces-mini-guide","status":"publish","type":"post","link":"https:\/\/www.extradrm.com\/?p=2044","title":{"rendered":"Xquery Namespaces Tips and tools Mini guide"},"content":{"rendered":"

Namespace declarations : example of catalog (cat) and products (prod) :<\/h2>\n
<cat:<\/strong>catalog xmlns:cat<\/strong>=\"http:\/\/datypic.com\/cat\"\r\n             xmlns:prod<\/strong>=\"http:\/\/datypic.com\/prod\">\r\n  <cat:<\/strong>number>1446<\/cat:number>\r\n  <prod:<\/strong>product>\r\n    <prod:<\/strong>number>565<\/prod:number>\r\n    <prod:name prod:language=\"en\">Sun Hat red<\/prod:name>\r\n  <\/prod:product>\r\n<\/cat:<\/strong>catalog><\/pre>\n
Xqurery and Namespaces declarations in xquery file :<\/h2>\n
How to Declare a name space and xquery loop function (in your file.xquery)<\/p>\n
\"xquery-namespace\"<\/a><\/p>\n
\u00a0BaseX as an xquery tool :<\/h2>\n
BaseX<\/em> is a very light-weight, high-performance and scalable XML Database engine and XPath\/XQuery Processor with Full Text and Update extensions (Sample File XML<\/a>)<\/p>\n
\"basex-xquery\"<\/a><\/p>\n
Some useful Xpath script notations :<\/h2>\n
The “\/” in the path informally means “go down one level”,
\nwhile the “\/\/” means “go down any number of levels”.
\nIf the path starts with “.\/” or “.\/\/” you can leave out the initial “.” (this assumes that the selection starts from the top of the tree, which is always the case in our examples).
\nYou can also use constructs like “\/..” to go up one level, and “\/@id” to select an attribute.
\nAgain, this will all be familiar if you already know XPath.<\/p>\n
 <\/p>\n
Accessing XML Documents with XQuery with Stylus Studio one of the best editors :
\n<\/b><\/h2>\n
XQuery allows you to access the file directly from either of these locations, using a suitable URL as an argument to its doc() function. Here’s an XQuery that simply retrieves and displays the whole document :<\/p>\n
doc(‘http:\/\/www.stylusstudio.com\/examples\/videos.xml’)<\/strong><\/p>\n
The file contains a number of sections. One of them is an <actors> element, which we can select like this:<\/p>\n
.\/\/actors<\/strong><\/p>\n
This produces the result:<\/p>\n
<actors>
\n<actor id=”00000015″>Anderson, Jeff<\/actor>
\n<actor id=”00000030″>Bishop, Kevin<\/actor>
\n<actor id=”0000000f”>Bonet, Lisa<\/actor>
\n<actor id=”00000024″>Bowz, Eddie<\/actor>
\n<actor id=”0000002d”>Curry, Tim<\/actor>
\n<actor id=”00000033″>Dullea, Keir<\/actor>
\n<actor id=”00000042″>Fisher, Carrie<\/actor>
\n<actor id=”00000006″>Ford, Harrison<\/actor>
\n<actor id=”00000045″>Foster, Jodie<\/actor>
\n…etc…<\/i>
\n<\/actors><\/p>\n
If you’re working in Stylus Studio\u00ae, click on XQuery<\/b> \/ Scenario Properties<\/b>, and under Main Input (optional)<\/b>, browse to the input file and select it. You can now refer to this document in your query simply as “.” (dot).<\/p>\n
\"accessing_xquery\"<\/a><\/p>\n
In the scrennshot above we can also write more complex XPath expressions like this one:<\/p>\n
.\/\/actors\/actor[ends-with(., ‘Lisa’)]<\/strong><\/p>\n
which gives the following output :<\/p>\n
<actor id=”0000000f”>Bonet, Lisa<\/actor>
\n<actor id=”0000001b”>Spoonhauer, Lisa<\/actor><\/p>\n
XQuery FLWOR Expressions<\/h2>\n
If you’ve used SQL, then you will have recognized the last example as a join between two tables, the videos table and the actors table. It’s not quite the same in XML, because the data is hierarchic rather than tabular, but XQuery allows you to write join queries in a similar way to the familiar SQL approach. Its equivalent of SQL’s SELECT expression is called the FLWOR expression, named after its five clauses: for, let, where, order by, return. Here’s the last example, rewritten this time as a FLWOR expression:<\/p>\n
let $doc := .
\nfor $v in $doc\/\/video,
\n$a in $doc\/\/actors\/actor
\nwhere ends-with($a, ‘Lisa’)
\nand $v\/actorRef = $a\/@id
\nreturn $v\/title<\/p>\n
And of course, we get the same result<\/p>\n
Prolog namespace declarations<\/h2>\n
declare default element namespace \"http:\/\/datypic.com\/report\";\r\ndeclare namespace cat = \"http:\/\/datypic.com\/cat\";\r\ndeclare namespace prod = \"http:\/\/datypic.com\/prod\";\r\n<report> {\r\n  for $product in doc(\"prod_ns.xml\")\/prod:product\r\n  return <lineItem>\r\n           {$product\/prod:number}\r\n           {$product\/prod:name}\r\n         <\/lineItem>\r\n} <\/report><\/pre>\n
Some related links :<\/strong><\/span><\/p>\n
http:\/\/www.xpathtester.com\/xquery
\nhttp:\/\/www.datypic.com\/books\/xquery\/examples.html<\/p>\n","protected":false},"excerpt":{"rendered":"
Namespace declarations : example of catalog (cat) and products (prod) : <cat:catalog xmlns:cat=”http:\/\/datypic.com\/cat” xmlns:prod=”http:\/\/datypic.com\/prod”> <cat:number>1446<\/cat:number> <prod:product> <prod:number>565<\/prod:number> <prod:name prod:language=”en”>Sun Hat red<\/prod:name> <\/prod:product> <\/cat:catalog> Xqurery and Namespaces declarations in xquery file : How to Declare...<\/p>\n","protected":false},"author":1,"featured_media":2848,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[296,26],"tags":[357,297,298,299,300],"youtube_video":null,"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/2044"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2044"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/2044\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/2848"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}