fix:[CORE-2010] removed the update statements for severity and category

[santhosh-challa]

Description

We are not persisting user updates on Policy category and severity. They are getting back to their original state post redeploy as we have update statements.

Problem

As the policy metadata script contains many update queries, redeploy updating the severity and category for many policies.

Solution

Removed all the update statements and updated their insert statement to contain the correct category and severity values.

Type of change

• [X] Bug fix (non-breaking change which fixes an issue)

How Has This Been Tested?

Ran the script in saasdev, and checked the pre and post-count of policies.

Checklist:

• [X] My code follows the style guidelines of this project
• [X] My commit message/PR follows the contribution guidelines of this project
• [X] I have performed a self-review of my code
• [X] New and existing unit tests pass locally with my changes

Other Information:

List any documentation updates that are needed for the Wiki

[github-actions[bot]]

⚠️ DELETE statement found in the changes of SQL files. Requesting review from @santhosh and @arun.

[santhosh-challa]

Please use this https://github.dev/PaladinCloud/CE/pull/2177 to see the diff.

[sonarcloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
No data about Coverage
No data about Duplication

See analysis details on SonarCloud