CHANGES

Changes
=======

0.16.5
------
The Postgres extensions that ``PostgresEngine`` tries to enable at startup
can now be configured.

0.16.4
------
 * Fixed a bug with ``MyTable.column != None``
 * Added ``is_null`` and ``is_not_null`` methods, to avoid linting issues when
   comparing with None.

0.16.3
------
 * Added ``WhereRaw``, so raw SQL can be used in where clauses.
 * ``piccolo shell run`` now uses syntax highlighting - courtesy of Fingel.

0.16.2
------
Reordering the dependencies in requirements.txt when using ``piccolo asgi new``
as the latest FastAPI and Starlette versions are incompatible.

0.16.1
------
Added ``Timestamptz`` column type, for storing datetimes which are timezone
aware.

0.16.0
------
 * Fixed a bug with creating a ``ForeignKey`` column with ``references="self"``
   in auto migrations.
 * Changed migration file naming, so there are no characters in there which
   are unsupported on Windows.

0.15.1
------
Changing the status code when creating a migration, and no changes were
detected. It now returns a status code of 0, so it doesn't fail build scripts.

0.15.0
------
Added ``Bytea`` / ``Blob`` column type.

0.14.13
-------
Fixing a bug with migrations which drop column defaults.

0.14.12
-------
 * Fixing a bug where re-running ``Table.create(if_not_exists=True)`` would
   fail if it contained columns with indexes.
 * Raising a ``ValueError`` if a relative path is provided to ``ForeignKey``
   ``references``. For example, ``.tables.Manager``. The paths must be absolute
   for now.

0.14.11
-------
Fixing a bug with ``Boolean`` column defaults, caused by the ``Table``
metaclass not being explicit enough when checking falsy values.

0.14.10
-------
 * The ``ForeignKey`` ``references`` argument can now be specified using a
   string, or a ``LazyTableReference`` instance, rather than just a ``Table``
   subclass. This allows a ``Table`` to be specified which is in a Piccolo app,
   or Python module. The ``Table`` is only loaded after imports have completed,
   which prevents circular import issues.
 * Faster column copying, which is important when specifying joins, e.g.
   ``await Band.select(Band.manager.name).run()``.
 * Fixed a bug with migrations and foreign key contraints.

0.14.9
------
Modified the exit codes for the ``forwards`` and ``backwards`` commands when no
migrations are left to run / reverse. Otherwise build scripts may fail.

0.14.8
------
 * Improved the method signature of the ``output`` query clause (explicitly
   added args, instead of using ``**kwargs``).
 * Fixed a bug where ``output(as_list=True)`` would fail if no rows were found.
 * Made ``piccolo migrations forwards`` command output more legible.
 * Improved renamed table detection in migrations.
 * Added the ``piccolo migrations clean`` command for removing orphaned rows
   from the migrations table.
 * Fixed a bug where ``get_migration_managers`` wasn't inclusive.
 * Raising a ``ValueError`` if ``is_in`` or ``not_in`` query clauses are passed
   an empty list.
 * Changed the migration commands to be top level async.
 * Combined ``print`` and ``sys.exit`` statements.

0.14.7
------
 * Added missing type annotation for ``run_sync``.
 * Updating type annotations for column default values - allowing callables.
 * Replaced instances of ``asyncio.run`` with ``run_sync``.
 * Tidied up aiosqlite imports.

0.14.6
------
 * Added JSON and JSONB column types, and the arrow function for JSONB.
 * Fixed a bug with the distinct clause.
 * Added ``as_alias``, so select queries can override column names in the
   response (i.e. SELECT foo AS bar from baz).
 * Refactored JSON encoding into a separate utils file.

0.14.5
------
 * Removed old iPython version recommendation in the ``piccolo shell run`` and
   ``piccolo playground run``, and enabled top level await.
 * Fixing outstanding mypy warnings.
 * Added optional requirements for the playground to setup.py

