weekly release 2.7dev
[moodle.git] / question / engine / tests / datalib_test.php
CommitLineData
603bd001
PS
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 contains tests for some of the code in ../datalib.php.
19 *
20 * @package moodlecore
21 * @subpackage questionengine
22 * @copyright 2009 The Open University
23 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
24 */
25
26
27defined('MOODLE_INTERNAL') || die();
28
29global $CFG;
30require_once(dirname(__FILE__) . '/../lib.php');
31
32
33/**
34 * Unit tests for some of the code in ../datalib.php.
35 *
36 * @copyright 2009 The Open University
37 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
38 */
39class qubaid_condition_test extends advanced_testcase {
40
41 protected function normalize_sql($sql, $params) {
42 $newparams = array();
43 preg_match_all('/(?<!:):([a-z][a-z0-9_]*)/', $sql, $named_matches);
44 foreach($named_matches[1] as $param) {
45 if (array_key_exists($param, $params)) {
46 $newparams[] = $params[$param];
47 }
48 }
49 $newsql = preg_replace('/(?<!:):[a-z][a-z0-9_]*/', '?', $sql);
50 return array($newsql, $newparams);
51 }
52
53 protected function check_typical_question_attempts_query(
54 qubaid_condition $qubaids, $expectedsql, $expectedparams) {
55 $sql = "SELECT qa.id, qa.maxmark
56 FROM {$qubaids->from_question_attempts('qa')}
57 WHERE {$qubaids->where()} AND qa.slot = :slot";
58 $params = $qubaids->from_where_params();
59 $params['slot'] = 1;
60
61 // NOTE: parameter names may change thanks to $DB->inorequaluniqueindex, normal comparison is very wrong!!
62 list($sql, $params) = $this->normalize_sql($sql, $params);
63 list($expectedsql, $expectedparams) = $this->normalize_sql($expectedsql, $expectedparams);
64
65 $this->assertEquals($expectedsql, $sql);
66 $this->assertEquals($expectedparams, $params);
67 }
68
69 protected function check_typical_in_query(qubaid_condition $qubaids,
70 $expectedsql, $expectedparams) {
71 $sql = "SELECT qa.id, qa.maxmark
72 FROM {question_attempts} qa
73 WHERE qa.questionusageid {$qubaids->usage_id_in()}";
74
75 // NOTE: parameter names may change thanks to $DB->inorequaluniqueindex, normal comparison is very wrong!!
76 list($sql, $params) = $this->normalize_sql($sql, $qubaids->usage_id_in_params());
77 list($expectedsql, $expectedparams) = $this->normalize_sql($expectedsql, $expectedparams);
78
79 $this->assertEquals($expectedsql, $sql);
80 $this->assertEquals($expectedparams, $params);
81 }
82
83 public function test_qubaid_list_one_join() {
84 $qubaids = new qubaid_list(array(1));
85 $this->check_typical_question_attempts_query($qubaids,
86 "SELECT qa.id, qa.maxmark
87 FROM {question_attempts} qa
88 WHERE qa.questionusageid = :qubaid1 AND qa.slot = :slot",
89 array('qubaid1' => 1, 'slot' => 1));
90 }
91
92 public function test_qubaid_list_several_join() {
93 $qubaids = new qubaid_list(array(1, 3, 7));
94 $this->check_typical_question_attempts_query($qubaids,
95 "SELECT qa.id, qa.maxmark
96 FROM {question_attempts} qa
97 WHERE qa.questionusageid IN (:qubaid2,:qubaid3,:qubaid4) AND qa.slot = :slot",
98 array('qubaid2' => 1, 'qubaid3' => 3, 'qubaid4' => 7, 'slot' => 1));
99 }
100
101 public function test_qubaid_join() {
102 $qubaids = new qubaid_join("{other_table} ot", 'ot.usageid', 'ot.id = 1');
103
104 $this->check_typical_question_attempts_query($qubaids,
105 "SELECT qa.id, qa.maxmark
106 FROM {other_table} ot
107 JOIN {question_attempts} qa ON qa.questionusageid = ot.usageid
108 WHERE ot.id = 1 AND qa.slot = :slot", array('slot' => 1));
109 }
110
111 public function test_qubaid_join_no_where_join() {
112 $qubaids = new qubaid_join("{other_table} ot", 'ot.usageid');
113
114 $this->check_typical_question_attempts_query($qubaids,
115 "SELECT qa.id, qa.maxmark
116 FROM {other_table} ot
117 JOIN {question_attempts} qa ON qa.questionusageid = ot.usageid
118 WHERE 1 = 1 AND qa.slot = :slot", array('slot' => 1));
119 }
120
121 public function test_qubaid_list_one_in() {
122 global $CFG;
123 $qubaids = new qubaid_list(array(1));
124 $this->check_typical_in_query($qubaids,
125 "SELECT qa.id, qa.maxmark
126 FROM {question_attempts} qa
127 WHERE qa.questionusageid = :qubaid5", array('qubaid5' => 1));
128 }
129
130 public function test_qubaid_list_several_in() {
131 global $CFG;
132 $qubaids = new qubaid_list(array(1, 2, 3));
133 $this->check_typical_in_query($qubaids,
134 "SELECT qa.id, qa.maxmark
135 FROM {question_attempts} qa
136 WHERE qa.questionusageid IN (:qubaid6,:qubaid7,:qubaid8)",
137 array('qubaid6' => 1, 'qubaid7' => 2, 'qubaid8' => 3));
138 }
139
140 public function test_qubaid_join_in() {
141 global $CFG;
142 $qubaids = new qubaid_join("{other_table} ot", 'ot.usageid', 'ot.id = 1');
143
144 $this->check_typical_in_query($qubaids,
145 "SELECT qa.id, qa.maxmark
146 FROM {question_attempts} qa
147 WHERE qa.questionusageid IN (SELECT ot.usageid FROM {other_table} ot WHERE ot.id = 1)",
148 array());
149 }
150
151 public function test_qubaid_join_no_where_in() {
152 global $CFG;
153 $qubaids = new qubaid_join("{other_table} ot", 'ot.usageid');
154
155 $this->check_typical_in_query($qubaids,
156 "SELECT qa.id, qa.maxmark
157 FROM {question_attempts} qa
158 WHERE qa.questionusageid IN (SELECT ot.usageid FROM {other_table} ot WHERE 1 = 1)",
159 array());
160 }
161}