• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

supabase / supabase-py / 43237516251
98%

Build:
DEFAULT BRANCH: main
Ran 12 Nov 2026 02:28PM UTC
Jobs 35
Files 143
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

12 Nov 2026 02:28PM UTC coverage: 97.817% (+0.07%) from 97.743%
43237516251

push

github

web-flow
feat(postgrest): add the remaining filter operators and orderings (#2042)

Step 2 of [SDK-2765](https://linear.app/supabase/issue/SDK-2765)
([SDK-2985](https://linear.app/supabase/issue/SDK-2985)): the operators
that step 1 left out and the orderings, on the column expressions and
the filter tree of #2041. A port of supabase-flutter #1794 with the
typed ranges of SDK-1755.

## What

- Text operators with `self: ColumnExpression[Row, str]`: `like`,
`ilike`, `match_regex`, `imatch_regex`, `like_all_of`, `like_any_of`,
`ilike_all_of`, `ilike_any_of`. The quantified forms take an iterable of
patterns and send it as the array literal `{a,b}`, with each member
escaped as that literal requires, where the string builder wraps one
comma-separated string in braces as given. One string in place of the
iterable raises `TypeError`, as `in_()` does.
- `contains`, `contained_by` and `overlaps` as overloads on the `self`
type, since the column type decides the shape of the operand: an array
column (`list[Element]`) takes an iterable of elements and sends
`{a,NULL}` through `_sanitize_array_param`; a range column
(`Range[Bound]`) takes a `Range[Bound]` and sends `[2,25)`, and
`contains()` also takes one `Bound` for `cs.21`; a JSON column
(`JsonValue`) takes a mapping and sends compact JSON. A JSON array or
scalar operand has no typed form and goes through `raw()`, as the
docstring says. jsonb has no `&&`, so `overlaps` has no JSON overload.
The range operators `range_lt`, `range_gt`, `range_gte`, `range_lte` and
`range_adjacent` exist on range columns only.
- `Range[Bound]`, a frozen dataclass shaped like psycopg's: `Range(2,
25)` is `[2,25)`, `bounds` picks the other three forms, `None` is an
unbounded side, and `str()` is the literal Postgres reads. Bounds render
as filter values and are quoted when they hold range syntax or are
empty. The parent issue leaves ranges as `str` or a typed range open;
the ticket's acceptance criterion, that a range operator on a non-ran... (continued)

14741 of 15070 relevant lines covered (97.82%)

5.05 hits per line

Coverage Regressions

Lines Coverage ∆ File
10
96.67
1.35% src/postgrest/filter.py
1
97.62
0.06% src/postgrest/utils.py
Jobs
ID Job ID Ran Files Coverage
1 functions-py3.13-highest - 43237516251.1 12 Nov 2026 02:28PM UTC 14
99.12
GitHub Action Run
2 supabase-py3.12-highest - 43237516251.2 12 Nov 2026 02:28PM UTC 20
99.32
GitHub Action Run
3 supabase-py3.15-highest - 43237516251.3 12 Nov 2026 02:30PM UTC 20
99.32
GitHub Action Run
4 auth-py3.12-highest - 43237516251.4 12 Nov 2026 02:30PM UTC 43
96.77
GitHub Action Run
5 utils-py3.13-highest - 43237516251.5 12 Nov 2026 02:29PM UTC 24
99.67
GitHub Action Run
6 realtime-py3.15-highest - 43237516251.6 12 Nov 2026 02:29PM UTC 10
97.27
GitHub Action Run
7 postgrest-py3.13-highest - 43237516251.7 12 Nov 2026 02:30PM UTC 39
98.66
GitHub Action Run
8 auth-py3.14-highest - 43237516251.8 12 Nov 2026 02:30PM UTC 43
96.77
GitHub Action Run
9 postgrest-py3.15-highest - 43237516251.9 12 Nov 2026 02:30PM UTC 39
98.66
GitHub Action Run
10 utils-py3.12-lowest-direct - 43237516251.10 12 Nov 2026 02:29PM UTC 24
99.67
GitHub Action Run
11 utils-py3.14-highest - 43237516251.11 12 Nov 2026 02:29PM UTC 24
99.66
GitHub Action Run
12 storage-py3.13-highest - 43237516251.12 12 Nov 2026 02:29PM UTC 24
95.99
GitHub Action Run
13 storage-py3.12-highest - 43237516251.13 12 Nov 2026 02:30PM UTC 24
95.99
GitHub Action Run
14 functions-py3.12-lowest-direct - 43237516251.14 12 Nov 2026 02:28PM UTC 14
99.12
GitHub Action Run
15 functions-py3.14-highest - 43237516251.15 12 Nov 2026 02:28PM UTC 14
99.12
GitHub Action Run
16 postgrest-py3.12-highest - 43237516251.16 12 Nov 2026 02:30PM UTC 39
98.66
GitHub Action Run
17 functions-py3.12-highest - 43237516251.17 12 Nov 2026 02:28PM UTC 14
99.12
GitHub Action Run
18 utils-py3.15-highest - 43237516251.18 12 Nov 2026 02:29PM UTC 24
99.66
GitHub Action Run
19 realtime-py3.12-lowest-direct - 43237516251.19 12 Nov 2026 02:30PM UTC 10
97.51
GitHub Action Run
20 functions-py3.15-highest - 43237516251.20 12 Nov 2026 02:28PM UTC 14
99.12
GitHub Action Run
21 supabase-py3.12-lowest-direct - 43237516251.21 12 Nov 2026 02:28PM UTC 20
99.32
GitHub Action Run
22 postgrest-py3.14-highest - 43237516251.22 12 Nov 2026 02:30PM UTC 39
98.66
GitHub Action Run
23 supabase-py3.14-highest - 43237516251.23 12 Nov 2026 02:28PM UTC 20
99.32
GitHub Action Run
24 realtime-py3.14-highest - 43237516251.24 12 Nov 2026 02:29PM UTC 10
97.27
GitHub Action Run
25 utils-py3.12-highest - 43237516251.25 12 Nov 2026 02:29PM UTC 24
99.67
GitHub Action Run
26 realtime-py3.13-highest - 43237516251.26 12 Nov 2026 02:29PM UTC 10
97.39
GitHub Action Run
27 storage-py3.12-lowest-direct - 43237516251.27 12 Nov 2026 02:30PM UTC 24
95.99
GitHub Action Run
28 realtime-py3.12-highest - 43237516251.28 12 Nov 2026 02:29PM UTC 10
97.51
GitHub Action Run
29 storage-py3.15-highest - 43237516251.29 12 Nov 2026 02:31PM UTC 24
95.99
GitHub Action Run
30 storage-py3.14-highest - 43237516251.30 12 Nov 2026 02:29PM UTC 24
95.99
GitHub Action Run
31 supabase-py3.13-highest - 43237516251.31 12 Nov 2026 02:28PM UTC 20
99.32
GitHub Action Run
32 auth-py3.12-lowest-direct - 43237516251.32 12 Nov 2026 02:30PM UTC 43
96.77
GitHub Action Run
33 postgrest-py3.12-lowest-direct - 43237516251.33 12 Nov 2026 02:30PM UTC 39
98.66
GitHub Action Run
34 auth-py3.13-highest - 43237516251.34 12 Nov 2026 02:30PM UTC 43
96.77
GitHub Action Run
35 auth-py3.15-highest - 43237516251.35 12 Nov 2026 02:30PM UTC 43
96.77
GitHub Action Run
Source Files on build 43237516251
  • Tree
  • List 143
  • Changed 7
  • Source Changed 0
  • Coverage Changed 7
Coverage ∆ File Lines Relevant Covered Missed Hits/Line
  • Back to Repo
  • Github Actions Build #43237516251
  • d1e755de on github
  • Prev Build on main (#43229511406)
  • Next Build on main (#43390254367)
  • Delete
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE TRIAL · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc