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