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

new script for checking of database schema

    XMLWordPrintable

Details

    • MOODLE_27_STABLE
    • MOODLE_28_STABLE
    • wip_MDL-45985_m28_dbschema
    • Hide

      1/ install moodle and run the new CLI script admin/cli/check_database_schema.php in all supported DBs - you should not get any errors

      • except for this one on oracle (it's a known issue MDL-32113):
        question_numerical_units
      • column 'multiplier' size is (38,20), expected (40,20) (N)

      2/ try db transfer experiment tool - no regressions expected
      3/ mess up your database - delete table and column, insert table and column, mess up column definitions and verify that the tool shows most the the changes (text field sizes are ignored, numbers may be bigger, floats are mostly ignored, etc.)

      Show
      1/ install moodle and run the new CLI script admin/cli/check_database_schema.php in all supported DBs - you should not get any errors except for this one on oracle (it's a known issue MDL-32113 ): question_numerical_units column 'multiplier' size is (38,20), expected (40,20) (N) 2/ try db transfer experiment tool - no regressions expected 3/ mess up your database - delete table and column, insert table and column, mess up column definitions and verify that the tool shows most the the changes (text field sizes are ignored, numbers may be bigger, floats are mostly ignored, etc.)

    Description

      At the moment the dbtransfer tool does some basic database schema checks before starting of the transfer/export. It would be useful for our Totara CI tools to be able to run full schema check regularly.

      Solution is to improve the database_manager->check_database_schema() and create a new cli script. It would also require new options in that method.

      Attachments

        Activity

          People

            skodak Petr Skoda
            skodak Petr Skoda
            Andrew Lyons Andrew Lyons
            Damyon Wiese Damyon Wiese
            Sam Hemelryk Sam Hemelryk
            David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              10/Nov/14