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'"); }