public async Task SmokeTest()
{
var csvData =
"A;B;C" + Environment.NewLine +
"a1;b1;c1" + Environment.NewLine +
"a2;b2;c2";
var sb = new StringBuilder();
using var csvWriter = new CsvWriter(sb);
var csvTableWriter = new CsvTableWriter(csvWriter);
await csvTableWriter.WriteHeadersAsync("A", "B", "C");
Assert.Equal(3, csvTableWriter.Headers.Count);
csvTableWriter[0] = "a1";
csvTableWriter[1] = "b1";
csvTableWriter[2] = "c1";
await csvTableWriter.WriteAsync();
csvTableWriter["A"] = "a2";
csvTableWriter["B"] = "b2";
csvTableWriter["C"] = "c2";
await csvTableWriter.WriteAsync();
Assert.Equal(csvData, sb.ToString());
}
public async Task TestJsonValues()
{
var csvData =
"A;B" + Environment.NewLine +
"42;\"{\"\"IntValue\"\":42,\"\"StrValue\"\":\"\"Forty-Two\"\"}\"" + Environment.NewLine +
"5;\"{\"\"IntValue\"\":5,\"\"StrValue\"\":\"\"Five\"\"}\"";
var sb = new StringBuilder();
using var csvWriter = new CsvWriter(sb);
var csvTableWriter = new CsvTableWriter(csvWriter);
csvTableWriter.AddConverter <CustomType>(new CustomTypeConverter());
await csvTableWriter.WriteHeadersAsync("A", "B");
Assert.Equal(2, csvTableWriter.Headers.Count);
csvTableWriter.SetValue("A", 42);
csvTableWriter.SetValue("B", new CustomType {
IntValue = 42, StrValue = "Forty-Two"
});
await csvTableWriter.WriteAsync();
csvTableWriter.SetValue("A", 5);
csvTableWriter.SetValue("B", new CustomType {
IntValue = 5, StrValue = "Five"
});
await csvTableWriter.WriteAsync();
Assert.Equal(csvData, sb.ToString());
}
public void CsvTableWriter_BlankRow()
{
string path = Path.GetTempFileName();
try
{
using (var writer = new CsvTableWriter(new string[] { "Col0", "Col1", "Col2" }, new FileStream(path, FileMode.Create), Encoding.UTF8))
{
writer.Set("Col0", "(0,0)");
writer.Set("Col1", "(1,0)");
writer.Set("Col2", "(2,0)");
writer.WriteRow();
writer.WriteRow();
writer.Set("Col0", "(0,2)");
writer.Set("Col1", "(1,2)");
writer.Set("Col2", "(2,2)");
writer.WriteRow();
}
using (var reader = new CsvTableReader(new FileStream(path, FileMode.Open), Encoding.UTF8))
{
Assert.True(reader.ColumnMap.ContainsKey("Col0"));
Assert.True(reader.ColumnMap.ContainsKey("Col1"));
Assert.True(reader.ColumnMap.ContainsKey("Col2"));
Assert.NotNull(reader.ReadRow());
Assert.Equal("(0,0)", reader["Col0"]);
Assert.Equal("(1,0)", reader["Col1"]);
Assert.Equal("(2,0)", reader["Col2"]);
Assert.NotNull(reader.ReadRow());
Assert.Equal("", reader["Col0"]);
Assert.Equal("", reader["Col1"]);
Assert.Equal("", reader["Col2"]);
Assert.NotNull(reader.ReadRow());
Assert.Equal("(0,2)", reader["Col0"]);
Assert.Equal("(1,2)", reader["Col1"]);
Assert.Equal("(2,2)", reader["Col2"]);
Assert.Null(reader.ReadRow());
}
}
finally
{
File.Delete(path);
}
}
public void CsvTableWriter_Basic()
{
string path = Path.GetTempFileName();
try
{
using (var writer = new CsvTableWriter(new string[] { "Col0", "Col1", "Col2" }, new FileStream(path, FileMode.Create), Encoding.UTF8))
{
Assert.AreEqual(0, writer.GetColumnIndex("Col0"));
Assert.AreEqual(1, writer.GetColumnIndex("Col1"));
Assert.AreEqual(2, writer.GetColumnIndex("Col2"));
Assert.AreEqual(-1, writer.GetColumnIndex("Col3"));
writer.Set("Col0", "(0,0)");
writer.Set("Col1", "(1,0)");
writer.Set("Col2", "(2,0)");
writer.WriteRow();
writer.Set("Col0", "(0,1)");
writer.Set("Col1", "(1,1)");
writer.Set("Col2", "(2,1)");
writer.WriteRow();
}
using (var reader = new CsvTableReader(new FileStream(path, FileMode.Open), Encoding.UTF8))
{
Assert.IsTrue(reader.ColumnMap.ContainsKey("Col0"));
Assert.IsTrue(reader.ColumnMap.ContainsKey("Col1"));
Assert.IsTrue(reader.ColumnMap.ContainsKey("Col2"));
Assert.IsNotNull(reader.ReadRow());
Assert.AreEqual("(0,0)", reader.Parse("Col0", (string)null));
Assert.AreEqual("(1,0)", reader.Parse("Col1", (string)null));
Assert.AreEqual("(2,0)", reader.Parse("Col2", (string)null));
Assert.IsNotNull(reader.ReadRow());
Assert.AreEqual("(0,1)", reader.Parse("Col0", (string)null));
Assert.AreEqual("(1,1)", reader.Parse("Col1", (string)null));
Assert.AreEqual("(2,1)", reader.Parse("Col2", (string)null));
Assert.IsNull(reader.ReadRow());
}
}
finally
{
Helper.DeleteFile(path);
}
}
public async Task TestStronglyTypedValues()
{
var csvData =
"A;B;C;D" + Environment.NewLine +
"22;Text;true;01.01.2010" + Environment.NewLine +
"-31;A long text;false;20.01.2050" + Environment.NewLine +
"55;\"A text with ;\";;31.07.1971";
var sb = new StringBuilder();
using var csvWriter = new CsvWriter(sb);
var csvTableWriter = new CsvTableWriter(csvWriter);
csvTableWriter.SetFormats <DateTime>("dd.MM.yyyy");
csvTableWriter.SetTrueFalseString <bool>("true", "false");
await csvTableWriter.WriteHeadersAsync("A", "B", "C", "D");
Assert.Equal(4, csvTableWriter.Headers.Count);
csvTableWriter.SetValue("A", 22);
csvTableWriter.SetValue("B", "Text");
csvTableWriter.SetValue("C", true);
csvTableWriter.SetValue("D", new DateTime(2010, 1, 1));
await csvTableWriter.WriteAsync();
csvTableWriter.SetValue("A", -31);
csvTableWriter.SetValue("B", "A long text");
csvTableWriter.SetValue("C", false);
csvTableWriter.SetValue("D", new DateTime(2050, 1, 20));
await csvTableWriter.WriteAsync();
Assert.True(csvTableWriter.TrySetValue("A", 55));
Assert.True(csvTableWriter.TrySetValue("B", "A text with ;"));
Assert.True(csvTableWriter.TrySetValue("C", null));
Assert.True(csvTableWriter.TrySetValue("D", new DateTime(1971, 7, 31)));
await csvTableWriter.WriteAsync();
Assert.Equal(csvData, sb.ToString());
}
public void CsvTableWriter_Basic()
{
using (var tempFolder = new TempFolder())
{
string path = Path.Combine(tempFolder.Path, "test.csv");
using (var writer = new CsvTableWriter(new string[] { "Col0", "Col1", "Col2" }, new FileStream(path, FileMode.Create), Encoding.UTF8))
{
Assert.Equal(0, writer.GetColumnIndex("Col0"));
Assert.Equal(1, writer.GetColumnIndex("Col1"));
Assert.Equal(2, writer.GetColumnIndex("Col2"));
Assert.Equal(-1, writer.GetColumnIndex("Col3"));
writer.Set("Col0", "(0,0)");
writer.Set("Col1", "(1,0)");
writer.Set("Col2", "(2,0)");
writer.WriteRow();
writer.Set("Col0", "(0,1)");
writer.Set("Col1", "(1,1)");
writer.Set("Col2", "(2,1)");
writer.WriteRow();
}
using (var reader = new CsvTableReader(new FileStream(path, FileMode.Open), Encoding.UTF8))
{
Assert.True(reader.ColumnMap.ContainsKey("Col0"));
Assert.True(reader.ColumnMap.ContainsKey("Col1"));
Assert.True(reader.ColumnMap.ContainsKey("Col2"));
Assert.NotNull(reader.ReadRow());
Assert.Equal("(0,0)", reader["Col0"]);
Assert.Equal("(1,0)", reader["Col1"]);
Assert.Equal("(2,0)", reader["Col2"]);
Assert.NotNull(reader.ReadRow());
Assert.Equal("(0,1)", reader["Col0"]);
Assert.Equal("(1,1)", reader["Col1"]);
Assert.Equal("(2,1)", reader["Col2"]);
Assert.Null(reader.ReadRow());
}
}
}
public async Task TestStronglyTypedWriter()
{
var csvData =
"A;B;C;D" + Environment.NewLine +
"22;Text;true;01.01.2010" + Environment.NewLine +
"-31;A long text;false;20.01.2050" + Environment.NewLine +
"55;\"A text with ;\";;31.07.1971";
var sb = new StringBuilder();
using var csvWriter = new CsvWriter(sb);
var csvTableWriter = new CsvTableWriter(csvWriter);
csvTableWriter.SetFormats <DateTime>("dd.MM.yyyy");
csvTableWriter.SetTrueFalseString <bool>("true", "false");
await csvTableWriter.WriteHeadersAsync <SampleObject>(x => new { x.A, x.B, x.C, x.D });
Assert.Equal(4, csvTableWriter.Headers.Count);
await csvTableWriter.WriteAsync(new SampleObject()
{
A = 22, B = "Text", C = true, D = new DateTime(2010, 1, 1)
});
await csvTableWriter.WriteAsync(new SampleObject()
{
A = -31, B = "A long text", C = false, D = new DateTime(2050, 1, 20)
});
await csvTableWriter.WriteAsync(new SampleObject()
{
A = 55, B = "A text with ;", C = null, D = new DateTime(1971, 7, 31)
});
Assert.Equal(csvData, sb.ToString());
}
private static int ListZones(string[] args)
{
bool db = args.Length >= 2 && String.Compare(args[1], "-db", true) == 0;
bool dbUpgrade = args.Length >= 2 && String.Compare(args[1], "-dbupgrade", true) == 0;
// Note that one obscure timezone has an ID and display name with a single
// quote (') that causes problems in the TSQL script. I'm going to correct
// this by replacing the quote with a dash.
if (db)
{
foreach (var zone in TimeZoneInfo.GetSystemTimeZones())
{
Console.WriteLine("insert into PortalTimeZones(ID,DisplayName,TimeZoneInfo) values('{0}','{1}','{2}')",
zone.Id.Replace("'", "-"),
zone.DisplayName.Replace("'", "-"),
zone.ToSerializedString().Replace("'", "-"));
}
}
else if (dbUpgrade)
{
// This is a one-time hack to deal with the fact that I mistakenly used
// the time zone DisplayName as the unique identifier in the Paraworks
// time zone table. I need to add an ID column instead and use this.
// The problem is that existing organizations will have references to
// this table (probably only to the PST zone) and I'd like to maintain
// these references.
//
// The script generated below performs the following steps:
//
// 1. Adds the ID and Upgraded columns to the PortalTimeZone
// table, initializing ID=' ' and Upgraded=0.
//
// 2. For each Windows time zone, code will be generated that
// looks for an exact match in the database based on
// the display name. If a match is found, the ID column
// will be set to the time zone ID and Upgraded will
// be set to 1. If no match is found, then a new
// time zone row will be added.
//
// 3. Any rows with Upgraded=0 will be deleted.
//
// 4. The Upgraded column will be removed.
//
// 5. Create an index on the ID column.
Console.WriteLine("alter table PortalTimeZones");
Console.WriteLine(" add ID $(ObjectName) not null default ' '");
Console.WriteLine("alter table PortalTimeZones");
Console.WriteLine(" add Upgraded bit");
Console.WriteLine("go");
Console.WriteLine();
Console.WriteLine("update PortalTimeZones set Upgraded=0");
Console.WriteLine("go");
Console.WriteLine();
foreach (var zone in TimeZoneInfo.GetSystemTimeZones())
{
string id = "'" + zone.Id.Replace("'", "-") + "'";
string displayName = "'" + zone.DisplayName.Replace("'", "-") + "'";
string data = "'" + zone.ToSerializedString().Replace("'", "-") + "'";
string script =
@"if exists(select 1 from PortalTimeZones where DisplayName={1})
update PortalTimeZones
set ID={0}, DisplayName={1}, Upgraded=1
where DisplayName={1}
else
insert into PortalTimeZones(ID,DisplayName,TimeZoneInfo,Upgraded) values({0},{1},{2},1)
";
Console.WriteLine(script, id, displayName, data);
}
Console.WriteLine("go");
Console.WriteLine();
Console.WriteLine("delete from PortalTimeZones where Upgraded=0");
Console.WriteLine("go");
Console.WriteLine();
Console.WriteLine("alter table PortalTimeZones");
Console.WriteLine(" drop column Upgraded");
Console.WriteLine("go");
Console.WriteLine();
Console.WriteLine("create unique index ID on PortalTimeZones(ID)");
Console.WriteLine("go");
}
else
{
using (var writer = new CsvTableWriter(new string[] { "ID", "DisplayName", "Data" }, Console.OpenStandardOutput(), Helper.AnsiEncoding))
{
foreach (var zone in TimeZoneInfo.GetSystemTimeZones())
{
writer.Set("ID", zone.Id);
writer.Set("DisplayName", zone.DisplayName.Replace("'", "-"));
writer.Set("Data", zone.ToSerializedString().Replace("'", "-"));
writer.WriteRow();
}
}
}
return(0);
}
