Piccolo

------
Lots of improvements to ``piccolo schema generate``:

* Dramatically improved performance, by executing more queries in parallel
(courtesy AliSayyah).
* If a table in the database has a foreign key to a table in another
schema, this will now work (courtesy AliSayyah).
* The column defaults are now extracted from the database (courtesy wmshort).
* The ``scale`` and ``precision`` values for ``Numeric`` / ``Decimal`` column
types are extracted from the database (courtesy wmshort).
* The ``ON DELETE`` and ``ON UPDATE`` values for ``ForeignKey`` columns are
now extracted from the database (courtesy wmshort).

Added ``BigSerial`` column type (courtesy aliereno).

Added GitHub issue templates (courtesy AbhijithGanesh).

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

------
Fixing a bug with ``on_delete`` and ``on_update`` not being set correctly.
Thanks to wmshort for discovering this.

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

------
Modified ``create_pydantic_model``, so ``JSON`` and ``JSONB`` columns have a
``format`` attribute of ``'json'``. This will be used by Piccolo Admin for
improved JSON support. Courtesy sinisaos.

Fixing a bug where the ``piccolo fixtures load`` command wasn't registered
with the Piccolo CLI.

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

------
The ``where`` clause can now accept multiple arguments (courtesy AliSayyah):

.. code-block:: python

Concert.select().where(
Concert.venue.name == 'Royal Albert Hall',
Concert.band_1.name == 'Pythonistas'
).run_sync()

It's another way of expressing `AND`. It's equivalent to both of these:

.. code-block:: python

Concert.select().where(
Concert.venue.name == 'Royal Albert Hall'
).where(
Concert.band_1.name == 'Pythonistas'
).run_sync()

Concert.select().where(
(Concert.venue.name == 'Royal Albert Hall') & (Concert.band_1.name == 'Pythonistas')
).run_sync()

Added a ``create`` method, which is an easier way of creating objects (courtesy
AliSayyah).

.. code-block:: python

This still works:
band = Band(name="C-Sharps", popularity=100)
band.save().run_sync()

But now we can do it in a single line using `create`:
band = Band.objects().create(name="C-Sharps", popularity=100).run_sync()

Fixed a bug with ``piccolo schema generate`` where columns with unrecognised
column types were omitted from the output (courtesy AliSayyah).

Added docs for the ``--trace`` argument, which can be used with Piccolo
commands to get a traceback if the command fails (courtesy hipertracker).

Added ``DoublePrecision`` column type, which is similar to ``Real`` in that
it stores ``float`` values. However, those values are stored at greater
precision (courtesy AliSayyah).

Improved ``AppRegistry``, so if a user only adds the app name (e.g. ``blog``),
instead of ``blog.piccolo_app``, it will now emit a warning, and will try to
import ``blog.piccolo_app`` (courtesy aliereno).

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

------
Fixed a bug with ``create_pydantic_model`` when used with a ``Decimal`` /
``Numeric`` column when no ``digits`` arguments was set (courtesy AliSayyah).

Added the ``create_tables`` function, which accepts a sequence of ``Table``
subclasses, then sorts them based on their ``ForeignKey`` columns, and creates
them. This is really useful for people who aren't using migrations (for
example, when using Piccolo in a simple data science script). Courtesy
AliSayyah.

.. code-block:: python

from piccolo.tables import create_tables

create_tables(Band, Manager, if_not_exists=True)

Equivalent to:
Manager.create_table(if_not_exists=True).run_sync()
Band.create_table(if_not_exists=True).run_sync()

Fixed typos with the new fixtures app - sometimes it was referred to as
``fixture`` and other times ``fixtures``. It's now standardised as
``fixtures`` (courtesy hipertracker).

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

------
The ``piccolo user create`` command can now be used by passing in command line
arguments, instead of using the interactive prompt (courtesy AliSayyah).

For example ``piccolo user create --username=bob ...``.

This is useful when you want to create users in a script.

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