public void when_requesting_equal_text_returns_correct_sql_string() { var filter = new StringTextFilter("notes", "", StringTextFilterMode.Equal); var result = filter.GetMySqlString(); Assert.That(result, Is.EqualTo("notes = ''")); }
public void when_requesting_exact_string_returns_correct_sql_string() { var filter = new StringTextFilter("email", "*****@*****.**", StringTextFilterMode.Equal); var result = filter.GetMySqlString(); Assert.That(result, Is.EqualTo("email = '*****@*****.**'")); }
public void when_requesting_contains_text_returns_correct_sql_string() { var filter = new StringTextFilter("notes", "a", StringTextFilterMode.Contains); var result = filter.GetMySqlString(); Assert.That(result, Is.EqualTo("notes LIKE '%a%'")); }
public void when_requesting_ending_with_string_returns_correct_sql_string() { var filter = new StringTextFilter("email", ".com", StringTextFilterMode.Ends); var result = filter.GetMySqlString(); Assert.That(result, Is.EqualTo("email LIKE '%.com'")); }