Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-44753

Rubrics tool association add a unique constraint per rubric / tool / item

    XMLWordPrintable

    Details

    • 21 Status:
      Verified
    • 20 status:
      Verified
    • 19 status:
      Verified
    • Conversion Script Required:
      Yes
    • Test Plan:
      Hide
      1. In a Site create a Rubric
      2. In the same site Create 2 entries in each tool that are associated with the same Rubric
        1. Discussions create 2 Topics graded with rubric
        2. Assignments create 2 Assignment graded with rubric
        3. Test & Quizes create 2 assessments grade with rubric
        4. Gradebook create 2 Grade Items with rubric
      3. 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

      Description

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

      • Rubric > the chosen rubric
      • tool > a sakai tool i.e. sakai.assignments
      • item > the resource in that tool i.e. "Week One"

      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);
      

        Gliffy Diagrams

          Zeplin

            Attachments

            1. 19x_student_gb.gif
              19x_student_gb.gif
              15 kB
            2. instructor_gb.gif
              instructor_gb.gif
              26 kB
            3. student_forums.gif
              student_forums.gif
              9 kB
            4. student_gb.gif
              student_gb.gif
              17 kB

              Issue Links

                Activity

                  People

                  Assignee:
                  a.fish@lancaster.ac.uk Adrian Fish
                  Reporter:
                  ern Earle R Nietzel
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration