Skip to content

Ensure Topics table can't have a duplicate key for an attribute #106

@JeremyCaney

Description

@JeremyCaney

Currently, the OnTopic Library evaluates whether or not a key already exists for a given attribute within the same Topic.Parent and, 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 the Topics table, which will then throw an exception when loading the topics via e.g. an ITopicRepository implementation. This can be mitigated by adding a unique constraint on the TopicKey and ParentID columns.

Metadata

Metadata

Assignees

Labels

Area: SQLRelates 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.Type: ImprovementImproves the functionality or interface of an existing feature.

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions