Create API/Factory methods to insert in the unique_fields table

[freddyDOTCMS]

Parent Issue

#29459

User Story

We need to create API and Factory methods to insert a record into the new unique_factory table:

• Factory Method:

This method should take the unique_key and the JSON for the supporting_values, this JSON can be pass like a Map. It will insert a new record. If an exception occurs due to a unique primary key (PK) violation, the method should allow the exception to propagate without handling it.

API Method:

This method should accept all the unqiue Criteria: Content Type ID, FIeld variable name, Host id, language Id, Field value, and content identifier. It must also check the value of the uniquePerSite field to determine how to calculate the hash. If uniquePerSite is true, the host_id must be included in the hash calculation. If a unique PK violation occurs, it should wrap the error in a custom exception.

AFter calculate the unique field key it must use the Factory method to save the new unique register.

Acceptance Criteria

API/Factory methods implemented

Proposed Objective

Core Features

Proposed Priority

Priority 2 - Important

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

No response

Assumptions & Initiation Needs

No response

Quality Assurance Notes & Workarounds

No response

Sub-Tasks & Estimates

No response

[github-actions]

PRs:

• Issue 30277 create api factory methods to insert in the unique fields table #30466

[freddyDOTCMS]

Note to QA: test together with #30279

[jcastro-dotcms]

As @freddyDOTCMS pointed out, this fix is not verifiable per se. It is validated after testing this related ticket:

• Create API/Factory methods to insert in the unique_fields table #30277

Such a ticket passed IQA, which means this one did as well.

[josemejias11]

Approved: Tested on trunk_7a2d6bc, Docker, macOS 14.5, FF v126.0.1