You are working as a system administrator and have been tasked with querying an XML file using only the CLI (Command Line Interface). You can download the file using the following `curl` command:
“`
curl -O -L https://github.com/linuxacademy/content-intro-to-databases-on-linux/raw/master/demo.xml
“`
Using the Java-based BaseX client, you will need to query this file for the name of the user with an ID of **1**, and find the ID of the user with the name **Sue**.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Start the BaseX Client
irst you will need to download the BaseX client from basex.org:
curl -O -L http://files.basex.org/releases/9.3.2/BaseX932.jarThe Java binaries will also be needed:
sudo yum -y install javaFinally, we can start the BaseX client:
java -cp BaseX932.jar org.basex.BaseX- Open the demo.xml File
With the client installed and running, we can open the demo file:
CREATE DB demo demo.xml- Print the Name of the User with an ID of 1
xquery /users/user[ID=1]/Name- Print ID of the User with a Name of Sue
xquery /users/user[Name="Sue"]/ID
