lib/tests/datalib_update_with_unique_index_test.php

   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  * Tests for {@link decompose_update_into_safe_changes()} and
  19  * {@link update_field_with_unique_index()}.
  20  *
  21  * @package   core
  22  * @copyright 2014 The Open University
  23  * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  24  */
  25
  26 defined('MOODLE_INTERNAL') || die();
  27
  28
  29 /**
  30  * Tests for {@link decompose_update_into_safe_changes()} and
  31  * {@link update_field_with_unique_index()}.
  32  *
  33  * @copyright 2014 The Open University
  34  * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  35  */
  36 class datalib_update_with_unique_index_testcase extends advanced_testcase {
  37
  38     public function test_decompose_update_into_safe_changes_identity() {
  39         $this->assertEquals(array(), decompose_update_into_safe_changes(
  40                 array(1 => 1, 2 => 2), -1));
  41     }
  42
  43     public function test_decompose_update_into_safe_changes_no_overlap() {
  44         $this->assertEquals(array(array(1, 3), array(2, 4)), decompose_update_into_safe_changes(
  45                 array(1 => 3, 2 => 4), -1));
  46     }
  47
  48     public function test_decompose_update_into_safe_changes_shift() {
  49         $this->assertSame(array(array(3, 4), array(2, 3), array(1, 2)), decompose_update_into_safe_changes(
  50                 array(1 => 2, 2 => 3, 3 => 4), -1));
  51     }
  52
  53     public function test_decompose_decompose_update_into_safe_changes_simple_swap() {
  54         $this->assertEquals(array(array(1, -1), array(2, 1), array(-1, 2)), decompose_update_into_safe_changes(
  55                 array(1 => 2, 2 => 1), -1));
  56     }
  57
  58     public function test_decompose_update_into_safe_changes_cycle() {
  59         $this->assertEquals(array(array(1, -2), array(3, 1), array(2, 3), array(-2, 2)),
  60                 decompose_update_into_safe_changes(
  61                 array(1 => 2, 2 => 3 , 3 => 1), -2));
  62     }
  63
  64     public function test_decompose_update_into_safe_changes_complex() {
  65         $this->assertEquals(array(array(9, 10), array(8, 9),
  66                 array(1, -1), array(5, 1), array(7, 5), array(-1, 7),
  67                 array(4, -1), array(6, 4), array(-1, 6)), decompose_update_into_safe_changes(
  68                 array(1 => 7, 2 => 2, 3 => 3, 4 => 6, 5 => 1, 6 => 4, 7 => 5, 8 => 9, 9 => 10), -1));
  69     }
  70
  71     public function test_decompose_update_into_safe_changes_unused_value_id_used() {
  72         try {
  73             decompose_update_into_safe_changes(array(1 => 1), 1);
  74             $this->fail('Expected exception was not thrown');
  75         } catch (coding_exception $e) {
  76             $this->assertEquals('Supposedly unused value 1 is actually used!', $e->a);
  77         }
  78     }
  79
  80     public function test_decompose_update_into_safe_changes_string_values() {
  81         // Sometimes this happens when data has been loaded from the database.
  82         $this->assertEquals(array(array(1, -1), array(2, 1),
  83                     array(3, 2), array(4, 3), array(-1, 4)),
  84                 decompose_update_into_safe_changes(
  85                     array(1 => '4', 2 => '1', 3 => '2', 4 => '3'), -1));
  86     }
  87
  88     public function test_reorder_rows() {
  89         global $DB;
  90         $dbman = $DB->get_manager();
  91         $this->resetAfterTest();
  92
  93         $table = new xmldb_table('test_table');
  94         $table->setComment("This is a test'n drop table. You can drop it safely");
  95         $tablename = $table->getName();
  96
  97         $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
  98         $table->add_field('otherid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
  99         $table->add_field('sortorder', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
 100         $table->add_field('otherdata', XMLDB_TYPE_TEXT, 'big', null, null, null);
 101         $table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
 102         $table->add_key('unique', XMLDB_KEY_UNIQUE, array('otherid', 'sortorder'));
 103         $dbman->create_table($table);
 104
 105         // Rows intentionally added in a slightly 'random' order.
 106         // Note we are testing hat the otherid = 1 rows don't get messed up,
 107         // as well as testing that the otherid = 2 rows are updated correctly.
 108         $DB->insert_record($tablename, array('otherid' => 2, 'sortorder' => 1, 'otherdata' => 'To become 4'));
 109         $DB->insert_record($tablename, array('otherid' => 2, 'sortorder' => 2, 'otherdata' => 'To become 1'));
 110         $DB->insert_record($tablename, array('otherid' => 1, 'sortorder' => 1, 'otherdata' => 'Other 1'));
 111         $DB->insert_record($tablename, array('otherid' => 1, 'sortorder' => 2, 'otherdata' => 'Other 2'));
 112         $DB->insert_record($tablename, array('otherid' => 2, 'sortorder' => 3, 'otherdata' => 'To stay at 3'));
 113         $DB->insert_record($tablename, array('otherid' => 2, 'sortorder' => 4, 'otherdata' => 'To become 2'));
 114
 115         update_field_with_unique_index($tablename, 'sortorder',
 116                 array(1 => 4, 2 => 1, 3 => 3, 4 => 2), array('otherid' => 2));
 117
 118         $this->assertEquals(array(
 119                 3 => (object) array('id' => 3, 'otherid' => 1, 'sortorder' => 1, 'otherdata' => 'Other 1'),
 120                 4 => (object) array('id' => 4, 'otherid' => 1, 'sortorder' => 2, 'otherdata' => 'Other 2'),
 121             ), $DB->get_records($tablename, array('otherid' => 1), 'sortorder'));
 122         $this->assertEquals(array(
 123                 2 => (object) array('id' => 2, 'otherid' => 2, 'sortorder' => 1, 'otherdata' => 'To become 1'),
 124                 6 => (object) array('id' => 6, 'otherid' => 2, 'sortorder' => 2, 'otherdata' => 'To become 2'),
 125                 5 => (object) array('id' => 5, 'otherid' => 2, 'sortorder' => 3, 'otherdata' => 'To stay at 3'),
 126                 1 => (object) array('id' => 1, 'otherid' => 2, 'sortorder' => 4, 'otherdata' => 'To become 4'),
 127             ), $DB->get_records($tablename, array('otherid' => 2), 'sortorder'));
 128     }
 129 }