Piccolo

------

We used to raise a ``ValueError`` if a column was both ``null=False`` and
``default=None``. This has now been removed, as there are situations where
it's valid for columns to be configured that way. Thanks to gmos for
suggesting this change.

-------------------------------------------------------------------------------

------

The ``where`` clause now raises a ``ValueError`` if a boolean value is
passed in by accident. This was possible in the following situation:

.. code-block:: python

await Band.select().where(Band.has_drummer is None)

Piccolo can't override the ``is`` operator because Python doesn't allow it,
so ``Band.has_drummer is None`` will always equal ``False``. Thanks to
trondhindenes for reporting this issue.

We've also put a lot of effort into improving documentation throughout the
project.

-------------------------------------------------------------------------------

------

* Lots of documentation improvements, including how to customise ``BaseUser``
(courtesy sinisaos).
* Fixed a bug with creating indexes when the column name clashes with a SQL
keyword (e.g. ``'order'``). See `Pr 433 <https://github.com/piccolo-orm/piccolo/pull/433>`_.
Thanks to wmshort for reporting this issue.
* Fixed an issue where some slots were incorrectly configured (courtesy
ariebovenberg). See `PR 426 <https://github.com/piccolo-orm/piccolo/pull/426>`_.

-------------------------------------------------------------------------------

------

Fixed a bug with auto migrations which rename columns - see
`PR 423 <https://github.com/piccolo-orm/piccolo/pull/423>`_. Thanks to
theelderbeever for reporting this, and sinisaos for help investigating.

-------------------------------------------------------------------------------

------

Added `Xpresso <https://xpresso-api.dev/>`_ as a supported ASGI framework when
using ``piccolo asgi new`` to generate a web app.

Thanks to sinisaos for adding this template, and adriangb for reviewing.

We also took this opportunity to update our FastAPI and BlackSheep ASGI
templates.

-------------------------------------------------------------------------------

------

``Update`` queries without a ``where`` clause
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If you try and perform an update query without a ``where`` clause you will now
get an error:

.. code-block:: python

>>> await Band.update({Band.name: 'New Band'})
UpdateError

If you want to update all rows in the table, you can still do so, but you must
pass ``force=True``.

.. code-block:: python

>>> await Band.update({Band.name: 'New Band'}, force=True)

This is a similar to ``delete`` queries, which require a ``where`` clause or
``force=True``.

It was pointed out by theelderbeever that an accidental mass update is almost
as bad as a mass deletion, which is why this safety measure has been added.

See `PR 412 <https://github.com/piccolo-orm/piccolo/pull/412>`_.

.. warning:: This is a breaking change. It you're doing update queries without
a where clause, you will need to add ``force=True``.

``JSONB`` improvements
~~~~~~~~~~~~~~~~~~~~~~

Fixed some bugs with nullable ``JSONB`` columns. A value of ``None`` is now
stored as ``null`` in the database, instead of the JSON string ``'null'``.
Thanks to theelderbeever for reporting this.

See `PR 413 <https://github.com/piccolo-orm/piccolo/pull/413>`_.

-------------------------------------------------------------------------------