public void From_FromStatement()
{
var query = Query.Select("*").From(new From("Users").As("[u]"));
Assert.IsInstanceOf <From>(query.FromClause);
SqlAssert.Minified(query.FromClause, "FROM Users AS [u]");
}
public void FullOutherJoin_WithCondition()
{
var join = Join.FullOuther("Persons").As("p").On("p.ID = u.Person");
Assert.IsInstanceOf <FullOutherJoin>(join);
SqlAssert.Minified(join, "FULL OUTHER JOIN Persons AS p ON p.ID = u.Person");
}
public void Add_LiteralToNone()
{
var alias = Alias.None;
var statement = alias + "[Identifier]";
SqlAssert.Minified(statement, "[Identifier]");
}
public void Add_String()
{
Alias alias = "tab";
var statement = alias + "[Identifier]";
SqlAssert.Minified(statement, "tab.[Identifier]");
}
public void Where_WhereStatement()
{
var query = Query.Select("*").Where(new Where("u.Name LIKE '%Bob%'"));
Assert.IsInstanceOf <Where>(query.WhereClause);
SqlAssert.Minified(query.WhereClause, "WHERE u.Name LIKE '%Bob%'");
}
public void RightJoin_WithCondition()
{
var join = Join.Right("Persons").As("p").On("p.ID = u.Person");
Assert.IsInstanceOf <RightJoin>(join);
SqlAssert.Minified(join, "RIGHT JOIN Persons AS p ON p.ID = u.Person");
}
public void From_Expression()
{
var query = Query.Select("*").From("Users", "[u]");
Assert.IsInstanceOf <From>(query.FromClause);
SqlAssert.Minified(query.FromClause, "FROM Users AS [u]");
}
public void LeftJoin_WithCondition()
{
var join = Join.Left("Persons").As("p").On("p.ID = u.Person");
Assert.IsInstanceOf <LeftJoin>(join);
SqlAssert.Minified(join,
"LEFT JOIN Persons AS p ON p.ID = u.Person");
}
public void InnerJoin_WithCondition()
{
var join = Join.Inner("Persons").As("p").On("p.ID = u.Person");
Assert.IsInstanceOf <InnerJoin>(join);
SqlAssert.Minified(join,
"INNER JOIN Persons AS p ON p.ID = u.Person");
}
public void Implicit_FromString()
{
Join join = "INNER JOIN Users AS u ON u.Id = p.User";
Assert.IsInstanceOf <RawJoin>(join);
SqlAssert.Minified(join, "INNER JOIN Users AS u ON u.Id = p.User");
Assert.AreEqual(default(Keyword), join.JoinType);
}
public void RawJoin_SomeRawSqlString()
{
var join = Join.Raw("INNER JOIN Users AS u ON u.Id = p.User");
Assert.IsInstanceOf <RawJoin>(join);
SqlAssert.Minified(join, "INNER JOIN Users AS u ON u.Id = p.User");
Assert.AreEqual(default(Keyword), join.JoinType);
}
public void Add_Literal()
{
Alias alias = "tab";
Literal literal = "[Identifier]";
var statement = alias + literal;
SqlAssert.Minified(statement, "tab.[Identifier]");
}
public void And_2Argument_Minified()
{
var statement = Logical.And("[dbo].[Column] = 17", "[dbo].[Id] <> 666");
SqlAssert.Minified(statement, "([dbo].[Column] = 17 AND [dbo].[Id] <> 666)");
}
public void Or_2Argument_Minified()
{
var statement = Logical.Or("[dbo].[Column] = 17", "[dbo].[Id] <> 666");
SqlAssert.Minified(statement, "([dbo].[Column] = 17 OR [dbo].[Id] <> 666)");
}
public void Parse_WithASC() => SqlAssert.Minified(OrderBy.Parse("[Name] asc"), "[Name] ASC");
public void Equal() => SqlAssert.Minified(Logical.Equal(left, right), "([Age] = @age)");
public void LessThanOrEqual() => SqlAssert.Minified(Logical.LessThanOrEqual(left, right), "([Age] <= @age)");
public void GreaterThanOrEqual() => SqlAssert.Minified(Logical.GreaterThanOrEqual(left, right), "([Age] >= @age)");
public void XOR_TwoArguments_Simplified()
{
var statement = Logical.Xor("@A", "@B");
SqlAssert.Minified(statement, "((@A OR @B) AND NOT((@A AND @B)))");
}
public void NotEqual() => SqlAssert.Minified(Logical.NotEqual(left, right), "([Age] <> @age)");
public void NOT_Minified()
{
var statement = Logical.Not("[dbo].[Column] = 17");
SqlAssert.Minified(statement, "NOT([dbo].[Column] = 17)");
}
public void Minified() => SqlAssert.Minified(TestStatement, "WHERE [u].Id = @id");
public void Parse_WithoutOrderBy() => SqlAssert.Minified(OrderBy.Parse("[Name]"), "[Name] ASC");
public void Minified_WithoutAs() => SqlAssert.Minified(new From("Users"), "FROM Users");
public void Parse_WithDESC() => SqlAssert.Minified(OrderBy.Parse("[Name] deSC"), "[Name] DESC");
public void Minified() => SqlAssert.Minified(TestStatement, "FROM Users AS [u]");
public void Minified_None() => SqlAssert.Minified(Where.None, "");