Pynonymizer

Added
- Added Integration tests for MSSQL
- Added Driver auto-selection for MSSQL. This should find the correct driver on different systems. Where multiple drivers are detected a warning will be issued, and the first driver will be selected. To override this behaviour, you can specify the driver manually using cli opt `--mssql-driver / $PYNONYMIZER_MSSQL_DRIVER`
- Added support for remote servers in MSSQL, provided RESTORE_DB/DUMP_DB is not being used.
- Added support for MSSQL servers using custom ports.
Changed
- Changed Integration tests to show cmd output better in CI.
- Changed MSSQL connection behaviour: provider will now allow truncation using `ANSI_WARNINGS off;` when updating tables.
- Changed verbose-mode behaviour to include more information via debug logs during CLI runs.
Fixed
- Fixed an issue in MSSQL where anonymization would be deterministically applied to all rows the same instead of distributed.
- Fixed a typo in mssql, mysql and postgres when running strategy before/after scripts.

Added
- Added New _additional-opts_ style parameters which allow you to control the behaviour of the underlying dump and restore tools more effectively.
`*-cmd-opts` will be appended to the batched restore subprocess, while `*-dump-opts` will be appended to the dump (pgdump, mysqldump) subprocess
These are advanced features and can seriously modify or even break the behaviour of pynonymizer. Use with caution!
* `--mysql-cmd-opts/$PYNONYMIZER_MYSQL_CMD_OPTS`
* `--postgres-cmd-opts/$PYNONYMIZER_POSTGRES_CMD_OPTS`
* `--postgres-dump-opts/$PYNONYMIZER_POSTGRES_DUMP_OPTS`
- Added cli warnings for deprecated positional arguments and environmental variables.
- Added Python 3.9 to official support description(pypi) and unit test targets.
Changed
- Changed order of `additional_args` for Mysql dump runner, so additional options are added _after_ the existing args.
Fixed
- Fixed a bug where `$PYNONYMIZER_VERBOSE` was not being detected correctly.

Added
- Added support for LZMA `*.xz` compression on file output. To use this feature, Specify an output path ending with `.xz`.
Changed
- Minor improvements to internal test suite.

Added
- Added main function `run` exposure to `pynonymizer` package.
Check out pynonymizer/pynonymize.py for more usage information
python
from pynonymizer import run

- Added more documentation to reflect usage & project features.
Changed
- Exclude `tests/` directory from pip package.

Added
- Added `fake_update` Strategy feature: `sql_type`: Choose an sql datatype to cast to when anonymizing values. The new value will be cast to the chosen datatype.
Fixed
- Fixed PostgreSQL column escaping. Keywords like `SELECT`, `FROM` or `WHERE` can now be used in strategy files.

Added
- Added new table strategy `DELETE`, which should delete _with_ checks (e.g. foreign keys) on most providers.