diff options
author | Santo Cariotti <santo@dcariotti.me> | 2021-02-06 22:41:59 +0100 |
---|---|---|
committer | Santo Cariotti <santo@dcariotti.me> | 2021-02-06 22:41:59 +0100 |
commit | c670e0583e5468646ab42903c95a80662d96cc89 (patch) | |
tree | 9171427b2752f36969f01bb334555e652eb7b039 /Year_2/Databases/verbale_ex1.xquery | |
parent | bcf585b1cfba4354989c828a3ecb3168f3eae8b9 (diff) |
databases: add xml exercise
Diffstat (limited to 'Year_2/Databases/verbale_ex1.xquery')
-rw-r--r-- | Year_2/Databases/verbale_ex1.xquery | 18 |
1 files changed, 18 insertions, 0 deletions
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> |