public void TransformationTableToString_CorrectTable_ReturnIEnumerable()
{
var table = new Table(new string[] { "id", "User", "Balance", "Date" });
table.AddRow("1234", "Иван Иванов", "10000.10", "10.10.2000");
table.AddRow("1243", "Петор Петров", "100000", "2000-12-12");
var result = step.TransformationTableToString(table);
result.Should().NotBeNull();
result.Should().HaveCount(2);
}
public void ToSqlQuery_CorrectTable_ReturnString()
{
var table = new Table(new string[] { "id", "User", "Balance", "Date", "Bool" });
table.AddRow("1243", "Петор Петров", "100000", "2000-12-12", "false");
var ListParams = step.TransformationTableToString(table);
var result = ListParams.ToSqlQuery(tableName);
result.Should().BeEquivalentTo("INSERT INTO Table (id,User,Balance,Date,Bool)" +
" VALUES (1243,'Петор Петров',100000,'2000-12-12',False)");
}