Palje

Summary

Palje v3 adopts the newly introduced Command Line Interface (CLI) from earlier releases, now featuring more Confluence handling utilities and performance improvements. Furthermore, various minor bugs have been addressed, and the generated database documentation has been slightly improved for better readability.

Breaking Changes

- The `palje` command now utilizes the new CLI (previously known as `palje2`).
- The intermediate `palje2` command has been removed.
- Changes have been made to Confluence parameter naming.
- A source/target prefix has been added into Confluence parameter names to clearly distinguish between read and write operations.
- For example, in the `palje document` command the previously used `--confluence-root-url` is now `--target-confluence-root-url`.
- The legacy CLI (former `palje`) remains available as `palje-old` for now. However, it will be completely removed in future releases.

New Features

- A separate `palje sort` command has been introduced for alphabetically sorting existing Confluence page hierarchies.
- An _experimental_ `palje copy` command is now available for copying Confluence page hierarchies:
- Please note that there are known **unresolved issues**, so use it with caution!
- This feature is only accessible if the `PALJE_EXPERIMENTAL_FEATURES_ENABLED` environment variable is set.
- Attachment type support is currently limited and unreliable; for instance, on the copied pages, seemingly working images get lost during Confluence web UI edits.

Improvements to Existing Features

- Enhanced performance for the `palje document` command.
- Minor readability improvements have been made to the database documentation style:
- Only "YES" is displayed for true values in boolean columns; otherwise, nothing is shown.
- Internally used temporary tables are not listed as procedure dependencies any more.

Bug fixes

- Various minor bugs have been fixed along the way.

Bug fixes

- Fixed issue with pages not getting in correct alphabetical order with palje2 document command. This only affects page creation; existing pages will keep their place on update.
- Changing databases in GUI now works with AZSQL databases, too.
- Fixed issue with auto-generated object type page titles. For example, a weird looking “db.schema.Tables” will be “Tables db.schema” instead (like it used to be).

**Major changes**

- significant performance improvements: documenting a database should be _much_ faster now
- new `palje2` CLI: more flexible and user-friendly command-line interface with support for reading parameter values from environment variables
- traditional database documenting is now available via new `palje2 document` command
- new `palje2 delete` -command: delete individual Confluence pages or complete page hierarchies with ease
- legacy `palje` CLI (with improved performance) is still available

**Minor changes**

- fix ODBC driver v18 issue with local connections
- various smaller improvements, bug-fixes and code refactoring

Full changelist:
* Make object_dependencies query fault tolerant
* Make sure that database names are spelled with correct case
* Implement release pipeline
* Update CLI hint text
* Add tkinter GUI
* Add icon for the app
* Update requests version to fix CVE-2024-35195

Added script to create msi installers.

Changes to usage:

- The Confluence url must now be given as `https://<your-organization-domain>.atlassian.net/`, instead of the old longer form
- You can now drop the `python -m` from the beginning and just run it using `palje`, e.g.
`palje "https://<your-org>.atlassian.net/" TEST "localhost,1433" MY_DB --schemas dbo store --dependent MY_OTHER_DB --authentication "SQL"`

Full changelist:

- Use Atlassian API v2
- Display symbols <, > and & correctly
- Add missing library dependency
- Drop support for Python versions < 3.11
- Use only pyproject.toml for setup