[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) ); }