[SAK-44753] Rubrics tool association add a unique constraint per rubric / tool / item - Sakai

XML

Word

Printable

Test Plan:
Hide

In a Site create a Rubric

In the same site Create 2 entries in each tool that are associated with the same Rubric

Discussions create 2 Topics graded with rubric

Assignments create 2 Assignment graded with rubric

Test & Quizes create 2 assessments grade with rubric

Gradebook create 2 Grade Items with rubric

If no errors were seen in the log and all items have the Rubric Icon the test passed
Show
In a Site create a Rubric In the same site Create 2 entries in each tool that are associated with the same Rubric Discussions create 2 Topics graded with rubric Assignments create 2 Assignment graded with rubric Test & Quizes create 2 assessments grade with rubric Gradebook create 2 Grade Items with rubric If no errors were seen in the log and all items have the Rubric Icon the test passed

Rubrics should not be allowed to create more than one association for the same item:

A constraint will be added to enforce this on:

@UniqueConstraint(columnNames = {"rubric_id", "toolId", "itemId"})

The db will require the following conversion:

alter table rbc_tool_item_rbc_assoc add constraint UKq4btc0dfymi80bb5mp3vp3r7u unique (rubric_id, toolId, itemId);

relates to

SAK-42700 Rubrics observed slow queries without indexes