private void writeRow(string connectionString, dcp.lib.DataCopier.Options opts)
{
using (var writer = new SqlServer(connectionString, opts))
{
writer.Next(rows);
}
}
void writeRows(dcp.lib.DataCopier.Options opts, List <dcp.lib.Row> rows)
{
using (var writer = new Csv(stream, opts))
{
writer.Next(rows);
}
}
public void ThrowsIfStringTooLong()
{
createCleanDatabase();
createCleanTable();
var opts = new dcp.lib.DataCopier.Options();
opts.outputTable = "testTable";
rows[0][1] = "tooLongString";
Assert.Throws <SqlException>(() => writeRow(CONNECTIONSTRINGWITHDATABASE, opts));
}
public void ReturnsCorrectNumberOfRows()
{
var opts = new dcp.lib.DataCopier.Options();
using (var reader = new Xlsx(stream, opts))
{
var rows = reader.Next(3);
Assert.Equal(3, rows.Count);
}
}
public void ReadsLastRowValue()
{
var opts = new dcp.lib.DataCopier.Options();
using (var reader = new Xlsx(stream, opts))
{
var row = reader.Next(1);
Assert.Equal(new DateTime(2031, 12, 1), row[0][2]);
}
}
public void ReturnsShortListIfNotEnoughRows()
{
var opts = new dcp.lib.DataCopier.Options();
using (var reader = new Xlsx(stream, opts))
{
var rows = reader.Next(9);
Assert.Equal(3, rows.Count);
}
}
public void ReadsAllColumns()
{
var opts = new dcp.lib.DataCopier.Options();
using (var reader = new Csv(stream, opts))
{
var row = reader.Next(1);
Assert.Equal(4, row[0].Count);
}
}
public void SkipsColumns()
{
var opts = new dcp.lib.DataCopier.Options();
opts.skipColumns = 1;
using (var reader = new Xlsx(stream, opts))
{
var rows = reader.Next(1);
Assert.Equal("one", rows[0][0]);
}
}
public void ReadsSelectedWorksheet()
{
var opts = new dcp.lib.DataCopier.Options();
opts.worksheetNumber = 1;
using (var reader = new Xlsx(stream, opts))
{
var rows = reader.Next(1);
Assert.Equal(new DateTime(9031, 12, 1), rows[0][2]);
}
}
public void LeavesRows()
{
var opts = new dcp.lib.DataCopier.Options();
opts.leaveRows = 1;
using (var reader = new Xlsx(stream, opts))
{
var rows = reader.Next(9);
Assert.Equal(2, rows.Count);
}
}
public void WritesLastRowValue()
{
createCleanDatabase();
createCleanTable();
var opts = new dcp.lib.DataCopier.Options();
opts.outputTable = TABLENAME;
writeRow(CONNECTIONSTRINGWITHDATABASE, opts);
var result = runQuery($"USE {DATABASENAME}; SELECT * FROM {TABLENAME}");
Assert.Equal(rows[0][2], result[2]);
}
public void WritesRow()
{
var opts = new dcp.lib.DataCopier.Options();
var rows = new List <dcp.lib.Row>()
{
row1
};
writeRows(opts, rows);
Assert.Equal("1,two,14/03/1961 01:02:03\r\n", getResult());
}
public void UsesMaxColumns()
{
var opts = new dcp.lib.DataCopier.Options();
opts.maxColumns = 1;
using (var reader = new Xlsx(stream, opts))
{
var rows = reader.Next(1);
Assert.Equal(1.1, rows[0][0]);
Assert.Single(rows[0]);
}
}
public void EscapesNewLine()
{
var row = new dcp.lib.Row();
row.Add("newline\nstring");
var opts = new dcp.lib.DataCopier.Options();
var rows = new List <dcp.lib.Row>()
{
row
};
writeRows(opts, rows);
Assert.Equal("\"newline\nstring\"\r\n", getResult());
}
public void TruncatesTableIfRequested()
{
createCleanDatabase();
createCleanTable();
addRowToTable();
var opts = new dcp.lib.DataCopier.Options();
opts.truncate = true;
opts.outputTable = TABLENAME;
writeRow(CONNECTIONSTRINGWITHDATABASE, opts);
var result = runQuery($"USE {DATABASENAME}; SELECT COUNT(col1) FROM {TABLENAME}");
Assert.Equal(1, result[0]);
}
