​

Description

This PR improves the database logic by:

• Analyzing database constraint violations to understand their causes.
• Adding proper uniqueness checks to prevent duplicate entries.
• Handling conflicts gracefully to avoid breaking the application.
• Ensuring idempotent and unique inserts for better data integrity.

​

Related Issue (Link to Github issue)

Closes #370

​

How Has This Been Tested?

• Manual Testing: Verified functionality by creating and updating records with different test cases.
• Unit Tests: Ran test suites to ensure database constraints work as expected. Specifically tested:

1. ./tests/test_organisation
2. ./tests/test_newsletter
3. ./tests/test_superadmin

​

Screenshots

​

Types of changes

• Bug fix (non-breaking change which fixes an issue)
• New feature (non-breaking change which adds functionality)
• Breaking change (fix or feature that would cause existing functionality to change)
  ​

Checklist:

• My code follows the code style of this project.
• I have updated the documentation accordingly.
• I have added tests to cover my changes.
• All new and existing tests passed.