Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-43749

Unpick quiz.questions DB column

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 2.6.1
    • 2.7
    • Quiz
    • MOODLE_26_STABLE
    • MOODLE_27_STABLE
    • Hide

      Note to testers: A lot of the code changed by this patch is going to be changed again as part of the epic MDL-40987, so really, too much detailed testing now is probably not the best use of your time.

      Note, on the order and paging tab, if you have a random question, clicking on the up or down arrows does not work. This is some sort of CSS bug, which will become irrelevant once MDL-40987 is done, so don't bother to report that.

      1. As teacher/admin, create a new course and add a quiz.
      2. On the edit quiz page, Edit quiz tab, make sure all the controls (icons, links and buttons) work. (Remember to expand the question bank.)
      3. Same, but on the Order & paging tab.
      4. When you finish checking all the buttons and icons, ensure you have left yourself with a working quiz, because you will need it for the next steps.
      5. Now preview the quiz.
      6. As student, attempt the quiz.
      7. Back as teacher/admin, have a quick look through all the quiz reports.
      8. Backup the course and restore it as a new course. Ensure that the quizzes have been transferred accurately.
      9. Get a backup including quizzesw with user data from a 2.6 site. Restore it, and ensure the quizzes have been restored accurately.
      10. Get a backup including quizzes with user data from a 2.0 site. Restore it, and ensure the quizzes have been restored accurately.
      11. Get a backup including quizzes from a 1.9 site. Restore it, and ensure the quizzes have been restored accurately. (1.9 restore cannot include user data.)

      For 10, you could use the backup file from MDL-44053, but I have already tested that.

      For 11, I used the backup attached tto MDL-27811.

      Show
      Note to testers: A lot of the code changed by this patch is going to be changed again as part of the epic MDL-40987 , so really, too much detailed testing now is probably not the best use of your time. Note, on the order and paging tab, if you have a random question, clicking on the up or down arrows does not work. This is some sort of CSS bug, which will become irrelevant once MDL-40987 is done, so don't bother to report that. 1. As teacher/admin, create a new course and add a quiz. 2. On the edit quiz page, Edit quiz tab, make sure all the controls (icons, links and buttons) work. (Remember to expand the question bank.) 3. Same, but on the Order & paging tab. 4. When you finish checking all the buttons and icons, ensure you have left yourself with a working quiz, because you will need it for the next steps. 5. Now preview the quiz. 6. As student, attempt the quiz. 7. Back as teacher/admin, have a quick look through all the quiz reports. 8. Backup the course and restore it as a new course. Ensure that the quizzes have been transferred accurately. 9. Get a backup including quizzesw with user data from a 2.6 site. Restore it, and ensure the quizzes have been restored accurately. 10. Get a backup including quizzes with user data from a 2.0 site. Restore it, and ensure the quizzes have been restored accurately. 11. Get a backup including quizzes from a 1.9 site. Restore it, and ensure the quizzes have been restored accurately. (1.9 restore cannot include user data.) For 10, you could use the backup file from MDL-44053 , but I have already tested that. For 11, I used the backup attached tto MDL-27811 .

    Description

      This is transform 2 of https://gist.github.com/timhunt/7342412

      TRANSFORM 2 - eliminate mdl_quiz.questions & rename question_instances -> slots
       
      mdl_quiz
      id SEQUENCE
      ...
      questionsperpage INT(10)
      navmethod CHAR(16) 'free' or 'seq'
      shufflequestions BOOL
      -
      ...
       
      *mdl_quiz_slots
      id SEQUENCE
      quizid INT(10) FK
      + slot INT(10) Similar to question_attempt.slot
      + page INT(10) All slots on a page must have consecutive numbers. Page numbers must be increasing.
      questionid INT(10) FK
      maxmark NUMBER(12.7) 
      

      Attachments

        Issue Links

          Activity

            People

              timhunt Tim Hunt
              timhunt Tim Hunt
              Eric Merrill Eric Merrill
              Dan Poltawski Dan Poltawski
              Rajesh Taneja Rajesh Taneja
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                12/May/14