public void ToSqlQuery_TableIsEmpty_ReturnThrow()
{
var ListParams = new List <Dictionary <string, object> >();
Action action = () => ParserToString.ToSqlQuery(ListParams, tableName);
action.Should()
.Throw <ArgumentNullException>()
.WithMessage($"Value cannot be null.{Environment.NewLine}Parameter name: List with table parameters is Empty.");
}
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 = ParserToString.ToSqlQuery(ListParams, tableName);
result.Should().BeEquivalentTo("INSERT INTO Table (id,User,Balance,Date,Bool)" +
" VALUES (1243,'Петор Петров',100000,'2000-12-12',False)");
}
public void ToSqlQuery_TableNameIsEmpty_ReturnThrow()
{
var tableName = string.Empty;
var table = new Table(new string[] { "id", "User", "Balance", "Date", "Bool", "idClient" });
table.AddRow("1243", "Петор Петров", "100000", "2000-12-12", "false", "");
var ListParams = step.TransformationTableToString(table);
Action action = () => ParserToString.ToSqlQuery(ListParams, tableName);
action.Should()
.Throw <ArgumentNullException>()
.WithMessage($"Value cannot be null.{Environment.NewLine}Parameter name: Table name is Empty.");
}