public void VerifyGenerateRawData() { // Arrange var statement = new InsertSqlStatement("MagicTable"); const string Column1 = "Column_1"; const string Column2 = "Column_2"; const string Column3 = "Magical_arbitrary_column"; statement.Columns.AddRange(new[] { Column1, Column2, Column3 }); statement.Rows.AddRange(new[] { new List <object> { "Data 1", 24, true }, new List <object> { "Cool 2", 42, false } }); // Act var query = statement.GenerateQuery(); // Assert var expected = $@" INSERT INTO MagicTable ({Column1}, {Column2}, {Column3}) VALUES ('Data 1', 24, 1), ('Cool 2', 42, 0); "; foreach (var c in Environment.NewLine) { expected = expected.Trim(c); } foreach (var c in Environment.NewLine) { expected = expected.Trim(c); } query.ShouldBe(expected); }
public void VerifyInsertWithNullValues() { // Arrange var statement = new InsertSqlStatement("My_magic_table"); statement.Columns.AddRange(new[] { "Column A", "Column B", "Column C" }); statement.Rows.Add(new List <object> { "Value A", 123, null }); // Act string generatedQuery = null; Should.NotThrow(() => generatedQuery = statement.GenerateQuery()); // Assert string.IsNullOrEmpty(generatedQuery).ShouldBeFalse(); }