/// <summary> /// will query an xml document given the document name and query or a query file name /// </summary> /// <param name="fileName"></param> /// <param name="query"></param> /// <returns></returns> private XmlDocument xmlQuery(string fileName, string query) { XmlDocument xmlResults = new XmlDocument(); try { fileName = "Config\\" + fileName; // create the collection XQueryNavigatorCollection col = new XQueryNavigatorCollection(); // add the file to the collection // the file will be referenced in the query statement by its alias col.AddNavigator(fileName, "theFile"); // if(fileName == "Config\\media.xml") // { // col.AddNavigator("Config\\fileTypes.xml", "fileTypes"); // } // copy the query out from the file String q = String.Empty; if (query.IndexOf(".xqu") > 0) //this is a query file { StreamReader sr = new StreamReader("XQu\\" + query); q = sr.ReadToEnd(); sr.Close(); } else { q = query; } // EventLog.WriteEntry("sctv",q.ToString()); // compile the query XQueryExpression expr = new XQueryExpression(q); xmlResults.LoadXml("<results>" + expr.Execute(col).ToXml() + "</results>"); // foreach(XmlNode node in xmlResults) // { // foreach(XmlElement elem in node) // { // lblMessage.Text += elem["Name"].InnerText.ToString(); // } // } } catch (Exception e) { // lblMessage.Text = e.ToString(); EventLog.WriteEntry("sctv", "File: " + fileName + " " + e.ToString()); } // EventLog.WriteEntry("sctv","Results: "+ expr.Execute(col).ToXml().ToString()); return(xmlResults); }
public void Evaluate(int SpreadMax) { if (this.FPinInput.PinIsChanged || this.FPinInQuery.PinIsChanged || this.FPinInAlias.PinIsChanged) { this.FPinOutIsValid.SliceCount = SpreadMax; this.FPinOutput.SliceCount = SpreadMax; for (int i = 0; i < SpreadMax; i++) { string input, query, alias; this.FPinInput.GetString(i, out input); this.FPinInAlias.GetString(i, out alias); this.FPinInQuery.GetString(i, out query); if (input == null) { input = String.Empty; } if (alias == null) { alias = String.Empty; } if (query == null) { query = String.Empty; } try { XQueryNavigatorCollection col = new XQueryNavigatorCollection(); XmlDocument doc = new XmlDocument(); doc.LoadXml(input); col.AddNavigator(doc.CreateNavigator(), alias); XQueryExpression expr = new XQueryExpression(query); string result = expr.Execute(col).ToXml(); this.FPinOutput.SetString(i, result); this.FPinOutIsValid.SetValue(i, 1); } catch { this.FPinOutput.SetString(i, ""); this.FPinOutIsValid.SetValue(i, 0); } } } }
private void Button_Click(object sender, RoutedEventArgs e) { try { XQueryNavigatorCollection col = new XQueryNavigatorCollection(); col.AddNavigator(_document.Navigator, "doc"); string query = _edtXQuery.Text; XQueryExpression xepr = new XQueryExpression(query); _edtResult.Text = xepr.Execute(col).ToXml(); } catch (Exception ex) { _edtResult.Text = ex.ToString(); _edtResult.Text += "\n\n"; _edtResult.Text += _edtXQuery.Text; } }
static void Main(string[] args) { XQueryNavigatorCollection col = new XQueryNavigatorCollection(); col.AddNavigator("C:\\Users\\matea\\workspace\\test\\my-file.xml", "doc"); string query = "for $x in document(\"doc\")/dsKurs/KursZbir return (<p>{$x/Oznaka/text(), \" \", $x/Nomin/text(), \" \", $x/Sreden/text()}</p>)"; XQueryExpression xepr = new XQueryExpression(query); string result = xepr.Execute(col).ToXml(); String html = "<html>" + result + "</html>"; using (FileStream fs = new FileStream("D:\\test.htm", FileMode.Create)) { using (StreamWriter w = new StreamWriter(fs, Encoding.UTF8)) { w.WriteLine(html); } } Console.Write(result); Console.ReadKey(); }
static void Main(string[] args) { XQueryNavigatorCollection col = new XQueryNavigatorCollection(); col.AddNavigator("C:\\Users\\matea\\workspace\\test\\my-file.xml", "doc"); string query = "for $x in document(\"doc\")/dsKurs/KursZbir return (<p>{$x/Oznaka/text(), \" \", $x/Nomin/text(), \" \", $x/Sreden/text()}</p>)"; XQueryExpression xepr = new XQueryExpression(query); string result = xepr.Execute(col).ToXml(); String html = "<html>" + result + "</html>"; using (FileStream fs = new FileStream("D:\\test.htm", FileMode.Create)) { using (StreamWriter w = new StreamWriter(fs, Encoding.UTF8)) { w.WriteLine(html); } } Console.Write(result); Console.ReadKey(); }
/// <summary> /// Runs the solutions to all problems /// </summary> public static void Main() { XmlDocument doc = new XmlDocument(); doc.Load(PathToXmlFile); XmlNode root = doc.DocumentElement ?? doc.CreateElement("root"); // Problem 2: Write program that extracts all different artists which are found in the catalog.xml. // For each author you should print the number of albums in the catalogue. // Use the DOM parser and a hash - table. PrintNumbersOfAlbumsForEachArtist(root); // Problem 3: Implement the previous using XPath. PrintArtistsNumberOfAlbumsUsingXPath(root); // Problem 4: Using the DOM parser write a program to delete from catalog.xml all albums having price > 20. DeleteAlbumsByPrice(root, 20.0); // Check that albums are deleted: PrintNumbersOfAlbumsForEachArtist(root); // Problem 5: Write a program, which using XmlReader extracts all song titles from catalog.xml. var songTitles = ExtractSongTitlesFromCatalogue(PathToXmlFile); Console.WriteLine("Song titles: " + string.Join(", ", (songTitles as List <string>).ToArray())); // Problem 6: Rewrite the same using XDocument and LINQ query. XDocument xDoc = XDocument.Load(PathToXmlFile); var songTitlesUsingLinq = from songs in xDoc.Descendants("title") select songs.Value.Trim(); Console.WriteLine("Song titles (using LINQ): " + string.Join(", ", songTitlesUsingLinq)); // Problem 7: In a text file we are given the name, address and phone number of given person (each at a single line). // Write a program, which creates new XML document, which contains these data in structured XML format. CreateXmlPhonebook("../../phonebook.txt"); // Problem 8: Write a program, which (using XmlReader and XmlWriter) reads the file catalog.xml and creates the file album.xml, // in which stores in appropriate way the names of all albums and their authors. CreateAlbumsXml(PathToXmlFile); // Problem 9: Write a program to traverse given directory and write to a XML file its contents together with all subdirectories and files. // Use tags < file > and < dir > with appropriate attributes. // For the generation of the XML document use the class XmlWriter. using (var writer = new XmlTextWriter("../../traverseWithXmlWriter.xml", Encoding.UTF8)) { writer.WriteStartDocument(); writer.WriteStartElement("DirectoriesRoot"); CreateFileSystemXmlTreeUsingXmlWriter("../../..", writer); writer.WriteEndElement(); writer.WriteEndDocument(); writer.Close(); } // Problem 10: Rewrite the last exercises using XDocument, XElement and XAttribute. var xDocument = new XDocument(); xDocument.Add(CreateFileSystemXmlTree("../../../")); xDocument.Save("../../traverseWithXElement.xml"); // Problem 11: Write a program, which extract from the file catalog.xml the prices for all albums, published 5 years ago or earlier. // Use XPath query. doc.Load(PathToXmlFile); root = doc.DocumentElement; // returns all (no albums in the catalogue are newer...) var oldAlbumsPrices = root.SelectNodes("album/price[../year/text() < 2010]"); //// var oldAlbumsPrices = root.SelectNodes("album/price[../year/text() < 1980]"); // returns 2 albums' prices Console.WriteLine(new string('-', 50)); Console.WriteLine("Prices of the albums, published before 2010: "); foreach (var price in oldAlbumsPrices) { Console.WriteLine((price as XmlElement).InnerXml.Trim()); } // Problem 12: Rewrite the previous using LINQ query. Console.WriteLine(new string('-', 50)); Console.WriteLine("Prices of the albums, published before 2010 (using LINQ): "); var oldAlbumsPricesUsingLinq = from album in xDoc.Descendants("album") where int.Parse(album.Element("year").Value) < 2010 select album.Descendants("price").FirstOrDefault(); foreach (var price in oldAlbumsPricesUsingLinq) { Console.WriteLine(price.Value.Trim()); } // Problem 13: Create an XSL stylesheet, which transforms the file catalog.xml into HTML document, // formatted for viewing in a standard Web-browser. // Problem 14: Write a C# program to apply the XSLT stylesheet transformation on the file catalog.xml // using the class XslTransform. XslCompiledTransform catalogueXslt = new XslCompiledTransform(); catalogueXslt.Load("../../catalogue.xslt"); catalogueXslt.Transform(PathToXmlFile, "../../catalogue.html"); // Problem 15: // *Read some tutorial about the XQuery language. // Implement the XML to HTML transformation with XQuery (instead of XSLT). // Download some open source XQuery library for .NET and execute the XQuery to transform the catalog.xml to HTML. XQueryNavigatorCollection col = new XQueryNavigatorCollection(); // Add the XML document catalogue.xml to the collection using cat as the name to reference. col.AddNavigator("../../catalogue.xml", "cat"); var expr = new XQueryExpression( "<html><body><head><title>Catalogue</title></head>" + "<h1>Catalogue generated using XQuery</h1>" + "{For $a IN document(\"cat\")/catalogue/album " + "RETURN <div><strong>Title:</strong> {$a/name/text()}<br />" + "<strong>Artist:</strong> {$a/artist/text()}<br />" + "<strong>Year:</strong> {$a/year/text()}<br />" + "<strong>Producer:</strong> {$a/producer/text()}<br />" + "<strong>Price:</strong> {$a/price/text()}<br />" + "<strong>Songs:</strong><ol>{For $s IN $a/songs/song RETURN <li>{$s/title/text()}</li>}</ol>" + "</div><hr />}</body></html>"); StreamWriter str = new StreamWriter("../../catalogueUsingXQuery.html"); XQueryNavigator nav = expr.Execute(col); nav.ToXml(str); str.Close(); // Problem 16: // Using Visual Studio generate an XSD schema for the file catalog.xml. // Write a C# program that takes an XML file and an XSD file (schema) and validates the XML file against the schema. // Test it with valid XML catalogs and invalid XML catalogs. string xsdMarkup = File.ReadAllText("../../catalogue.xsd"); XmlSchemaSet schemas = new XmlSchemaSet(); schemas.Add(string.Empty, XmlReader.Create(new StringReader(xsdMarkup))); XDocument valid = XDocument.Load(PathToXmlFile); XDocument invalid = new XDocument( new XElement( "Root", new XElement("Child1", "content1"), new XElement("Child2", "content2"))); Console.WriteLine(new string('-', 50)); Console.WriteLine("Validating valid document:"); bool errors = false; valid.Validate(schemas, (o, e) => { Console.WriteLine("{0}", e.Message); errors = true; }); Console.WriteLine("Valid {0}", errors ? "did not validate" : "validated"); Console.WriteLine(); Console.WriteLine("Validating invalid document:"); errors = false; invalid.Validate(schemas, (o, e) => { Console.WriteLine("{0}", e.Message); errors = true; }); Console.WriteLine("doc2 {0}", errors ? "did not validate" : "validated"); }
/// <summary> /// Runs the solutions to all problems /// </summary> public static void Main() { XmlDocument doc = new XmlDocument(); doc.Load(PathToXmlFile); XmlNode root = doc.DocumentElement ?? doc.CreateElement("root"); // Problem 2: Write program that extracts all different artists which are found in the catalog.xml. // For each author you should print the number of albums in the catalogue. // Use the DOM parser and a hash - table. PrintNumbersOfAlbumsForEachArtist(root); // Problem 3: Implement the previous using XPath. PrintArtistsNumberOfAlbumsUsingXPath(root); // Problem 4: Using the DOM parser write a program to delete from catalog.xml all albums having price > 20. DeleteAlbumsByPrice(root, 20.0); // Check that albums are deleted: PrintNumbersOfAlbumsForEachArtist(root); // Problem 5: Write a program, which using XmlReader extracts all song titles from catalog.xml. var songTitles = ExtractSongTitlesFromCatalogue(PathToXmlFile); Console.WriteLine("Song titles: " + string.Join(", ", (songTitles as List<string>).ToArray())); // Problem 6: Rewrite the same using XDocument and LINQ query. XDocument xDoc = XDocument.Load(PathToXmlFile); var songTitlesUsingLinq = from songs in xDoc.Descendants("title") select songs.Value.Trim(); Console.WriteLine("Song titles (using LINQ): " + string.Join(", ", songTitlesUsingLinq)); // Problem 7: In a text file we are given the name, address and phone number of given person (each at a single line). // Write a program, which creates new XML document, which contains these data in structured XML format. CreateXmlPhonebook("../../phonebook.txt"); // Problem 8: Write a program, which (using XmlReader and XmlWriter) reads the file catalog.xml and creates the file album.xml, // in which stores in appropriate way the names of all albums and their authors. CreateAlbumsXml(PathToXmlFile); // Problem 9: Write a program to traverse given directory and write to a XML file its contents together with all subdirectories and files. // Use tags < file > and < dir > with appropriate attributes. // For the generation of the XML document use the class XmlWriter. using (var writer = new XmlTextWriter("../../traverseWithXmlWriter.xml", Encoding.UTF8)) { writer.WriteStartDocument(); writer.WriteStartElement("DirectoriesRoot"); CreateFileSystemXmlTreeUsingXmlWriter("../../..", writer); writer.WriteEndElement(); writer.WriteEndDocument(); writer.Close(); } // Problem 10: Rewrite the last exercises using XDocument, XElement and XAttribute. var xDocument = new XDocument(); xDocument.Add(CreateFileSystemXmlTree("../../../")); xDocument.Save("../../traverseWithXElement.xml"); // Problem 11: Write a program, which extract from the file catalog.xml the prices for all albums, published 5 years ago or earlier. // Use XPath query. doc.Load(PathToXmlFile); root = doc.DocumentElement; // returns all (no albums in the catalogue are newer...) var oldAlbumsPrices = root.SelectNodes("album/price[../year/text() < 2010]"); //// var oldAlbumsPrices = root.SelectNodes("album/price[../year/text() < 1980]"); // returns 2 albums' prices Console.WriteLine(new string('-', 50)); Console.WriteLine("Prices of the albums, published before 2010: "); foreach (var price in oldAlbumsPrices) { Console.WriteLine((price as XmlElement).InnerXml.Trim()); } // Problem 12: Rewrite the previous using LINQ query. Console.WriteLine(new string('-', 50)); Console.WriteLine("Prices of the albums, published before 2010 (using LINQ): "); var oldAlbumsPricesUsingLinq = from album in xDoc.Descendants("album") where int.Parse(album.Element("year").Value) < 2010 select album.Descendants("price").FirstOrDefault(); foreach (var price in oldAlbumsPricesUsingLinq) { Console.WriteLine(price.Value.Trim()); } // Problem 13: Create an XSL stylesheet, which transforms the file catalog.xml into HTML document, // formatted for viewing in a standard Web-browser. // Problem 14: Write a C# program to apply the XSLT stylesheet transformation on the file catalog.xml // using the class XslTransform. XslCompiledTransform catalogueXslt = new XslCompiledTransform(); catalogueXslt.Load("../../catalogue.xslt"); catalogueXslt.Transform(PathToXmlFile, "../../catalogue.html"); // Problem 15: // *Read some tutorial about the XQuery language. // Implement the XML to HTML transformation with XQuery (instead of XSLT). // Download some open source XQuery library for .NET and execute the XQuery to transform the catalog.xml to HTML. XQueryNavigatorCollection col = new XQueryNavigatorCollection(); // Add the XML document catalogue.xml to the collection using cat as the name to reference. col.AddNavigator("../../catalogue.xml", "cat"); var expr = new XQueryExpression( "<html><body><head><title>Catalogue</title></head>" + "<h1>Catalogue generated using XQuery</h1>" + "{For $a IN document(\"cat\")/catalogue/album " + "RETURN <div><strong>Title:</strong> {$a/name/text()}<br />" + "<strong>Artist:</strong> {$a/artist/text()}<br />" + "<strong>Year:</strong> {$a/year/text()}<br />" + "<strong>Producer:</strong> {$a/producer/text()}<br />" + "<strong>Price:</strong> {$a/price/text()}<br />" + "<strong>Songs:</strong><ol>{For $s IN $a/songs/song RETURN <li>{$s/title/text()}</li>}</ol>" + "</div><hr />}</body></html>"); StreamWriter str = new StreamWriter("../../catalogueUsingXQuery.html"); XQueryNavigator nav = expr.Execute(col); nav.ToXml(str); str.Close(); // Problem 16: // Using Visual Studio generate an XSD schema for the file catalog.xml. // Write a C# program that takes an XML file and an XSD file (schema) and validates the XML file against the schema. // Test it with valid XML catalogs and invalid XML catalogs. string xsdMarkup = File.ReadAllText("../../catalogue.xsd"); XmlSchemaSet schemas = new XmlSchemaSet(); schemas.Add(string.Empty, XmlReader.Create(new StringReader(xsdMarkup))); XDocument valid = XDocument.Load(PathToXmlFile); XDocument invalid = new XDocument( new XElement( "Root", new XElement("Child1", "content1"), new XElement("Child2", "content2"))); Console.WriteLine(new string('-', 50)); Console.WriteLine("Validating valid document:"); bool errors = false; valid.Validate(schemas, (o, e) => { Console.WriteLine("{0}", e.Message); errors = true; }); Console.WriteLine("Valid {0}", errors ? "did not validate" : "validated"); Console.WriteLine(); Console.WriteLine("Validating invalid document:"); errors = false; invalid.Validate(schemas, (o, e) => { Console.WriteLine("{0}", e.Message); errors = true; }); Console.WriteLine("doc2 {0}", errors ? "did not validate" : "validated"); }