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

supabase / supabase-py / 43431591727
98%

Build:
DEFAULT BRANCH: main
Ran 13 Nov 2026 01:12PM UTC
Jobs 35
Files 148
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

13 Nov 2026 01:11PM UTC coverage: 97.923% (+0.003%) from 97.92%
43431591727

push

github

web-flow
fix(postgrest)!: send datetime filter values as iso 8601 with an offset (#2047)

## Summary

Filter values went through `str()`, so a `datetime` was sent as
`2024-01-01 12:00:00`, with a space and, for a naive value, no offset.
PostgREST then read the time in the database time zone, which can shift
results by hours.

- `_serialize_filter_value` renders a `datetime` as ISO 8601 with its
UTC offset. An aware `datetime` keeps its offset. A naive `datetime` is
taken as UTC. This matches supabase-swift, which sends dates in UTC and
reads timestamps without an offset as UTC, and the old behavior on
Supabase, where the database runs in UTC. It also works for
`datetime.min` and `datetime.max`.
- The string builder `in_()`, array literal members (`cs()`, `cd()`,
`contains()`, `contained_by()`, `overlaps()`) and RPC query arguments
now use the same serialization, so the same value is rendered the same
way everywhere. For array members, this also renders booleans as
`true`/`false` and dicts and lists as compact JSON.
- `_rpc_query_param` delegates to `_serialize_filter_value` instead of
duplicating its boolean and dict branches, and the typed filter no
longer serializes array members twice.
- `date` and `time` values are unchanged, since `str()` already gives
ISO 8601 for them.
- `MIGRATION.md` documents the change and the rule for naive values.

## Tests

- Unit tests for aware, naive, `date` and `time` values, `datetime.min`
and `datetime.max`, array elements, `in_()`, RPC query arguments, and
the typed filter rendering at top level and inside an `or` group.
- Range rendering tests updated to the `T` separator.

Closes SDK-2760

15606 of 15937 relevant lines covered (97.92%)

5.05 hits per line

Coverage Regressions

Lines Coverage ∆ File
10
96.3
0.0% src/postgrest/request_builder.py
9
96.64
-0.02% src/postgrest/filter.py
1
97.78
0.16% src/postgrest/utils.py
Jobs
ID Job ID Ran Files Coverage
1 supabase-py3.12-lowest-direct - 43431591727.1 13 Nov 2026 01:12PM UTC 20
99.32
GitHub Action Run
2 supabase-py3.14-highest - 43431591727.2 13 Nov 2026 01:12PM UTC 20
99.32
GitHub Action Run
3 storage-py3.12-lowest-direct - 43431591727.3 13 Nov 2026 01:13PM UTC 24
95.99
GitHub Action Run
4 realtime-py3.12-lowest-direct - 43431591727.4 13 Nov 2026 01:13PM UTC 10
97.51
GitHub Action Run
5 auth-py3.15-highest - 43431591727.5 13 Nov 2026 01:14PM UTC 43
96.77
GitHub Action Run
6 realtime-py3.14-highest - 43431591727.6 13 Nov 2026 01:13PM UTC 10
97.27
GitHub Action Run
7 functions-py3.12-highest - 43431591727.7 13 Nov 2026 01:12PM UTC 14
99.12
GitHub Action Run
8 auth-py3.12-lowest-direct - 43431591727.8 13 Nov 2026 01:14PM UTC 43
96.77
GitHub Action Run
9 functions-py3.13-highest - 43431591727.9 13 Nov 2026 01:12PM UTC 14
99.12
GitHub Action Run
10 supabase-py3.13-highest - 43431591727.10 13 Nov 2026 01:12PM UTC 20
99.32
GitHub Action Run
11 auth-py3.14-highest - 43431591727.11 13 Nov 2026 01:14PM UTC 43
96.77
GitHub Action Run
12 functions-py3.14-highest - 43431591727.12 13 Nov 2026 01:12PM UTC 14
99.12
GitHub Action Run
13 storage-py3.12-highest - 43431591727.13 13 Nov 2026 01:13PM UTC 24
95.99
GitHub Action Run
14 auth-py3.12-highest - 43431591727.14 13 Nov 2026 01:13PM UTC 43
96.77
GitHub Action Run
15 postgrest-py3.13-highest - 43431591727.15 13 Nov 2026 01:14PM UTC 44
98.86
GitHub Action Run
16 realtime-py3.15-highest - 43431591727.16 13 Nov 2026 01:13PM UTC 10
97.27
GitHub Action Run
17 utils-py3.12-highest - 43431591727.17 13 Nov 2026 01:12PM UTC 24
99.67
GitHub Action Run
18 postgrest-py3.12-highest - 43431591727.18 13 Nov 2026 01:14PM UTC 44
98.86
GitHub Action Run
19 functions-py3.12-lowest-direct - 43431591727.19 13 Nov 2026 01:12PM UTC 14
99.12
GitHub Action Run
20 utils-py3.14-highest - 43431591727.20 13 Nov 2026 01:12PM UTC 24
99.67
GitHub Action Run
21 utils-py3.13-highest - 43431591727.21 13 Nov 2026 01:12PM UTC 24
99.67
GitHub Action Run
22 postgrest-py3.12-lowest-direct - 43431591727.22 13 Nov 2026 01:14PM UTC 44
98.86
GitHub Action Run
23 utils-py3.15-highest - 43431591727.23 13 Nov 2026 01:12PM UTC 24
99.67
GitHub Action Run
24 realtime-py3.12-highest - 43431591727.24 13 Nov 2026 01:13PM UTC 10
97.51
GitHub Action Run
25 utils-py3.12-lowest-direct - 43431591727.25 13 Nov 2026 01:12PM UTC 24
99.67
GitHub Action Run
26 realtime-py3.13-highest - 43431591727.26 13 Nov 2026 01:13PM UTC 10
97.39
GitHub Action Run
27 supabase-py3.15-highest - 43431591727.27 13 Nov 2026 01:13PM UTC 20
99.32
GitHub Action Run
28 storage-py3.14-highest - 43431591727.28 13 Nov 2026 01:13PM UTC 24
95.99
GitHub Action Run
29 storage-py3.15-highest - 43431591727.29 13 Nov 2026 01:14PM UTC 24
95.99
GitHub Action Run
30 supabase-py3.12-highest - 43431591727.30 13 Nov 2026 01:12PM UTC 20
99.32
GitHub Action Run
31 postgrest-py3.15-highest - 43431591727.31 13 Nov 2026 01:14PM UTC 44
98.85
GitHub Action Run
32 functions-py3.15-highest - 43431591727.32 13 Nov 2026 01:12PM UTC 14
99.12
GitHub Action Run
33 postgrest-py3.14-highest - 43431591727.33 13 Nov 2026 01:14PM UTC 44
98.85
GitHub Action Run
34 storage-py3.13-highest - 43431591727.34 13 Nov 2026 01:13PM UTC 24
95.99
GitHub Action Run
35 auth-py3.13-highest - 43431591727.35 13 Nov 2026 01:13PM UTC 43
96.77
GitHub Action Run
Source Files on build 43431591727
  • Tree
  • List 148
  • Changed 8
  • Source Changed 0
  • Coverage Changed 8
Coverage ∆ File Lines Relevant Covered Missed Hits/Line
  • Back to Repo
  • Github Actions Build #43431591727
  • 8b1ab30a on github
  • Prev Build on main (#43431449431)
  • Next Build on main (#43434015101)
  • 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