Handle the Cleanup of Resource Sharing Policies and Attributes During Resource, Attribute, and Organization Deletion

[BimsaraBodaragama]

The proper cleanup of resource-sharing policies and shared attributes is critical to maintaining database consistency and avoiding unnecessary data accumulation. Currently, there is no mechanism to handle these cleanups systematically during deletions.

Is your feature request related to a problem? Please describe.

The current system does not clean up resource-sharing policies and shared attributes when resources, attributes, or organizations are deleted. This issue arises because resource-sharing policies are managed in a generalized table for all resources, and shared attributes are managed in a generalized table for all shared attributes. This results in:

1. Inconsistencies in the database due to orphaned entries.
2. Unnecessary accumulation of data, increasing storage usage.
3. Difficulties in maintaining data integrity across organizational hierarchies.

Describe the solution you would prefer

Introduce SQL queries and implement the necessary methods to:

1. Delete resource-sharing policies based on resource type and ID when resources are deleted.
2. Delete shared attributes based on attribute type and ID when attributes are deleted.
3. Delete resource-sharing policies based on organization ID when organizations are deleted.

Additionally, include unit tests to validate the correctness and reliability of these changes.

Additional context

Implementing these changes will:

1. Maintain consistency and integrity of the database.
2. Prevent unnecessary data accumulation.
3. Simplify future maintenance by ensuring that deletions are handled efficiently and systematically.

[BimsaraBodaragama]

You can track the PR here.