| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| 1.32.0 source code.tar.gz | 2026-02-11 | 547.7 kB | |
| 1.32.0 source code.zip | 2026-02-11 | 781.9 kB | |
| README.md | 2026-02-11 | 636 Bytes | |
| Totals: 3 Items | 1.3 MB | 0 | |
Added the having clause, which is useful when working with group_by.
For example, here we get the number of albums per band, but exclude any bands with less than 2 albums:
:::python
>>> from piccolo.query.functions.aggregate import Count
>>> await Album.select(
... Album.band.name.as_alias('band_name'),
... Count()
... ).group_by(
... Album.band
... ).having(
... Count() >= 2
... )
[
{"band_name": "Pythonistas", "count": 2},
]
We also updated our CockroachDB support to the latest version (thanks to @sinisaos for this).