public void CompressedWriterTest()
{
var uri = new Uri("CsvFileTest_CompressedWriterTest.csv.gz", UriKind.Relative);
using (var csv = new CsvFile(uri, DataFileMode.Write, CompressionMethod.GZip))
{
using (var cn = new SqlConnection(Jhu.Graywulf.Test.Constants.TestConnectionString))
{
cn.Open();
using (var cmd = new SqlCommand("SELECT SampleData.* FROM SampleData", cn))
{
using (var dr = cmd.ExecuteReader())
{
csv.WriteFromDataReader(dr);
}
}
}
}
Assert.IsTrue(File.Exists(uri.ToString()));
File.Delete(uri.ToString());
}
public void SimpleWriterTest()
{
var w = new StringWriter();
using (var cn = new SqlConnection(Jhu.Graywulf.Test.Constants.TestConnectionString))
{
cn.Open();
using (var cmd = new SqlCommand("SELECT SampleData.* FROM SampleData", cn))
{
using (var dr = cmd.ExecuteReader())
{
var csv = new CsvFile(w);
csv.WriteFromDataReader(dr);
}
}
}
Assert.AreEqual(
@"#float,double,decimal,nvarchar(50),bigint,int,tinyint,smallint,bit,ntext,char,datetime,guid
1.234568,1.23456789,1.2346,""this is text"",123456789,123456,123,12345,True,""this is unicode text ő"",""A"",08/17/2012 00:00:00,68652251-c9e4-4630-80be-88b96d3258ce
",
w.ToString());
}