{"id":7729,"date":"2022-09-07T23:00:00","date_gmt":"2022-09-07T17:30:00","guid":{"rendered":"https:\/\/www.codingbroz.com\/?p=7729"},"modified":"2022-09-02T08:43:10","modified_gmt":"2022-09-02T03:13:10","slug":"querying-xml-datastores-with-xpath-9-hackerrank-solution","status":"publish","type":"post","link":"https:\/\/www.codingbroz.com\/querying-xml-datastores-with-xpath-9-hackerrank-solution\/","title":{"rendered":"Querying XML Datastores with XPath &#8211; 9 &#8211; HackerRank Solution"},"content":{"rendered":"\n<p>In this post, we will solve <strong>Querying XML Datastores with XPath &#8211; 9 HackerRank Solution<\/strong>. This problem <strong>(Querying XML Datastores with XPath &#8211; 9)<\/strong> is a part of <strong>HackerRank Databases<\/strong> series.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<label for=\"ez-toc-cssicon-toggle-item-662d1eb46c1b3\" class=\"ez-toc-cssicon-toggle-label\"><label class=\"ez-toc-title\">Table of Contents<\/label>\n<span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0090ff;color:#0090ff\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0090ff;color:#0090ff\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-662d1eb46c1b3\" checked \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.codingbroz.com\/querying-xml-datastores-with-xpath-9-hackerrank-solution\/#Task\" title=\"Task\">Task<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.codingbroz.com\/querying-xml-datastores-with-xpath-9-hackerrank-solution\/#Solution_%E2%80%93_Querying_XML_Datastores_with_XPath_%E2%80%93_9_%E2%80%93_HackerRank_Solution\" title=\"Solution &#8211; Querying XML Datastores with XPath &#8211; 9 &#8211; HackerRank Solution\">Solution &#8211; Querying XML Datastores with XPath &#8211; 9 &#8211; HackerRank Solution<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Task\"><\/span><strong>Task<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>XPath<\/strong>&nbsp;is a very valuable tool, often used for querying XML databases. XPath queries (or close variants) are also used in the process of Web Scraping while retreiving data from structured XHTML-compliant web pages, specially those with tabulated data.<\/p>\n\n\n\n<p>A quick XPath tutorial is available&nbsp;<a href=\"http:\/\/edutechwiki.unige.ch\/en\/XPath_tutorial_-_basics\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n\n\n\n<p><strong>Provided XML Fragment and Task Description<\/strong><\/p>\n\n\n\n<p>Assume that you have been provided the fragment of XML, shown below. Your task is to write the XPath selector for listing the title of the second movie for which the marked shelf = &#8220;B&#8221;.<\/p>\n\n\n\n<p>The Ruby code for handling input, output and document construction has already been provided. You only need to fill up the required blanks as indicated in the template code provided. This challenge is agnostic to language-specific knowledge and you do not require to know ruby &#8211; as only the XPath selector needs to be completed by you.<\/p>\n\n\n\n<pre class=\"wp-block-code has-ast-global-color-5-color has-ast-global-color-8-background-color has-text-color has-background\"><code>&lt;collection shelf=\"Classics\">\r\n&lt;movie title=\"The Enemy\" shelf=\"A\">\r\n   &lt;type>War, Thriller&lt;\/type>\r\n   &lt;format>DVD&lt;\/format>\r\n   &lt;year>2001&lt;\/year>\r\n   &lt;rating>PG&lt;\/rating>\r\n   &lt;popularity>10&lt;\/popularity>\r\n   &lt;description>Talk about a war&lt;\/description>\r\n&lt;\/movie>\r\n&lt;movie title=\"Transformers\" shelf=\"B\">\r\n   &lt;type>Science Fiction&lt;\/type>\r\n   &lt;format>DVD&lt;\/format>\r\n   &lt;year>1980&lt;\/year>\r\n   &lt;rating>R&lt;\/rating>\r\n   &lt;popularity>7&lt;\/popularity>\r\n   &lt;description>Science Fiction&lt;\/description>\r\n&lt;\/movie>\r\n   &lt;movie title=\"Trigun\" shelf=\"B\">\r\n   &lt;type>Action&lt;\/type>\r\n   &lt;format>DVD&lt;\/format>\r\n   &lt;episodes>4&lt;\/episodes>\r\n   &lt;rating>PG&lt;\/rating>\r\n   &lt;popularity>10&lt;\/popularity>\r\n   &lt;description>Quite a bit of action!&lt;\/description>\r\n&lt;\/movie>\r\n&lt;movie title=\"Ishtar\" shelf=\"A\">\r\n   &lt;type>Comedy&lt;\/type>\r\n   &lt;format>VHS&lt;\/format>\r\n   &lt;rating>PG&lt;\/rating>\r\n   &lt;popularity>2&lt;\/popularity>\r\n   &lt;description>Boring&lt;\/description>\r\n&lt;\/movie>\r\n&lt;\/collection><\/code><\/pre>\n\n\n\n<p><strong>Expected Output<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-ast-global-color-5-color has-ast-global-color-8-background-color has-text-color has-background\"><code>Trigun  <\/code><\/pre>\n\n\n\n<p>Your code will also be run against a hidden test case, which is similar in schema and format to the XML fragment shown above &#8211; only some of the values in the fields will be changed. This is to prevent the submission of hard-coded answers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Solution_%E2%80%93_Querying_XML_Datastores_with_XPath_%E2%80%93_9_%E2%80%93_HackerRank_Solution\"><\/span><strong>Solution &#8211; Querying XML Datastores with XPath &#8211; 9 &#8211; HackerRank Solution<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"ruby\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># Standard ruby library for XML parsing\nrequire 'rexml\/document'\ninclude REXML\n\n# Enter your code here. Read input from STDIN. Print output to STDOUT\nxmlText = \"\" \n\n# Read the input XML Fragment\nwhile line = gets()\n   xmlText += line\nend\n\ndoc = Document.new xmlText\n# Write the XPath selector for listing the title of the second movie for which the marked shelf = \"B\".\n# Fill in the blanks to complete the required XPath selector query\nputs doc.elements.each(\"collection\/movie[@shelf = 'B'][2]\/@title\")\n<\/pre>\n\n\n\n<p><strong>Note:<\/strong> This problem <strong>(<a href=\"https:\/\/www.hackerrank.com\/challenges\/querying-xml-datastores-with-xpath-9\/problem\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Querying XML Datastores with XPath &#8211; 9<\/a>)<\/strong> is generated by <strong><a href=\"https:\/\/www.hackerrank.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">HackerRank<\/a><\/strong> but the solution is provided by <strong><a href=\"https:\/\/www.codingbroz.com\/\">CodingBroz<\/a><\/strong>. This tutorial is only for <strong>Educational<\/strong> and <strong>Learning<\/strong> purpose.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this post, we will solve Querying XML Datastores with XPath &#8211; 9 HackerRank Solution. This problem (Querying XML Datastores with XPath &#8211; 9) is a part of HackerRank Databases series.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,772],"tags":[773],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.codingbroz.com\/wp-json\/wp\/v2\/posts\/7729"}],"collection":[{"href":"https:\/\/www.codingbroz.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.codingbroz.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.codingbroz.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.codingbroz.com\/wp-json\/wp\/v2\/comments?post=7729"}],"version-history":[{"count":2,"href":"https:\/\/www.codingbroz.com\/wp-json\/wp\/v2\/posts\/7729\/revisions"}],"predecessor-version":[{"id":7731,"href":"https:\/\/www.codingbroz.com\/wp-json\/wp\/v2\/posts\/7729\/revisions\/7731"}],"wp:attachment":[{"href":"https:\/\/www.codingbroz.com\/wp-json\/wp\/v2\/media?parent=7729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codingbroz.com\/wp-json\/wp\/v2\/categories?post=7729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codingbroz.com\/wp-json\/wp\/v2\/tags?post=7729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}