==Meeskonnaliikmed==
* Taavi Põder
* Raido Vell
* Taavi Vesinurm - [RIP]

Team Foundation Version Control: [[https://pillarofautumn.visualstudio.com/Pillarofautumn/Pillarofautumn%20Team/_git/Pillarofautumn?_a=contents]]

==Analüüs==

Antud projekti korral on tegemist arsti visiitide registreerimise süsteemiga, mille erinevateks kasutajateks on siis arstid ja nende patsiendid. Süsteem võimaldab patsiendil valida arsti ning registreerida aeg, kui see pole varasemalt juba võetud. Registreerimine on võimalik anonüümselt ilma kontot omamata. Samas on võimalik luua konto, et näha endaga seotud varasemaid arstile pöördumisi, ning konkreetse visiidiga seotud arsti poolseid tähelepanekuid.

===Kasutajad===
* Arstid
* Kliendid

===Funktsionaalsus===

====Must have:====
CRUD:
* Visiidi loomine
* Visiidi vaatamine
* Visiidi muutmine
* Visiidi kustutamine
* Kasutaja loomine
* Kasutaja vaatamine
* Kasutaja muutmine
* Kasutaja kustutamine.
* Protseduuri ...
* Kliiniku ...
* Visiidi tüübi ...

Otsin:
* Kasutaja nime järgi (1)

Statistika:
* Sisselogimiste koguarv
* Kasutaja visiitide koguarv
* Kasutaja aktiivsete visiitide koguarv

Registreermise nõuded:
* Visiidi aeg on 30 minutit.
* Topelt broneeringuid ei ole.
* Visiitide ajad jäävad 10:00-16:00, esmaspäevast reedeni.
* Visiidi aeg ei tohi olla minevikus.
* Arstide valik on drop down menüüs.

Turvalisus:
* Andmebaasi väljade omavad piiranguid.
* Andmebaasi pöördumised on piiratud.

==== Nice to have: ====
Teavitused:
* Tervitus sõnum esmase sisselogimise korral.
* Teavitus sõnum korduval sisselogimisel.
* Teavitused tulevasest visiidist.
* Teavitus kustutatud visiidist.
* teavitus uue visiidi loomisest.
* Valik saada teavitusi.

Statistika:
* Ära olnud visiitide arv.

Integratsioon:
* Google kalender sync.

CRUD:
* Kasutaja saab muuta Kasutaja visiidi aegu.(2)

(1) - Kasutaja visiitide otsingud nii arsti kui tavakasutaja nime järgi. 
(2) - Arstil on võimekus muuta tavakasutaja aegu.

===Andmemudel===
[[File:Erdnewsmaller.png]]

==Retsensioonid==
Retsensioonid ilmuvad siia.

==XML==

'''XML'''
XML näidise lõime 1 visiidi näitel. Illustreerivatel eesmärkidel, ei hakanud duubeldama.
<source lang="xml">
<?xml version="1.0" encoding="utf-8"?>
<Appointments>
<Appointment id="1" app_date="05/01/2018" length="00:30">
<appointment_type id="1">
<name>Esmakordne visiit</name>
<description>Suuõõne ülevaatus ja konsultatsioon.</description>
</appointment_type>
<person1 id="1" citizen_id="32554694115" >
<firstname> James </firstname>
<surname> Bond </surname>
<middlename></middlename>
<Contacts>
<Contact id="1" type="phone" value =""></Contact>
<Contact id="2" type="email" value ="J.Bond@SIS.uk"></Contact>
<Contact id="3" type="address">
<address>
<city>London</city>
<street>Whitehall</street>
<house> 25 </house>
<apartment> 5 </apartment>
</address>
</Contact>
</Contacts>
</person1>
<person2 id="2" citizen_id="36522141652" >
<firstname> Frederick </firstname>
<surname> Aldeman </surname>
<middlename>Ender</middlename>
<Contacts>
<Contact id ="1" type="phone" value=""></Contact>
<Contact id="2" type="email" value="F.E.Aldeman@gmail.com"></Contact>
<Contact id="3" type="Address">
<address>
<city> Wyoming </city>
<street>Elm street</street>
<house> 112 </house>
<apartment> 5 </apartment>
</address>
</Contact>
</Contacts>
</person2>
</Appointment>
</Appointments>
</source>

<source lang="xml">
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="Appointments">
<xs:complexType>
<xs:sequence>
<xs:element name="Appointment">
<xs:complexType>
<xs:sequence>
<xs:element name="appointment_type">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="name"/>
<xs:element type="xs:string" name="description"/>
</xs:sequence>
<xs:attribute type="xs:int" name="id" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="person1">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="firstname"/>
<xs:element type="xs:string" name="surname"/>
<xs:element type="xs:string" name="middlename"/>
<xs:element name="Contacts">
<xs:complexType>
<xs:sequence>
<xs:element name="Contact" maxOccurs="unbounded" minOccurs="0">
<xs:complexType mixed="true">
<xs:sequence>
<xs:element name="address" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="city"/>
<xs:element type="xs:string" name="street"/>
<xs:element type="xs:float" name="house"/>
<xs:element type="xs:float" name="apartment"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute type="xs:int" name="id" use="optional"/>
<xs:attribute type="xs:string" name="type" use="optional"/>
<xs:attribute type="xs:string" name="value" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute type="xs:int" name="id" use="required"/>
<xs:attribute type="xs:long" name="citizen_id"/>
</xs:complexType>
</xs:element>
<xs:element name="person2">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="firstname"/>
<xs:element type="xs:string" name="surname"/>
<xs:element type="xs:string" name="middlename"/>
<xs:element name="Contacts">
<xs:complexType>
<xs:sequence>
<xs:element name="Contact" maxOccurs="unbounded" minOccurs="0">
<xs:complexType mixed="true">
<xs:sequence>
<xs:element name="address" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="city"/>
<xs:element type="xs:string" name="street"/>
<xs:element type="xs:float" name="house"/>
<xs:element type="xs:float" name="apartment"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute type="xs:int" name="id" use="optional"/>
<xs:attribute type="xs:string" name="type" use="optional"/>
<xs:attribute type="xs:string" name="value" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute type="xs:int" name="id" use="required"/>
<xs:attribute type="xs:long" name="citizen_id"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute type="xs:int" name="id" use="required"/>
<xs:attribute type="xs:string" name="app_date" use="required"/>
<xs:attribute type="xs:string" name="length" use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
</source>

==Muudatused==
Wiki lehe struktuur 31.03.18 12:00 
Analüüsi Must ja nice to have funktsionaalsus 31.03.18 16:00 
Funktsionaalsuse täiendus 17.04.18 21:00 
XML example 05.06.18 19:00

Pillarofautumn

2018-06-05T16:09:46Z

Rvell: /* Muudatused */

Pillarofautumn

2018-06-05T16:06:59Z

Rvell: /* XML */

Pillarofautumn

2018-06-05T16:05:53Z

Rvell:

Pillarofautumn

2018-06-04T16:27:30Z

Rvell: /* Meeskonnaliikmed */

Pillarofautumn

2018-04-17T18:07:20Z

Rvell: /* Muudatused */

==Meeskonnaliikmed==
* Taavi Põder
* Raido Vell
* Taavi Vesinurm

Team Foundation Version Control: TBA

==Analüüs==

Antud projekti korral on tegemist arsti visiitide registreerimise süsteemiga, mille erinevateks kasutajateks on siis arstid ja nende patsiendid. Süsteem võimaldab patsiendil valida arsti ning registreerida aeg, kui see pole varasemalt juba võetud. Registreerimine on võimalik anonüümselt ilma kontot omamata. Samas on võimalik luua konto, et näha endaga seotud varasemaid arstile pöördumisi, ning konkreetse visiidiga seotud arsti poolseid tähelepanekuid.

===Kasutajad===
* Arstid
* Kliendid

===Funktsionaalsus===

====Must have:====
CRUD:
* Visiidi loomine
* Visiidi vaatamine
* Visiidi muutmine
* Visiidi kustutamine
* Kasutaja loomine
* Kasutaja vaatamine
* Kasutaja muutmine
* Kasutaja kustutamine.
* Protseduuri ...
* Kliiniku ...
* Visiidi tüübi ...

Otsin:
* Kasutaja nime järgi (1)

Statistika:
* Sisselogimiste koguarv
* Kasutaja visiitide koguarv
* Kasutaja aktiivsete visiitide koguarv

Registreermise nõuded:
* Visiidi aeg on 30 minutit.
* Topelt broneeringuid ei ole.
* Visiitide ajad jäävad 10:00-16:00, esmaspäevast reedeni.
* Visiidi aeg ei tohi olla minevikus.
* Arstide valik on drop down menüüs.

Turvalisus:
* Andmebaasi väljade omavad piiranguid.
* Andmebaasi pöördumised on piiratud.

==== Nice to have: ====
Teavitused:
* Tervitus sõnum esmase sisselogimise korral.
* Teavitus sõnum korduval sisselogimisel.
* Teavitused tulevasest visiidist.
* Teavitus kustutatud visiidist.
* teavitus uue visiidi loomisest.
* Valik saada teavitusi.

Statistika:
* Ära olnud visiitide arv.

Integratsioon:
* Google kalender sync.

CRUD:
* Kasutaja saab muuta Kasutaja visiidi aegu.(2)

(1) - Kasutaja visiitide otsingud nii arsti kui tavakasutaja nime järgi. 
(2) - Arstil on võimekus muuta tavakasutaja aegu.

===Andmemudel===
[[File:POE_erd.PNG]]

==Retsensioonid==
Retsensioonid ilmuvad siia.

==Muudatused==
Wiki lehe struktuur 31.03.18 12:00 
Analüüsi Must ja nice to have funktsionaalsus 31.03.18 16:00 
Funktsionaalsuse täiendus 17.04.18 21:00

2017-03-27T17:32:11Z

Rvell: Created page with "= XML/XSLT/XSD retsensioon = Retsenseeris meeskond '''Nope'''. Meeskonna Bob's Burgers XML fail on korralikult koostatud ning omab vajalikke kriteeriume. Olemas on töökä..."

= XML/XSLT/XSD retsensioon =

Retsenseeris meeskond '''Nope'''.

Meeskonna Bob's Burgers XML fail on korralikult koostatud ning omab vajalikke kriteeriume. Olemas on töökäsus nõutud dimensioonid ning loodud väljad on mõistlikult jaotatud. Eraldi tuleks tähelepanu juhtida atribuutidest puuduvale ID-le, mis hilisema töö käigus võib muutuda vajalikuks.
XSD fail on korrektselt tehtud ning andmetüübid ja piirangud on tehtud väljade jaoks sobivad.
Transformatsiooni käigus on kasutatud lisaks for-each lausetele ka parameetreid ning tingimuste kontrolle. Transformatsioon HTML-i on eraldi väljatoodud koos esitusega ning annab suurepäraselt edasi informatsiooni tavalise inimese jaoks loetavale kujule.

Suuremalt jaolt on nõutud kriteeriumid täidetud ning töö on korralikult tehtud.

27.03.2017

Meeskond "Nope":

2017-03-20T10:32:03Z

Rvell: /* XSLT-XML */

Meeskond "Nope":

2017-03-20T07:04:09Z

Rvell: /* History */

== Meeskond ==
* Raido Vell
* Taavi Vesinurm
* Kaspar Kaal
* Lisette Noor
* Madis Roosioks

== Idee ==

== XML Fail ==

===XML===
<pre>
<?xml version="1.0" encoding="utf-8" ?>

<music>
<artists>
<artist id="1" name="Michael Jackson">
<album name="Thriller" releaseDate="1982">
<description>
Thriller is the sixth studio album by American singer Michael Jackson,
released on November 30, 1982 by Epic Records. The follow-up to Jackson's successful previous album, Off the Wall (1979),
Thriller explores genres similar to those of its predecessor, including pop, post-disco, rock and funk.
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/5/55/Michael_Jackson_-_Thriller.png</ImageUrl>
</albumCover>
<songs>
<song name="Billie Jean" duration="4:54" durationUnit="minutes:seconds">
<lyrics>
She was more like a beauty queen from a movie scene 
I said don't mind, but what do you mean I am the one 
Who will dance on the floor in the round 
She said I am the one who will dance on the floor in the round 

She told me her name was Billie Jean, as she caused a scene 
Then every head turned with eyes that dreamed of being the one 
Who will dance on the floor in the round 

People always told me be careful of what you do 
And don't go around breaking young girls' hearts 
And mother always told me be careful of who you love 
And be careful of what you do 'cause the lie becomes the truth 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 

For forty days and forty nights 
The law was on her side 
But who can stand when she's in demand 
Her schemes and plans 
'cause we danced on the floor in the round 
So take my strong advice, just remember to always think twice 
(do think twice.) 

She told my baby we'd danced 'til three 
Then she looked at me 
She showed a photo of a baby crying 
His eyes looked like mine 
Go on dance on the floor in the round, baby 

People always told me be careful of what you do 
And don't go around breaking young girls' hearts 
She came and stood right by me 
Then the smell of sweet perfume 
This happened much too soon 
She called me to her room 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 

She says I am the one, but the kid is not my son 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 
She says I am the one, she says he is my son 
She says I am the one 
Billie Jean is not my lover 
Billie Jean is not my lover 

</lyrics>
<genres>
<genre>Post-disco</genre>
<genre>Rhythm and Blues</genre>
<genre>Funk</genre>
<genre>Dance-Pop</genre>
</genres>
</song>
<song name="Thriller" duration="5:58" durationUnit="minutes:seconds">
<lyrics>
It's close to midnight and something evil's lurking 
In the dark 
Under the moonlight you see a sight that almost stops 
Your heart 
You try to scream, but terror takes the sound before 
You make it 
You start to freeze as horror looks you right between 
The eyes 
You're paralyzed 

'Cause this is thriller, thriller night 
And no one's gonna save you from the beast about to 
Strike 
You know it's thriller, thriller night 
You're fighting for your life inside a killer 
Thriller tonight 

You hear the door slam and realize there's nowhere 
Left to run 
You feel the cold hand and wonder if you'll ever see 
The sun 
You close your eyes and hope that this is just 
Imagination 
But all the while you hear the creature creepin' up 
Behind 
You're out of time 

'Cause this is thriller, thriller night 
There ain't no second chance against the thing with 
Forty eyes 
You know it's thriller, thriller night 
You're fighting for your life inside a killer 
Thriller tonight 

Night creatures call 
And the dead start to walk in their masquerade 
There's no escapin' the jaws of the alien this time 
(They're open wide) 
This is the end of your life 

They're out to get you; there's demons closing in on 
Every side 
They will possess you unless you change the number on 
Your dial 
Now is the time for you and I to cuddle close 
Together 
All through the night I'll save you from the terrors on 
The screen 
I'll make you see 

That it's a thriller, thriller night 
'Cause I can thrill you more than any ghost 
Would ever dare try 
Girl, this is thriller, thriller night 
So let me hold you tight and share a killer, diller 
Chiller 
Thriller here tonight 

That it's a thriller, thriller night 
'Cause I can thrill you more than any ghost 
Would ever dare try 
Girl, this is thriller, thriller night 
So let me hold you tight and share a killer, diller 

Darkness falls across the land 
The midnight hour is close at hand 
Creatures crawl in search of blood 
To terrorize y'awl's neighborhood 
And whosoever shall be found 
Without the soul for getting down 
Must stand and face the hounds of hell 
And rot inside a corpse's shell 

The foulest stench is in the air 
The funk of forty thousand years 
And grizzly ghouls from every tomb 
Are closing in to seal your doom 
And though you fight to stay alive 
Your body starts to shiver 
For no mere mortal can resist 
The evil of the thriller 
</lyrics>
<genres>
<genre>Disco</genre>
<genre>Pop</genre>
</genres>
</song>
<song name="Beat it" duration="4:18" durationUnit="minutes:seconds">
<lyrics>
They told him don't you ever come around here 
Don't wanna see your face, you better disappear 
The fire's in their eyes and their words are really clear 
So beat it, just beat it 
You better run, you better do what you can 
Don't wanna see no blood, don't be a macho man 
You wanna be tough, better do what you can 
So beat it, but you wanna be bad 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 
Just beat it (beat it) 
Just beat it (beat it) 
Just beat it (beat it) 
Just beat it (beat it uuh) 

They're out to get you, better leave while you can 
Don't wanna be a boy, you wanna be a man 
You wanna stay alive, better do what you can 
So beat it, just beat it 
You have to show them that you're really not scared 
You're playin' with your life, this ain't no truth or dare 
They'll kick you, then they'll beat you 
Then they'll tell you it's fair 
So beat it, but you wanna be bad 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 
Just beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 

Beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it (beat it) 
</lyrics>
<genres>
<genre>Hard Rock</genre>
<genre>Dance-Rock</genre>
</genres>
</song>
</songs>
</album>
</artist>
<artist name="Imagine Dragons" id="2">
<album name="Smoke + Mirrors" releaseDate="2015">
<description>
Smoke + Mirrors is the second studio album by American rock band Imagine Dragons.
The album was recorded during 2014 at the band's home studio in Las Vegas, Nevada.
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/c/ce/Imagine_Dragons_-_Smoke_%2B_Mirrors.png</ImageUrl>
</albumCover>
<songs>
<song name="Shots" duration="3:52" durationUnit="minutes:seconds">
<lyrics>
I'm sorry for everything 
Oh, everything I've done 

Am I out of touch? 
Am I out of my place? 
When I keep saying that I'm looking for an empty space 
Oh, I'm wishing you're here 
But I'm wishing you're gone 
I can't have you and I'm only gonna do you wrong 

Oh, I'm going to mess this up 
Oh, this is just my luck 
Over and over and over again 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

Am I out of luck? 
Am I waiting to break? 
When I keep saying that I'm looking for a way to escape 
Oh, I'm wishing I had what I'd taken for granted 
I can't help you when I'm only gonna do you wrong 

Oh, I'm going to mess this up 
Oh, this is just my luck 
Over and over and over again 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

In the meantime we let it go 
At the roadside 
We used to know 
We can let this drift away 
Oh, we let this drift away 
At the bay side 
You used to show 
In the moonlight 
We let it go 
We can let this drift away 
Oh, we let this drift away 

And there's always time to change your mind 
Oh, there's always time to change your mind 
Oh, love, can you hear me? 
Oh, let it drift away 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

In the meantime we let it go 
At the roadside 
We used to know 
We can let this drift away 
Oh, we let this drift away 
At the bay side 
You used to show 
In the moonlight 
We let it go 
We can let this drift away 
Oh, we let this drift away 

And there's always time to change your mind 
Oh, there's always time to change your mind 
Oh, love, can you hear me? 
Oh, let it drift away 
</lyrics>
<genres>
<genre>Dance-rock</genre>
<genre>Synthpop</genre>
</genres>
</song>
<song name="I Bet My Life" duration="3:14" durationUnit="minutes:seconds">
<lyrics>
I know I took the path that you would never want for me 
I know I let you down, didn't I? 
So many sleepless nights where you were waiting up on me 
Well I'm just a slave unto the night 

Now remember when I told you that's the last you'll see of me 
Remember when I broke you down to tears 
I know I took the path that you would never want for me 
I gave you hell through all the years 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

I've been around the world and never in my wildest dreams 
Would I come running home to you 
I've told a million lies but now I tell a single truth 
There's you in everything I do 

Now remember when I told you that's the last you'll see of me 
Remember when I broke you down to tears 
I know I took the path that you would never want for me 
I gave you hell through all the years 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

Don't tell me that I'm wrong 
I've walked that road before 
And left you on your own 
And please believe them when they say 
That it's left for yesterday 
And the records that I've played 
Please forgive me for all I've done 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 
</lyrics>
<genres>
<genre>Folk Rock</genre>
<genre>Alternative Rock</genre>
</genres>
</song>
<song name="Gold" duration="3:37" durationUnit="minutes:seconds">
<lyrics>
First comes the blessing of all that you've dreamed, 
But then comes the curses of diamonds and rings. 
Only at first did it have its appeal, but now you can't tell the false from the real. 
Who can you trust? 
(Who can you trust?) 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 

Statues and empires are all at your hands, 
Water to wine and the finest of sands. 
When all that you have's turning stale and it's cold, 
Oh, you'll no longer feel when your heart's turned to gold. 
Who can you trust 
(Who can you trust) 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 

I'm dying to feel again, 
Oh, anything at all, 
But, oh, I feel nothin', nothin', nothin', nothin' 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 
</lyrics>
</song>
<genres>
<genre>Alternative Rock</genre>
<genre>Indie Rock</genre>
</genres>
</songs>
</album>
</artist>
<artist name="Of Monsters and Men" id="3">
<album name="My Head Is an Animal" releaseDate="2011">
<description>
My Head Is an Animal is the debut studio album by the Icelandic indie folk band Of Monsters and Men,
released through Record Records in Iceland on 20 September 2011. After their success, topping the Icelandic charts
with their debut single, "Little Talks", the band signed with Universal Music Group and the album was released in
North America through Republic Records on 3 April 2012. The title of the album comes from the second line in "Dirty Paws".
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/0/07/My_Head_Is_An_Animal.jpg</ImageUrl>
</albumCover>
<songs>
<song name="Dirty Paws" duration="4:38" durationUnit="minutes:seconds">
<lyrics>
Jumping up and down the floor, my head is an animal 
And once there was an animal, it had a son that mowed the lawn 
The son was an ok guy 
They had a pet dragonfly 
The dragonfly, it ran away 
But it came back with a story to say 

Her dirty paws and furry coat, she ran down the forest slope 
The forest of talking trees, they used to sing about the birds and the bees 
The bees had declared a war - the sky wasn't big enough for them all 
The birds, they got help from below 
From dirty paws and the creatures of snow 

And for a while things were cold, they were scared down in their holes 
The forest that once was green was coloured black by those killing machines 
But she and her furry friends took down the queen bee and her men 
And that's how the story goes, the story of the beast with those four dirty paws 
</lyrics>
<genres>
<genre>Indie Rock</genre>
<genre>Alternative Rock</genre>
</genres>
</song>
<song name="Little Talks" duration="4:26" durationUnit="minutes:seconds">
<lyrics>
Hey! Hey! Hey! 
I don't like walking around this old and empty house 
So hold my hand, I'll walk with you, my dear 
The stairs creak as you sleep, it's keeping me awake 
It's the house telling you to close your eyes 

And some days I can't even dress myself 
It's killing me to see you this way 

'Cause though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! Hey! Hey! 

There's an old voice in my head that's holding me back 
Well tell her that I miss our little talks 
Soon it will be over and buried with our past 
We used to play outside when we were young 
And full of life and full of love. 

Some days I don't know if I am wrong or right 
Your mind is playing tricks on you, my dear 

'Cause though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! 
Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! 
Hey! 

You're gone, gone, gone away 
I watched you disappear 
All that's left is the ghost of you. 
Now we're torn, torn, torn apart, 
There's nothing we can do 
Just let me go we'll meet again soon 
Now wait, wait, wait for me 
Please hang around 
I'll see you when I fall asleep 

Hey! 
Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 
Though the truth may vary 
This ship will carry our bodies safe to shore 

Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Though the truth may vary 
This ship will carry our bodies safe to shore 
</lyrics>
<genres>
<genre>Indie Pop</genre>
<genre>Indie Folk</genre>
</genres>
</song>
<song name="King And Lionheart" duration="4:33" durationUnit="minutes:seconds">
<lyrics>
Taking over this town they should worry, 
But these problems aside I think I taught you well. 
That we won't run, and we won't run, and we won't run. 

And in the winter night sky ships are sailing, 
Looking down on these bright blue city lights. 
And they won't wait, and they won't wait, and they won't wait. 
We're here to stay, we're here to stay, we're here to stay. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
A lionheart. 

His crown lit up the way as we moved slowly 
Past the wondering eyes of the ones that were left behind. 
Though far away, though far away, though far away 
We're still the same, we're still the same, we're still the same. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
And in the sea that's painted black, 
Creatures lurk below the deck 
But you're a king and I'm a lionheart. 

And as the world comes to an end 
I'll be here to hold your hand 
'Cause you're my king and I'm your lionheart. 
A lionheart. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
And in the sea that's painted black, 
Creatures lurk below the deck 
But you're a king and I'm a lionheart. 
A lionheart. 
</lyrics>
<genres>
<genre>Alternative Rock</genre>
<genre>Indie Rock</genre>
</genres>
</song>
</songs>
</album>
</artist>
</artists>
</music>
</pre>

===XSLT-HTML===
<pre>

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="html" indent="yes"/>

<xsl:template match="/">
<html>
<head>
<title>Muusika</title>
</head>
<body>
<h1>
2015 and newer albums
</h1>
<table border="1">
<tr>
<th>
<xsl:text>Artist</xsl:text>
</th>
<th>
<xsl:text>Album</xsl:text>
</th>
<th>
<xsl:text>Songs</xsl:text>
</th>
<th>
<xsl:text>Album cover</xsl:text>
</th>
</tr>
<xsl:for-each select="/music/artists/artist/album">
<xsl:if test="@releaseDate > 2014">
<xsl:for-each select="../.">
<tr>
<th>
<xsl:value-of select="@name"/>
</th>
<xsl:for-each select="album">
<td>
<xsl:value-of select="@name"/>
 
<xsl:text> Release year: </xsl:text>
<xsl:value-of select="@releaseDate"/>
</td>
<td>
<xsl:for-each select="songs/song">
<xsl:value-of select="@name"/>
<xsl:text> (</xsl:text>
<xsl:value-of select="@duration"/>
<xsl:text> </xsl:text>
<xsl:value-of select="@durationUnit"/>
<xsl:text>)</xsl:text>
 
</xsl:for-each>
</td>
<td>
<xsl:for-each select="albumCover/ImageUrl">
<xsl:variable name="img" select="."/>
<img src="{$img}"></img>
</xsl:for-each>
</td>
</xsl:for-each>
</tr>
</xsl:for-each>
</xsl:if>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

</pre>

===XSLT-XML===
<pre>

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
<xsl:text>Muusika kataloog</xsl:text>
<xsl:for-each select="artist[@id]">
<xsl:text></xsl:text>
<xsl:for-each select="artist/name">
<xsl:text></xsl:text>
<xsl:value-of select="album[@name][@releaseDate]" />
<xsl:text></xsl:text>
<xsl:text></xsl:text>
</xsl:for-each>
<xsl:value-of select="album/title"/>
<xsl:text></xsl:text>
<xsl:value-of select="album/description"/>
<xsl:text></xsl:text>
<img>
<xsl:attribute name="albumCover">
<xsl:value-of select="albumCover/ImageUrl"/>
</xsl:attribute>
</img>
<xsl:for-each select="Songs/song">
<xsl:text></xsl:text>
<xsl:value-of select="song[@duration][@durationUnit]"/>
<xsl:text></xsl:text>
<xsl:text></xsl:text>
<xsl:value-of select="song/title"/>
<xsl:text></xsl:text>
<xsl:value-of select="song/lyrics"/>
<xsl:text></xsl:text>
</xsl:for-each>
<xsl:for-each select="genres/genre">
<xsl:value-of select="genre"/>
<xsl:text></xsl:text>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

</pre>

===XSD===
<pre>
<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="music">
<xs:complexType>
<xs:sequence>
<xs:element name="artists">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="artist">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="album">
<xs:complexType>
<xs:sequence>
<xs:element name="description" type="xs:string" />
<xs:element name="albumCover">
<xs:complexType>
<xs:sequence>
<xs:element name="ImageUrl" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="songs">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="song">
<xs:complexType>
<xs:sequence>
<xs:element name="lyrics">
<xs:complexType mixed="true">
<xs:sequence>
<xs:element maxOccurs="unbounded" name="br" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="genres">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="genre" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="name" type="xs:string" use="required" />
<xs:attribute name="duration" type="xs:string" use="required" />
<xs:attribute name="durationUnit" type="xs:string" use="required" />
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="genres">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="genre" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="name" type="xs:string" use="required" />
<xs:attribute name="releaseDate" type="xs:unsignedShort" use="required" />
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="id" type="xs:unsignedLong" use="required" />
<xs:attribute name="name" type="xs:string" use="required" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

</pre>

== History ==
19.03.17 - Wiki Loodud 
19.03.17 - Lisatud 2 * XSLT ja XML fail. 
20.03.17 - Lisatud XSD fail

Meeskond "Nope":

2017-03-20T07:02:35Z

Rvell: /* History */

== Meeskond ==
* Raido Vell
* Taavi Vesinurm
* Kaspar Kaal
* Lisette Noor
* Madis Roosioks

== Idee ==

== XML Fail ==

===XML===
<pre>
<?xml version="1.0" encoding="utf-8" ?>

<music>
<artists>
<artist id="1" name="Michael Jackson">
<album name="Thriller" releaseDate="1982">
<description>
Thriller is the sixth studio album by American singer Michael Jackson,
released on November 30, 1982 by Epic Records. The follow-up to Jackson's successful previous album, Off the Wall (1979),
Thriller explores genres similar to those of its predecessor, including pop, post-disco, rock and funk.
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/5/55/Michael_Jackson_-_Thriller.png</ImageUrl>
</albumCover>
<songs>
<song name="Billie Jean" duration="4:54" durationUnit="minutes:seconds">
<lyrics>
She was more like a beauty queen from a movie scene 
I said don't mind, but what do you mean I am the one 
Who will dance on the floor in the round 
She said I am the one who will dance on the floor in the round 

She told me her name was Billie Jean, as she caused a scene 
Then every head turned with eyes that dreamed of being the one 
Who will dance on the floor in the round 

People always told me be careful of what you do 
And don't go around breaking young girls' hearts 
And mother always told me be careful of who you love 
And be careful of what you do 'cause the lie becomes the truth 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 

For forty days and forty nights 
The law was on her side 
But who can stand when she's in demand 
Her schemes and plans 
'cause we danced on the floor in the round 
So take my strong advice, just remember to always think twice 
(do think twice.) 

She told my baby we'd danced 'til three 
Then she looked at me 
She showed a photo of a baby crying 
His eyes looked like mine 
Go on dance on the floor in the round, baby 

People always told me be careful of what you do 
And don't go around breaking young girls' hearts 
She came and stood right by me 
Then the smell of sweet perfume 
This happened much too soon 
She called me to her room 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 

She says I am the one, but the kid is not my son 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 
She says I am the one, she says he is my son 
She says I am the one 
Billie Jean is not my lover 
Billie Jean is not my lover 

</lyrics>
<genres>
<genre>Post-disco</genre>
<genre>Rhythm and Blues</genre>
<genre>Funk</genre>
<genre>Dance-Pop</genre>
</genres>
</song>
<song name="Thriller" duration="5:58" durationUnit="minutes:seconds">
<lyrics>
It's close to midnight and something evil's lurking 
In the dark 
Under the moonlight you see a sight that almost stops 
Your heart 
You try to scream, but terror takes the sound before 
You make it 
You start to freeze as horror looks you right between 
The eyes 
You're paralyzed 

'Cause this is thriller, thriller night 
And no one's gonna save you from the beast about to 
Strike 
You know it's thriller, thriller night 
You're fighting for your life inside a killer 
Thriller tonight 

You hear the door slam and realize there's nowhere 
Left to run 
You feel the cold hand and wonder if you'll ever see 
The sun 
You close your eyes and hope that this is just 
Imagination 
But all the while you hear the creature creepin' up 
Behind 
You're out of time 

'Cause this is thriller, thriller night 
There ain't no second chance against the thing with 
Forty eyes 
You know it's thriller, thriller night 
You're fighting for your life inside a killer 
Thriller tonight 

Night creatures call 
And the dead start to walk in their masquerade 
There's no escapin' the jaws of the alien this time 
(They're open wide) 
This is the end of your life 

They're out to get you; there's demons closing in on 
Every side 
They will possess you unless you change the number on 
Your dial 
Now is the time for you and I to cuddle close 
Together 
All through the night I'll save you from the terrors on 
The screen 
I'll make you see 

That it's a thriller, thriller night 
'Cause I can thrill you more than any ghost 
Would ever dare try 
Girl, this is thriller, thriller night 
So let me hold you tight and share a killer, diller 
Chiller 
Thriller here tonight 

That it's a thriller, thriller night 
'Cause I can thrill you more than any ghost 
Would ever dare try 
Girl, this is thriller, thriller night 
So let me hold you tight and share a killer, diller 

Darkness falls across the land 
The midnight hour is close at hand 
Creatures crawl in search of blood 
To terrorize y'awl's neighborhood 
And whosoever shall be found 
Without the soul for getting down 
Must stand and face the hounds of hell 
And rot inside a corpse's shell 

The foulest stench is in the air 
The funk of forty thousand years 
And grizzly ghouls from every tomb 
Are closing in to seal your doom 
And though you fight to stay alive 
Your body starts to shiver 
For no mere mortal can resist 
The evil of the thriller 
</lyrics>
<genres>
<genre>Disco</genre>
<genre>Pop</genre>
</genres>
</song>
<song name="Beat it" duration="4:18" durationUnit="minutes:seconds">
<lyrics>
They told him don't you ever come around here 
Don't wanna see your face, you better disappear 
The fire's in their eyes and their words are really clear 
So beat it, just beat it 
You better run, you better do what you can 
Don't wanna see no blood, don't be a macho man 
You wanna be tough, better do what you can 
So beat it, but you wanna be bad 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 
Just beat it (beat it) 
Just beat it (beat it) 
Just beat it (beat it) 
Just beat it (beat it uuh) 

They're out to get you, better leave while you can 
Don't wanna be a boy, you wanna be a man 
You wanna stay alive, better do what you can 
So beat it, just beat it 
You have to show them that you're really not scared 
You're playin' with your life, this ain't no truth or dare 
They'll kick you, then they'll beat you 
Then they'll tell you it's fair 
So beat it, but you wanna be bad 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 
Just beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 

Beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it (beat it) 
</lyrics>
<genres>
<genre>Hard Rock</genre>
<genre>Dance-Rock</genre>
</genres>
</song>
</songs>
</album>
</artist>
<artist name="Imagine Dragons" id="2">
<album name="Smoke + Mirrors" releaseDate="2015">
<description>
Smoke + Mirrors is the second studio album by American rock band Imagine Dragons.
The album was recorded during 2014 at the band's home studio in Las Vegas, Nevada.
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/c/ce/Imagine_Dragons_-_Smoke_%2B_Mirrors.png</ImageUrl>
</albumCover>
<songs>
<song name="Shots" duration="3:52" durationUnit="minutes:seconds">
<lyrics>
I'm sorry for everything 
Oh, everything I've done 

Am I out of touch? 
Am I out of my place? 
When I keep saying that I'm looking for an empty space 
Oh, I'm wishing you're here 
But I'm wishing you're gone 
I can't have you and I'm only gonna do you wrong 

Oh, I'm going to mess this up 
Oh, this is just my luck 
Over and over and over again 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

Am I out of luck? 
Am I waiting to break? 
When I keep saying that I'm looking for a way to escape 
Oh, I'm wishing I had what I'd taken for granted 
I can't help you when I'm only gonna do you wrong 

Oh, I'm going to mess this up 
Oh, this is just my luck 
Over and over and over again 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

In the meantime we let it go 
At the roadside 
We used to know 
We can let this drift away 
Oh, we let this drift away 
At the bay side 
You used to show 
In the moonlight 
We let it go 
We can let this drift away 
Oh, we let this drift away 

And there's always time to change your mind 
Oh, there's always time to change your mind 
Oh, love, can you hear me? 
Oh, let it drift away 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

In the meantime we let it go 
At the roadside 
We used to know 
We can let this drift away 
Oh, we let this drift away 
At the bay side 
You used to show 
In the moonlight 
We let it go 
We can let this drift away 
Oh, we let this drift away 

And there's always time to change your mind 
Oh, there's always time to change your mind 
Oh, love, can you hear me? 
Oh, let it drift away 
</lyrics>
<genres>
<genre>Dance-rock</genre>
<genre>Synthpop</genre>
</genres>
</song>
<song name="I Bet My Life" duration="3:14" durationUnit="minutes:seconds">
<lyrics>
I know I took the path that you would never want for me 
I know I let you down, didn't I? 
So many sleepless nights where you were waiting up on me 
Well I'm just a slave unto the night 

Now remember when I told you that's the last you'll see of me 
Remember when I broke you down to tears 
I know I took the path that you would never want for me 
I gave you hell through all the years 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

I've been around the world and never in my wildest dreams 
Would I come running home to you 
I've told a million lies but now I tell a single truth 
There's you in everything I do 

Now remember when I told you that's the last you'll see of me 
Remember when I broke you down to tears 
I know I took the path that you would never want for me 
I gave you hell through all the years 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

Don't tell me that I'm wrong 
I've walked that road before 
And left you on your own 
And please believe them when they say 
That it's left for yesterday 
And the records that I've played 
Please forgive me for all I've done 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 
</lyrics>
<genres>
<genre>Folk Rock</genre>
<genre>Alternative Rock</genre>
</genres>
</song>
<song name="Gold" duration="3:37" durationUnit="minutes:seconds">
<lyrics>
First comes the blessing of all that you've dreamed, 
But then comes the curses of diamonds and rings. 
Only at first did it have its appeal, but now you can't tell the false from the real. 
Who can you trust? 
(Who can you trust?) 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 

Statues and empires are all at your hands, 
Water to wine and the finest of sands. 
When all that you have's turning stale and it's cold, 
Oh, you'll no longer feel when your heart's turned to gold. 
Who can you trust 
(Who can you trust) 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 

I'm dying to feel again, 
Oh, anything at all, 
But, oh, I feel nothin', nothin', nothin', nothin' 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 
</lyrics>
</song>
<genres>
<genre>Alternative Rock</genre>
<genre>Indie Rock</genre>
</genres>
</songs>
</album>
</artist>
<artist name="Of Monsters and Men" id="3">
<album name="My Head Is an Animal" releaseDate="2011">
<description>
My Head Is an Animal is the debut studio album by the Icelandic indie folk band Of Monsters and Men,
released through Record Records in Iceland on 20 September 2011. After their success, topping the Icelandic charts
with their debut single, "Little Talks", the band signed with Universal Music Group and the album was released in
North America through Republic Records on 3 April 2012. The title of the album comes from the second line in "Dirty Paws".
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/0/07/My_Head_Is_An_Animal.jpg</ImageUrl>
</albumCover>
<songs>
<song name="Dirty Paws" duration="4:38" durationUnit="minutes:seconds">
<lyrics>
Jumping up and down the floor, my head is an animal 
And once there was an animal, it had a son that mowed the lawn 
The son was an ok guy 
They had a pet dragonfly 
The dragonfly, it ran away 
But it came back with a story to say 

Her dirty paws and furry coat, she ran down the forest slope 
The forest of talking trees, they used to sing about the birds and the bees 
The bees had declared a war - the sky wasn't big enough for them all 
The birds, they got help from below 
From dirty paws and the creatures of snow 

And for a while things were cold, they were scared down in their holes 
The forest that once was green was coloured black by those killing machines 
But she and her furry friends took down the queen bee and her men 
And that's how the story goes, the story of the beast with those four dirty paws 
</lyrics>
<genres>
<genre>Indie Rock</genre>
<genre>Alternative Rock</genre>
</genres>
</song>
<song name="Little Talks" duration="4:26" durationUnit="minutes:seconds">
<lyrics>
Hey! Hey! Hey! 
I don't like walking around this old and empty house 
So hold my hand, I'll walk with you, my dear 
The stairs creak as you sleep, it's keeping me awake 
It's the house telling you to close your eyes 

And some days I can't even dress myself 
It's killing me to see you this way 

'Cause though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! Hey! Hey! 

There's an old voice in my head that's holding me back 
Well tell her that I miss our little talks 
Soon it will be over and buried with our past 
We used to play outside when we were young 
And full of life and full of love. 

Some days I don't know if I am wrong or right 
Your mind is playing tricks on you, my dear 

'Cause though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! 
Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! 
Hey! 

You're gone, gone, gone away 
I watched you disappear 
All that's left is the ghost of you. 
Now we're torn, torn, torn apart, 
There's nothing we can do 
Just let me go we'll meet again soon 
Now wait, wait, wait for me 
Please hang around 
I'll see you when I fall asleep 

Hey! 
Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 
Though the truth may vary 
This ship will carry our bodies safe to shore 

Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Though the truth may vary 
This ship will carry our bodies safe to shore 
</lyrics>
<genres>
<genre>Indie Pop</genre>
<genre>Indie Folk</genre>
</genres>
</song>
<song name="King And Lionheart" duration="4:33" durationUnit="minutes:seconds">
<lyrics>
Taking over this town they should worry, 
But these problems aside I think I taught you well. 
That we won't run, and we won't run, and we won't run. 

And in the winter night sky ships are sailing, 
Looking down on these bright blue city lights. 
And they won't wait, and they won't wait, and they won't wait. 
We're here to stay, we're here to stay, we're here to stay. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
A lionheart. 

His crown lit up the way as we moved slowly 
Past the wondering eyes of the ones that were left behind. 
Though far away, though far away, though far away 
We're still the same, we're still the same, we're still the same. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
And in the sea that's painted black, 
Creatures lurk below the deck 
But you're a king and I'm a lionheart. 

And as the world comes to an end 
I'll be here to hold your hand 
'Cause you're my king and I'm your lionheart. 
A lionheart. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
And in the sea that's painted black, 
Creatures lurk below the deck 
But you're a king and I'm a lionheart. 
A lionheart. 
</lyrics>
<genres>
<genre>Alternative Rock</genre>
<genre>Indie Rock</genre>
</genres>
</song>
</songs>
</album>
</artist>
</artists>
</music>
</pre>

===XSLT-HTML===
<pre>

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="html" indent="yes"/>

<xsl:template match="/">
<html>
<head>
<title>Muusika</title>
</head>
<body>
<h1>
2015 and newer albums
</h1>
<table border="1">
<tr>
<th>
<xsl:text>Artist</xsl:text>
</th>
<th>
<xsl:text>Album</xsl:text>
</th>
<th>
<xsl:text>Songs</xsl:text>
</th>
<th>
<xsl:text>Album cover</xsl:text>
</th>
</tr>
<xsl:for-each select="/music/artists/artist/album">
<xsl:if test="@releaseDate > 2014">
<xsl:for-each select="../.">
<tr>
<th>
<xsl:value-of select="@name"/>
</th>
<xsl:for-each select="album">
<td>
<xsl:value-of select="@name"/>
 
<xsl:text> Release year: </xsl:text>
<xsl:value-of select="@releaseDate"/>
</td>
<td>
<xsl:for-each select="songs/song">
<xsl:value-of select="@name"/>
<xsl:text> (</xsl:text>
<xsl:value-of select="@duration"/>
<xsl:text> </xsl:text>
<xsl:value-of select="@durationUnit"/>
<xsl:text>)</xsl:text>
 
</xsl:for-each>
</td>
<td>
<xsl:for-each select="albumCover/ImageUrl">
<xsl:variable name="img" select="."/>
<img src="{$img}"></img>
</xsl:for-each>
</td>
</xsl:for-each>
</tr>
</xsl:for-each>
</xsl:if>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

</pre>

===XSLT-XML===
<pre>

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
<xsl:text>Muusika kataloog</xsl:text>
<xsl:for-each select="artist[@id]">
<xsl:text></xsl:text>
<xsl:for-each select="artist/name">
<xsl:text></xsl:text>
<xsl:value-of select="album[@name][@releaseDate]" />
<xsl:text></xsl:text>
<xsl:text></xsl:text>
</xsl:for-each>
<xsl:value-of select="album/title"/>
<xsl:text></xsl:text>
<xsl:value-of select="album/description"/>
<xsl:text></xsl:text>
<img>
<xsl:attribute name="albumCover">
<xsl:value-of select="albumCover/ImageUrl"/>
</xsl:attribute>
</img>
<xsl:for-each select="Songs/song">
<xsl:text></xsl:text>
<xsl:value-of select="song[@duration][@durationUnit]"/>
<xsl:text></xsl:text>
<xsl:text></xsl:text>
<xsl:value-of select="song/title"/>
<xsl:text></xsl:text>
<xsl:value-of select="song/lyrics"/>
<xsl:text></xsl:text>
</xsl:for-each>
<xsl:for-each select="genres/genre">
<xsl:value-of select="genre"/>
<xsl:text></xsl:text>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

</pre>

===XSD===
<pre>
<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="music">
<xs:complexType>
<xs:sequence>
<xs:element name="artists">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="artist">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="album">
<xs:complexType>
<xs:sequence>
<xs:element name="description" type="xs:string" />
<xs:element name="albumCover">
<xs:complexType>
<xs:sequence>
<xs:element name="ImageUrl" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="songs">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="song">
<xs:complexType>
<xs:sequence>
<xs:element name="lyrics">
<xs:complexType mixed="true">
<xs:sequence>
<xs:element maxOccurs="unbounded" name="br" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="genres">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="genre" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="name" type="xs:string" use="required" />
<xs:attribute name="duration" type="xs:string" use="required" />
<xs:attribute name="durationUnit" type="xs:string" use="required" />
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="genres">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="genre" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="name" type="xs:string" use="required" />
<xs:attribute name="releaseDate" type="xs:unsignedShort" use="required" />
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="id" type="xs:unsignedLong" use="required" />
<xs:attribute name="name" type="xs:string" use="required" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

</pre>

== History ==
19.03.17 - Wiki Loodud 
19.03.17 - Lisatud 2 * XSLT ja XML fail. 
20.03.17 - Lisatud XSD fail (tehnilistel tõrgete tõttu hilines).

Meeskond "Nope":

2017-03-20T06:59:49Z

Rvell: /* XML Fail */

== Meeskond ==
* Raido Vell
* Taavi Vesinurm
* Kaspar Kaal
* Lisette Noor
* Madis Roosioks

== Idee ==

== XML Fail ==

===XML===
<pre>
<?xml version="1.0" encoding="utf-8" ?>

<music>
<artists>
<artist id="1" name="Michael Jackson">
<album name="Thriller" releaseDate="1982">
<description>
Thriller is the sixth studio album by American singer Michael Jackson,
released on November 30, 1982 by Epic Records. The follow-up to Jackson's successful previous album, Off the Wall (1979),
Thriller explores genres similar to those of its predecessor, including pop, post-disco, rock and funk.
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/5/55/Michael_Jackson_-_Thriller.png</ImageUrl>
</albumCover>
<songs>
<song name="Billie Jean" duration="4:54" durationUnit="minutes:seconds">
<lyrics>
She was more like a beauty queen from a movie scene 
I said don't mind, but what do you mean I am the one 
Who will dance on the floor in the round 
She said I am the one who will dance on the floor in the round 

She told me her name was Billie Jean, as she caused a scene 
Then every head turned with eyes that dreamed of being the one 
Who will dance on the floor in the round 

People always told me be careful of what you do 
And don't go around breaking young girls' hearts 
And mother always told me be careful of who you love 
And be careful of what you do 'cause the lie becomes the truth 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 

For forty days and forty nights 
The law was on her side 
But who can stand when she's in demand 
Her schemes and plans 
'cause we danced on the floor in the round 
So take my strong advice, just remember to always think twice 
(do think twice.) 

She told my baby we'd danced 'til three 
Then she looked at me 
She showed a photo of a baby crying 
His eyes looked like mine 
Go on dance on the floor in the round, baby 

People always told me be careful of what you do 
And don't go around breaking young girls' hearts 
She came and stood right by me 
Then the smell of sweet perfume 
This happened much too soon 
She called me to her room 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 

She says I am the one, but the kid is not my son 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 
She says I am the one, she says he is my son 
She says I am the one 
Billie Jean is not my lover 
Billie Jean is not my lover 

</lyrics>
<genres>
<genre>Post-disco</genre>
<genre>Rhythm and Blues</genre>
<genre>Funk</genre>
<genre>Dance-Pop</genre>
</genres>
</song>
<song name="Thriller" duration="5:58" durationUnit="minutes:seconds">
<lyrics>
It's close to midnight and something evil's lurking 
In the dark 
Under the moonlight you see a sight that almost stops 
Your heart 
You try to scream, but terror takes the sound before 
You make it 
You start to freeze as horror looks you right between 
The eyes 
You're paralyzed 

'Cause this is thriller, thriller night 
And no one's gonna save you from the beast about to 
Strike 
You know it's thriller, thriller night 
You're fighting for your life inside a killer 
Thriller tonight 

You hear the door slam and realize there's nowhere 
Left to run 
You feel the cold hand and wonder if you'll ever see 
The sun 
You close your eyes and hope that this is just 
Imagination 
But all the while you hear the creature creepin' up 
Behind 
You're out of time 

'Cause this is thriller, thriller night 
There ain't no second chance against the thing with 
Forty eyes 
You know it's thriller, thriller night 
You're fighting for your life inside a killer 
Thriller tonight 

Night creatures call 
And the dead start to walk in their masquerade 
There's no escapin' the jaws of the alien this time 
(They're open wide) 
This is the end of your life 

They're out to get you; there's demons closing in on 
Every side 
They will possess you unless you change the number on 
Your dial 
Now is the time for you and I to cuddle close 
Together 
All through the night I'll save you from the terrors on 
The screen 
I'll make you see 

That it's a thriller, thriller night 
'Cause I can thrill you more than any ghost 
Would ever dare try 
Girl, this is thriller, thriller night 
So let me hold you tight and share a killer, diller 
Chiller 
Thriller here tonight 

That it's a thriller, thriller night 
'Cause I can thrill you more than any ghost 
Would ever dare try 
Girl, this is thriller, thriller night 
So let me hold you tight and share a killer, diller 

Darkness falls across the land 
The midnight hour is close at hand 
Creatures crawl in search of blood 
To terrorize y'awl's neighborhood 
And whosoever shall be found 
Without the soul for getting down 
Must stand and face the hounds of hell 
And rot inside a corpse's shell 

The foulest stench is in the air 
The funk of forty thousand years 
And grizzly ghouls from every tomb 
Are closing in to seal your doom 
And though you fight to stay alive 
Your body starts to shiver 
For no mere mortal can resist 
The evil of the thriller 
</lyrics>
<genres>
<genre>Disco</genre>
<genre>Pop</genre>
</genres>
</song>
<song name="Beat it" duration="4:18" durationUnit="minutes:seconds">
<lyrics>
They told him don't you ever come around here 
Don't wanna see your face, you better disappear 
The fire's in their eyes and their words are really clear 
So beat it, just beat it 
You better run, you better do what you can 
Don't wanna see no blood, don't be a macho man 
You wanna be tough, better do what you can 
So beat it, but you wanna be bad 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 
Just beat it (beat it) 
Just beat it (beat it) 
Just beat it (beat it) 
Just beat it (beat it uuh) 

They're out to get you, better leave while you can 
Don't wanna be a boy, you wanna be a man 
You wanna stay alive, better do what you can 
So beat it, just beat it 
You have to show them that you're really not scared 
You're playin' with your life, this ain't no truth or dare 
They'll kick you, then they'll beat you 
Then they'll tell you it's fair 
So beat it, but you wanna be bad 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 
Just beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 

Beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it (beat it) 
</lyrics>
<genres>
<genre>Hard Rock</genre>
<genre>Dance-Rock</genre>
</genres>
</song>
</songs>
</album>
</artist>
<artist name="Imagine Dragons" id="2">
<album name="Smoke + Mirrors" releaseDate="2015">
<description>
Smoke + Mirrors is the second studio album by American rock band Imagine Dragons.
The album was recorded during 2014 at the band's home studio in Las Vegas, Nevada.
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/c/ce/Imagine_Dragons_-_Smoke_%2B_Mirrors.png</ImageUrl>
</albumCover>
<songs>
<song name="Shots" duration="3:52" durationUnit="minutes:seconds">
<lyrics>
I'm sorry for everything 
Oh, everything I've done 

Am I out of touch? 
Am I out of my place? 
When I keep saying that I'm looking for an empty space 
Oh, I'm wishing you're here 
But I'm wishing you're gone 
I can't have you and I'm only gonna do you wrong 

Oh, I'm going to mess this up 
Oh, this is just my luck 
Over and over and over again 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

Am I out of luck? 
Am I waiting to break? 
When I keep saying that I'm looking for a way to escape 
Oh, I'm wishing I had what I'd taken for granted 
I can't help you when I'm only gonna do you wrong 

Oh, I'm going to mess this up 
Oh, this is just my luck 
Over and over and over again 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

In the meantime we let it go 
At the roadside 
We used to know 
We can let this drift away 
Oh, we let this drift away 
At the bay side 
You used to show 
In the moonlight 
We let it go 
We can let this drift away 
Oh, we let this drift away 

And there's always time to change your mind 
Oh, there's always time to change your mind 
Oh, love, can you hear me? 
Oh, let it drift away 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

In the meantime we let it go 
At the roadside 
We used to know 
We can let this drift away 
Oh, we let this drift away 
At the bay side 
You used to show 
In the moonlight 
We let it go 
We can let this drift away 
Oh, we let this drift away 

And there's always time to change your mind 
Oh, there's always time to change your mind 
Oh, love, can you hear me? 
Oh, let it drift away 
</lyrics>
<genres>
<genre>Dance-rock</genre>
<genre>Synthpop</genre>
</genres>
</song>
<song name="I Bet My Life" duration="3:14" durationUnit="minutes:seconds">
<lyrics>
I know I took the path that you would never want for me 
I know I let you down, didn't I? 
So many sleepless nights where you were waiting up on me 
Well I'm just a slave unto the night 

Now remember when I told you that's the last you'll see of me 
Remember when I broke you down to tears 
I know I took the path that you would never want for me 
I gave you hell through all the years 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

I've been around the world and never in my wildest dreams 
Would I come running home to you 
I've told a million lies but now I tell a single truth 
There's you in everything I do 

Now remember when I told you that's the last you'll see of me 
Remember when I broke you down to tears 
I know I took the path that you would never want for me 
I gave you hell through all the years 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

Don't tell me that I'm wrong 
I've walked that road before 
And left you on your own 
And please believe them when they say 
That it's left for yesterday 
And the records that I've played 
Please forgive me for all I've done 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 
</lyrics>
<genres>
<genre>Folk Rock</genre>
<genre>Alternative Rock</genre>
</genres>
</song>
<song name="Gold" duration="3:37" durationUnit="minutes:seconds">
<lyrics>
First comes the blessing of all that you've dreamed, 
But then comes the curses of diamonds and rings. 
Only at first did it have its appeal, but now you can't tell the false from the real. 
Who can you trust? 
(Who can you trust?) 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 

Statues and empires are all at your hands, 
Water to wine and the finest of sands. 
When all that you have's turning stale and it's cold, 
Oh, you'll no longer feel when your heart's turned to gold. 
Who can you trust 
(Who can you trust) 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 

I'm dying to feel again, 
Oh, anything at all, 
But, oh, I feel nothin', nothin', nothin', nothin' 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 
</lyrics>
</song>
<genres>
<genre>Alternative Rock</genre>
<genre>Indie Rock</genre>
</genres>
</songs>
</album>
</artist>
<artist name="Of Monsters and Men" id="3">
<album name="My Head Is an Animal" releaseDate="2011">
<description>
My Head Is an Animal is the debut studio album by the Icelandic indie folk band Of Monsters and Men,
released through Record Records in Iceland on 20 September 2011. After their success, topping the Icelandic charts
with their debut single, "Little Talks", the band signed with Universal Music Group and the album was released in
North America through Republic Records on 3 April 2012. The title of the album comes from the second line in "Dirty Paws".
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/0/07/My_Head_Is_An_Animal.jpg</ImageUrl>
</albumCover>
<songs>
<song name="Dirty Paws" duration="4:38" durationUnit="minutes:seconds">
<lyrics>
Jumping up and down the floor, my head is an animal 
And once there was an animal, it had a son that mowed the lawn 
The son was an ok guy 
They had a pet dragonfly 
The dragonfly, it ran away 
But it came back with a story to say 

Her dirty paws and furry coat, she ran down the forest slope 
The forest of talking trees, they used to sing about the birds and the bees 
The bees had declared a war - the sky wasn't big enough for them all 
The birds, they got help from below 
From dirty paws and the creatures of snow 

And for a while things were cold, they were scared down in their holes 
The forest that once was green was coloured black by those killing machines 
But she and her furry friends took down the queen bee and her men 
And that's how the story goes, the story of the beast with those four dirty paws 
</lyrics>
<genres>
<genre>Indie Rock</genre>
<genre>Alternative Rock</genre>
</genres>
</song>
<song name="Little Talks" duration="4:26" durationUnit="minutes:seconds">
<lyrics>
Hey! Hey! Hey! 
I don't like walking around this old and empty house 
So hold my hand, I'll walk with you, my dear 
The stairs creak as you sleep, it's keeping me awake 
It's the house telling you to close your eyes 

And some days I can't even dress myself 
It's killing me to see you this way 

'Cause though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! Hey! Hey! 

There's an old voice in my head that's holding me back 
Well tell her that I miss our little talks 
Soon it will be over and buried with our past 
We used to play outside when we were young 
And full of life and full of love. 

Some days I don't know if I am wrong or right 
Your mind is playing tricks on you, my dear 

'Cause though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! 
Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! 
Hey! 

You're gone, gone, gone away 
I watched you disappear 
All that's left is the ghost of you. 
Now we're torn, torn, torn apart, 
There's nothing we can do 
Just let me go we'll meet again soon 
Now wait, wait, wait for me 
Please hang around 
I'll see you when I fall asleep 

Hey! 
Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 
Though the truth may vary 
This ship will carry our bodies safe to shore 

Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Though the truth may vary 
This ship will carry our bodies safe to shore 
</lyrics>
<genres>
<genre>Indie Pop</genre>
<genre>Indie Folk</genre>
</genres>
</song>
<song name="King And Lionheart" duration="4:33" durationUnit="minutes:seconds">
<lyrics>
Taking over this town they should worry, 
But these problems aside I think I taught you well. 
That we won't run, and we won't run, and we won't run. 

And in the winter night sky ships are sailing, 
Looking down on these bright blue city lights. 
And they won't wait, and they won't wait, and they won't wait. 
We're here to stay, we're here to stay, we're here to stay. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
A lionheart. 

His crown lit up the way as we moved slowly 
Past the wondering eyes of the ones that were left behind. 
Though far away, though far away, though far away 
We're still the same, we're still the same, we're still the same. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
And in the sea that's painted black, 
Creatures lurk below the deck 
But you're a king and I'm a lionheart. 

And as the world comes to an end 
I'll be here to hold your hand 
'Cause you're my king and I'm your lionheart. 
A lionheart. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
And in the sea that's painted black, 
Creatures lurk below the deck 
But you're a king and I'm a lionheart. 
A lionheart. 
</lyrics>
<genres>
<genre>Alternative Rock</genre>
<genre>Indie Rock</genre>
</genres>
</song>
</songs>
</album>
</artist>
</artists>
</music>
</pre>

===XSLT-HTML===
<pre>

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="html" indent="yes"/>

<xsl:template match="/">
<html>
<head>
<title>Muusika</title>
</head>
<body>
<h1>
2015 and newer albums
</h1>
<table border="1">
<tr>
<th>
<xsl:text>Artist</xsl:text>
</th>
<th>
<xsl:text>Album</xsl:text>
</th>
<th>
<xsl:text>Songs</xsl:text>
</th>
<th>
<xsl:text>Album cover</xsl:text>
</th>
</tr>
<xsl:for-each select="/music/artists/artist/album">
<xsl:if test="@releaseDate > 2014">
<xsl:for-each select="../.">
<tr>
<th>
<xsl:value-of select="@name"/>
</th>
<xsl:for-each select="album">
<td>
<xsl:value-of select="@name"/>
 
<xsl:text> Release year: </xsl:text>
<xsl:value-of select="@releaseDate"/>
</td>
<td>
<xsl:for-each select="songs/song">
<xsl:value-of select="@name"/>
<xsl:text> (</xsl:text>
<xsl:value-of select="@duration"/>
<xsl:text> </xsl:text>
<xsl:value-of select="@durationUnit"/>
<xsl:text>)</xsl:text>
 
</xsl:for-each>
</td>
<td>
<xsl:for-each select="albumCover/ImageUrl">
<xsl:variable name="img" select="."/>
<img src="{$img}"></img>
</xsl:for-each>
</td>
</xsl:for-each>
</tr>
</xsl:for-each>
</xsl:if>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

</pre>

===XSLT-XML===
<pre>

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
<xsl:text>Muusika kataloog</xsl:text>
<xsl:for-each select="artist[@id]">
<xsl:text></xsl:text>
<xsl:for-each select="artist/name">
<xsl:text></xsl:text>
<xsl:value-of select="album[@name][@releaseDate]" />
<xsl:text></xsl:text>
<xsl:text></xsl:text>
</xsl:for-each>
<xsl:value-of select="album/title"/>
<xsl:text></xsl:text>
<xsl:value-of select="album/description"/>
<xsl:text></xsl:text>
<img>
<xsl:attribute name="albumCover">
<xsl:value-of select="albumCover/ImageUrl"/>
</xsl:attribute>
</img>
<xsl:for-each select="Songs/song">
<xsl:text></xsl:text>
<xsl:value-of select="song[@duration][@durationUnit]"/>
<xsl:text></xsl:text>
<xsl:text></xsl:text>
<xsl:value-of select="song/title"/>
<xsl:text></xsl:text>
<xsl:value-of select="song/lyrics"/>
<xsl:text></xsl:text>
</xsl:for-each>
<xsl:for-each select="genres/genre">
<xsl:value-of select="genre"/>
<xsl:text></xsl:text>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

</pre>

===XSD===
<pre>
<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="music">
<xs:complexType>
<xs:sequence>
<xs:element name="artists">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="artist">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="album">
<xs:complexType>
<xs:sequence>
<xs:element name="description" type="xs:string" />
<xs:element name="albumCover">
<xs:complexType>
<xs:sequence>
<xs:element name="ImageUrl" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="songs">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="song">
<xs:complexType>
<xs:sequence>
<xs:element name="lyrics">
<xs:complexType mixed="true">
<xs:sequence>
<xs:element maxOccurs="unbounded" name="br" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="genres">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="genre" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="name" type="xs:string" use="required" />
<xs:attribute name="duration" type="xs:string" use="required" />
<xs:attribute name="durationUnit" type="xs:string" use="required" />
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="genres">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="genre" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="name" type="xs:string" use="required" />
<xs:attribute name="releaseDate" type="xs:unsignedShort" use="required" />
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="id" type="xs:unsignedLong" use="required" />
<xs:attribute name="name" type="xs:string" use="required" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

</pre>

== History ==
19.03.17 - Wiki Loodud 
19.03.17 - Lisatud 2 * XSLT ja XML fail.

Meeskond "Nope":

2017-03-19T20:06:08Z

Rvell: Created page with "== Meeskond == * Raido Vell * Taavi Vesinurm * Kaspar Kaal * Lisette Noor * Madis Roosioks == Idee == == XML Fail == ===XML=== <pre> <?xml version="1.0" encoding="utf-8" ?>..."

== Meeskond ==
* Raido Vell
* Taavi Vesinurm
* Kaspar Kaal
* Lisette Noor
* Madis Roosioks

== Idee ==

== XML Fail ==

===XML===
<pre>
<?xml version="1.0" encoding="utf-8" ?>

<music>
<artists>
<artist id="1" name="Michael Jackson">
<album name="Thriller" releaseDate="1982">
<description>
Thriller is the sixth studio album by American singer Michael Jackson,
released on November 30, 1982 by Epic Records. The follow-up to Jackson's successful previous album, Off the Wall (1979),
Thriller explores genres similar to those of its predecessor, including pop, post-disco, rock and funk.
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/5/55/Michael_Jackson_-_Thriller.png</ImageUrl>
</albumCover>
<songs>
<song name="Billie Jean" duration="4:54" durationUnit="minutes:seconds">
<lyrics>
She was more like a beauty queen from a movie scene 
I said don't mind, but what do you mean I am the one 
Who will dance on the floor in the round 
She said I am the one who will dance on the floor in the round 

She told me her name was Billie Jean, as she caused a scene 
Then every head turned with eyes that dreamed of being the one 
Who will dance on the floor in the round 

People always told me be careful of what you do 
And don't go around breaking young girls' hearts 
And mother always told me be careful of who you love 
And be careful of what you do 'cause the lie becomes the truth 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 

For forty days and forty nights 
The law was on her side 
But who can stand when she's in demand 
Her schemes and plans 
'cause we danced on the floor in the round 
So take my strong advice, just remember to always think twice 
(do think twice.) 

She told my baby we'd danced 'til three 
Then she looked at me 
She showed a photo of a baby crying 
His eyes looked like mine 
Go on dance on the floor in the round, baby 

People always told me be careful of what you do 
And don't go around breaking young girls' hearts 
She came and stood right by me 
Then the smell of sweet perfume 
This happened much too soon 
She called me to her room 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 

She says I am the one, but the kid is not my son 

Billie Jean is not my lover 
She's just a girl who claims that I am the one 
But the kid is not my son 
She says I am the one, but the kid is not my son 
She says I am the one, she says he is my son 
She says I am the one 
Billie Jean is not my lover 
Billie Jean is not my lover 

</lyrics>
<genres>
<genre>Post-disco</genre>
<genre>Rhythm and Blues</genre>
<genre>Funk</genre>
<genre>Dance-Pop</genre>
</genres>
</song>
<song name="Thriller" duration="5:58" durationUnit="minutes:seconds">
<lyrics>
It's close to midnight and something evil's lurking 
In the dark 
Under the moonlight you see a sight that almost stops 
Your heart 
You try to scream, but terror takes the sound before 
You make it 
You start to freeze as horror looks you right between 
The eyes 
You're paralyzed 

'Cause this is thriller, thriller night 
And no one's gonna save you from the beast about to 
Strike 
You know it's thriller, thriller night 
You're fighting for your life inside a killer 
Thriller tonight 

You hear the door slam and realize there's nowhere 
Left to run 
You feel the cold hand and wonder if you'll ever see 
The sun 
You close your eyes and hope that this is just 
Imagination 
But all the while you hear the creature creepin' up 
Behind 
You're out of time 

'Cause this is thriller, thriller night 
There ain't no second chance against the thing with 
Forty eyes 
You know it's thriller, thriller night 
You're fighting for your life inside a killer 
Thriller tonight 

Night creatures call 
And the dead start to walk in their masquerade 
There's no escapin' the jaws of the alien this time 
(They're open wide) 
This is the end of your life 

They're out to get you; there's demons closing in on 
Every side 
They will possess you unless you change the number on 
Your dial 
Now is the time for you and I to cuddle close 
Together 
All through the night I'll save you from the terrors on 
The screen 
I'll make you see 

That it's a thriller, thriller night 
'Cause I can thrill you more than any ghost 
Would ever dare try 
Girl, this is thriller, thriller night 
So let me hold you tight and share a killer, diller 
Chiller 
Thriller here tonight 

That it's a thriller, thriller night 
'Cause I can thrill you more than any ghost 
Would ever dare try 
Girl, this is thriller, thriller night 
So let me hold you tight and share a killer, diller 

Darkness falls across the land 
The midnight hour is close at hand 
Creatures crawl in search of blood 
To terrorize y'awl's neighborhood 
And whosoever shall be found 
Without the soul for getting down 
Must stand and face the hounds of hell 
And rot inside a corpse's shell 

The foulest stench is in the air 
The funk of forty thousand years 
And grizzly ghouls from every tomb 
Are closing in to seal your doom 
And though you fight to stay alive 
Your body starts to shiver 
For no mere mortal can resist 
The evil of the thriller 
</lyrics>
<genres>
<genre>Disco</genre>
<genre>Pop</genre>
</genres>
</song>
<song name="Beat it" duration="4:18" durationUnit="minutes:seconds">
<lyrics>
They told him don't you ever come around here 
Don't wanna see your face, you better disappear 
The fire's in their eyes and their words are really clear 
So beat it, just beat it 
You better run, you better do what you can 
Don't wanna see no blood, don't be a macho man 
You wanna be tough, better do what you can 
So beat it, but you wanna be bad 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 
Just beat it (beat it) 
Just beat it (beat it) 
Just beat it (beat it) 
Just beat it (beat it uuh) 

They're out to get you, better leave while you can 
Don't wanna be a boy, you wanna be a man 
You wanna stay alive, better do what you can 
So beat it, just beat it 
You have to show them that you're really not scared 
You're playin' with your life, this ain't no truth or dare 
They'll kick you, then they'll beat you 
Then they'll tell you it's fair 
So beat it, but you wanna be bad 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 
Just beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 
Beat it (beat it) 

Beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it, beat it, beat it, beat it 
No one wants to be defeated 
Showin' how funky and strong is your fight 
It doesn't matter who's wrong or right 

Just beat it (beat it) 
</lyrics>
<genres>
<genre>Hard Rock</genre>
<genre>Dance-Rock</genre>
</genres>
</song>
</songs>
</album>
</artist>
<artist name="Imagine Dragons" id="2">
<album name="Smoke + Mirrors" releaseDate="2015">
<description>
Smoke + Mirrors is the second studio album by American rock band Imagine Dragons.
The album was recorded during 2014 at the band's home studio in Las Vegas, Nevada.
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/c/ce/Imagine_Dragons_-_Smoke_%2B_Mirrors.png</ImageUrl>
</albumCover>
<songs>
<song name="Shots" duration="3:52" durationUnit="minutes:seconds">
<lyrics>
I'm sorry for everything 
Oh, everything I've done 

Am I out of touch? 
Am I out of my place? 
When I keep saying that I'm looking for an empty space 
Oh, I'm wishing you're here 
But I'm wishing you're gone 
I can't have you and I'm only gonna do you wrong 

Oh, I'm going to mess this up 
Oh, this is just my luck 
Over and over and over again 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

Am I out of luck? 
Am I waiting to break? 
When I keep saying that I'm looking for a way to escape 
Oh, I'm wishing I had what I'd taken for granted 
I can't help you when I'm only gonna do you wrong 

Oh, I'm going to mess this up 
Oh, this is just my luck 
Over and over and over again 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

In the meantime we let it go 
At the roadside 
We used to know 
We can let this drift away 
Oh, we let this drift away 
At the bay side 
You used to show 
In the moonlight 
We let it go 
We can let this drift away 
Oh, we let this drift away 

And there's always time to change your mind 
Oh, there's always time to change your mind 
Oh, love, can you hear me? 
Oh, let it drift away 

I'm sorry for everything 
Oh, everything I've done 
From the second that I was born it seems I had a loaded gun 
And then I shot, shot, shot a hole through everything I loved 
Oh, I shot, shot, shot a hole through every single thing that I loved 

In the meantime we let it go 
At the roadside 
We used to know 
We can let this drift away 
Oh, we let this drift away 
At the bay side 
You used to show 
In the moonlight 
We let it go 
We can let this drift away 
Oh, we let this drift away 

And there's always time to change your mind 
Oh, there's always time to change your mind 
Oh, love, can you hear me? 
Oh, let it drift away 
</lyrics>
<genres>
<genre>Dance-rock</genre>
<genre>Synthpop</genre>
</genres>
</song>
<song name="I Bet My Life" duration="3:14" durationUnit="minutes:seconds">
<lyrics>
I know I took the path that you would never want for me 
I know I let you down, didn't I? 
So many sleepless nights where you were waiting up on me 
Well I'm just a slave unto the night 

Now remember when I told you that's the last you'll see of me 
Remember when I broke you down to tears 
I know I took the path that you would never want for me 
I gave you hell through all the years 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

I've been around the world and never in my wildest dreams 
Would I come running home to you 
I've told a million lies but now I tell a single truth 
There's you in everything I do 

Now remember when I told you that's the last you'll see of me 
Remember when I broke you down to tears 
I know I took the path that you would never want for me 
I gave you hell through all the years 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

Don't tell me that I'm wrong 
I've walked that road before 
And left you on your own 
And please believe them when they say 
That it's left for yesterday 
And the records that I've played 
Please forgive me for all I've done 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 

So I, I bet my life, I bet my life 
I bet my life on you 
I, I bet my life, I bet my life 
I bet my life on you 
</lyrics>
<genres>
<genre>Folk Rock</genre>
<genre>Alternative Rock</genre>
</genres>
</song>
<song name="Gold" duration="3:37" durationUnit="minutes:seconds">
<lyrics>
First comes the blessing of all that you've dreamed, 
But then comes the curses of diamonds and rings. 
Only at first did it have its appeal, but now you can't tell the false from the real. 
Who can you trust? 
(Who can you trust?) 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 

Statues and empires are all at your hands, 
Water to wine and the finest of sands. 
When all that you have's turning stale and it's cold, 
Oh, you'll no longer feel when your heart's turned to gold. 
Who can you trust 
(Who can you trust) 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 

I'm dying to feel again, 
Oh, anything at all, 
But, oh, I feel nothin', nothin', nothin', nothin' 

When everything, everything, everything you touch turns to gold, gold, gold. 
When everything, everything, everything you touch turns to gold, gold 
(Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa 
Ooh, gold, whoa) 
</lyrics>
</song>
<genres>
<genre>Alternative Rock</genre>
<genre>Indie Rock</genre>
</genres>
</songs>
</album>
</artist>
<artist name="Of Monsters and Men" id="3">
<album name="My Head Is an Animal" releaseDate="2011">
<description>
My Head Is an Animal is the debut studio album by the Icelandic indie folk band Of Monsters and Men,
released through Record Records in Iceland on 20 September 2011. After their success, topping the Icelandic charts
with their debut single, "Little Talks", the band signed with Universal Music Group and the album was released in
North America through Republic Records on 3 April 2012. The title of the album comes from the second line in "Dirty Paws".
</description>
<albumCover>
<ImageUrl>https://upload.wikimedia.org/wikipedia/en/0/07/My_Head_Is_An_Animal.jpg</ImageUrl>
</albumCover>
<songs>
<song name="Dirty Paws" duration="4:38" durationUnit="minutes:seconds">
<lyrics>
Jumping up and down the floor, my head is an animal 
And once there was an animal, it had a son that mowed the lawn 
The son was an ok guy 
They had a pet dragonfly 
The dragonfly, it ran away 
But it came back with a story to say 

Her dirty paws and furry coat, she ran down the forest slope 
The forest of talking trees, they used to sing about the birds and the bees 
The bees had declared a war - the sky wasn't big enough for them all 
The birds, they got help from below 
From dirty paws and the creatures of snow 

And for a while things were cold, they were scared down in their holes 
The forest that once was green was coloured black by those killing machines 
But she and her furry friends took down the queen bee and her men 
And that's how the story goes, the story of the beast with those four dirty paws 
</lyrics>
<genres>
<genre>Indie Rock</genre>
<genre>Alternative Rock</genre>
</genres>
</song>
<song name="Little Talks" duration="4:26" durationUnit="minutes:seconds">
<lyrics>
Hey! Hey! Hey! 
I don't like walking around this old and empty house 
So hold my hand, I'll walk with you, my dear 
The stairs creak as you sleep, it's keeping me awake 
It's the house telling you to close your eyes 

And some days I can't even dress myself 
It's killing me to see you this way 

'Cause though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! Hey! Hey! 

There's an old voice in my head that's holding me back 
Well tell her that I miss our little talks 
Soon it will be over and buried with our past 
We used to play outside when we were young 
And full of life and full of love. 

Some days I don't know if I am wrong or right 
Your mind is playing tricks on you, my dear 

'Cause though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! 
Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Hey! 
Hey! 

You're gone, gone, gone away 
I watched you disappear 
All that's left is the ghost of you. 
Now we're torn, torn, torn apart, 
There's nothing we can do 
Just let me go we'll meet again soon 
Now wait, wait, wait for me 
Please hang around 
I'll see you when I fall asleep 

Hey! 
Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 
Though the truth may vary 
This ship will carry our bodies safe to shore 

Don't listen to a word I say 
Hey! 
The screams all sound the same 
Hey! 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Though the truth may vary 
This ship will carry our bodies safe to shore 

Though the truth may vary 
This ship will carry our bodies safe to shore 
</lyrics>
<genres>
<genre>Indie Pop</genre>
<genre>Indie Folk</genre>
</genres>
</song>
<song name="King And Lionheart" duration="4:33" durationUnit="minutes:seconds">
<lyrics>
Taking over this town they should worry, 
But these problems aside I think I taught you well. 
That we won't run, and we won't run, and we won't run. 

And in the winter night sky ships are sailing, 
Looking down on these bright blue city lights. 
And they won't wait, and they won't wait, and they won't wait. 
We're here to stay, we're here to stay, we're here to stay. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
A lionheart. 

His crown lit up the way as we moved slowly 
Past the wondering eyes of the ones that were left behind. 
Though far away, though far away, though far away 
We're still the same, we're still the same, we're still the same. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
And in the sea that's painted black, 
Creatures lurk below the deck 
But you're a king and I'm a lionheart. 

And as the world comes to an end 
I'll be here to hold your hand 
'Cause you're my king and I'm your lionheart. 
A lionheart. 

Howling ghosts – they reappear 
In mountains that are stacked with fear 
But you're a king and I'm a lionheart. 
And in the sea that's painted black, 
Creatures lurk below the deck 
But you're a king and I'm a lionheart. 
A lionheart. 
</lyrics>
<genres>
<genre>Alternative Rock</genre>
<genre>Indie Rock</genre>
</genres>
</song>
</songs>
</album>
</artist>
</artists>
</music>
</pre>

===XSLT-HTML===
<pre>

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="html" indent="yes"/>

<xsl:template match="/">
<html>
<head>
<title>Muusika</title>
</head>
<body>
<h1>
2015 and newer albums
</h1>
<table border="1">
<tr>
<th>
<xsl:text>Artist</xsl:text>
</th>
<th>
<xsl:text>Album</xsl:text>
</th>
<th>
<xsl:text>Songs</xsl:text>
</th>
<th>
<xsl:text>Album cover</xsl:text>
</th>
</tr>
<xsl:for-each select="/music/artists/artist/album">
<xsl:if test="@releaseDate > 2014">
<xsl:for-each select="../.">
<tr>
<th>
<xsl:value-of select="@name"/>
</th>
<xsl:for-each select="album">
<td>
<xsl:value-of select="@name"/>
 
<xsl:text> Release year: </xsl:text>
<xsl:value-of select="@releaseDate"/>
</td>
<td>
<xsl:for-each select="songs/song">
<xsl:value-of select="@name"/>
<xsl:text> (</xsl:text>
<xsl:value-of select="@duration"/>
<xsl:text> </xsl:text>
<xsl:value-of select="@durationUnit"/>
<xsl:text>)</xsl:text>
 
</xsl:for-each>
</td>
<td>
<xsl:for-each select="albumCover/ImageUrl">
<xsl:variable name="img" select="."/>
<img src="{$img}"></img>
</xsl:for-each>
</td>
</xsl:for-each>
</tr>
</xsl:for-each>
</xsl:if>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

</pre>

===XSLT-XML===
<pre>

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
<xsl:text>Muusika kataloog</xsl:text>
<xsl:for-each select="artist[@id]">
<xsl:text></xsl:text>
<xsl:for-each select="artist/name">
<xsl:text></xsl:text>
<xsl:value-of select="album[@name][@releaseDate]" />
<xsl:text></xsl:text>
<xsl:text></xsl:text>
</xsl:for-each>
<xsl:value-of select="album/title"/>
<xsl:text></xsl:text>
<xsl:value-of select="album/description"/>
<xsl:text></xsl:text>
<img>
<xsl:attribute name="albumCover">
<xsl:value-of select="albumCover/ImageUrl"/>
</xsl:attribute>
</img>
<xsl:for-each select="Songs/song">
<xsl:text></xsl:text>
<xsl:value-of select="song[@duration][@durationUnit]"/>
<xsl:text></xsl:text>
<xsl:text></xsl:text>
<xsl:value-of select="song/title"/>
<xsl:text></xsl:text>
<xsl:value-of select="song/lyrics"/>
<xsl:text></xsl:text>
</xsl:for-each>
<xsl:for-each select="genres/genre">
<xsl:value-of select="genre"/>
<xsl:text></xsl:text>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

</pre>

== History ==
19.03.17 - Wiki Loodud 
19.03.17 - Lisatud 2 * XSLT ja XML fail.

Kodutöö aines "Võrgurakendused II: hajussüsteemide ehitamine" 2017

2017-03-19T19:41:14Z

Rvell: /* Päevaõpe */

[[Category: Võrgurakendused II: hajussüsteemide ehitamine]]
__NOINDEX__

=Kodutöö aines "Võrgurakendused II: hajussüsteemide ehitamine" 2017=
==Eesmärk==
Saada praktiline kogemus hajussüsteemide ehitamisest XML(SOAP) või Rest veebiteenusel ja sellele klientrakenduse loomise abil ning süvendada meeskonnatööoskust.
*SOAP veebiteenuse puhul eeldatakse WCF tehnoloogia kasutamist. Vanema põlvkonna ASP.NET veebiteenuse loomine ei ole lubatud, kuna seda ei toeta ka Microsoft enam tänasel päeval.
*REST teenuste loomisel tuleks kasutada ASP.NET Web API võimalusi.

Kaugem eesmärk on loomulikult hinne :).

==Reeglid==
''' Kodutöö koosneb kolmest eraldiseisvast ülesandest:'''
* Luua XML fail vabalt valitud andmete edastamiseks,selle faili skeemifail ning XSL fail(id) erinevate transformatsioonide tarvis (soovitavalt vähemalt andmete HTML ja XML kujul kuvamiseks)
* Luua veebiteenus, mis võimaldaks pakkuda teenust, eristada kasutajaid ning näidata teenuse kasutamise statistikat kasutajate ja tegevuste lõikes
* Luua klientrakendused (soovitavalt vähemalt kaks)endaloodud veebiteenusele

Ühte projektimeeskonda kuulub 3..4 tudengit ning ühel teemal teostab projekti üks või mitu meeskonda. 1,2 ja viie liikmelised meeskonnad tuleks õppejõuga eraldi kooskõlastada.

Töö käiku kajastatakse http://wiki.itcollege.ee keskkonnas. Wikilehe täitmise eesmärke on kaks: nii on võimalik kirja panna kõik mõtted ja ideed (ning nendest jääb jälg) ning õppejõul on hiljem võimalik saada ülevaade iga projektimeeskonna liikme panusest.

==Tähtajad==

* '''XML fail''' [https://wiki.itcollege.ee/index.php/Kodut%C3%B6%C3%B6_aines_%22V%C3%B5rgurakendused_II:_hajuss%C3%BCsteemide_ehitamine%22_2017#XML_andmefail NB! Täpsem info]
** XML fail, stiilifail ja skeemifail peavad olema valmis ja wikilehel kirjeldatud hiljemalt '''20. märts 2017'''.
** Retsensioonid XML-failide kohta peavad tehtud olema '''27. märts 2017'''.
** '''Meeskonnad on loonud omale enda wiki lehe, kuhu kirjeldavad meeskonna ja panevad nad üles oma tööd. Lisaks hakkavad kogunema ka sinna teiste gruppide poolt kirjutatavad retsensioonid. <ins>Meeskonnalehed lingitakse selle lehe lõppu Meeskonna pealkirja alla.</ins>'''

* '''Veebiteenus''' [https://wiki.itcollege.ee/index.php/Kodut%C3%B6%C3%B6_aines_%22V%C3%B5rgurakendused_II:_hajuss%C3%BCsteemide_ehitamine%22_2017#Veebiteenus NB! Täpsem info]
** Veebiteenuse analüüs peab olema valmis, esitatud ja wikilehel kirjeldatud hiljemalt: '''17.aprill 2017'''
** Veebiteenus peab olema valmis, esitatud ja ja wikilehel kirjeldatud hiljemalt '''29. mai 2017'''.
** Retsensioonid veebiteenuste kohta peavad tehtud olema '''08. juuni 2017'''.



* '''Klientrakendused''' [https://wiki.itcollege.ee/index.php/Kodut%C3%B6%C3%B6_aines_%22V%C3%B5rgurakendused_II:_hajuss%C3%BCsteemide_ehitamine%22_2017#Klientrakendus NB! Täpsem info]
** Klientrakendused peavad olema valmis, esitatud ja ja wikilehel kirjeldatud hiljemalt '''29. mai 2017'''.
** Retsensioonid klientrakenduste kohta peavad tehtud olema '''08. juuni 2017'''.





==Hindamine==
===Üldised kriteeriumid===

Teostatuks loetakse projekt juhul, kui lähteülesanne on realiseeritud, lahendus on töötav, kuid esineb suuremaid vigu ning piirsituatsioonidega ei ole arvestatud.

Maksimumtulemuse saavutamiseks peab projekt olema teostatud tehniliselt veatult ning varustatud dokumentatsiooniga, milles sisaldub arendusprotsessi kirjeldus (peab selguma ka iga rühmaliikme panus projekti teostamisel), kasutajajuhend ning lahenduse kirjeldus.

'''Maksimumtulemuse annab (vähemalt 4/6):'''

* Majanduslik mõtlemine (kas loodav teenus ja rakendused oleks kasutatav ka ärilistel eesmärkidel)
* Mobiilrakendused
* AngularJS klientrakendus
* Kogukondade kaasamine
* Kasutajamugavus
* Läbimõeldud töökorraldus
* Lisavõimaluste realiseerimine (vt näidisteemad)

===XML andmefail===
Ülesande täitmiseks tuleb luua XML fail andmete edastamiseks, selle XML faili skeemifail ning minimaalselt kaks sobivat XSL transformatsiooni faili loodud XML failis olevate andmete transformeerimiseks HTML formaati ja XML faili formaadi muutmiseks. Transformatsioonid peavad sisaldama midagi enamat, kui ainult üks for-each klausel. Transformatsiooni käigus peaks kasutama vajadusel parameetreid ning kindlasti ka erinevaid tingimuste kontrolle.

XML-il peab olema vähemalt 4 loogilist dimensiooni.
<dim1>
<dim2>
<dim3>
<dim4>
</dim4>
</dim3>
</dim2>
</dim1>
Lisaks tuleb kasutada 3-el dimensioonil attribuute, mis one enamat, kui lihtsalt ID.

Käesoleva ülesande käigus peab looma meeskonna ning selle wiki lehekülje

===Veebiteenus===
Loodav veebiteenus peab võimaldama:
* Teenuse pakkumist
* '''Teenuse kasutajate tuvastamist ning haldamist'''
* Teenuse kasutajate ja kasutusstatistika üle arve pidamist kasutajate lõikes
* Teenuse poole pöördumiste arvu piiramist ja piirangute haldamist.

Loodav veebiteenus peab toetama mitme kasutaja võimalust.

Loodav veebiteenus tuleb luua kasutades ''Windows Communication Foundation'' või ASP.NET MVC Web API tehnoloogiat

Andmebaasis peab olema vähemalt 9 olemit ehk andmebaas on eeldus,

Soovitav on luua teenus (FE) ja teenuse seadistamiseks ning kasutajate haldamiseks mõeldud rakendus (BE).

===Klientrakendus===
Klientrakendus mõnele olemasolevale veebiteenusele, võib olla teostatud veebirakendusena, Silverlight, WPF või vormirakendusena.

Variant1: teha klientrakendus enda loodud veebiteenusele

Variant2: teha klientrakendus mõnele levinud veebiteenusele.
Näiteks:
* http://www.bing.com/developer
* http://www.flickr.com/services/api/response.soap.html
* http://developer.ebay.com/developercenter/windows/
* http://apiwiki.twitter.com/Getting-Started

===Retsensioonid===
Retsensioon on üliõpilase iseseisva teadustöö kriitilise analüüsi põhjal koostatud argumenteeritud hinnang. Retsensioonis tuleb hinnata töö vastavust esitatud tingimustele, programmikoodi loetavust ning kommenteeritust, dokumentatsiooni ja kirjeldada puudusi. Retsensioonide põhjal on meeskondadel õigus oma projekte parandada enne määratud esitamistähtaja kättejõudmist.

Retsensioon peab sisaldama minimaalselt...
* XML - ...200 sõna.
* Veebiteenus - ...600 sõna.
* Klientrakendus - ...600 sõna.

Mõnelauselisest arvamusest ei piisa, kuna tegemist on grupi loodavate arvustustega, mitte individuaalsete arvustustega.

==Konsultatsioonid==
Igal projektimeeskonnal on piiramatu õigus saada õppejõu käest konsultatsiooni ja juhendamist oma
töö tegemiseks, kas harjutuste ajal või pärast harjutusi ja loenguid. Eriaegade suhtes saab sõlmida
õppejõuga kokkuleppeid kontaktidel
mait.poska [ät] itcollege.ee või (+372 53 469 734)
(teksti originaalautor Priit Raspel)

=Teemad 2017 kevad=
''' Kodutöö koosneb kolmest eraldiseisvast ülesandest:'''
* Luua XML fail vabalt valitud andmete edastamiseks,selle faili skeemifail ning XSL fail(id) erinevate transformatsioonide tarvis (soovitavalt vähemalt andmete HTML ja XML kujul kuvamiseks)
* Luua veebiteenus, mis võimaldaks pakkuda teenust, eristada kasutajaid ning näidata teenuse kasutamise statistikat kasutajate ja tegevuste lõikes
* Luua klientrakendus mõnele olemasolevale või endaloodud veebiteenusele

NB! XML andmefail ja veebiteenus ei pea olema omavahel seotud.

==Näidisteemad==

===Nimede pakkumise teenus===
Mõte selles, et luua nimede baas, mille abil pakkuda rakenduse loojale sobiva algusega nimesid. Reaalne rakendus: ''autocompleter'' tarvis teenuse pakkumine

====Ülesanne====
Luua sobiva alguse järgi nimede pakkumise teenus:
* alates kahetähelisetest algustest pakkuda sobivad nimesid
* luua võimalus kasutajatel nimesid lisada
* luua võimalus administraatoril nimesid muuta/kustutada
* meeste ja naiste nimed peavad olema süsteemis eristatavad
* luua võimalus, mis võimaldab kuvada populaarseid nimesid
* luua võimalus ühele kasutajale (või erinevatele kasutajagruppidele) maksimumpäringute hulga määramiseks
* luua võimalus, et nimi lisatakse baasi alles siis, kui administraatori õigustega inimene on selleks vastava loa andnud

===Külastusstatistika teenus===
Mõte selles, et pakkuda teenust, kus kasutajal on võimalik registreerida külastused ning küsida oma külastusstatistikat.

====Ülesanne====
Luua külastusstatistika teenus:
* kasutaja saab teenuses registreerida külastusi
* kasutaja saab küsida külastusstatistikat päevade/kuude/kogu perioodi lõikes
* luua võimalus ühele kasutajale (või erinevatele kasutajagruppidele) maksimumpäringute hulga määramiseks

Lisavõimalused:
* luua võimalus registreerida alamlehtede külastusstatistikat
* luua võimalus külastusstatistikale lisaparameetrite lisamiseks (ip aadress, sirviku versioon jne)

===Telefoniraamatu teenus===
Mõte selles, et kasutaja saab teenuse abil salvestada kontakte ja nende seast otsida

====Ülesanne====
Luua telefoniraamatu teenus:
* kasutaja saab teenuses kontakte lisada ja kustutada
* kasutaja saab kontaktide nime/telefoninumbri jne abil otsida
* luua võimalus ühele kasutajale (või erinevatele kasutajagruppidele) maksimumpäringute hulga määramiseks
* kasutajaid on võimalik lisada gruppidesse
* kasutajal on võimalik lisada vajalike kontaktandmete liike
* kasutajatel on võimalik jagada omavahel kontakte ja kontaktide grupper

===RSS voogude kogumise ja uudiste kuvamise teenus===
Mõte selles, et kasutaja saab teenuse abil salvestada talle huvipakkuvaid RSS vooge ja nendelt voogudelt uudiseid lugeda

====Ülesanne====
Luua RSS voogude haldusteenus:
* kasutaja saab teenuses RSS vooge lisada ja kustudada
* kasutaja saab pärida talle huvipakkuvate voogude viimaseid uudiseid
* luua võimalus ühele kasutajale (või erinevatele kasutajagruppidele) maksimumpäringute hulga määramiseks
* kasutaja saab RSS vooge vaadata eraldi või grupeeritult
* vooge peab puhverdama, kuna voogude lugemine võtab enamasti üsna palju aega
*

= Meeskonnad 2017=
==Päevaõpe==

===Meeskond: QView===
Liikmed:
* Semjon Greef
* Martin Nigul
* Martin Nõukas
* Margus Muru
* Lisandra Noor
Meeskonna koduleht: [[Meeskond: QView]]

===Meeskond: Redundant Rappers===
Liikmed:
*Taavi Kliss
*Kertu Nurmberg
*Anneli Asser
*Mart-Erki Nõumees

Meeskonna koduleht: [[Meeskond: Redundant Rappers]]

Meeskonna XML/XSD/XSLT : [https://wiki.itcollege.ee/index.php/Meeskond:_Redundant_Rappers#XML_.2F_XSD_.2F_XSLT]

Meeskonna retsensioon meeskonnale Sense Of Direction: [https://wiki.itcollege.ee/index.php/Talk:Sense_Of_Direction]

===Meeskond: Sense Of Direction===
Liikmed:
*Ilja Andrejev
*Aleksandr Babõkin
*Vladislav Lahtarin
*Vladislav Kovaltšuk
Meeskonna koduleht: [[Sense Of Direction]] 
XML/XSD/XSLT osa asub [https://wiki.itcollege.ee/index.php/Sense_Of_Direction#XML siin]

===[https://wiki.itcollege.ee/index.php/RK Meeskond: RK]===
Liikmed:
*Raido Kivinurm

Esimene osa: [https://wiki.itcollege.ee/index.php/RK#XML XML] / [https://wiki.itcollege.ee/index.php/RK#XSD XSD] / [https://wiki.itcollege.ee/index.php/RK#XSLT_HTML XSLT HTML] / [https://wiki.itcollege.ee/index.php/RK#XSLT_XML XSLT XML]

===[https://wiki.itcollege.ee/index.php/Team_Echo Meeskond: Echo]===
Liikmed:
* Mihkel Vajak
* Janno Oolo
* Mari-Liis Oldja
* Arti Zirk
* Joosep Voolma

[https://wiki.itcollege.ee/index.php/Team_Echo#XML XML/XSD/XSLT]

[https://wiki.itcollege.ee/index.php/Talk:Meeskond:_Redundant_Rappers#Retsensioon_Team_Echo_poolt Retsensioon meeskonnale Redundant Rappers]

===[https://wiki.itcollege.ee/index.php/Bob%27s_Burgers Meeskond: Bob's Burgers]===
Liikmed:
*Aleksei Kopõlov
*Sander Perens

===[https://wiki.itcollege.ee/index.php/User:Meeskond:_VeebiGurmaanid Meeskond: VeebiGurmaanid]===
Liikmed:
* Koit Kõrvel
* Marko Kask
* Melissa Eenmaa
* Joosep Koort

===[https://wiki.itcollege.ee/index.php/Muru Meeskond: Muru]===
Liikmed:
*Murdho Savila

===[https://wiki.itcollege.ee/index.php/Repi Meeskond: Repi]===
Liikmed:
*Renet Pirso

===Meeskond: HelpOut===
Liikmed:
* Mikk Sarapuu
* Martin Paakspuu
* Kerdo Kullamäe
* Marvin Mardiat
* Piret Pomerants
[https://wiki.itcollege.ee/index.php/Meeskond:_HelpOut Meeskonna koduleht]

===[https://wiki.itcollege.ee/index.php/2017_Meeskond_Poly Meeskond: Poly]===
Liikmed:
* Kristian Kalm
* Roland Kontson

=== Meeskond [https://wiki.itcollege.ee/index.php/Meeskond_%22Nope%22: Nope] ===
* Raido Vell
* Taavi Vesinurm
* Kaspar Kaal
* Lisette Noor
* Madis Roosioks

==Kaugõpe==

===Meeskond: CoverMe===
Liikmed:
* Karit Kilgi
* Sten Kaasik
* Ragne Auling
* Silja Kralik
Meeskonna koduleht: [[Meeskond: CoverMe]]

===[https://wiki.itcollege.ee/index.php/Team_SPOT Meeskond: SPOT]===
Liikmed:
* Sigrid Pachel
* Oliver Tiks

===[https://wiki.itcollege.ee/index.php/JRT Meeskond: JRT]===
Liikmed:
* Riho Uusjärv
* Jevgeni Gavrilov
* Tiit Kuuskmäe

===[https://wiki.itcollege.ee/index.php/Ticketer Meeskond: Ticketer]===
Liikmed:
* Liina Abner
* Krista Rüütel
* Roland Türi

===[https://wiki.itcollege.ee/index.php/Ninjas_in_pyjamas Meeskond: Ninjas in Pyjamas]===
Liikmed:
* Anna Linskaja
* Karen Grigorjan
* Sergei Hristoforov
* Artyom Likhachev

===[https://wiki.itcollege.ee/index.php/Talupood Meeskond: Talutooted]===
Liikmed:
* Mihkel Matson
* Taavi Tilk

===[https://wiki.itcollege.ee/index.php/DevHelpVR Meeskond: DevHelp]===
Liikmed:
* Martin Jääger
* Kristo Leemets

===[https://wiki.itcollege.ee/index.php/YAWS Meeskond: Yet Another Weather Station]===
Liikmed:
* Andres Kepler