0.14.4
------
 * Added ``piccolo sql_shell run`` command, which launches the psql or sqlite3
   shell, using the connection parameters defined in ``piccolo_conf.py``.
   This is convenient when you want to run raw SQL on your database.
 * ``run_sync`` now handles more edge cases, for example if there's already
   an event loop in the current thread.
 * Removed asgiref dependency.

0.14.3
------
 * Queries can be directly awaited - ``await MyTable.select()``, as an
   alternative to using the run method ``await MyTable.select().run()``.
 * The ``piccolo asgi new`` command now accepts a ``name`` argument, which is
   used to populate the default database name within the template.

0.14.2
------
 * Centralised code for importing Piccolo apps and tables - laying the
   foundation for fixtures.
 * Made orjson an optional dependency, installable using
   ``pip install piccolo[orjson]``.
 * Improved version number parsing in Postgres.

0.14.1
------
Fixing a bug with dropping tables in auto migrations.

0.14.0
------
Added ``Interval`` column type.

0.13.5
------
 * Added ``allowed_hosts`` to ``create_admin`` in ASGI template.
 * Fixing bug with default ``root`` argument in some piccolo commands.

0.13.4
------
 * Fixed bug with ``SchemaSnapshot`` when dropping columns.
 * Added custom ``__repr__`` method to ``Table``.

0.13.3
------
Added ``piccolo shell run`` command for running adhoc queries using Piccolo.

0.13.2
------
 * Fixing bug with auto migrations when dropping columns.
 * Added a ``root`` argument to ``piccolo asgi new``, ``piccolo app new`` and
   ``piccolo project new`` commands, to override where the files are placed.

0.13.1
------
Added support for ``group_by`` and ``Count`` for aggregate queries.

0.13.0
------
Added `required` argument to ``Column``. This allows the user to indicate which
fields must be provided by the user. Other tools can use this value when
generating forms and serialisers.

0.12.6
------
 * Fixing a typo in ``TimestampCustom`` arguments.
 * Fixing bug in ``TimestampCustom`` SQL representation.
 * Added more extensive deserialisation for migrations.

0.12.5
------
 * Improved ``PostgresEngine`` docstring.
 * Resolving rename migrations before adding columns.
 * Fixed bug serialising ``TimestampCustom``.
 * Fixed bug with altering column defaults to be non-static values.
 * Removed ``response_handler`` from ``Alter`` query.

0.12.4
------
Using orjson for JSON serialisation when using the ``output(as_json=True)``
clause. It supports more Python types than ujson.

0.12.3
------
Improved ``piccolo user create`` command - defaults the username to the current
system user.

0.12.2
------
Fixing bug when sorting ``extra_definitions`` in auto migrations.

0.12.1
------
 * Fixed typos.
 * Bumped requirements.

0.12.0
------
 * Added ``Date`` and ``Time`` columns.
 * Improved support for column default values.
 * Auto migrations can now serialise more Python types.
 * Added ``Table.indexes`` method for listing table indexes.
 * Auto migrations can handle adding / removing indexes.
 * Improved ASGI template for FastAPI.

0.11.8
------
ASGI template fix.

0.11.7
------
 * Improved ``UUID`` columns in SQLite - prepending 'uuid:' to the stored value
   to make the type more explicit for the engine.
 * Removed SQLite as an option for ``piccolo asgi new`` until auto migrations
   are supported.

0.11.6
------
Added support for FastAPI to ``piccolo asgi new``.

0.11.5
------
Fixed bug in ``BaseMigrationManager.get_migration_modules`` - wasn't
excluding non-Python files well enough.

0.11.4
------
 * Stopped ``piccolo migrations new`` from creating a config.py file - was
   legacy.
 * Added a README file to the `piccolo_migrations` folder in the ASGI template.

0.11.3
------
Fixed `__pycache__` bug when using ``piccolo asgi new``.

0.11.2
------
 * Showing a warning if trying auto migrations with SQLite.
 * Added a command for creating a new ASGI app - ``piccolo asgi new``.
 * Added a meta app for printing out the Piccolo version -
   ``piccolo meta version``.
 * Added example queries to the playground.

