MDL-58596 core_stats: unit test for stats_get_base_weekly
[moodle.git] / lib / tests / statslib_test.php
CommitLineData
c0f00c5f
TB
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 ../statslib.php
19 *
d53111c0
PS
20 * @package core_stats
21 * @category phpunit
c0f00c5f
TB
22 * @copyright 2012 Tyler Bannister
23 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
24 */
25
26defined('MOODLE_INTERNAL') || die();
27
28global $CFG;
29require_once($CFG->libdir . '/adminlib.php');
30require_once($CFG->libdir . '/statslib.php');
613eebfc 31require_once($CFG->libdir . '/cronlib.php');
92927fba 32require_once(__DIR__ . '/fixtures/stats_events.php');
c0f00c5f
TB
33
34/**
d53111c0 35 * Test functions that affect daily stats.
c0f00c5f 36 */
d53111c0 37class core_statslib_testcase extends advanced_testcase {
c0f00c5f 38 /** The day to use for testing **/
67690cfa
TB
39 const DAY = 1272672000;
40
41 /** The timezone to use for testing **/
42 const TIMEZONE = 0;
c0f00c5f
TB
43
44 /** @var array The list of temporary tables created for the statistic calculations **/
45 protected $tables = array('temp_log1', 'temp_log2', 'temp_stats_daily', 'temp_stats_user_daily');
46
47 /** @var array The replacements to be used when loading XML files **/
48 protected $replacements = null;
49
c0f00c5f
TB
50
51 /**
52 * Setup function
53 * - Allow changes to CFG->debug for testing purposes.
54 */
55 protected function setUp() {
ba923f4f 56 global $CFG, $DB;
c0f00c5f
TB
57 parent::setUp();
58
d53111c0 59 // Settings to force statistic to run during testing.
d6e7a63d
PS
60 $this->setTimezone(self::TIMEZONE);
61 core_date::set_default_server_timezone();
c0f00c5f
TB
62 $CFG->statsfirstrun = 'all';
63 $CFG->statslastdaily = 0;
67690cfa 64
d53111c0 65 // Figure out the broken day start so I can figure out when to the start time should be.
67690cfa 66 $time = time();
d6e7a63d
PS
67 // This nonsense needs to be rewritten.
68 $date = new DateTime('now', core_date::get_server_timezone_object());
69 $offset = $date->getOffset();
67690cfa
TB
70 $stime = $time + $offset;
71 $stime = intval($stime / (60*60*24)) * 60*60*24;
72 $stime -= $offset;
73
74 $shour = intval(($time - $stime) / (60*60));
75
ba923f4f
EV
76 if ($DB->record_exists('user', array('username' => 'user1'))) {
77 return;
78 }
79
80 // Set up the database.
81 $datagen = self::getDataGenerator();
82
83 $user1 = $datagen->create_user(array('username'=>'user1'));
84 $user2 = $datagen->create_user(array('username'=>'user2'));
85
86 $course1 = $datagen->create_course(array('shortname'=>'course1'));
73f755a7 87 $datagen->enrol_user($user1->id, $course1->id);
ba923f4f
EV
88
89 $this->generate_replacement_list();
c0f00c5f 90
ba923f4f 91 // Reset between tests.
d53111c0 92 $this->resetAfterTest();
c0f00c5f
TB
93 }
94
95 /**
96 * Function to setup database.
97 *
98 * @param array $dataset An array of tables including the log table.
d53111c0 99 * @param array $tables
c0f00c5f
TB
100 */
101 protected function prepare_db($dataset, $tables) {
102 global $DB;
103
104 foreach ($tables as $tablename) {
105 $DB->delete_records($tablename);
106
107 foreach ($dataset as $name => $table) {
108
109 if ($tablename == $name) {
110
111 $rows = $table->getRowCount();
112
113 for ($i = 0; $i < $rows; $i++) {
114 $row = $table->getRow($i);
115
116 $DB->insert_record($tablename, $row, false, true);
117 }
118 }
119 }
120 }
121 }
122
123 /**
d53111c0 124 * Load dataset from XML file.
c0f00c5f
TB
125 */
126 protected function generate_replacement_list() {
127 global $CFG, $DB;
128
129 if ($this->replacements !== null) {
130 return;
131 }
132
d6e7a63d 133 $this->setTimezone(self::TIMEZONE);
67690cfa 134
c0f00c5f
TB
135 $guest = $DB->get_record('user', array('id' => $CFG->siteguest));
136 $user1 = $DB->get_record('user', array('username' => 'user1'));
137 $user2 = $DB->get_record('user', array('username' => 'user2'));
138
139 if (($guest === false) || ($user1 === false) || ($user2 === false)) {
140 trigger_error('User setup incomplete', E_USER_ERROR);
141 }
142
143 $site = $DB->get_record('course', array('id' => SITEID));
144 $course1 = $DB->get_record('course', array('shortname' => 'course1'));
145
146 if (($site === false) || ($course1 === false)) {
147 trigger_error('Course setup incomplete', E_USER_ERROR);
148 }
149
150 $start = stats_get_base_daily(self::DAY + 3600);
151 $startnolog = stats_get_base_daily(stats_get_start_from('daily'));
152 $gr = get_guest_role();
73f755a7 153 $studentrole = $DB->get_record('role', array('shortname' => 'student'));
c0f00c5f
TB
154
155 $this->replacements = array(
d53111c0
PS
156 // Start and end times.
157 '[start_0]' => $start - 14410, // 4 hours before.
158 '[start_1]' => $start + 14410, // 4 hours after.
c0f00c5f
TB
159 '[start_2]' => $start + 14420,
160 '[start_3]' => $start + 14430,
d53111c0 161 '[start_4]' => $start + 100800, // 28 hours after.
c0f00c5f
TB
162 '[end]' => stats_get_next_day_start($start),
163 '[end_no_logs]' => stats_get_next_day_start($startnolog),
164
d53111c0 165 // User ids.
c0f00c5f
TB
166 '[guest_id]' => $guest->id,
167 '[user1_id]' => $user1->id,
168 '[user2_id]' => $user2->id,
169
d53111c0 170 // Course ids.
c0f00c5f
TB
171 '[course1_id]' => $course1->id,
172 '[site_id]' => SITEID,
173
d53111c0 174 // Role ids.
c0f00c5f
TB
175 '[frontpage_roleid]' => (int) $CFG->defaultfrontpageroleid,
176 '[guest_roleid]' => $gr->id,
73f755a7 177 '[student_roleid]' => $studentrole->id,
c0f00c5f
TB
178 );
179 }
180
181 /**
d53111c0 182 * Load dataset from XML file.
c0f00c5f
TB
183 *
184 * @param string $file The name of the file to load
d53111c0 185 * @return array
c0f00c5f
TB
186 */
187 protected function load_xml_data_file($file) {
188 static $replacements = null;
189
190 $raw = $this->createXMLDataSet($file);
801a372d 191 $clean = new PHPUnit\DbUnit\DataSet\ReplacementDataSet($raw);
c0f00c5f
TB
192
193 foreach ($this->replacements as $placeholder => $value) {
194 $clean->addFullReplacement($placeholder, $value);
195 }
196
796e48a5 197 $logs = new PHPUnit\DbUnit\DataSet\Filter($clean);
c0f00c5f
TB
198 $logs->addIncludeTables(array('log'));
199
796e48a5 200 $stats = new PHPUnit\DbUnit\DataSet\Filter($clean);
c0f00c5f
TB
201 $stats->addIncludeTables(array('stats_daily', 'stats_user_daily'));
202
203 return array($logs, $stats);
204 }
205
206 /**
d53111c0 207 * Provides the log data for test_statslib_cron_daily.
ba923f4f
EV
208 *
209 * @return array of fixture XML log file names.
c0f00c5f
TB
210 */
211 public function daily_log_provider() {
ba923f4f
EV
212 $logfiles = array();
213 $fileno = array('00', '01', '02', '03', '04', '05', '06', '07', '08');
c0f00c5f 214
ba923f4f
EV
215 foreach ($fileno as $no) {
216 $logfiles[] = array("statslib-test{$no}.xml");
c0f00c5f
TB
217 }
218
ba923f4f 219 return $logfiles;
c0f00c5f
TB
220 }
221
5007d1cb
VDF
222 /**
223 * Set of data for test_statlibs_get_base_weekly
224 *
225 * @return array Dates and timezones for which the first day of the week will be calculated
226 */
227 public function get_base_weekly_provider() {
228 return [
229 [
230 "startwday" => 0,
231 "timezone" => 'America/Chicago',
232 "timestart" => '18-03-2017 22:00',
233 "expected" => '12-03-2017 00:00:00'
234 ],
235 [
236 "startwday" => 0,
237 "timezone" => 'America/Chicago',
238 "date" => '25-03-2017 22:00',
239 "expected" => '19-03-2017 00:00:00'
240 ],
241 [
242 "startwday" => 1,
243 "timezone" => 'Atlantic/Canary',
244 "date" => '06-08-2018 22:00',
245 "expected" => '06-08-2018 00:00:00'
246 ],
247 ];
248 }
249
c0f00c5f
TB
250 /**
251 * Compare the expected stats to those in the database.
252 *
d53111c0
PS
253 * @param array $expected
254 * @param string $output
c0f00c5f 255 */
12ccfc12 256 protected function verify_stats($expected, $output = '') {
c0f00c5f
TB
257 global $DB;
258
259 // Note: We can not use $this->assertDataSetEqual($expected, $actual) because there's no
260 // $this->getConnection() in advanced_testcase.
261
262 foreach ($expected as $type => $table) {
263 $records = $DB->get_records($type);
264
265 $rows = $table->getRowCount();
266
12ccfc12
TB
267 $message = 'Incorrect number of results returned for '. $type;
268
269 if ($output != '') {
270 $message .= "\nCron output:\n$output";
271 }
272
d53111c0 273 $this->assertCount($rows, $records, $message);
c0f00c5f
TB
274
275 for ($i = 0; $i < $rows; $i++) {
276 $row = $table->getRow($i);
277 $found = 0;
278
279 foreach ($records as $key => $record) {
280 $record = (array) $record;
281 unset($record['id']);
282 $diff = array_merge(array_diff_assoc($row, $record),
283 array_diff_assoc($record, $row));
284
285 if (empty($diff)) {
286 $found = $key;
287 break;
288 }
289 }
12ccfc12 290
c0f00c5f
TB
291 $this->assertGreaterThan(0, $found, 'Expected log '. var_export($row, true)
292 ." was not found in $type ". var_export($records, true));
293 unset($records[$found]);
294 }
295 }
296 }
297
298 /**
d53111c0 299 * Test progress output when debug is on.
c0f00c5f
TB
300 */
301 public function test_statslib_progress_debug() {
96f81ea3 302 set_debugging(DEBUG_ALL);
c0f00c5f
TB
303 $this->expectOutputString('1:0 ');
304 stats_progress('init');
305 stats_progress('1');
96f81ea3 306 $this->resetDebugging();
c0f00c5f
TB
307 }
308
309 /**
d53111c0 310 * Test progress output when debug is off.
c0f00c5f
TB
311 */
312 public function test_statslib_progress_no_debug() {
96f81ea3 313 set_debugging(DEBUG_NONE);
c0f00c5f
TB
314 $this->expectOutputString('.');
315 stats_progress('init');
316 stats_progress('1');
96f81ea3 317 $this->resetDebugging();
c0f00c5f
TB
318 }
319
320 /**
d53111c0 321 * Test the function that gets the start date from the config.
c0f00c5f
TB
322 */
323 public function test_statslib_get_start_from() {
324 global $CFG, $DB;
325
326 $dataset = $this->load_xml_data_file(__DIR__."/fixtures/statslib-test01.xml");
c0f00c5f
TB
327 $DB->delete_records('log');
328
d6e7a63d
PS
329 $date = new DateTime('now', core_date::get_server_timezone_object());
330 $day = self::DAY - $date->getOffset();
67690cfa 331
c0f00c5f
TB
332 $CFG->statsfirstrun = 'all';
333 // Allow 1 second difference in case we cross a second boundary.
594d66c2 334 // Note: within 3 days of a DST change - -3 days != 3 * 24 hours (it may be more or less).
f978c334 335 $this->assertLessThanOrEqual(1, stats_get_start_from('daily') - strtotime('-3 days', time()), 'All start time');
c0f00c5f
TB
336
337 $this->prepare_db($dataset[0], array('log'));
338 $records = $DB->get_records('log');
339
67690cfa 340 $this->assertEquals($day + 14410, stats_get_start_from('daily'), 'Log entry start');
c0f00c5f
TB
341
342 $CFG->statsfirstrun = 'none';
f978c334 343 $this->assertLessThanOrEqual(1, stats_get_start_from('daily') - strtotime('-3 days', time()), 'None start time');
c0f00c5f
TB
344
345 $CFG->statsfirstrun = 14515200;
f978c334 346 $this->assertLessThanOrEqual(1, stats_get_start_from('daily') - (time() - (14515200)), 'Specified start time');
c0f00c5f
TB
347
348 $this->prepare_db($dataset[1], array('stats_daily'));
f978c334 349 $this->assertEquals($day + DAYSECS, stats_get_start_from('daily'), 'Daily stats start time');
92927fba
350
351 // New log stores.
352 $this->preventResetByRollback();
353
354 $this->assertFileExists("$CFG->dirroot/$CFG->admin/tool/log/store/standard/version.php");
355 set_config('enabled_stores', 'logstore_standard', 'tool_log');
356 set_config('buffersize', 0, 'logstore_standard');
357 set_config('logguests', 1, 'logstore_standard');
358 get_log_manager(true);
359
360 $this->assertEquals(0, $DB->count_records('logstore_standard_log'));
361
362 $DB->delete_records('stats_daily');
363 $CFG->statsfirstrun = 'all';
364 $firstoldtime = $DB->get_field_sql('SELECT MIN(time) FROM {log}');
365
366 $this->assertEquals($firstoldtime, stats_get_start_from('daily'));
367
d504e920 368 $time = time() - 5;
92927fba 369 \core_tests\event\create_executed::create(array('context' => context_system::instance()))->trigger();
d504e920
AN
370 $DB->set_field('logstore_standard_log', 'timecreated', $time++, [
371 'eventname' => '\\core_tests\\event\\create_executed',
372 ]);
373
92927fba 374 \core_tests\event\read_executed::create(array('context' => context_system::instance()))->trigger();
d504e920
AN
375 $DB->set_field('logstore_standard_log', 'timecreated', $time++, [
376 'eventname' => '\\core_tests\\event\\read_executed',
377 ]);
378
92927fba 379 \core_tests\event\update_executed::create(array('context' => context_system::instance()))->trigger();
d504e920
AN
380 $DB->set_field('logstore_standard_log', 'timecreated', $time++, [
381 'eventname' => '\\core_tests\\event\\update_executed',
382 ]);
383
92927fba 384 \core_tests\event\delete_executed::create(array('context' => context_system::instance()))->trigger();
d504e920
AN
385 $DB->set_field('logstore_standard_log', 'timecreated', $time++, [
386 'eventname' => '\\core_tests\\event\\delete_executed',
387 ]);
92927fba 388
8dcb7ae6 389 $DB->set_field('logstore_standard_log', 'origin', 'web', array());
d504e920 390 $logs = $DB->get_records('logstore_standard_log', null, 'timecreated ASC');
92927fba
391 $this->assertCount(4, $logs);
392
393 $firstnew = reset($logs);
394 $this->assertGreaterThan($firstoldtime, $firstnew->timecreated);
395 $DB->set_field('logstore_standard_log', 'timecreated', 10, array('id' => $firstnew->id));
396 $this->assertEquals(10, stats_get_start_from('daily'));
397
398 $DB->set_field('logstore_standard_log', 'timecreated', $firstnew->timecreated, array('id' => $firstnew->id));
399 $DB->delete_records('log');
400 $this->assertEquals($firstnew->timecreated, stats_get_start_from('daily'));
401
402 set_config('enabled_stores', '', 'tool_log');
403 get_log_manager(true);
c0f00c5f
TB
404 }
405
406 /**
d53111c0 407 * Test the function that calculates the start of the day.
67690cfa
TB
408 *
409 * NOTE: I don't think this is the way this function should work.
410 * This test documents the current functionality.
c0f00c5f
TB
411 */
412 public function test_statslib_get_base_daily() {
413 global $CFG;
414
d6e7a63d
PS
415 for ($x = 0; $x < 13; $x += 1) {
416 $this->setTimezone($x);
67690cfa
TB
417
418 $start = 1272672000 - ($x * 3600);
419 if ($x >= 20) {
420 $start += (24 * 3600);
421 }
422
423 $this->assertEquals($start, stats_get_base_daily(1272686410), "Timezone $x check");
424 }
c0f00c5f
TB
425 }
426
427 /**
d53111c0 428 * Test the function that gets the start of the next day.
c0f00c5f
TB
429 */
430 public function test_statslib_get_next_day_start() {
d6e7a63d 431 $this->setTimezone(0);
c0f00c5f 432 $this->assertEquals(1272758400, stats_get_next_day_start(1272686410));
3b873397
AG
433
434 // Try setting timezone to some place in the US.
435 $this->setTimezone('America/New_York', 'America/New_York');
436 // Then set the time for midnight before daylight savings.
437 // 1425790800 is midnight in New York (2015-03-08) Daylight saving will occur in 2 hours time.
438 // 1425873600 is midnight the next day.
439 $this->assertEquals(1425873600, stats_get_next_day_start(1425790800));
440 $this->assertEquals(23, ((1425873600 - 1425790800) / 60 ) / 60);
441 // Then set the time for midnight before daylight savings ends.
442 // 1446350400 is midnight in New York (2015-11-01) Daylight saving will finish in 2 hours time.
443 // 1446440400 is midnight the next day.
444 $this->assertEquals(1446440400, stats_get_next_day_start(1446350400));
445 $this->assertEquals(25, ((1446440400 - 1446350400) / 60 ) / 60);
446 // The next day should be normal.
447 $this->assertEquals(1446526800, stats_get_next_day_start(1446440400));
448 $this->assertEquals(24, ((1446526800 - 1446440400) / 60 ) / 60);
c0f00c5f
TB
449 }
450
5007d1cb
VDF
451 /**
452 * Test the function that calculates the start of the week.
453 *
454 * @dataProvider get_base_weekly_provider
455 * @param int $startwday Day in which the week starts (Sunday = 0)
456 * @param string $timezone Default timezone
457 * @param string $timestart Date and time for which the first day of the week will be obtained
458 * @param string $expected Expected date of the first day of the week
459 */
460 public function test_statslib_get_base_weekly($startwday, $timezone, $timestart, $expected) {
461 $this->setTimezone($timezone);
462 $time = strtotime($timestart);
463 $expected = strtotime($expected);
464 set_config('calendar_startwday', $startwday);
465 set_config('statslastweekly', $time);
466
467 $weekstarttime = stats_get_base_weekly($time);
468
469 $this->assertEquals($expected, $weekstarttime);
470 }
471
c0f00c5f 472 /**
d53111c0 473 * Test the function that gets the action names.
c0f00c5f
TB
474 *
475 * Note: The function results depend on installed modules. The hard coded lists are the
476 * defaults for a new Moodle 2.3 install.
477 */
478 public function test_statslib_get_action_names() {
479 $basepostactions = array (
480 0 => 'add',
481 1 => 'delete',
482 2 => 'edit',
483 3 => 'add mod',
484 4 => 'delete mod',
485 5 => 'edit sectionenrol',
486 6 => 'loginas',
487 7 => 'new',
488 8 => 'unenrol',
489 9 => 'update',
490 10 => 'update mod',
491 11 => 'upload',
492 12 => 'submit',
493 13 => 'submit for grading',
494 14 => 'talk',
495 15 => 'choose',
496 16 => 'choose again',
497 17 => 'record delete',
498 18 => 'add discussion',
499 19 => 'add post',
500 20 => 'delete discussion',
501 21 => 'delete post',
502 22 => 'move discussion',
503 23 => 'prune post',
504 24 => 'update post',
505 25 => 'add category',
506 26 => 'add entry',
507 27 => 'approve entry',
508 28 => 'delete category',
509 29 => 'delete entry',
510 30 => 'edit category',
511 31 => 'update entry',
512 32 => 'end',
513 33 => 'start',
514 34 => 'attempt',
515 35 => 'close attempt',
516 36 => 'preview',
517 37 => 'editquestions',
518 38 => 'delete attempt',
519 39 => 'manualgrade',
520 );
521
522 $baseviewactions = array (
523 0 => 'view',
524 1 => 'view all',
525 2 => 'history',
526 3 => 'view submission',
527 4 => 'view feedback',
528 5 => 'print',
529 6 => 'report',
530 7 => 'view discussion',
531 8 => 'search',
532 9 => 'forum',
533 10 => 'forums',
534 11 => 'subscribers',
535 12 => 'view forum',
536 13 => 'view entry',
537 14 => 'review',
538 15 => 'pre-view',
539 16 => 'download',
540 17 => 'view form',
541 18 => 'view graph',
542 19 => 'view report',
543 );
544
545 $postactions = stats_get_action_names('post');
546
547 foreach ($basepostactions as $action) {
548 $this->assertContains($action, $postactions);
549 }
550
551 $viewactions = stats_get_action_names('view');
552
553 foreach ($baseviewactions as $action) {
554 $this->assertContains($action, $viewactions);
555 }
556 }
557
558 /**
559 * Test the temporary table creation and deletion.
560 */
561 public function test_statslib_temp_table_create_and_drop() {
562 global $DB;
563
564 foreach ($this->tables as $table) {
565 $this->assertFalse($DB->get_manager()->table_exists($table));
566 }
567
568 stats_temp_table_create();
569
570 foreach ($this->tables as $table) {
571 $this->assertTrue($DB->get_manager()->table_exists($table));
572 }
573
574 stats_temp_table_drop();
575
576 foreach ($this->tables as $table) {
577 $this->assertFalse($DB->get_manager()->table_exists($table));
578 }
579 }
580
581 /**
582 * Test the temporary table creation and deletion.
583 *
584 * @depends test_statslib_temp_table_create_and_drop
585 */
586 public function test_statslib_temp_table_fill() {
92927fba 587 global $CFG, $DB, $USER;
c0f00c5f
TB
588
589 $dataset = $this->load_xml_data_file(__DIR__."/fixtures/statslib-test09.xml");
590
591 $this->prepare_db($dataset[0], array('log'));
592
d6e7a63d
PS
593 // This nonsense needs to be rewritten.
594 $date = new DateTime('now', core_date::get_server_timezone_object());
595 $start = self::DAY - $date->getOffset();
67690cfa
TB
596 $end = $start + (24 * 3600);
597
c0f00c5f 598 stats_temp_table_create();
67690cfa 599 stats_temp_table_fill($start, $end);
c0f00c5f
TB
600
601 $this->assertEquals(1, $DB->count_records('temp_log1'));
602 $this->assertEquals(1, $DB->count_records('temp_log2'));
603
604 stats_temp_table_drop();
92927fba
605
606 // New log stores.
607 $this->preventResetByRollback();
608 stats_temp_table_create();
609
610 $course = $this->getDataGenerator()->create_course();
611 $context = context_course::instance($course->id);
612 $fcontext = context_course::instance(SITEID);
613 $user = $this->getDataGenerator()->create_user();
614 $this->setUser($user);
615
616 $this->assertFileExists("$CFG->dirroot/$CFG->admin/tool/log/store/standard/version.php");
617 set_config('enabled_stores', 'logstore_standard', 'tool_log');
618 set_config('buffersize', 0, 'logstore_standard');
619 set_config('logguests', 1, 'logstore_standard');
620 get_log_manager(true);
621
622 $DB->delete_records('logstore_standard_log');
623
624 \core_tests\event\create_executed::create(array('context' => $fcontext, 'courseid' => SITEID))->trigger();
625 \core_tests\event\read_executed::create(array('context' => $context, 'courseid' => $course->id))->trigger();
626 \core_tests\event\update_executed::create(array('context' => context_system::instance()))->trigger();
627 \core_tests\event\delete_executed::create(array('context' => context_system::instance()))->trigger();
628
629 \core\event\user_loggedin::create(
630 array(
631 'userid' => $USER->id,
632 'objectid' => $USER->id,
633 'other' => array('username' => $USER->username),
634 )
635 )->trigger();
636
637 $DB->set_field('logstore_standard_log', 'timecreated', 10);
638
639 $this->assertEquals(5, $DB->count_records('logstore_standard_log'));
640
641 \core_tests\event\delete_executed::create(array('context' => context_system::instance()))->trigger();
642 \core_tests\event\delete_executed::create(array('context' => context_system::instance()))->trigger();
643
8dcb7ae6
PS
644 // Fake the origin of events.
645 $DB->set_field('logstore_standard_log', 'origin', 'web', array());
646
92927fba
647 $this->assertEquals(7, $DB->count_records('logstore_standard_log'));
648
649 stats_temp_table_fill(9, 11);
650
651 $logs1 = $DB->get_records('temp_log1');
652 $logs2 = $DB->get_records('temp_log2');
653 $this->assertCount(5, $logs1);
654 $this->assertCount(5, $logs2);
655 // The order of records in the temp tables is not guaranteed...
656
657 $viewcount = 0;
658 $updatecount = 0;
659 $logincount = 0;
660 foreach ($logs1 as $log) {
661 if ($log->course == $course->id) {
662 $this->assertEquals('view', $log->action);
663 $viewcount++;
664 } else {
665 $this->assertTrue(in_array($log->action, array('update', 'login')));
666 if ($log->action === 'update') {
667 $updatecount++;
668 } else {
669 $logincount++;
670 }
671 $this->assertEquals(SITEID, $log->course);
672 }
673 $this->assertEquals($user->id, $log->userid);
674 }
675 $this->assertEquals(1, $viewcount);
676 $this->assertEquals(3, $updatecount);
677 $this->assertEquals(1, $logincount);
678
679 set_config('enabled_stores', '', 'tool_log');
680 get_log_manager(true);
681 stats_temp_table_drop();
c0f00c5f
TB
682 }
683
684 /**
685 * Test the temporary table creation and deletion.
686 *
687 * @depends test_statslib_temp_table_create_and_drop
688 */
689 public function test_statslib_temp_table_setup() {
690 global $DB;
691
692 $logs = array();
693 $this->prepare_db($logs, array('log'));
694
695 stats_temp_table_create();
696 stats_temp_table_setup();
697
698 $this->assertEquals(1, $DB->count_records('temp_enroled'));
699
700 stats_temp_table_drop();
701 }
702
703 /**
704 * Test the function that clean out the temporary tables.
705 *
706 * @depends test_statslib_temp_table_create_and_drop
707 */
708 public function test_statslib_temp_table_clean() {
709 global $DB;
710
711 $rows = array(
712 'temp_log1' => array('id' => 1, 'course' => 1),
713 'temp_log2' => array('id' => 1, 'course' => 1),
714 'temp_stats_daily' => array('id' => 1, 'courseid' => 1),
715 'temp_stats_user_daily' => array('id' => 1, 'courseid' => 1),
716 );
717
718 stats_temp_table_create();
719
720 foreach ($rows as $table => $row) {
721 $DB->insert_record_raw($table, $row);
722 $this->assertEquals(1, $DB->count_records($table));
723 }
724
725 stats_temp_table_clean();
726
727 foreach ($rows as $table => $row) {
728 $this->assertEquals(0, $DB->count_records($table));
729 }
730
731 $this->assertEquals(1, $DB->count_records('stats_daily'));
732 $this->assertEquals(1, $DB->count_records('stats_user_daily'));
733
734 stats_temp_table_drop();
735 }
736
737 /**
d53111c0 738 * Test the daily stats function.
c0f00c5f
TB
739 *
740 * @depends test_statslib_get_base_daily
741 * @depends test_statslib_get_next_day_start
67690cfa 742 * @depends test_statslib_get_start_from
c0f00c5f
TB
743 * @depends test_statslib_temp_table_create_and_drop
744 * @depends test_statslib_temp_table_setup
745 * @depends test_statslib_temp_table_fill
746 * @dataProvider daily_log_provider
747 */
ba923f4f 748 public function test_statslib_cron_daily($xmlfile) {
67690cfa 749 global $CFG, $DB;
c0f00c5f 750
ba923f4f
EV
751 $dataset = $this->load_xml_data_file(__DIR__."/fixtures/{$xmlfile}");
752
753 list($logs, $stats) = $dataset;
c0f00c5f
TB
754 $this->prepare_db($logs, array('log'));
755
756 // Stats cron daily uses mtrace, turn on buffering to silence output.
757 ob_start();
758 stats_cron_daily(1);
12ccfc12 759 $output = ob_get_contents();
c0f00c5f
TB
760 ob_end_clean();
761
12ccfc12 762 $this->verify_stats($stats, $output);
c0f00c5f
TB
763 }
764
765 /**
d53111c0
PS
766 * Test the daily stats function.
767 *
c0f00c5f
TB
768 * @depends test_statslib_get_base_daily
769 * @depends test_statslib_get_next_day_start
770 */
771 public function test_statslib_cron_daily_no_default_profile_id() {
772 global $CFG, $DB;
773 $CFG->defaultfrontpageroleid = 0;
774
775 $course1 = $DB->get_record('course', array('shortname' => 'course1'));
776 $guestid = $CFG->siteguest;
777 $start = stats_get_base_daily(1272758400);
778 $end = stats_get_next_day_start($start);
779 $fpid = (int) $CFG->defaultfrontpageroleid;
780 $gr = get_guest_role();
781
782 $dataset = $this->load_xml_data_file(__DIR__."/fixtures/statslib-test10.xml");
783
c0f00c5f
TB
784 $this->prepare_db($dataset[0], array('log'));
785
786 // Stats cron daily uses mtrace, turn on buffering to silence output.
787 ob_start();
788 stats_cron_daily($maxdays=1);
12ccfc12 789 $output = ob_get_contents();
c0f00c5f
TB
790 ob_end_clean();
791
12ccfc12 792 $this->verify_stats($dataset[1], $output);
c0f00c5f
TB
793 }
794}