Piccolo

------

Fixed bug with ``BaseUser`` and Piccolo API.

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

------

The ``BaseUser`` table hashes passwords before storing them in the database.

When we create a fixture from the ``BaseUser`` table (using ``piccolo fixtures dump``),
it looks something like:

.. code-block:: json

{
"id": 11,
"username": "bob",
"password": "pbkdf2_sha256$10000$abc123",
}

When we load the fixture (using ``piccolo fixtures load``) we need to be
careful in case ``BaseUser`` tries to hash the password again (it would then be a hash of
a hash, and hence incorrect). We now have additional checks in place to prevent
this.

Thanks to mrbazzan for implementing this, and sinisaos for help reviewing.

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

------

Added initial support for ``ForeignKey`` columns referencing non-primary key
columns. For example:

.. code-block:: python

class Manager(Table):
name = Varchar()
email = Varchar(unique=True)

class Band(Table):
manager = ForeignKey(Manager, target_column=Manager.email)

Thanks to theelderbeever for suggesting this feature, and with help testing.

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

------

Fixed an issue with the ``value_type`` of ``ForeignKey`` columns when
referencing a table with a custom primary key column (such as a ``UUID``).

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

------

Added an ``exclude_imported`` option to ``table_finder``.

.. code-block:: python

APP_CONFIG = AppConfig(
table_classes=table_finder(['music.tables'], exclude_imported=True)
)

It's useful when we want to import ``Table`` subclasses defined within a
module itself, but not imported ones:

.. code-block:: python

tables.py
from piccolo.apps.user.tables import BaseUser excluded
from piccolo.columns.column_types import ForeignKey, Varchar
from piccolo.table import Table


class Musician(Table): included
name = Varchar()
user = ForeignKey(BaseUser)

This was also possible using tags, but was less convenient. Thanks to sinisaos
for reporting this issue.

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

------

Fixed the error message in ``LazyTableReference``.

Fixed a bug with ``create_pydantic_model`` with nested models. For example:

.. code-block:: python

create_pydantic_model(Band, nested=(Band.manager,))

Sometimes Pydantic couldn't uniquely identify the nested models. Thanks to
wmshort and sinisaos for their help with this.

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