Proovitud abielu
From ICO wiki
Meeskond "Proovitud abielu"
- Berit Põldoja
- Elina Kuldkepp
XML/XSD/XSLT
XML
<?xml version="1.0" encoding="utf-8" ?>
<Bookstores>
<Bookstore id="1" country="Spain">
<Name>Señorita</Name>
<Book category="Crime" quantity="50" language="english" pages="250">
<Title><![CDATA[The Case of the Counterfeit Eye]]></Title>
<Description><![CDATA[After wealthy businessman Hartley Bassetts apparent suicide, Perry Mason discovers too many suspects who may have wanted him dead to believe the obvious evidence of a suicide note and three guns near the body.]]></Description>
<Author gender="Male">
<FirstName>Erle Stanley</FirstName>
<LastName>Gardner</LastName>
<BirthYear>1889</BirthYear>
<Country>USA</Country>
</Author>
<ReleaseDate>
<Day>20</Day>
<Month>March</Month>
<Year>1928</Year>
</ReleaseDate>
<Price>30.50</Price>
<Location>Madrid</Location>
</Book>
<Book category="Drama" quantity="20" language="english" pages="150">
<Title><![CDATA[Beating hearts.]]></Title>
<Description><![CDATA[Beating Hearts maintains that sentence or ability to have subjective experiences.]]></Description>
<Author gender="Female">
<FirstName>Hannah</FirstName>
<LastName>Cole</LastName>
<BirthYear>1985</BirthYear>
<Country>USA</Country>
</Author>
<ReleaseDate>
<Day>14</Day>
<Month>May</Month>
<Year>2005</Year>
</ReleaseDate>
<Price>20</Price>
<Location>Sevilla</Location>
</Book>
</Bookstore>
<Bookstore id="2" country="France">
<Name>Mademoiselle</Name>
<Book category="Romance" quantity="43" language="english" pages="400">
<Title><![CDATA[The Case of the Counterfeit Eye]]></Title>
<Description><![CDATA[After wealthy businessman Hartley Bassetts apparent suicide, Perry Mason discovers too many suspects who may have wanted him dead to believe the obvious evidence of a suicide note and three guns near the body.]]></Description>
<Author gender="Woman">
<FirstName>Charlotte</FirstName>
<LastName> Brontë</LastName>
<BirthYear>1816</BirthYear>
<Country>England</Country>
</Author>
<ReleaseDate>
<Day>16</Day>
<Month>October</Month>
<Year>1847</Year>
</ReleaseDate>
<Price>20.99</Price>
<Location>Paris</Location>
</Book>
<Book category="Crime" quantity="50" language="english" pages="250">
<Title><![CDATA[The Case of the Counterfeit Eye]]></Title>
<Description><![CDATA[When a murdered man is found in the home of shady insurance adjustor Walter Prescott, a simple divorce case turns into a courtroom puzzler, as Perry Mason follows the clues to catch a killer. Reissue.]]></Description>
<Author gender="Male">
<FirstName>Erle Stanley</FirstName>
<LastName>Gardner</LastName>
<BirthYear>1889</BirthYear>
<Country>USA</Country>
</Author>
<ReleaseDate>
<Day>21</Day>
<Month>September</Month>
<Year>1920</Year>
</ReleaseDate>
<Price>25</Price>
<Location>Paris</Location>
</Book>
<Book category="Sci-fi" quantity="50" language="france" pages="450">
<Title><![CDATA[Something suspicious]]></Title>
<Description><![CDATA[Something happened]]></Description>
<Author gender="Male">
<FirstName>Erle Stanley</FirstName>
<LastName>Gardner</LastName>
<BirthYear>1889</BirthYear>
<Country>USA</Country>
</Author>
<ReleaseDate>
<Day>12</Day>
<Month>August</Month>
<Year>1905</Year>
</ReleaseDate>
<Price>27.99</Price>
<Location>Nice</Location>
</Book>
</Bookstore>
<Bookstore id="3" country="Great Britain">
<Name>Fraŭlino</Name>
<Book category="Comedy" quantity="25" language="english" pages="150">
<Title><![CDATA[This was fun.]]></Title>
<Description><![CDATA[So much fun stuff happens. Must read.]]></Description>
<Author gender="Woman">
<FirstName>Berit</FirstName>
<LastName>Põldoja</LastName>
<BirthYear>1996</BirthYear>
<Country>Estonia</Country>
</Author>
<ReleaseDate>
<Day>17</Day>
<Month>May</Month>
<Year>2019</Year>
</ReleaseDate>
<Price>35.99</Price>
<Location>London</Location>
</Book>
<Book category="Drama" quantity="15" language="english" pages="450">
<Title><![CDATA[Sad Woman.]]></Title>
<Description><![CDATA[Woman is very sad.]]></Description>
<Author gender="Woman">
<FirstName>Elina</FirstName>
<LastName>Kuldkepp</LastName>
<BirthYear>1994</BirthYear>
<Country>Estonia</Country>
</Author>
<ReleaseDate>
<Day>30</Day>
<Month>October</Month>
<Year>2020</Year>
</ReleaseDate>
<Price>20</Price>
<Location>Oxford</Location>
</Book>
</Bookstore>
</Bookstores>
XSD
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="XMLSchema1"
targetNamespace="http://tempuri.org/XMLSchema1.xsd"
elementFormDefault="qualified"
xmlns="http://tempuri.org/XMLSchema1.xsd"
xmlns:mstns="http://tempuri.org/XMLSchema1.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
>
<xs:element name="Bookstores">
<xs:complexType>
<xs:element name="Bookstore" type="xs:string">
<xs:complexType>
<xs:sequence>
<xs:element name="Name" type="xs:string"/>
<xs:element name="Book">
<xs:complexType>
<xs:sequence>
<xs:element name="Title" type="xs:string"/>
<xs:element name="Description" type="xs:string"/>
<xs:element name="Author" type="xs:string">
<xs:complexType>
<xs:sequence>
<xs:element name="FirstName" type="xs:string"/>
<xs:element name="LastName" type="xs:string"/>
<xs:element name="BirthYear" type="xs:string"/>
<xs:element name="Country" type="xs:string"/>
</xs:sequence>
<xs:attribute name="gender" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="ReleaseDate" type="xs:string">
<xs:complexType>
<xs:sequence>
<xs:element name="Day" type="xs:datetime"/>
<xs:element name="Month" type="xs:datetime"/>
<xs:element name="Year" type="xs:datetime"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Price" type="xs:decimal"/>
<xs:element name="Location" type="xs:string"/>
</xs:sequence>
<xs:attribute name="category" type="xs:string" use="required"/>
<xs:attribute name="quantity" type="xs:string" use="required"/>
<xs:attribute name="language" type="xs:string" use="required"/>
<xs:attribute name="pages" type="xs:int" use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="id" type="xs:string" use="required"/>
<xs:attribute name="country" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:complexType>
</xs:element>
</xs:schema>
XSLT XML
<?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>Raamatupoed</title>
</head>
<body>
<h1>Raamatupoed</h1>
</body>
<table border="1">
<tr bgcolor="#9acd32">
<th>Raamatupood ja raamatud</th>
<th>Kirjeldus</th>
<th>Info</th>
</tr>
<xsl:for-each select="Bookstores/Bookstore">
<tr>
<td bgcolor="#9acd32">
<xsl:value-of select="Name"/>
</td>
<xsl:for-each select="Book">
<tr>
<td>
<xsl:value-of select="Title"/>
</td>
<td>
<xsl:value-of select="Description"/>
</td>
<td>
<xsl:value-of select="Author"/>
</td>
</tr>
</xsl:for-each>
</tr>
</xsl:for-each>
</table>
<table border="1">
<tr bgcolor="#9acd32">
<th>Sugu</th>
<th>Eesnimi</th>
<th>Perekonnanimi</th>
<th>Riik</th>
<th>Sünniaasta</th>
</tr>
<xsl:for-each select="Bookstores/Bookstore/Book/Author">
<tr>
<xsl:if test="@gender='Woman'">
<xsl:if test="Country='Estonia'">
<td>
<xsl:value-of select="@gender" />
</td>
<td>
<xsl:value-of select="FirstName" />
</td>
<td>
<xsl:value-of select="LastName" />
</td>
<td>
<xsl:value-of select="Country" />
</td>
<td>
<xsl:value-of select="BirthYear" />
</td>
</xsl:if>
</xsl:if>
</tr>
</xsl:for-each>
</table>
</html>
</xsl:template>
</xsl:stylesheet>
Output
