public void Formats_ulong_parameter()
{
Assert.Equal(
"'777'",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", (ulong)777, true, ParameterDirection.Input, DbType.UInt64, false, 0, 0, 0)));
}
public void Formats_sensitive_nullable_int_parameter()
{
Assert.Equal(
"'?'",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", "?", false, ParameterDirection.Input, DbType.Int32, true, 0, 0, 0)));
}
public void Formats_null_nullable_int_parameter()
{
Assert.Equal(
"'' (DbType = Int32)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", null, true, ParameterDirection.Input, DbType.Int32, true, 0, 0, 0)));
}
public void Formats_int_parameter_with_no_type()
{
Assert.Equal(
"'777'",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", 777, true, ParameterDirection.Input, 0, false, 0, 0, 0)));
}
public void Formats_binary_parameter()
{
Assert.Equal(
"'0x0102'",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", new byte[] { 1, 2 }, true, ParameterDirection.Input, DbType.Binary, true, 0, 0, 0)));
}
public void Formats_decimal_parameter_with_precision_and_scale()
{
Assert.Equal(
"'77.7' (Precision = 18) (Scale = 2)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", (decimal)77.7, true, ParameterDirection.Input, DbType.Decimal, false, 0, 18, 2)));
}
public void Formats_non_unicode_non_nullable_sized_string_parameter()
{
Assert.Equal(
"'Muffin' (Nullable = false) (Size = 100) (DbType = AnsiString)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", "Muffin", true, ParameterDirection.Input, DbType.AnsiString, false, 100, 0, 0)));
}
public void Formats_TimeSpan_parameter_with_unusual_type()
{
Assert.Equal(
"'-08:00:00' (DbType = DateTime)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", new TimeSpan(-8, 0, 0), true, ParameterDirection.Input, DbType.DateTime, false, 0, 0, 0)));
}
public void Format_parameter_with_direction()
{
Assert.Equal(
"'Muffin' (Direction = Output)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", "Muffin", true, ParameterDirection.Output, DbType.String, true, 0, 0, 0)));
}
public void Formats_DateTime_parameter_with_unusual_type()
{
Assert.Equal(
"'09/03/1973 00:00:00' (DbType = DateTime)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", new DateTime(1973, 9, 3), true, ParameterDirection.Input, DbType.DateTime, false, 0, 0, 0)));
}
public void Formats_object_parameter()
{
Assert.Equal(
"'System.Object'",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", new object(), true, ParameterDirection.Input, DbType.Object, true, 0, 0, 0)));
}
public void Formats_object_parameter_with_unusual_type()
{
Assert.Equal(
"'System.Object' (DbType = VarNumeric)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", new object(), true, ParameterDirection.Input, DbType.VarNumeric, true, 0, 0, 0)));
}
public void Formats_float_parameter_with_unusual_type()
{
Assert.Equal(
"'777' (DbType = VarNumeric)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", (float)777, true, ParameterDirection.Input, DbType.VarNumeric, false, 0, 0, 0)));
}
public void Formats_binary_parameter_with_unusual_type()
{
Assert.Equal(
"'0x0102' (DbType = Object)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", new byte[] { 1, 2 }, true, ParameterDirection.Input, DbType.Object, true, 0, 0, 0)));
}
public void Formats_null_string_parameter()
{
Assert.Equal(
"'' (DbType = String)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", null, true, ParameterDirection.Input, DbType.String, true, 0, 0, 0)));
}
public void Formats_float_parameter()
{
Assert.Equal(
"'777'",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", (float)777, true, ParameterDirection.Input, DbType.Single, false, 0, 0, 0)));
}
public void Formats_decimal_parameter()
{
Assert.Equal(
"'777'",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", (decimal)777, true, ParameterDirection.Input, DbType.Decimal, false, 0, 0, 0)));
}
public void Formats_bool_parameter_with_unusual_type()
{
Assert.Equal(
"'True' (DbType = Int32)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", true, true, ParameterDirection.Input, DbType.Int32, false, 0, 0, 0)));
}
public void Formats_bool_parameter()
{
Assert.Equal(
"'True'",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", true, true, ParameterDirection.Input, DbType.Boolean, false, 0, 0, 0)));
}
public void Formats_non_unicode_string_parameter()
{
Assert.Equal(
"'Muffin' (DbType = AnsiString)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", "Muffin", true, ParameterDirection.Input, DbType.AnsiString, true, 0, 0, 0)));
}
public void Formats_DateTimeOffset_parameter()
{
Assert.Equal(
"'09/03/1973 00:00:00 -08:00'",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", new DateTimeOffset(new DateTime(1973, 9, 3), new TimeSpan(-8, 0, 0)),
true, ParameterDirection.Input, DbType.DateTimeOffset, false, 0, 0, 0)));
}
public void Formats_Guid_parameter_with_unusual_type()
{
Assert.Equal(
"'304afb2a-8b8c-49ac-996e-8561f7559a3f' (DbType = Binary)",
RelationalLoggerExtensions.FormatParameter(new DbParameterLogData(
"@param", Guid.Parse("304afb2a-8b8c-49ac-996e-8561f7559a3f"),
true, ParameterDirection.Input, DbType.Binary, false, 0, 0, 0)));
}
public void Short_byte_arrays_are_not_truncated()
{
var shortArray = new Guid("21EC2020-3AEA-4069-A2DD-08002B30309D").ToByteArray();
var longerShortArray = shortArray.Concat(shortArray).ToArray();
Assert.Equal("0x2020EC21EA3A6940A2DD08002B30309D", RelationalLoggerExtensions.FormatParameterValue(shortArray));
Assert.Equal("0x2020EC21EA3A6940A2DD08002B30309D2020EC21EA3A6940A2DD08002B30309D", RelationalLoggerExtensions.FormatParameterValue(longerShortArray));
}
public void Long_byte_arrays_are_truncated()
{
var shortArray = new Guid("21EC2020-3AEA-4069-A2DD-08002B30309D").ToByteArray();
var longArray = shortArray.Concat(shortArray).Concat(shortArray).ToArray();
var builder = new StringBuilder();
RelationalLoggerExtensions.FormatParameterValue(builder, longArray);
Assert.Equal("'0x2020EC21EA3A6940A2DD08002B30309D2020EC21EA3A6940A2DD08002B30309D...'", builder.ToString());
}
