File size: 5,055 Bytes
bf8c0ce | 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 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 | <?php
/**
* Matomo - free/libre analytics platform
*
* @link https://matomo.org
* @license https://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*/
namespace Piwik\Tests\Integration;
use Piwik\Common;
use Piwik\Date;
use Piwik\Db;
use Piwik\DbHelper;
use Piwik\Option;
use Piwik\Segment;
use Piwik\Tests\Framework\TestCase\IntegrationTestCase;
use Piwik\Version;
/**
* @group Core
* @group DbHelper
*/
class DbHelperTest extends IntegrationTestCase
{
public function setUp(): void
{
parent::setUp();
DbHelper::dropDatabase('newdb; create database anotherdb;');
DbHelper::dropDatabase('testdb');
}
public function testTableExists()
{
$this->assertFalse(DbHelper::tableExists('foobar'));
$this->assertTrue(DbHelper::tableExists(Common::prefixTable('user_token_auth')));
$this->assertFalse(DbHelper::tableExists(Common::prefixTable('user_t%oke%n_auth')));
}
public function testGetInstallVersionIsCurrentVersion()
{
$this->assertSame(Version::VERSION, DbHelper::getInstallVersion());
}
public function testRecordInstallVersionSetsCurrentVersion()
{
Option::delete(Db\Schema\Mysql::OPTION_NAME_MATOMO_INSTALL_VERSION);
$this->assertEmpty(DbHelper::getInstallVersion());
$this->assertEquals('0', DbHelper::getInstallVersion()); // since php 8.1 this is required
DbHelper::recordInstallVersion();
$this->assertSame(Version::VERSION, DbHelper::getInstallVersion());
}
public function testRecordInstallVersionDoesNotOverwritePreviouslySetVersion()
{
$this->setInstallVersion('2.1.0');
DbHelper::recordInstallVersion();
DbHelper::recordInstallVersion();
DbHelper::recordInstallVersion();
$this->assertSame('2.1.0', DbHelper::getInstallVersion());
}
public function testWasMatomoInstalledBeforeVersionSameVersion()
{
$this->setInstallVersion('2.1.0');
$this->assertFalse(DbHelper::wasMatomoInstalledBeforeVersion('2.1.0'));
}
public function testWasMatomoInstalledBeforeVersionWhenUsedNewerVersion()
{
$this->setInstallVersion('2.1.0');
$this->assertFalse(DbHelper::wasMatomoInstalledBeforeVersion('2.0.0'));
}
public function testWasMatomoInstalledBeforeVersionWhenWasInstalledBeforeThatVersion()
{
$this->setInstallVersion('2.1.0');
$this->assertTrue(DbHelper::wasMatomoInstalledBeforeVersion('2.2.0'));
}
private function setInstallVersion($version)
{
Option::set(Db\Schema\Mysql::OPTION_NAME_MATOMO_INSTALL_VERSION, $version);
}
public function testCreateDatabaseEscapesInputProperly()
{
$dbName = 'newdb`; create database anotherdb;`';
DbHelper::createDatabase($dbName);
$this->assertDbExists($dbName);
$this->assertDbNotExists('anotherdb');
}
public function testDropDatabaseEscapesInputProperly()
{
DbHelper::createDatabase("testdb");
$this->assertDbExists('testdb');
DbHelper::dropDatabase('testdb`; create database anotherdb;`');
$this->assertDbExists('testdb');
$this->assertDbNotExists('anotherdb');
}
public function testAddOriginHintToQuery()
{
$expected = 'SELECT /* segmenthash 37d1b27c81afefbcf0961472b9abdb0f */ /* sites 1 */ /* 2022-01-01,2022-01-02 */ /* origin test */ idvisit FROM log_visit WHERE idvisit > 1 LIMIT 1';
$segment = new Segment('countryCode==fr', [1]);
$sql = "SELECT idvisit FROM " . Common::prefixTable('log_visit') . " WHERE idvisit > 1 LIMIT 1";
$startDate = Date::factory('2022-01-01 00:00:00');
$endDate = Date::factory('2022-01-02 23:59:59');
$sites = [1];
$result = DbHelper::addOriginHintToQuery($sql, 'origin test', $startDate, $endDate, $sites, $segment);
self::assertEquals($expected, $result);
}
public function testGetDefaultCollationForCharset(): void
{
$charset = 'utf8mb4';
$collation = DbHelper::getDefaultCollationForCharset($charset);
$expectedPrefix = $charset . '_';
// exact collation depends on the database used
// but should always start with the charset
self::assertStringStartsWith($expectedPrefix, $collation);
}
public function testGetDefaultCollationForCharsetWithoutDefault(): void
{
self::assertSame('', DbHelper::getDefaultCollationForCharset('invalid'));
}
private function assertDbExists($dbName)
{
$dbs = Db::fetchAll("SHOW DATABASES");
$dbs = array_column($dbs, 'Database');
self::assertTrue(in_array($this->cleanName($dbName), $dbs));
}
private function assertDbNotExists($dbName)
{
$dbs = Db::fetchAll("SHOW DATABASES");
$dbs = array_column($dbs, 'Database');
self::assertTrue(!in_array($this->cleanName($dbName), $dbs));
}
private function cleanName($dbName)
{
return str_replace('`', '', $dbName);
}
}
|