public void ItCanGenerateSqlForToLower()
{
var stream =
S.SelectNode(
S.Select(S.Func(AST.FunctionType.Lower, new[] { S.Col <Person>("Name") })),
S.From <Person>(),
S.Where(
S.BinExp(
S.Func(AST.FunctionType.Lower, new[] { S.Col <Person>("Name") }),
BinaryOperation.Equal,
S.Const("'kalle'"))
));
var result = SqlGen.SqlifyExpression(AnsiSql.Dialect, stream);
string expected = "SELECT LOWER(PersonRef.Name) FROM Person PersonRef WHERE LOWER(PersonRef.Name) = 'kalle'";
Assert.That(result, Is.EqualTo(expected));
}
public void ItCanGenerateSqlForAConcatFunctionCall()
{
var stream =
S.SelectNode(
S.Select(S.Func(AST.FunctionType.Concat, new[] { S.Col <Person>("Name"), S.Col <Car>("Brand"), S.Col <Person>("Name") })),
S.From <Person>(
S.Join <Person, Car>(
AST.JoinType.InnerJoin,
S.BinExp(S.Col <Person>("Id"), BinaryOperation.Equal, S.Col <Car>("DriverId")))),
S.Where(
S.BinExp(
S.Func(AST.FunctionType.Concat, new[] { S.Col <Person>("Name"), S.Col <Car>("Brand"), }),
BinaryOperation.Equal,
S.Const("'kallesaab'"))));
var result = SqlGen.SqlifyExpression(AnsiSql.Dialect, stream);
string expected =
"SELECT CONCAT(PersonRef.Name, CarRef.Brand, PersonRef.Name) " +
"FROM Person PersonRef " +
"INNER JOIN Car CarRef ON PersonRef.Id = CarRef.DriverId " +
"WHERE CONCAT(PersonRef.Name, CarRef.Brand) = 'kallesaab'";
Assert.That(result, Is.EqualTo(expected));
}