v4.2.0

chore(release): 4.2.0

# [4.2.0](https://gitlab.dockstudios.co.uk/pub/terrareg/compare/v4.1.0...v4.2.0) (2025-05-08)

### Features

* Add support for .tfignore file to ignore files in module archives when supplying modules as archives ([73d7d95](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/73d7d9566dd6a05db48760acbf8bc16d3e3f907f)), closes [#561](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/561)

v4.1.0

chore(release): 4.1.0

# [4.1.0](https://gitlab.dockstudios.co.uk/pub/terrareg/compare/v4.0.0...v4.1.0) (2025-05-06)

### Bug Fixes

* Add columns to group by for module search for tables that are included in the select ([96a531e](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/96a531e440af8c134e0f8687046c9fac00cdb136)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Cast action enum to a string to fix ordering of action in audit ([e81fd5e](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/e81fd5e2a11dcd86102b2b4cad364515bee089b6)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* **db:** Fix enum migrations for Postgres ([2354fb3](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/2354fb335a72c05c01d3bd7fffda2ad44f35e871)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* **db:** Handle constraints not existing (by checking if they exist) ([60e7d11](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/60e7d11345df81a263c4568a7300cf3e8016f1e7)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* **db:** Mark all 'id' columns as incremental, ensuring that incrementing IDs are used in Postgres ([ccba696](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/ccba6962f1167df33776f0582fb412a5a75f4564)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Ensure audit action column is cast where performing string comparison ([48149fc](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/48149fcd959b34bf74975295181f0d9b43a39036)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Fix enum creation for Postgres, as the Enum must be created beforehand ([e5b4d54](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/e5b4d541fecf88350bae9b0b51480bd33570dafa)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Fix non-consistent ordering of results in Postgresl in search when relevant scores are the same. ([58086a5](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/58086a5fb617651dff871943376495dcd6176beb)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Fix provider search base query to include all columns in WHERE clause in the GROUP BY clause ([0eba7dc](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/0eba7dc852ede848488abb3660cf5f8a75c05970)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Fix sql query, where table is being selected, which treats first argument as a where clause, resulting in the column being added to "WHERE" without an operator. ([c787ab1](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/c787ab1b9c3bff0279e2b82ae23ab3204d222ac5)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Handle differences in true/false values in Postgres for DB migration scripts ([180cdaa](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/180cdaa6146879fb1255d45166c4be4470b86f25)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Handle git_provider_id being an empty string and do not treat as a set value in create module provider endpoint ([8387d66](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/8387d663718360446cf4c35faa16ceb9a1917045)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Include all selected fields that are grouped by in analytics base and module usage count queries ([a31e8d1](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/a31e8d1e7b6d4b48ea5967b2d736a2bf47c0e52d)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Include ID column in analytics query, as this is used in the group_by, meaning it must be included in the selected fields, otherwise Postgres will throw an error ([8878ff6](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/8878ff6375074217193ce30c4f3b834f836b823a)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Lower-case all remaining non-timestamp fields when ordering audit data. Update tests to expect the fact that the engines still don't match. ([2231ba7](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/2231ba733a7f593e263a9006c6ea2796a8059c47)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Only attempt to resolve GitRepository when updating module provider if the git provider ID is non-empty ([376bf6a](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/376bf6a4231fc7a526466319e08395251e29c39d)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Order rows returned for prometheus metrics ([fc3c1db](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/fc3c1db06edb178457d96b46379d32285ebb876c)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Perform lower-case comparison of username in audit filtering ([43cf696](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/43cf6966c4c328c4cb87f480a626b7c86317db72)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Replace use of `lastrowid` with `inserted_primary_key` when obtaining primary key values of inserted rows. ([bc00185](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/bc0018563f9c39e368514b3f171ce837f36c7664)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* Update DB migrations to use LargeBinary as variant to "blob" for Postgresql as blob is not available for Postgresql ([0173908](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/01739087a2038f9d768d9e83292730f5489ae248)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)

### Features

* Add package for postgresql connector ([74c792c](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/74c792c33edc3c691eb18cc05f24060dfb404f75)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)
* **database:** Add support for Postgres server ([1197088](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/1197088b4b912f9e0b0e83304ac1d68f7bc5a54a)), closes [#562](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/562)

v4.0.0

chore(release): 4.0.0

# [4.0.0](https://gitlab.dockstudios.co.uk/pub/terrareg/compare/v3.13.5...v4.0.0) (2025-04-19)

* feat(build)!: Switch to Poetry for dependency management ([4365ac1](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/4365ac1a5954973de1383fad33295e711577c0f0)), closes [#565](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/565)

### BREAKING CHANGES

* Moving package management to poetry, meaning that binaries/scripts must be executed with `poetry run`.
This may break integrations where scripts are being run within the container.
Ensure any pre-existing configuration that executes scripts within the container are prepended with `poetry run`.
NOTE: The use of requirements-*.txt files is now **deprecated** and will be removed in future minor/patch versions.

Merge branch '565-move-from-pip-file-to-alternative-depdency-locking' into 'main'

Resolve "Move from pip file to alternative dependency locking"

v3.13.5

chore(release): 3.13.5

## [3.13.5](https://gitlab.dockstudios.co.uk/pub/terrareg/compare/v3.13.4...v3.13.5) (2025-03-07)

### Bug Fixes

* Enforce authentication server-side before returning state HTML files ([d662189](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/d66218909ea7d3fa0823d1f175f97980064d47cd)), closes [#560](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/560)

v3.13.4

chore(release): 3.13.4

## [3.13.4](https://gitlab.dockstudios.co.uk/pub/terrareg/compare/v3.13.3...v3.13.4) (2025-01-20)

### Bug Fixes

* Fix typo in EXAMPLE.env ([973e029](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/973e029375c5500a15153094399342f450dcefaf)), closes [#554](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/554)
* Remove extra entrypoint in dockerfile.tests ([fbb3077](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/fbb307731163adc7f677fd46c50f32c711aca325)), closes [#555](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/555)

v3.13.3

chore(release): 3.13.3

## [3.13.3](https://gitlab.dockstudios.co.uk/pub/terrareg/compare/v3.13.2...v3.13.3) (2025-01-09)

### Bug Fixes

* Remove deprecated 'version' key from docker-compose configuration ([8e9f257](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/8e9f257a08dae6b3e6a089b061400f74a083e27d)), closes [#553](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/553)

v3.13.2

chore(release): 3.13.2

## [3.13.2](https://gitlab.dockstudios.co.uk/pub/terrareg/compare/v3.13.1...v3.13.2) (2025-01-07)

### Bug Fixes

* Support 'EMPTY' string as an alternative for passing empty string value as environment variable for EXAMPLE_ANALYTICS_TOKEN ([047f7a4](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/047f7a49d01123e4302d4b2c8a7332f9a98ce85b)), closes [#548](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/548)

v3.13.1

chore(release): 3.13.1

## [3.13.1](https://gitlab.dockstudios.co.uk/pub/terrareg/compare/v3.13.0...v3.13.1) (2024-12-09)

### Bug Fixes

* Fix authentication when downloading modules that use archives and use a sub-path, when anonymous access is disabled ([599261b](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/599261b6006758e346f395ca839ea5dd6041f9c3)), closes [#547](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/547)
* Fix supplying module download redirects that contain an encryption key and a path (for modules that use git path and not archive_git_path) ([5cff918](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/5cff918505065d3aae9bee48f26c600190ba1faa)), closes [#547](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/547)
* Move presign key for downloading source zip file into path, rather than query string argument ([15e0915](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/15e09156f778528371005742cd86678df64e1d77)), closes [#547](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/547)
* Switch path arguments for source download URL, so that the 'file' (final path section) is source.zip ([947cedf](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/947cedf6cce8589d9d1bd94ab43c379350ec33ab)), closes [#547](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/547)

v3.13.0

chore(release): 3.13.0

# [3.13.0](https://gitlab.dockstudios.co.uk/pub/terrareg/compare/v3.12.2...v3.13.0) (2024-12-07)

### Bug Fixes

* Fix browser console errors in module provider page ([a372be7](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/a372be7269159c78419a99dec52c10862e806421))

### Features

* Add API endpoint to manually register analytics ([52ac3a4](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/52ac3a4a6c6df01ebcba35d069441c8eade0ce53)), closes [#548](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/548)

v3.12.2

chore(release): 3.12.2

## [3.12.2](https://gitlab.dockstudios.co.uk/pub/terrareg/compare/v3.12.1...v3.12.2) (2024-11-01)

### Bug Fixes

* Allow ampersands in templated URLs for module provider, allowing query string delimiter to not be escaped ([c688aa2](https://gitlab.dockstudios.co.uk/pub/terrareg/commit/c688aa2e325cc0973d8ea7bcdfa3ee570064182e)), closes [#546](https://gitlab.dockstudios.co.uk/pub/terrareg/issues/546)