[Summary view]

Differences Between: [Versions 310 and 311] [Versions 310 and 400] [Versions 310 and 401] [Versions 310 and 402] [Versions 310 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   * DML read/read-write database handle tests for mysqli_native_moodle_database
  19   *
  20   * @package    core
  21   * @category   dml
  22   * @copyright  2018 Srdjan Janković, Catalyst IT
  23   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  24   */
  25  
  26  defined('MOODLE_INTERNAL') || die();
  27  
  28  require_once (__DIR__.'/fixtures/read_slave_moodle_database_mock_mysqli.php');
  29  
  30  /**
  31   * DML mysqli_native_moodle_database read slave specific tests
  32   *
  33   * @package    core
  34   * @category   dml
  35   * @copyright  2018 Catalyst IT
  36   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  37   */
  38  class core_dml_mysqli_read_slave_testcase extends base_testcase {
  39      /**
  40       * Test readonly handle is not used for reading from special pg_*() call queries,
  41       * pg_try_advisory_lock and pg_advisory_unlock.
  42       *
  43       * @return void
  44       */
  45      public function test_lock() : void {
  46          $DB = new read_slave_moodle_database_mock_mysqli();
  47  
  48          $this->assertEquals(0, $DB->perf_get_reads_slave());
  49  
  50          $DB->query_start("SELECT GET_LOCK('lock',1)", null, SQL_QUERY_SELECT);
  51          $this->assertEquals('test_rw', $DB->get_db_handle());
  52          $DB->query_end(null);
  53          $this->assertEquals(0, $DB->perf_get_reads_slave());
  54  
  55          $DB->query_start("SELECT RELEASE_LOCK('lock',1)", null, SQL_QUERY_SELECT);
  56          $this->assertEquals('test_rw', $DB->get_db_handle());
  57          $DB->query_end(null);
  58          $this->assertEquals(0, $DB->perf_get_reads_slave());
  59      }
  60  
  61      /**
  62       * Test readonly connection failure with real mysqli connection
  63       *
  64       * @return void
  65       */
  66      public function test_real_readslave_connect_fail() : void {
  67          global $DB;
  68  
  69          if ($DB->get_dbfamily() != 'mysql') {
  70              $this->markTestSkipped("Not mysql");
  71          }
  72  
  73          // Open second connection.
  74          $cfg = $DB->export_dbconfig();
  75          if (!isset($cfg->dboptions)) {
  76              $cfg->dboptions = array();
  77          }
  78          $cfg->dboptions['readonly'] = [
  79              'instance' => ['host.that.is.not'],
  80              'connecttimeout' => 1
  81          ];
  82  
  83          $db2 = moodle_database::get_driver_instance($cfg->dbtype, $cfg->dblibrary);
  84          $db2->connect($cfg->dbhost, $cfg->dbuser, $cfg->dbpass, $cfg->dbname, $cfg->prefix, $cfg->dboptions);
  85          $this->assertTrue(count($db2->get_records('user')) > 0);
  86      }
  87  }