Mifano ya XQuery

Katika sekta hii, tunafungua mafanikio kwa kusoma uandikisho wa XQuery wa kawaida.

Uandikisho wa XML

Tunatumia hili uandikisho kwenye mafanikio yetu.

"books.xml" :

<?xml version="1.0" encoding="ISO-8859-1"?>
<bookstore>
<book category="COOKING">
  <title lang="en">Everyday Italian</title>
  <author>Giada De Laurentiis</author>
  <year>2005</year>
  <price>30.00</price>
</book>
<book category="CHILDREN">
  <title lang="en">Harry Potter</title>
  <author>J K. Rowling</author>
  <year>2005</year>
  <price>29.99</price>
</book>
<book category="WEB">
  <title lang="en">XQuery Kick Start</title>
  <author>James McGovern</author>
  <author>Per Bothner</author>
  <author>Kurt Cagle</author>
  <author>James Linn</author>
  <author>Vaidyanathan Nagarajan</author>
  <year>2003</year>
  <price>49.99</price>
</book>
<book category="WEB">
  <title lang="en">Learning XML</title>
  <author>Erik T. Ray</author>
  <year>2003</year>
  <price>39.95</price>
</book>
</bookstore>

Angalia faili "books.xml" kwenye kitaa chako kwa kibarua.

Hujui kusafirisha haiti kwenye "books.xml"?

Mifano

XQuery inatumia mifano kusafirisha data kwenye uandikisho wa XML.

doc() inatumia kufungua faili "books.xml":

doc("books.xml")

Mawingu ya jina

XQuery inatumiwa kwenye mawingu ya jina kusafirisha kwenye uandikisho wa XML.

Tafuta jina la mawingu kwenye faili "books.xml"

doc("books.xml")/bookstore/book/title

(/bookstore umeza kusanya elementi ya bookstore, /book umeza kusanya barua za elementi ya bookstore, na /title umeza kusanya barua za elementi za kila book elementi)

XQuery ya juu inaweza kutambua data inayofuata:

<title lang="en">Everyday Italian</title>
<title lang="en">Harry Potter</title>
<title lang="en">XQuery Kick Start</title>
<title lang="en">Learning XML</title>

Mawazo

XQuery inatumia mawazo wa kuzingatia data ya kutumia kwa mafungo ya XML.

Mawazo yafuatavyo yanatumiwa kuwaambatana na mifungo ya bookstore ya kila book element, na thamani ya price ya kila book element inahitaji kuwa chini ya 30:

doc("books.xml")/bookstore/book[price<30]

XQuery ya juu inaweza kutambua data inayofuata:

<book category="CHILDREN">
  <title lang="en">Harry Potter</title>
  <author>J K. Rowling</author>
  <year>2005</year>
  <price>29.99</price>
</book>