Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 3.11.x will end 14 Nov 2022 (12 months plus 6 months extension).
  • Bug fixes for security issues in 3.11.x will end 13 Nov 2023 (18 months plus 12 months extension).
  • PHP version: minimum PHP 7.3.0 Note: minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is supported too.

Differences Between: [Versions 311 and 402] [Versions 311 and 403]

   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   * Native MariaDB class representing moodle database interface.
  19   *
  20   * @package    core_dml
  21   * @copyright  2013 Petr Skoda {@link http://skodak.org}
  22   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  23   */
  24  
  25  defined('MOODLE_INTERNAL') || die();
  26  
  27  require_once (__DIR__.'/moodle_database.php');
  28  require_once (__DIR__.'/mysqli_native_moodle_database.php');
  29  require_once (__DIR__.'/mysqli_native_moodle_recordset.php');
  30  require_once (__DIR__.'/mysqli_native_moodle_temptables.php');
  31  
  32  /**
  33   * Native MariaDB class representing moodle database interface.
  34   *
  35   * @package    core_dml
  36   * @copyright  2013 Petr Skoda {@link http://skodak.org}
  37   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  38   */
  39  class mariadb_native_moodle_database extends mysqli_native_moodle_database {
  40  
  41      /**
  42       * Returns localised database type name
  43       * Note: can be used before connect()
  44       * @return string
  45       */
  46      public function get_name() {
  47          return get_string('nativemariadb', 'install');
  48      }
  49  
  50      /**
  51       * Returns localised database configuration help.
  52       * Note: can be used before connect()
  53       * @return string
  54       */
  55      public function get_configuration_help() {
  56          return get_string('nativemariadbhelp', 'install');
  57      }
  58  
  59      /**
  60       * Returns the database vendor.
  61       * Note: can be used before connect()
  62       * @return string The db vendor name, usually the same as db family name.
  63       */
  64      public function get_dbvendor() {
  65          return 'mariadb';
  66      }
  67  
  68      /**
  69       * Returns more specific database driver type
  70       * Note: can be used before connect()
  71       * @return string db type mysqli, pgsql, oci, mssql, sqlsrv
  72       */
  73      protected function get_dbtype() {
  74          return 'mariadb';
  75      }
  76  
  77      /**
  78       * Returns database server info array
  79       * @return array Array containing 'description' and 'version' info
  80       */
  81      public function get_server_info() {
  82          $version = $this->mysqli->server_info;
  83          $matches = null;
  84          if (preg_match('/^5\.5\.5-(10\..+)-MariaDB/i', $version, $matches)) {
  85              // Looks like MariaDB decided to use these weird version numbers for better BC with MySQL...
  86              $version = $matches[1];
  87          }
  88          return array('description'=>$this->mysqli->server_info, 'version'=>$version);
  89      }
  90  
  91      protected function has_breaking_change_quoted_defaults() {
  92          $version = $this->get_server_info()['version'];
  93          // Breaking change since 10.2.7: MDEV-13132.
  94          return version_compare($version, '10.2.7', '>=');
  95      }
  96  
  97      public function has_breaking_change_sqlmode() {
  98          $version = $this->get_server_info()['version'];
  99          // Breaking change since 10.2.4: https://mariadb.com/kb/en/the-mariadb-library/sql-mode/#setting-sql_mode.
 100          return version_compare($version, '10.2.4', '>=');
 101      }
 102  
 103      /**
 104       * It is time to require transactions everywhere.
 105       *
 106       * MyISAM is NOT supported!
 107       *
 108       * @return bool
 109       */
 110      protected function transactions_supported() {
 111          if ($this->external) {
 112              return parent::transactions_supported();
 113          }
 114          return true;
 115      }
 116  
 117      /**
 118       * Does this mariadb instance support fulltext indexes?
 119       *
 120       * @return bool
 121       */
 122      public function is_fulltext_search_supported() {
 123          $info = $this->get_server_info();
 124  
 125          if (version_compare($info['version'], '10.0.5', '>=')) {
 126              return true;
 127          }
 128          return false;
 129      }
 130  }