supabase-community / postgrest-csharp

A C# Client library for Postgrest
https://supabase-community.github.io/postgrest-csharp/api/Postgrest.html
MIT License
114 stars 22 forks source link

Chore: Unit Tests for Individual Filters #15

Closed acupofjose closed 3 years ago

acupofjose commented 3 years ago

Chore

Describe the chore

In the process of creating the Not shorthand methods, I've noticed that some of the filter requests are not necessarily being formed correctly. For instance, contains and includes while similar in functionality, require different request formatting.

Per filter tests will be required based off of: http://postgrest.org/en/v7.0.0/api.html#operators

acupofjose commented 3 years ago

Interestingly, attempting to use the contains operator gives me an error:

{
"hint": "No operator matches the given name and argument types. You might need to add explicit type casts.",
"details": null,
"code": "42883",
"message": "operator does not exist: text @> unknown"
}

As though postgrest doesn't know how to use it's own operator?

elrhomariyounes commented 3 years ago

@acupofjose We can close this for now all filters have tests, still to support some types in contains and contained filters as mentioned in #24