Piccolo

------

When using ``pip install piccolo[all]`` on Windows it would fail because uvloop
isn't supported. Thanks to jack1142 for reporting this issue.

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

------

We've had the ability to bulk modify rows for a while. Here we append ``'!!!'``
to each band's name:

.. code-block:: python

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

It only worked for some columns - ``Varchar``, ``Text``, ``Integer`` etc.

We now allow ``Date``, ``Timestamp``, ``Timestamptz`` and ``Interval`` columns
to be bulk modified using a ``timedelta``. Here we modify each concert's start
date, so it's one day later:

.. code-block:: python

>>> await Concert.update(
... {Concert.starts: Concert.starts + timedelta(days=1)},
... force=True
... )

Thanks to theelderbeever for suggesting this feature.

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

------

You can now specify extra nodes for a database. For example, if you have a
read replica.

.. code-block:: python

DB = PostgresEngine(
config={'database': 'main_db'},
extra_nodes={
'read_replica_1': PostgresEngine(
config={
'database': 'main_db',
'host': 'read_replica_1.my_db.com'
}
)
}
)

And can then run queries on these other nodes:

.. code-block:: python

>>> await MyTable.select().run(node="read_replica_1")

See `PR 481 <https://github.com/piccolo-orm/piccolo/pull/481>`_. Thanks to
dashsatish for suggesting this feature.

Also, the ``targ`` library has been updated so it tells users about the
``--trace`` argument which can be used to get a full traceback when a CLI
command fails.

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

------

Fixed typos with ``drop_constraints``. Courtesy smythp.

Lots of documentation improvements, such as fixing Sphinx's autodoc for the
``Array`` column.

``AppConfig`` now accepts a ``pathlib.Path`` instance. For example:

.. code-block:: python

piccolo_app.py

import pathlib

APP_CONFIG = AppConfig(
app_name="blog",
migrations_folder_path=pathlib.Path(__file__) / "piccolo_migrations"
)

Thanks to theelderbeever for recommending this feature.

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

------

Fixed a bug with ``ModelBuilder`` and nullable columns (see `PR 462 <https://github.com/piccolo-orm/piccolo/pull/462>`_).
Thanks to fiolet069 for reporting this issue.

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

------

The ``ModelBuilder`` class, which is used to generate mock data in tests, now
supports ``Array`` columns. Courtesy backwardspy.

Lots of internal code optimisations and clean up. Courtesy yezz123.

Added docs for troubleshooting common MyPy errors.

Also thanks to adriangb for helping us with our dependency issues.

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