public void GetRowValuesString_DateTimeValue_ShouldBeWrappedByQuotes() { var data = DateTime.Now; var dataColumns = new DataColumn[] { new DataColumn("Col1", typeof(DateTime)) }; var dataTable = GetDataTable(dataColumns); dataTable.Rows.Add(data); IQueryFormatter queryFormatter = new QueryFormatter(); queryFormatter.GetRowValuesString(dataTable.Rows[0]).Should().StartWith("'"); queryFormatter.GetRowValuesString(dataTable.Rows[0]).Should().EndWith("'"); }
public void GetRowValuesString_DecimalValue_ShouldNotBeWrappedByQuotes() { var data = 1.1m; var dataColumns = new DataColumn[] { new DataColumn("Col1", typeof(decimal)) }; var dataTable = GetDataTable(dataColumns); dataTable.Rows.Add(data); IQueryFormatter queryFormatter = new QueryFormatter(); queryFormatter.GetRowValuesString(dataTable.Rows[0]).Should().BeEquivalentTo($"{data}"); queryFormatter.GetRowValuesString(dataTable.Rows[0]).Should().NotContain("'"); }
public void GetRowValuesString_DateTimeValue_ShouldHaveSqlFormatting(DateTime dateTime, string expectedFormat) { var dataColumns = new DataColumn[] { new DataColumn("Col1", typeof(DateTime)) }; var dataTable = GetDataTable(dataColumns); dataTable.Rows.Add(dateTime); IQueryFormatter queryFormatter = new QueryFormatter(); queryFormatter.GetRowValuesString(dataTable.Rows[0]).Should().BeEquivalentTo($"'{expectedFormat}'"); }
public void GetRowValuesString_StringValue_ShouldBeWrappedByQuotes() { var data = "foo"; var dataColumns = new DataColumn[] { new DataColumn("Col1", typeof(string)) }; var dataTable = GetDataTable(dataColumns); dataTable.Rows.Add(data); IQueryFormatter queryFormatter = new QueryFormatter(); queryFormatter.GetRowValuesString(dataTable.Rows[0]).Should().BeEquivalentTo($"'{data}'"); }
public void GetRowValuesString_ShouldProduceNull_IfColumnIsNullableAndValueIsNull() { var data = new object[] { null, null, null }; var col1 = new DataColumn("Col1", typeof(string)); col1.AllowDBNull = true; var col2 = new DataColumn("Col2", typeof(DateTime)); col2.AllowDBNull = true; var col3 = new DataColumn("Col3", typeof(int)); col3.AllowDBNull = true; var dataColumns = new DataColumn[] { col1, col2, col3 }; var dataTable = GetDataTable(dataColumns); dataTable.Rows.Add(data); IQueryFormatter queryFormatter = new QueryFormatter(); queryFormatter.GetRowValuesString(dataTable.Rows[0]).Should().BeEquivalentTo($"NULL, NULL, NULL"); }