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

Update qtype_match tables to match the coding guidelines

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.5
    • 2.4.1
    • Questions
    • MOODLE_24_STABLE
    • MOODLE_25_STABLE
    • Hide

      You need to test all aspects of match questions.

      1. Create, edit and delete match questions.

      2. Preview a match question.

      3. Export match questions as Moodle XML, and re-import and check that all the options are correctly preserved.

      4. Backup and restore a course with match questions, and check that all the settings are correctly preserved.

      5. In a Moodle 2.0 install, create a quiz including some match questions. Attempt that quiz with some student accounts. Backup the course including user data, and restore it to your master install. Verify the question definitions and attempt data is transferred correctly.

      6. In am Moodle 1.9 install, create a quiz including some match questions. Back up that course, and restore it into your master install. Verify that the question definitions are transferred correctly.

      Show
      You need to test all aspects of match questions. 1. Create, edit and delete match questions. 2. Preview a match question. 3. Export match questions as Moodle XML, and re-import and check that all the options are correctly preserved. 4. Backup and restore a course with match questions, and check that all the settings are correctly preserved. 5. In a Moodle 2.0 install, create a quiz including some match questions. Attempt that quiz with some student accounts. Backup the course including user data, and restore it to your master install. Verify the question definitions and attempt data is transferred correctly. 6. In am Moodle 1.9 install, create a quiz including some match questions. Back up that course, and restore it into your master install. Verify that the question definitions are transferred correctly.

      • Rename table question_match -> qtype_match_options.
      • Rename table question_match_sub -> qtype_match_subquestions.
      • Rename column question -> questionid in both tables.
      • Since we have to drop and re-create the foreign key, make qtype_match_options.questionid a foreign-unique key.
      • Drop the unnecessary column qtype_match_options.subquestions.
      • Drop the unnecessary column qtype_match_subquestions.code.

            timhunt Tim Hunt
            timhunt Tim Hunt
            Frédéric Massart Frédéric Massart
            Dan Poltawski Dan Poltawski
            David Monllaó David Monllaó
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.