From c670e0583e5468646ab42903c95a80662d96cc89 Mon Sep 17 00:00:00 2001
From: Santo Cariotti <santo@dcariotti.me>
Date: Sat, 6 Feb 2021 22:41:59 +0100
Subject: databases: add xml exercise

---
 Year_2/Databases/verbale_ex1.xquery | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 Year_2/Databases/verbale_ex1.xquery

(limited to 'Year_2/Databases/verbale_ex1.xquery')

diff --git a/Year_2/Databases/verbale_ex1.xquery b/Year_2/Databases/verbale_ex1.xquery
new file mode 100644
index 0000000..2be6f06
--- /dev/null
+++ b/Year_2/Databases/verbale_ex1.xquery
@@ -0,0 +1,18 @@
+<ex1>
+{
+let $f := doc("verbale.xml")
+for $verbale in $f//verbale
+where $verbale/studente[@cdl="667"] and $verbale/esame/materia/text()="Reti di Calcolatori"
+return <voto>
+    <valore>
+    {
+    $verbale/esame/voto/text()
+    }
+    </valore>
+    {if ($verbale/esame/lode) then (
+    <lode>Y</lode>
+    ) else () }
+    </voto>
+
+}
+</ex1>
-- 
cgit v1.2.3-18-g5258