public void StructuredFileWriterXMLEncodeTest() { var writeFile = new StructuredFile { ID = "Write", FileName = Path.Combine(m_ApplicationDirectory, "StructuredFileOutputXML.txt"), SqlStatement = "Read", InOverview = true, JSONEncode = false }; var cols = DetermineColumnFormat.GetWriterSourceColumns(writeFile, CancellationToken.None); var sb = new StringBuilder(); sb.AppendLine("<?xml version=\"1.0\"?>\n"); sb.AppendLine("<rowset>"); writeFile.Header = sb.ToString(); sb.Clear(); sb.AppendLine(" <row>"); foreach (var col in cols) { sb.AppendFormat(" <{0}>{1}</{0}>\n", HTMLStyle.XmlElementName(col.Header), string.Format(System.Globalization.CultureInfo.InvariantCulture, StructuredFileWriter.cFieldPlaceholderByName, col.Header)); } sb.AppendLine(" </row>"); writeFile.Row = sb.ToString(); writeFile.Footer = "</rowset>"; var writer = new StructuredFileWriter(writeFile, CancellationToken.None); _ = writer.Write(); }
public void StructuredFileWriterJSONEncodeTest() { var writeFile = new StructuredFile { ID = "Write", FileName = Path.Combine(m_ApplicationDirectory, "StructuredFileOutputJSON.txt"), SqlStatement = "Read", InOverview = true, JSONEncode = true }; var cols = DetermineColumnFormat.GetWriterSourceColumns(writeFile, CancellationToken.None); writeFile.Header = "{\"rowset\":[\n"; var sb = new StringBuilder("{"); // { "firstName":"John", "lastName":"Doe"}, foreach (var col in cols) { sb.AppendFormat("\"{0}\":\"{1}\", ", HTMLStyle.JsonElementName(col.Header), string.Format(System.Globalization.CultureInfo.InvariantCulture, StructuredFileWriter.cFieldPlaceholderByName, col.Header)); } if (sb.Length > 1) { sb.Length -= 2; } sb.AppendLine("},"); writeFile.Row = sb.ToString(); var writer = new StructuredFileWriter(writeFile, CancellationToken.None); _ = writer.Write(); }
public async Task StructuredFileWriterJSONEncodeTestAsync() { var writeFile = new StructuredFile { ID = "Write", FileName = "StructuredFileOutputJSON.txt", SqlStatement = c_ReadID, InOverview = true, JSONEncode = true }; var sb = new StringBuilder("{"); using (var processDisplay = new CustomProcessDisplay(UnitTestInitializeCsv.Token)) { var cols = await DetermineColumnFormat.GetSqlColumnNamesAsync(writeFile.SqlStatement, writeFile.Timeout, processDisplay.CancellationToken); writeFile.Header = "{\"rowset\":[\n"; // { "firstName":"John", "lastName":"Doe"}, foreach (var col in cols) { sb.AppendFormat("\"{0}\":\"{1}\", ", HTMLStyle.JsonElementName(col), string.Format(CultureInfo.InvariantCulture, StructuredFileWriter.cFieldPlaceholderByName, col)); } if (sb.Length > 1) { sb.Length -= 2; } sb.AppendLine("},"); writeFile.Row = sb.ToString(); var writer = new StructuredFileWriter(writeFile, processDisplay); var result = await writer.WriteAsync(writeFile.SqlStatement, writeFile.Timeout, t => processDisplay.SetProcess(t, 0, true), processDisplay.CancellationToken); Assert.AreEqual(7L, result); } }
public async Task StructuredFileWriterXMLEncodeTest() { var writeFile = new StructuredFile { ID = "Write", FileName = "StructuredFileOutputXML.txt", SqlStatement = c_ReadID, InOverview = true, JSONEncode = false }; var sb = new StringBuilder(); using (var processDisplay = new CustomProcessDisplay(UnitTestInitializeCsv.Token)) { var cols = await DetermineColumnFormat.GetSqlColumnNamesAsync(writeFile.SqlStatement, writeFile.Timeout, processDisplay.CancellationToken); sb.AppendLine("<?xml version=\"1.0\"?>\n"); sb.AppendLine("<rowset>"); writeFile.Header = sb.ToString(); sb.Clear(); sb.AppendLine(" <row>"); foreach (var col in cols) { sb.AppendFormat(" <{0}>{1}</{0}>\n", HTMLStyle.XmlElementName(col), string.Format(CultureInfo.InvariantCulture, StructuredFileWriter.cFieldPlaceholderByName, col)); } sb.AppendLine(" </row>"); writeFile.Row = sb.ToString(); writeFile.Footer = "</rowset>"; var writer = new StructuredFileWriter(writeFile, processDisplay); await writer.WriteAsync(writeFile.SqlStatement, writeFile.Timeout, null, processDisplay.CancellationToken); } }