public void ReadAll_InputWithHeader_Ok()
{
string input = "Header#1;Header#2;Header#3\r\n1;2;3\r\n4;5;6";
IDataTransformer transformer = new NullTransformerForAdapterTesting(
new string[]
{
"Header#1",
"Header#2",
"Header#3"
},
new ArrayList()
{
new string[] {"1", "2", "3"},
new string[] {"4", "5", "6"},
});
using (Dialect dialect = new Dialect(true, ';', '"', '\\', true, "\r\n", QuoteStyle.QUOTE_NONE, true, true))
{
using (CSVAdapter adapter = new CSVAdapter(dialect, new StringReader(input)))
{
adapter.ReadAll(transformer);
}
}
}
public void Adapter_HeaderIsNull_ThrowsException()
{
IDataTransformer transformer = new NullTransformerForAdapterTesting(new string[] {}, new string[] {});
using (var dialect = new Dialect(true, ';', '"', '\\', true, "\r\n", QuoteStyle.QuoteNone, true, true))
{
using (var adapter = new CSVAdapter(dialect, new StringWriter(), null))
{
}
}
}
public void ReadAll_ExistingFileName_ReturnsRecords()
{
IDataTransformer transformer = new NullTransformerForAdapterTesting(
new[] { "Header#1", "Header#2", "Header#3" },
new[]
{
new[] {"1", "2", "3"},
new[] {"4", "5", "6"}
});
using (var dialect = new Dialect(true, ';', '"', '\\', true, "\r\n", QuoteStyle.QuoteNone, true, true))
{
using (var adapter = new CSVAdapter(dialect, "test.csv", "utf-8"))
{
adapter.ReadAll(transformer);
}
}
}
public void ReadAll_WithoutHeaders_ReturnRecords()
{
const string input = "1;2;3\r\n4;5;6";
IDataTransformer transformer = new NullTransformerForAdapterTesting(
null,
new[]
{
new[] {"1", "2", "3"},
new[] {"4", "5", "6"}
});
using (var dialect = new Dialect(true, ';', '"', '\\', true, "\r\n", QuoteStyle.QuoteNone, true, false))
{
using (var adapter = new CSVAdapter(dialect, new StringReader(input)))
{
adapter.ReadAll(transformer);
}
}
}
public void ReadAll_ExistingStream_ReturnsRecords()
{
const string input = "Header#1;Header#2;Header#3\r\n1;2;3\r\n4;5;6";
IDataTransformer transformer = new NullTransformerForAdapterTesting(
new[] { "Header#1", "Header#2", "Header#3" },
new[]
{
new[] {"1", "2", "3"},
new[] {"4", "5", "6"}
});
using (var dialect = new Dialect(true, ';', '"', '\\', true, "\r\n", QuoteStyle.QuoteNone, true, true))
{
using (var adapter = new CSVAdapter(dialect, new StringReader(input)))
{
adapter.ReadAll(transformer);
}
}
}
public void WriteAll_OutputWithHeader_Ok()
{
string[] header = new string[]
{
"Header#1",
"Header#2",
"Header#3"
};
ArrayList data = new ArrayList()
{
header,
new string[] {"1", "2", "3"},
new string[] {"4", "5", "6"},
};
IDataTransformer transformer = new NullTransformerForAdapterTesting(
header,
data);
using (Dialect dialect = new Dialect(true, ';', '"', '\\', true, "\r\n", QuoteStyle.QUOTE_NONE, true, true))
{
using (CSVAdapter adapter = new CSVAdapter(dialect, new StringWriter()))
{
adapter.WriteAll(data, transformer);
}
}
}
public void WriteAll_DataTransformerIsNull_ThrowsException()
{
var headers = new[]
{
"Header#1",
"Header#2",
"Header#3"
};
var data = new[]
{
new[] {"1", "2", "3"},
new[] {"4", "5", "6"}
};
using (var dialect = new Dialect(true, ';', '"', '\\', true, "\r\n", QuoteStyle.QuoteNone, true, false))
{
using (var adapter = new CSVAdapter(dialect, new StringWriter(), headers))
{
adapter.WriteAll(data, null);
}
}
}
public void WriteAll_WithoutHeaders_WroteRecords()
{
var data = new[]
{
new[] {"1", "2", "3"},
new[] {"4", "5", "6"}
};
IDataTransformer transformer = new NullTransformerForAdapterTesting(
null, data);
using (var dialect = new Dialect(true, ';', '"', '\\', true, "\r\n", QuoteStyle.QuoteNone, true, false))
{
using (var adapter = new CSVAdapter(dialect, new StringWriter()))
{
adapter.WriteAll(data, transformer);
}
}
}
public void WriteAll_NotEqualCellCountInRows_ThrowsException()
{
var headers = new[]
{
"Header#1",
"Header#2",
"Header#3"
};
var data = new[]
{
new[] {"1", "2", "3"},
new[] {"4", "5"}
};
IDataTransformer transformer = new NullTransformerForAdapterTesting(headers, data);
using (var dialect = new Dialect(true, ';', '"', '\\', true, "\r\n", QuoteStyle.QuoteNone, true, false))
{
using (var adapter = new CSVAdapter(dialect, new StringWriter(), null))
{
adapter.WriteAll(data, transformer);
}
}
}