Pgmerge

Changed

- Update all dependencies to latest versions that still have Python 3.7 support:
- This includes `SQLAlchemy` from 1.4.43 to 2.0.30 & `typer` from 0.4.2 to 0.12.3 (and prefer `typer-slim`).
- As well as all dev dependencies.
- Replace deprecated `appdirs` dependency with `platformdirs` 4.0.0.
- Updated build tool `Poetry` from 1.4.2 to 1.5.1.
- Standardise code formatting.

Fixed

- Fix negative table counts when reporting success output.

Changed

- Include file count in reported success output.
- Enable updated transaction-level API when using database engine to prepare for SQLAlchemy 2.0.

Fixed

* Fix `--single-table` option to also work when no config is provided.
* Detect invalid config that has duplicate subset names within one table's configs.

Changed

* Table config schema has been changed to use standard JSON schema.
* Table config's format remains unchanged and the format of the schema file is still YAML.
* Dependency `rxjson` has been replaced with `fastjsonschema` (version 2.19.1).
* Details about validation failure are now included in reported error messages.

Fixed

* Fix reported version when running `--version`.

Changed

* Upsert operations more consistenly maintains ordering of newly inserted rows in PostgreSQL 16+.
* Move to Poetry for build and dependency management.

Removed

* Support for Python 3.6 & Ubuntu 18.04.

Added

* Changelog.
* Mypy type checking & CI improvements.

Changed

* Make changes to partially migrate and prepare for new APIs in SQLAlchemy 2.0.
* Return exit code 3 when exceptions cause execution to fail and exit code 4 when there are unexpected data issues.

Added

* Add extra tests, code coverage and CI checks.