[Test] // http://bugzilla.gnome.org/show_bug.cgi?id=644145
public void EscapeUriWithStartsWithOperator ()
{
QueryValue val = new ExactUriStringQueryValue ();
val.ParseUserQuery ("/mnt/mydrive/rock & roll");
Assert.AreEqual (
@"(CoreTracks.Uri IS NOT NULL AND" +
@" CoreTracks.Uri LIKE 'file:///mnt/mydrive/rock\%20&\%20roll%' ESCAPE '\')",
UriField.ToSql (StringQueryValue.StartsWith, val)
);
}
[Test] // http://bugzilla.gnome.org/show_bug.cgi?id=612152
public void EscapeUri ()
{
QueryValue val = new ExactUriStringQueryValue ();
val.ParseUserQuery ("space 3quotes`'\"underscore_percentage%slash/backslash\\");
Assert.AreEqual (
@"(CoreTracks.Uri IS NOT NULL AND CoreTracks.Uri LIKE '%space\%203quotes\%60''\%22underscore\_percentage\%25slash/backslash\%5C%' ESCAPE '\')",
UriField.ToSql (StringQueryValue.Contains, val)
);
}