mirror of
https://github.com/yiisoft/yii2.git
synced 2025-08-14 06:11:35 +08:00
120 lines
3.4 KiB
PHP
120 lines
3.4 KiB
PHP
<?php
|
|
/**
|
|
* @link https://www.yiiframework.com/
|
|
* @copyright Copyright (c) 2008 Yii Software LLC
|
|
* @license https://www.yiiframework.com/license/
|
|
*/
|
|
|
|
namespace yiiunit\framework\caching;
|
|
|
|
use yii\caching\DbCache;
|
|
use yii\db\Connection;
|
|
|
|
/**
|
|
* Class for testing file cache backend.
|
|
* @group db
|
|
* @group mssql
|
|
* @group caching
|
|
*/
|
|
class MssqlCacheTest extends CacheTestCase
|
|
{
|
|
private ?\yii\caching\DbCache $_cacheInstance = null;
|
|
private ?\yii\db\Connection $_connection = null;
|
|
|
|
protected function setUp(): void
|
|
{
|
|
if (!extension_loaded('pdo') || !extension_loaded('pdo_sqlsrv')) {
|
|
$this->markTestSkipped('pdo and pdo_mssql extensions are required.');
|
|
}
|
|
|
|
parent::setUp();
|
|
|
|
if ($this->getConnection()->getSchema()->getTableSchema('cache') !== null) {
|
|
$this->getConnection()->createCommand()->dropTable('cache')->execute();
|
|
}
|
|
$this->getConnection()->createCommand()->createTable('cache', [
|
|
'id' => 'VARCHAR(128) NOT NULL PRIMARY KEY',
|
|
'expire' => 'INT',
|
|
'data' => 'VARBINARY(MAX)',
|
|
])->execute();
|
|
|
|
}
|
|
|
|
/**
|
|
* @param bool $reset whether to clean up the test database
|
|
* @return \yii\db\Connection
|
|
*/
|
|
public function getConnection($reset = true)
|
|
{
|
|
if ($this->_connection === null) {
|
|
$databases = self::getParam('databases');
|
|
$params = $databases['sqlsrv'];
|
|
$db = new Connection();
|
|
$db->dsn = $params['dsn'];
|
|
$db->username = $params['username'];
|
|
$db->password = $params['password'];
|
|
if ($reset) {
|
|
$db->open();
|
|
$lines = explode(';', file_get_contents($params['fixture']));
|
|
foreach ($lines as $line) {
|
|
if (trim($line) !== '') {
|
|
$db->pdo->exec($line);
|
|
}
|
|
}
|
|
}
|
|
$this->_connection = $db;
|
|
}
|
|
|
|
return $this->_connection;
|
|
}
|
|
|
|
/**
|
|
* @return DbCache
|
|
*/
|
|
protected function getCacheInstance()
|
|
{
|
|
if ($this->_cacheInstance === null) {
|
|
$this->_cacheInstance = new DbCache(['db' => $this->getConnection()]);
|
|
}
|
|
return $this->_cacheInstance;
|
|
}
|
|
|
|
public function testExpire(): void
|
|
{
|
|
$cache = $this->getCacheInstance();
|
|
|
|
static::$time = \time();
|
|
$this->assertTrue($cache->set('expire_test', 'expire_test', 2));
|
|
static::$time++;
|
|
$this->assertEquals('expire_test', $cache->get('expire_test'));
|
|
static::$time++;
|
|
$this->assertFalse($cache->get('expire_test'));
|
|
}
|
|
|
|
public function testExpireAdd(): void
|
|
{
|
|
$cache = $this->getCacheInstance();
|
|
|
|
static::$time = \time();
|
|
$this->assertTrue($cache->add('expire_testa', 'expire_testa', 2));
|
|
static::$time++;
|
|
$this->assertEquals('expire_testa', $cache->get('expire_testa'));
|
|
static::$time++;
|
|
$this->assertFalse($cache->get('expire_testa'));
|
|
}
|
|
|
|
public function testSynchronousSetWithTheSameKey(): void
|
|
{
|
|
$KEY = 'sync-test-key';
|
|
$VALUE = 'sync-test-value';
|
|
|
|
$cache = $this->getCacheInstance();
|
|
static::$time = \time();
|
|
|
|
$this->assertTrue($cache->set($KEY, $VALUE, 60));
|
|
$this->assertTrue($cache->set($KEY, $VALUE, 60));
|
|
|
|
$this->assertEquals($VALUE, $cache->get($KEY));
|
|
}
|
|
}
|