Spinta

===================

Backwards incompatible:

- Changed `spinta_sqlite` driver name to `spinta`. Old naming was unnecessary since you needed to use `sqlite+spinta_sqlite:///...`,
now you can just use `sqlite+spinta:///...` (`723`_).
- `spinta push` `state` database now will always going to append `sqlite+spinta:///` prefix, instead of `sqlite:///`. This
ensures, that `sqlite` version is now dependant on `sqlean` library, instead of taking default python `sqlite` version
(makes it easier to ensure, that users are using correct version of `sqlite`) (`723`_).
- Changed `sqlalchemy` default `sqlite` driver to `SQLiteDialect_spinta` (instead of `SQLiteDialect_pysqlite`). Meaning
every time you use `sqlite:///...` it will default to `spinta` driver, instead of `pysqlite` (default `sqlalchemy`) (`723`_).

Improvements:

- Writing `InternalSQLManifest` now is done using `transaction`, meaning if there are errors, it will rollback any changes
(This is useful when doing `copy` on already existing structure, since it clears all old data before writing new) (`715`_).

- Changed `state` db, to always use `spinta` `sqlite` driver (`723`_).

.. _723: https://github.com/atviriduomenys/spinta/issues/723

Bug fixes:

- Fixed `InternalSQLManifest` structure being fetched without index order (`715`_).

.. _715: https://github.com/atviriduomenys/spinta/issues/715

===================

New features:

- Added support for `eq`, `&` and `|` operators to `Dask` `backend` (`702`_).

.. _702: https://github.com/atviriduomenys/spinta/issues/702


Bug fixes:

- Fixed `formula` being ignored when using `inspect` (`685`_).

.. _685: https://github.com/atviriduomenys/spinta/issues/685

- Fixed errors with different formats when returning empty data (`684`_).

.. _684: https://github.com/atviriduomenys/spinta/issues/684

- Fixed `keymap.yml` not updating mapping when changing `client_name` (`688`_).

.. _688: https://github.com/atviriduomenys/spinta/issues/688

- Fixed error when opening `changes` in `html` format, when there is no `select` and you have
only one language given to `Text` property (`693`_).

.. _693: https://github.com/atviriduomenys/spinta/issues/693

- Fixed assertion error when only selecting not expanded `array` (`696`_).

.. _696: https://github.com/atviriduomenys/spinta/issues/696

- Fixed issue, where sometimes `json` `blank nodes` gets discarded and return empty `dict` (`699`_).

.. _699: https://github.com/atviriduomenys/spinta/issues/696

- Fixed error when trying to use `Dask` `backend` `&` and `|` operators (`705`_).

.. _705: https://github.com/atviriduomenys/spinta/issues/705

===================

Backwards incompatible changes:

- Changed `starlette` version requirement from `"*"` to `">=0.22"`. From version `0.22.0` `starlette` added better
compatibility support for `AnyIO`.

Bug fixes:

- Fixed `getone` with `jsonl` format (`679`_)

- Rolled back `Templates` warning fixes (caused errors with older `starlette` versions) (`679`_)

.. _679: https://github.com/atviriduomenys/spinta/issues/679

===================

Bug fixes:

- Changed json Geometry type converter import to BaseGeometry (`673`_)

.. _673: https://github.com/atviriduomenys/spinta/issues/673

===================

Backwards incompatible changes:

- When migrating from version of `spinta`, where `push` pagination
was not supported, to a version, where it is, the old `push state` database
structure is outdated and it can result in getting `InfiniteLoopWithPagination`
or `TooShortPageSize` errors (new `push state` database structure now stores pagination values, while old one does not).
With the addition of (`P98`) change, you now are able to run `push --sync` command to synchronize `push state` database.
It is important to note that it will also update pagination values, which could fix some of the infinite loop errors.

- With (`P98`) change, `internal` will no longer disable pagination when page key types are not supported.
Before this change, when model's page went through `link` process, if there was any page keys, that were not supported,
pagination was disabled, no matter what type of backend is used. Since all internal backends support `_id` property,
which is always present and unique, if we find page keys that are not supported, we can always force pagination using `_id`.
This results in that all of the requests will now by default going to be sorted by `_id` property.
Important to note, if we use `sort` with unsupported keys, pagination is still going to be disabled.


New features:

- Mermaid format support for ability to create class diagrams (`634`_).

.. _634: https://github.com/atviriduomenys/spinta/issues/634

- Parametrization support for XML and JSON external backends (`217`_,
`256`_).

.. _217: https://github.com/atviriduomenys/spinta/issues/217
.. _256: https://github.com/atviriduomenys/spinta/issues/256

- Added new manifest backend for XSD schemas (`160`_).

.. _160: https://github.com/atviriduomenys/spinta/issues/160

- Added `distinct()` function to `model.prepare` (`579`_).

.. _579: https://github.com/atviriduomenys/spinta/issues/579

- Added push state database synchronization. (`P98`)

- Added `checksum()` `select` function to PostgreSQL backend. (`P98`)

Improvements:

- Added `ResultBuilder` support to PostgreSQL backend, also changed it's
`QueryBuilder` to work like external SQL. (`P98`)

- Changed `internal` backend page assignment logic to default to `_id`
property, if any of the page keys are not supported. (`P98`)

- Added proper support for functions in `select()` expressions (`P100`).

Bug fixes:

- Migrate internal backend changed types (`580`_).

.. _580: https://github.com/atviriduomenys/spinta/issues/580

- Added support for language tags in RDF strings (`549`_).

.. _549: https://github.com/atviriduomenys/spinta/issues/549

- Show values of `text` type in tabular output (`550`_, `581`_).

.. _550: https://github.com/atviriduomenys/spinta/issues/550
.. _581: https://github.com/atviriduomenys/spinta/issues/581

- Added support for PostgreSQL OID type (`568`_).

.. _568: https://github.com/atviriduomenys/spinta/issues/568

- Fixed sorting issue with MySQL and MSSQL external backends (`P90`).

- Fixed issue with open transactions when writing data (`P92`).

- Fixed issue with outdated page key in push state tables (`P95`).

- Words in dataset names separated by underscores. (`626`__).

__ https://github.com/atviriduomenys/spinta/issues/626

- Added support for `getone` for `sql` backend (`513`__).

__ https://github.com/atviriduomenys/spinta/issues/513

- Fixed Ref id mapping with non-primary keys when primary keys were not initialized (`653`__).

__ https://github.com/atviriduomenys/spinta/issues/653

- Fixed issue with Geometry type conversion when pushing data (`652`__).

__ https://github.com/atviriduomenys/spinta/issues/652

- Fixed issue with Geometry bounding box check not applying CRS projection (`654`__).

__ https://github.com/atviriduomenys/spinta/issues/654

===================

New features:

- Add possibility to update manifest via HTTP API, without restarting server
(`479`_).

.. _479: https://github.com/atviriduomenys/spinta/issues/479

Bug fixes:

- Fixed error with index names exceeding 63 character limit on PostgreSQL
(`566`_).

.. _566: https://github.com/atviriduomenys/spinta/issues/566

- Set WGS84 SRID for geometry tupe if SRID is not given as specified in
documentation (`562`_).

.. _562: https://github.com/atviriduomenys/spinta/issues/562