public void Ctor_WithDialect_ReturnsDialect()
{
var builder = new StringBuilder();
var writer = new TestSqlWriter(builder, SqlDialect.Default);
Assert.NotNull(writer.DialectTest);
Assert.Same(SqlDialect.Default, writer.DialectTest);
}
public void WriteLimit_WithNullCount_WritesOffsetOnly()
{
var expected = "OFFSET 42 ROWS";
var dialect = new SqlServerDialect();
var builder = new StringBuilder();
using (TestSqlWriter writer = new TestSqlWriter(builder, dialect))
{
dialect.WriteLimit(writer, 42, null);
}
var actual = builder.ToString();
Assert.Equal(expected, actual);
}
public void WriteLimit_WritesLimit()
{
var expected = "LIMIT 42, 10";
var dialect = new MySqlDialect();
var builder = new StringBuilder();
using (TestSqlWriter writer = new TestSqlWriter(builder, dialect))
{
dialect.WriteLimit(writer, 42, 10);
}
var actual = builder.ToString();
Assert.Equal(expected, actual);
}
public void EnsureNotDisposed_WhenDisposed_ThrowsObjectDisposed()
{
var builder = new StringBuilder();
TestSqlWriter writer;
using (writer = new TestSqlWriter(builder))
{
}
Assert.Throws<ObjectDisposedException>(() => writer.EnsureNotDisposedTest());
}
public void Ctor_WithTextWriterAndWriterSettings_UsesSpecifiedSettings()
{
var settings = new SqlWriterSettings();
TestSqlWriter writer = new TestSqlWriter(new StringWriter(new StringBuilder()), settings);
Assert.Same(settings, writer.SettingsTest);
}
public void Write_WritesText()
{
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.WriteTest("Write()");
writer.WriteTest("does");
writer.WriteTest("write");
writer.WriteTest("spaces");
writer.WriteTest("between");
writer.WriteTest("calls.");
}
Assert.Equal("Write() does write spaces between calls.", builder.ToString());
}
public void WriteValue_WithString_WritesString()
{
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.WriteValue("The rain in spain falls mainly on the plain.");
}
Assert.Equal("'The rain in spain falls mainly on the plain.'", builder.ToString());
}
public void WriteValue_WithOther_WritesDouble()
{
var value = new { id = 5 };
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.WriteValue(value);
}
Assert.Equal($"'{Convert.ToString(value, CultureInfo.InvariantCulture)}'", builder.ToString());
}
public void WriteKeyword_WithWriteKeywordsInLowerCase_WritesKeywordsInLowerCase()
{
var builder = new StringBuilder();
var settings = new SqlWriterSettings
{
WriteKeywordsInLowerCase = true
};
using (var writer = new TestSqlWriter(builder, settings))
{
writer.WriteKeyword(SqlKeywords.Select);
}
Assert.Equal("select", builder.ToString());
}
public void WriteLimit_WritesOffsetFetch()
{
var expected = "OFFSET 42 ROWS FETCH FIRST 10 ROWS ONLY";
var dialect = new SqlServerDialect();
var builder = new StringBuilder();
using (TestSqlWriter writer = new TestSqlWriter(builder, dialect))
{
dialect.WriteLimit(writer, 42, 10);
}
var actual = builder.ToString();
Assert.Equal(expected, actual);
}
public void WriteValue_WithFloatingPoint_WritesFloatingPoint()
{
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.WriteValue(Math.PI);
}
Assert.Equal(Math.PI.ToString(CultureInfo.InvariantCulture), builder.ToString());
}
public void WriteRaw_WritesRawText()
{
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.WriteRawTest("WriteRaw");
writer.WriteRawTest("() ");
writer.WriteRawTest("does n");
writer.WriteRawTest("ot wri");
writer.WriteRawTest("te spaces between");
writer.WriteRawTest(" calls.");
}
Assert.Equal("WriteRaw() does not write spaces between calls.", builder.ToString());
}
public void WriteParameter_WithParameterName_WritesParameter()
{
string expected;
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.WriteParameter("Id");
expected = writer.DialectTest.FormatParameterName("Id");
}
Assert.Equal(expected, builder.ToString());
}
public void WriteParameter_WithNullParameterName_ThrowsArgumentNull()
{
Assert.Throws<ArgumentNullException>(() =>
{
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.WriteParameter(null);
}
});
}
public void WriteKeyword_WritesKeyword()
{
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.WriteKeyword(SqlKeywords.Select);
}
Assert.Equal("SELECT", builder.ToString());
}
public void WriteLimit_WithNullOffset_WritesNoOffset()
{
var expected = "FETCH FIRST 10 ROWS ONLY";
var dialect = new SqlDialect();
var builder = new StringBuilder();
using (TestSqlWriter writer = new TestSqlWriter(builder, dialect))
{
dialect.WriteLimit(writer, null, 10);
}
var actual = builder.ToString();
Assert.Equal(expected, actual);
}
public void WriteValue_WithInteger_WritesInteger()
{
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.WriteValue(long.MaxValue);
}
Assert.Equal(long.MaxValue.ToString(CultureInfo.InvariantCulture), builder.ToString());
}
public void WriteValue_WithNullValue_WritesNull()
{
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.WriteValue(null);
}
Assert.Equal("NULL", builder.ToString());
}
public void EnsureNotDisposed_WhenNotDisposed_DoesNotThrow()
{
var builder = new StringBuilder();
using (var writer = new TestSqlWriter(builder))
{
writer.EnsureNotDisposedTest();
}
}
