[Summary view]

Differences Between: [Versions 39 and 400] [Versions 39 and 402]

   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   * Task to cleanup old question statistics cache.
  19   *
  20   * @package    core
  21   * @copyright  2019 Simey Lameze <simey@moodle.com>
  22   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  23   */
  24  namespace core\task;
  25  
  26  defined('MOODLE_INTERNAL') || die();
  27  
  28  /**
  29   * A task to cleanup old question statistics cache.
  30   *
  31   * @copyright  2019 Simey Lameze <simey@moodle.com>
  32   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  33   */
  34  class question_stats_cleanup_task extends scheduled_task {
  35  
  36      /**
  37       * Get a descriptive name for this task (shown to admins).
  38       *
  39       * @return string
  40       */
  41      public function get_name() {
  42          return get_string('taskquestionstatscleanupcron', 'admin');
  43      }
  44  
  45      /**
  46       * Perform the cleanup task.
  47       */
  48      public function execute() {
  49          global $DB;
  50  
  51          mtrace("\n  Cleaning up old question statistics cache records...", '');
  52  
  53          $expiretime = time() - 5 * HOURSECS;
  54          $DB->delete_records_select('question_statistics', 'timemodified < ?', [$expiretime]);
  55          $responseanlysisids = $DB->get_records_select_menu('question_response_analysis',
  56              'timemodified < ?',
  57              [$expiretime],
  58              'id',
  59              'id, id AS id2');
  60          $DB->delete_records_list('question_response_analysis', 'id', $responseanlysisids);
  61          $DB->delete_records_list('question_response_count', 'analysisid', $responseanlysisids);
  62  
  63          mtrace('done.');
  64      }
  65  }