0.11.1
------
 * Added ``table_finder``, for use in ``AppConfig``.
 * Added support for concatenating strings using an update query.
 * Added more tables to the playground, with more column types.
 * Improved consistency between SQLite and Postgres with ``UUID`` columns,
   ``Integer`` columns, and ``exists`` queries.

0.11.0
------
Added ``Numeric`` and ``Real`` column types.

0.10.8
------
Fixing a bug where Postgres versions without a patch number couldn't be parsed.

0.10.7
------
Improving release script.

0.10.6
------
Sorting out packaging issue - old files were appearing in release.

0.10.5
------
Auto migrations can now run backwards.

0.10.4
------
Fixing some typos with ``Table`` imports. Showing a traceback when piccolo_conf
can't be found by ``engine_finder``.

0.10.3
------
Adding missing jinja templates to setup.py.

0.10.2
------
Fixing a bug when using ``piccolo project new`` in a new project.

0.10.1
------
Fixing bug with enum default values.

0.10.0
------
Using targ for the CLI. Refactored some core code into apps.

0.9.3
-----
Suppressing exceptions when trying to find the Postgres version, to avoid
an ``ImportError`` when importing `piccolo_conf.py`.

0.9.2
-----
``.first()`` bug fix.

0.9.1
-----
Auto migration fixes, and ``.first()`` method now returns None if no match is
found.

0.9.0
-----
Added support for auto migrations.

0.8.3
-----
Can use operators in update queries, and fixing 'new' migration command.

0.8.2
-----
Fixing release issue.

0.8.1
-----
Improved transaction support - can now use a context manager. Added ``Secret``,
``BigInt`` and ``SmallInt`` column types. Foreign keys can now reference the
parent table.

0.8.0
-----
Fixing bug when joining across several tables. Can pass values directly into
the ``Table.update`` method. Added ``if_not_exists`` option when creating a
table.

0.7.7
-----
Column sequencing matches the definition order.

0.7.6
-----
Supporting `ON DELETE` and `ON UPDATE` for foreign keys. Recording reverse
foreign key relationships.

0.7.5
-----
Made ``response_handler`` async. Made it easier to rename columns.

0.7.4
-----
Bug fixes and dependency updates.

0.7.3
-----
Adding missing `__int__.py` file.

0.7.2
-----
Changed migration import paths.

0.7.1
-----
Added ``remove_db_file`` method to ``SQLiteEngine`` - makes testing easier.

0.7.0
-----
Renamed ``create`` to ``create_table``, and can register commands via
`piccolo_conf`.

0.6.1
-----
Adding missing `__init__.py` files.

0.6.0
-----
Moved ``BaseUser``. Migration refactor.

0.5.2
-----
Moved drop table under ``Alter`` - to help prevent accidental drops.

0.5.1
-----
Added ``batch`` support.

0.5.0
-----
Refactored the ``Table`` Metaclass - much simpler now. Scoped more of the
attributes on ``Column`` to avoid name clashes. Added ``engine_finder`` to make
database configuration easier.

0.4.1
-----
SQLite is now returning datetime objects for timestamp fields.

0.4.0
-----
Refactored to improve code completion, along with bug fixes.

0.3.7
-----
Allowing ``Update`` queries in SQLite

0.3.6
-----
Falling back to `LIKE` instead of `ILIKE` for SQLite

0.3.5
-----
Renamed ``User`` to ``BaseUser``.

0.3.4
-----
Added ``ilike``.

0.3.3
-----
Added value types to columns.

0.3.2
-----
Default values infer the engine type.

0.3.1
-----
Update click version.

0.3
---
Tweaked API to support more auto completion. Join support in where clause.
Basic SQLite support - mostly for playground.

0.2
---
Using ``QueryString`` internally to represent queries, instead of raw strings,
to harden against SQL injection.

0.1.2
-----
Allowing joins across multiple tables.

0.1.1
-----
Added playground.