XQuery Transformation 🎯

Welcome back to CodeYourCraft! Today, we're diving into XQuery, a powerful language for querying and transforming XML documents. Let's get started!

Introduction 📝

XQuery is an essential tool for working with XML data. It allows us to extract, manipulate, and update XML content, making it a must-know for any developer dealing with structured data.

In this lesson, we'll cover the basics of XQuery and learn how to perform various transformation tasks using this powerful language.

XML Basics 📝

Before we dive into XQuery, let's quickly review some XML basics. XML (eXtensible Markup Language) is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable.

Here's a simple XML example:

xml

<books>
  <book id="1">
    <title>Book One</title>
    <author>John Doe</author>
  </book>
  <book id="2">
    <title>Book Two</title>
    <author>Jane Smith</author>
  </book>
</books>

In this example, we have an XML document containing a root element <books> with two child elements, <book>. Each <book> element has its own attributes and child elements representing the book's title and author.

XQuery Basics 📝

XQuery is used to query and manipulate XML documents. It's often compared to SQL, but for XML instead of databases. Here's a simple XQuery example:

xquery

doc("example.xml")/books/book

In this example, we're using XQuery to extract all <book> elements from an XML document named example.xml. The doc() function is used to load the XML document, and the XPath syntax (/books/book) is used to navigate the XML tree and select the desired nodes.

XQuery Functions 📝

XQuery provides a rich set of functions for working with XML data. Here are a few examples:

count(): Returns the number of matching nodes.
concat(): Concatenates strings.
sum(): Sums numerical values of matching nodes.

XQuery Variables 📝

XQuery also allows us to define variables. Variables are used to store values for later use in our queries. Here's an example:

xquery

let $book := doc("example.xml")/books/book[1]
return $book/title

In this example, we're defining a variable $book and storing the first <book> element from the XML document. We then return the <title> element of the stored book.

XQuery Queries 📝

XQuery queries allow us to extract specific information from XML documents. Here's an example:

xquery

doc("example.xml")/books/book[title='Book One']

In this example, we're querying the XML document to find the <book> element with a title of "Book One".

Practical Example 🎯

Let's put our newfound XQuery knowledge to use with a practical example. Suppose we have an XML document containing a list of products, and we want to find all products with a price greater than 50.

xml

<products>
  <product id="1">
    <name>Product A</name>
    <price>45</price>
  </product>
  <product id="2">
    <name>Product B</name>
    <price>60</price>
  </product>
  <product id="3">
    <name>Product C</name>
    <price>75</price>
  </product>
</products>

To achieve this, we can use the following XQuery:

xquery

doc("products.xml")/products/product[price > 50]

In this example, we're using XQuery to find all <product> elements with a price greater than 50 in the products.xml document.

XQuery Quiz 🎯

That's all for today's XQuery Transformation lesson! Stay tuned for more exciting topics as we continue our journey in the world of programming. Happy coding! 💡