blob: 9626b7aceb5d05e9cc91491a9629af9fce76376c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
<?php
/**
* Piwik - Open source web analytics
*
* @link http://piwik.org
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*/
class TablePartitioningTest extends DatabaseTestCase
{
/**
* test no timestamp => exception
* @group Core
* @group TablePartitioning
*/
public function testNoTimestamp()
{
try {
$p = new Piwik_TablePartitioning_Monthly('testtable');
$p->getTableName();
} catch (Exception $e) {
return;
}
$this->fail('Expected exception not raised');
}
/**
* test table absent => create
* @group Core
* @group TablePartitioning
*/
public function testNoTable()
{
$tableName = 'archive_numeric';
$p = new Piwik_TablePartitioning_Monthly($tableName);
$timestamp = strtotime("10 September 2000");
$suffixShouldBe = "_2000_09";
$prefixTables = Piwik_Config::getInstance()->database['tables_prefix'];
$tablename = $prefixTables . $tableName . $suffixShouldBe;
$p->setTimestamp($timestamp);
$allTablesInstalled = Piwik::getTablesInstalled($forceReload = true);
$this->assertContains($tablename, $allTablesInstalled);
$this->assertEquals($tablename, $p->getTableName());
$this->assertEquals($tablename, (string)$p->__toString());
}
/**
* test monthly
* @group Core
* @group TablePartitioning
*/
public function testMonthlyPartition()
{
$tableName = 'archive_numeric';
$p = new Piwik_TablePartitioning_Monthly($tableName);
$timestamp = strtotime("10 September 2000");
$suffixShouldBe = "_2000_09";
$prefixTables = Piwik_Config::getInstance()->database['tables_prefix'];
$tablename = $prefixTables . $tableName . $suffixShouldBe;
$p->setTimestamp($timestamp);
$allTablesInstalled = Piwik::getTablesInstalled($forceReload = true);
$this->assertContains($tablename, $allTablesInstalled);
$this->assertEquals($tablename, $p->getTableName());
$this->assertEquals($tablename, (string)$p->__toString());
}
/**
* test daily
* @group Core
* @group TablePartitioning
*/
public function testDailyPartition()
{
$tableName = 'archive_numeric';
$p = new Piwik_TablePartitioning_Daily($tableName);
$timestamp = strtotime("10 September 2000");
$suffixShouldBe = "_2000_09_10";
$prefixTables = Piwik_Config::getInstance()->database['tables_prefix'];
$tablename = $prefixTables . $tableName . $suffixShouldBe;
$p->setTimestamp($timestamp);
$allTablesInstalled = Piwik::getTablesInstalled();
$this->assertContains($tablename, $allTablesInstalled);
$this->assertEquals($tablename, $p->getTableName());
$this->assertEquals($tablename, (string)$p->__toString());
}
}
|