public void EmptyColumnName_ThrowsException()
{
var ex = Assert.Throws <ArgumentNullException>(() => Dialect.GetColumnName(null, string.Empty, null));
Assert.Equal("columnName", ex.ParamName);
Assert.Contains("cannot be null", ex.Message);
}
public void NullColumnName_ThrowsException()
{
var ex = Assert.Throws <ArgumentNullException>(() => Dialect.GetColumnName(null, null, null));
Assert.Equal("ColumnName", ex.ParamName);
Assert.True(ex.Message.Contains("cannot be null"));
}
public void WhitespaceColumnName_ThrowsException()
{
var ex = Assert.Throws <ArgumentNullException>(() => Dialect.GetColumnName(null, " ", null));
Assert.AreEqual("columnName", ex.ParamName);
StringAssert.Contains("cannot be null", ex.Message);
}
public void WhitespaceColumnName_ThrowsException()
{
Action action = () => Dialect.GetColumnName(null, " ", null);
action.Should().Throw <ArgumentNullException>()
.WithMessage("*cannot be null*")
.Where(m => m.ParamName.Equals("columnName", StringComparison.InvariantCultureIgnoreCase));
}
public void ContainsQuotes_DoesNotAddExtraQuotes()
{
string result = Dialect.GetColumnName("\"bar\"", "\"foo\"", "\"al\"");
Assert.Equal("\"bar\".\"foo\" AS \"al\"", result);
}
public void AllParams_ReturnsProperlyQuoted()
{
string result = Dialect.GetColumnName("bar", "foo", "al");
Assert.Equal("\"bar\".\"foo\" AS \"al\"", result);
}
public void PrefixColumnName_ReturnsProperlyQuoted()
{
string result = Dialect.GetColumnName("bar", "foo", null);
Assert.Equal("\"bar\".\"foo\"", result);
}
public void ColumnNameOnly_ReturnsProperlyQuoted()
{
string result = Dialect.GetColumnName(null, "foo", null);
Assert.Equal("\"foo\"", result);
}
public void ContainsQuotes_DoesNotAddExtraQuotes()
{
var result = Dialect.GetColumnName("\"bar\"", "\"foo\"", "\"al\"");
result.Should().Be("\"bar\".\"foo\" AS \"al\"");
}
public void AllParams_ReturnsProperlyQuoted()
{
var result = Dialect.GetColumnName("bar", "foo", "al");
result.Should().Be("bar.foo AS al");
}
public void PrefixColumnName_ReturnsProperlyQuoted()
{
var result = Dialect.GetColumnName("bar", "foo", null);
result.Should().Be("bar.foo");
}
public void ColumnNameOnly_ReturnsProperlyQuoted()
{
var result = Dialect.GetColumnName(null, "foo", null);
result.Should().Be("foo");
}
public void ContainsQuotes_DoesNotAddExtraQuotes()
{
var result = Dialect.GetColumnName("\"bar\"", "\"foo\"", "\"al\"");
result.Should().BeEquivalentTo($"{Dialect.OpenQuote}bar{Dialect.CloseQuote}.{Dialect.OpenQuote}foo{Dialect.CloseQuote} AS {Dialect.OpenQuote}al{Dialect.CloseQuote}");
}
public void AllParams_ReturnsProperlyQuoted()
{
var result = Dialect.GetColumnName("bar", "foo", "al");
result.Should().BeEquivalentTo($"{Dialect.OpenQuote}bar{Dialect.CloseQuote}.{Dialect.OpenQuote}foo{Dialect.CloseQuote} AS {Dialect.OpenQuote}al{Dialect.CloseQuote}");
}
public void PrefixColumnName_ReturnsProperlyQuoted()
{
var result = Dialect.GetColumnName("bar", "foo", null);
result.Should().BeEquivalentTo($"{Dialect.OpenQuote}bar{Dialect.CloseQuote}.{Dialect.OpenQuote}foo{Dialect.CloseQuote}");
}
public void ColumnNameOnly_ReturnsProperlyQuoted()
{
var result = Dialect.GetColumnName(null, "foo", null);
result.Should().BeEquivalentTo($"{Dialect.OpenQuote}foo{Dialect.CloseQuote}");
}
