-
Notifications
You must be signed in to change notification settings - Fork 2
Ensure Topics table can't have a duplicate key for an attribute #106
Copy link
Copy link
Closed
Labels
Area: SQLRelates to the SQL Server database objects; do not use for the repository.Relates to the SQL Server database objects; do not use for the repository.Priority: 3Severity 0: Nice to haveStatus 5: CompleteTask is considered complete, and ready for deployment.Task is considered complete, and ready for deployment.Type: ImprovementImproves the functionality or interface of an existing feature.Improves the functionality or interface of an existing feature.
Milestone
Metadata
Metadata
Assignees
Labels
Area: SQLRelates to the SQL Server database objects; do not use for the repository.Relates to the SQL Server database objects; do not use for the repository.Priority: 3Severity 0: Nice to haveStatus 5: CompleteTask is considered complete, and ready for deployment.Task is considered complete, and ready for deployment.Type: ImprovementImproves the functionality or interface of an existing feature.Improves the functionality or interface of an existing feature.
Currently, the OnTopic Library evaluates whether or not a key already exists for a given attribute within the same
Topic.Parentand, if so, throws an exception. This is not enforced by the database itself, however, and can thus result in inadvertent duplicates when making manual updates to theTopicstable, which will then throw an exception when loading the topics via e.g. anITopicRepositoryimplementation. This can be mitigated by adding a unique constraint on theTopicKeyandParentIDcolumns.