[Summary view]

Differences Between: [Versions 310 and 311] [Versions 311 and 400] [Versions 311 and 401] [Versions 311 and 402] [Versions 311 and 403] [Versions 39 and 311]

   1  <?php
   2  // This file is part of Moodle - http://moodle.org/
   3  //
   4  // Moodle is free software: you can redistribute it and/or modify
   5  // it under the terms of the GNU General Public License as published by
   6  // the Free Software Foundation, either version 3 of the License, or
   7  // (at your option) any later version.
   8  //
   9  // Moodle is distributed in the hope that it will be useful,
  10  // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  // GNU General Public License for more details.
  13  //
  14  // You should have received a copy of the GNU General Public License
  15  // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
  16  
  17  /**
  18   * This file keeps track of upgrades to the recentlyaccesseditems block
  19   *
  20   * Sometimes, changes between versions involve alterations to database structures
  21   * and other major things that may break installations.
  22   *
  23   * The upgrade function in this file will attempt to perform all the necessary
  24   * actions to upgrade your older installation to the current version.
  25   *
  26   * If there's something it cannot do itself, it will tell you what you need to do.
  27   *
  28   * The commands in here will all be database-neutral, using the methods of
  29   * database_manager class
  30   *
  31   * Please do not forget to use upgrade_set_timeout()
  32   * before any action that may take longer time to finish.
  33   *
  34   * @package block_recentlyaccesseditems
  35   * @copyright 2019 Peter Dias
  36   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  37   */
  38  
  39  defined('MOODLE_INTERNAL') || die();
  40  
  41  /**
  42   * Upgrade the recentlyaccesseditems db table.
  43   *
  44   * @param $oldversion
  45   * @return bool
  46   */
  47  function xmldb_block_recentlyaccesseditems_upgrade($oldversion, $block) {
  48      global $DB;
  49  
  50      // Automatically generated Moodle v3.7.0 release upgrade line.
  51      // Put any upgrade step following this.
  52      if ($oldversion < 2019052001) {
  53          // Query the items to be deleted as a list of IDs. We cannot delete directly from this as a
  54          // subquery because MySQL does not support delete with subqueries.
  55          $fordeletion = $DB->get_fieldset_sql("
  56                  SELECT rai.id
  57                    FROM {block_recentlyaccesseditems} rai
  58               LEFT JOIN {course} c ON c.id = rai.courseid
  59               LEFT JOIN {course_modules} cm ON cm.id = rai.cmid
  60                   WHERE c.id IS NULL OR cm.id IS NULL");
  61  
  62          // Delete the array in chunks of 500 (Oracle does not support more than 1000 parameters,
  63          // let's leave some leeway, there are likely only one chunk anyway).
  64          $chunks = array_chunk($fordeletion, 500);
  65          foreach ($chunks as $chunk) {
  66              $DB->delete_records_list('block_recentlyaccesseditems', 'id', $chunk);
  67          }
  68  
  69          upgrade_block_savepoint(true, 2019052001, 'recentlyaccesseditems', false);
  70      }
  71  
  72      // Automatically generated Moodle v3.8.0 release upgrade line.
  73      // Put any upgrade step following this.
  74  
  75      // Automatically generated Moodle v3.9.0 release upgrade line.
  76      // Put any upgrade step following this.
  77  
  78      // Automatically generated Moodle v3.10.0 release upgrade line.
  79      // Put any upgrade step following this.
  80  
  81      // Automatically generated Moodle v3.11.0 release upgrade line.
  82      // Put any upgrade step following this.
  83  
  84      return true;
  85  }