Piccolo

------

In Piccolo you can print out any query to see the SQL which will be generated:

.. code-block:: python

>>> print(Band.select())
SELECT "band"."id", "band"."name", "band"."manager", "band"."popularity" FROM band

It didn't represent ``UUID`` and ``datetime`` values correctly, which is now fixed (courtesy theelderbeever).
See `PR 405 <https://github.com/piccolo-orm/piccolo/pull/405>`_.

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

------

Using descriptors to improve MyPy support (`PR 399 <https://github.com/piccolo-orm/piccolo/pull/399>`_).

MyPy is now able to correctly infer the type in lots of different scenarios:

.. code-block:: python

class Band(Table):
name = Varchar()

MyPy knows this is a Varchar
Band.name

band = Band()
band.name = "Pythonistas" MyPy knows we can assign strings when it's a class instance
band.name MyPy knows we will get a string back

band.name = 1 MyPy knows this is an error, as we should only be allowed to assign strings

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

------

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``).

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