refactor:update the prefix logic in DA

[arya-girish-k]

Description

Refactored the code logic for prefix variable by adding default value for prefix and marked as required in catalog manifest.Also allowed prefix to be "" (empty string) for advanced users.
#11959

Release required?

• No release
• Patch release (x.x.X)
• Minor release (x.X.x)
• Major release (X.x.x)

Release notes content

Add the default value for prefix variable and mark as required in catalog manifest. Also allowed prefix to be "" (empty string ).The addition of a default value for the prefix variable has caused a failure in the TestRunStandardUpgradeSolution. However, if users remove the prefix, it will not result in a breaking change.

Run the pipeline

If the CI pipeline doesn't run when you create the PR, the PR requires a user with GitHub collaborators access to run the pipeline.

Run the CI pipeline when the PR is ready for review and you expect tests to pass. Add a comment to the PR with the following text:

/run pipeline

Checklist for reviewers

• If relevant, a test for the change is included or updated with this PR.
• If relevant, documentation for the change is included or updated with this PR.

For mergers

• Use a conventional commit message to set the release level. Follow the guidelines.
• Include information that users need to know about the PR in the commit message. The commit message becomes part of the GitHub release notes.
• Use the Squash and merge option.

[arya-girish-k]

/run pipeline

[arya-girish-k]

/run pipeline

[arya-girish-k]

Please find test reference .
https://github.ibm.com/GoldenEye/issues/issues/11959#issuecomment-101858594

[arya-girish-k]

The TestRunStandardUpgradeSolution is failing due to the addition of a default value for the prefix variable.
https://github.com/terraform-ibm-modules/terraform-ibm-icd-postgresql/actions/runs/12789666604/job/35653920290#step:7:2292

As per the test terraform will execute the following actions:

• Update the resource_group, kms_policy, and postgresql_db resources.

• Destroy the existing kms_key, kms_key_ring, and kms_key_policy resources.

• Create new instances of kms_key, kms_key_ring, and kms_key_policy resources.

Since removing the prefix won't result in a breaking change for the user, So as per the discussion it is fine to skip the upgrade test in this scenario.

[arya-girish-k]

/run pipeline