Conversió de documents XML i plantilles

volver a M04 Lenguajes de marcas y sistemas de gestión de información

Material de teoria i soporte

En estas webs encontraréis el material de soporte para este apartado:

• eXist-db acceso online
• tutorial Xpath de w3School (inglés)
• ¿Qué es una base de datos nativa en XML? -eXist-
• ¿Cómo instalar eXist?
• Tutorial básico XPath
• Xpath Tester Online

Exercicis

• Games.xml

<Catalog>
    <Game id="bk101">
        <Developers>
            <Developer>Epic Games</Developer>
        </Developers>
        <Publisher>Epic Games</Publisher>
        <Title>Fortnite</Title>
        <Genres>
            <Genre>Survival</Genre>
            <Genre>Third Person Shooter</Genre>
            <Genre>Battle Royale</Genre>
        </Genres>
        <Prices>
            <Pc>free-to-play</Pc>
            <Ps4>free-to-play</Ps4>
            <XboxOne>free-to-play</XboxOne>
            <Switch>free-to-play</Switch>
        </Prices>
        <PublishDate>2017-07-25</PublishDate>
        <Description>Fortnite is an online video game developed by Epic Games and released in 2017. It is available in three distinct game mode versions that otherwise share the same general gameplay and game engine: Fortnite: Save the World, a cooperative shooter-survival game for up to four players to fight off zombie-like creatures and defend objects with fortifications they can build, Fortnite Battle Royale, a free-to-play battle royale game where up to 100 players fight to be the last person standing, and Fortnite Creative, where players are given complete freedom to create worlds and battle arenas</Description>
    </Game>
    <Game id="bk102">
        <Developers>
            <Developer>Massive Entertainment</Developer>
        </Developers>
        <Publisher>Ubisoft</Publisher>
        <Title>The Division 2</Title>
        <Genres>
            <Genre>Action Role-Playing</Genre>
            <Genre>Survival</Genre>
            <Genre>Third Person Shooter</Genre>
        </Genres>
        <Prices>
            <Pc>49</Pc>
            <Ps4>64</Ps4>
            <XboxOne>64</XboxOne>
        </Prices>
        <PublishDate>2019-03-15</PublishDate>
        <Description>Tom Clancy's The Division 2 is an upcoming online action role-playing video game developed by Massive Entertainment and published by Ubisoft. The sequel to Tom Clancy's The Division</Description>
    </Game>
    <Game id="bk103">
        <Developers>
            <Developer>Bioware</Developer>
        </Developers>
        <Publisher>EA</Publisher>
        <Title>Anthem</Title>
        <Genres>
            <Genre>Action Role-Playing</Genre>
            <Genre>Third Person Shooter</Genre>
        </Genres>
        <Prices>
            <Pc>54</Pc>
            <Ps4>64</Ps4>
            <XboxOne>64</XboxOne>
        </Prices>
        <PublishDate>2019-2-22</PublishDate>
        <Description>Anthem combines third-person shooter and action role-playing game elements in a "contiguous open world" shared with up to three other players in which they take the role of a Freelancer donning fully customizable exosuits called Javelins.</Description>
    </Game>
    <Game id="bk104">
        <Developers>
            <Developer>Bungie</Developer>
        </Developers>
        <Publisher>Activision</Publisher>
        <Title>Destiny 2</Title>
        <Genres>
            <Genre>Action Role-Playing</Genre>
            <Genre>Frist Person Shooter</Genre>
        </Genres>
        <Prices>
            <Pc>15</Pc>
            <Ps4>16</Ps4>
            <XboxOne>21.90</XboxOne>
        </Prices>
        <PublishDate>2017-09-06</PublishDate>
        <Description>Destiny 2 is an online-only multiplayer first-person shooter video game developed by Bungie and published by Activision.</Description>
   </Game>
       <Game id="bk105">
        <Developers>
            <Developer>Motive</Developer>
            <Developer>Criterion</Developer>
            <Developer>DICE</Developer>
        </Developers>
        <Publisher>EA</Publisher>
        <Title>Battlefront II</Title>
        <Genres>
            <Genre>Third Person Shooter</Genre>
            <Genre>Frist Person Shooter</Genre>
        </Genres>
        <Prices>
            <Pc>19</Pc>
            <Ps4>26</Ps4>
            <XboxOne>34</XboxOne>
        </Prices>
        <PublishDate>2017-11-17</PublishDate>
        <Description>Star Wars Battlefront II is an action shooter video game based on the Star Wars film franchise. It is the fourth major installment of the Star Wars: Battlefront series and seventh overall, and a sequel to the 2015 reboot of the series.</Description>
   </Game>
   <Game id="bk106">
        <Developers>
            <Developer>Nintendo</Developer>
        </Developers>
        <Publisher>Nintendo</Publisher>
        <Title>Luigi's Mansion 3</Title>
        <Genres>
            <Genre>Action</Genre>
            <Genre>Adventure</Genre>
        </Genres>
        <Prices>
            <Switch>49</Switch>
        </Prices>
        <PublishDate>2019-10-31</PublishDate>
        <Description>Luigi's Mansion 3 is an action-adventure game, in which players control the character of Luigi from a fixed third-person perspective, as they capture ghosts across a large hotel setting. The game features two modes of gameplay – a single-player story mode, and a set of multiplayer game modes – in which ghost catching functions in the same manner as previous installments: players stun ghosts with Luigi's flashlight, snag them with his Poltergust, and weaken their health down to 0 in order to capture them. </Description>
   </Game>
   <Game id="bk107">
        <Developers>
            <Developer>Monolith</Developer>
        </Developers>
        <Publisher>Nintendo</Publisher>
        <Title>Xenoblade Chronicles 2</Title>
        <Genres>
            <Genre>Action</Genre>
            <Genre>Adventure</Genre>
            <Genre>JRPG</Genre>
        </Genres>
        <Prices>
            <Switch>49</Switch>
        </Prices>
        <PublishDate>2017-12-1</PublishDate>
        <Description>Xenoblade Chronicles 2[a] is an open world action role-playing game developed by Monolith Soft and published by Nintendo for the Nintendo Switch video game console. Released worldwide on December 1, 2017, it is the third installment in the Xenoblade Chronicles series, and the seventh main entry in the Xeno meta series; although it features a different setting and characters than the first Xenoblade Chronicles, it marks a return to a story-driven game, unlike the previous game in the series, Xenoblade Chronicles X, which was oriented towards open world exploration. </Description>
   </Game>
</Catalog>

• Consultas Easy

1. Lista todo el contenido del fichero Games.xml
2. Lista todos los ids
3. Lista todos los títulos
4. Lista los títulos y la fecha de publicación
5. Lista los juegos de la distribuidora EA del año 2019
6. Que hace esta instrucción? "//Game/Genres/Genre[.="Frist Person Shooter"]/../.."

• Consultas Normal

1. Lista los géneros de los juegos cuyo id sea "bk102" o "bk104"
2. Lista el título y la fecha de publicación de los juegos que salgan para las 4 plataformas
3. Lista los títulos de los juegos y sus precios en las respectivas plataformas cuyo genero sea First Person Shooter
4. Lista las descripciones de los juegos que sean First Person Shooter o Third Person Shooter
5. Lista los juegos que tengan más de un desarrollador

• Consultas Hard

1. Lista el título de los juegos cuyo precio en PS4 este entre 15 y 30 euros
2. Lista los juegos cuyo precio en PC sea inferior a 19€