public void LikeTest()
{
var compiler = new MySqlCompiler();
var query = new Query("some_example_table");
var exp = new ExpressionParser <ExpressionTestClass>(x => x.Description.Like("matter"),
ExpressionTestClass.Mapping(),
query);
var whereClause = compiler.Compile(exp.ToSQL()).ToString();
Assert.IsTrue(whereClause == "SELECT * FROM `some_example_table` WHERE LOWER(`description`) like 'matter'");
}
public void InUintArrayTest()
{
var compiler = new MySqlCompiler();
var query = new Query("some_example_table");
var exp = new ExpressionParser <ExpressionTestClass>(x => x.Id.In <uint>(1, 2, 3, 4),
ExpressionTestClass.Mapping(),
query);
var whereClause = compiler.Compile(exp.ToSQL()).ToString();
Assert.IsTrue(whereClause == "SELECT * FROM `some_example_table` WHERE `id` IN ('1', '2', '3', '4')");
}
public void InStringArrayTest()
{
var compiler = new MySqlCompiler();
var query = new Query("some_example_table");
var exp = new ExpressionParser <ExpressionTestClass>(x => x.Description.In("day", "word", "sunset"),
ExpressionTestClass.Mapping(),
query);
var whereClause = compiler.Compile(exp.ToSQL()).ToString();
Assert.IsTrue(whereClause == "SELECT * FROM `some_example_table` WHERE `description` IN ('day', 'word', 'sunset')");
}
public void SimpleBoolTest()
{
var compiler = new MySqlCompiler();
var query = new Query("some_example_table");
var exp = new ExpressionParser <ExpressionTestClass>(x => !x.IsActive && x.IsActive,
ExpressionTestClass.Mapping(),
query);
var whereClause = compiler.Compile(exp.ToSQL()).ToString();
Assert.IsTrue(whereClause == "SELECT * FROM `some_example_table` WHERE `is_active` = true AND `is_active` = false");
}
public void CombinedConditionTest()
{
var compiler = new MySqlCompiler();
var query = new Query("some_example_table");
var exp = new ExpressionParser <ExpressionTestClass>(x => x.Description.Like("matter") &&
!x.IsActive &&
x.Id.In <uint>(1, 2, 3, 4) &&
x.Description.In("day", "word", "sunset"),
ExpressionTestClass.Mapping(),
query);
var whereClause = compiler.Compile(exp.ToSQL()).ToString();
Assert.IsTrue(whereClause == "SELECT * FROM `some_example_table` WHERE `description` IN ('day', 'word', 'sunset') AND `id` IN ('1', '2', '3', '4') AND `is_active` = false AND LOWER(`description`) like 'matter'");
}
