DBTest - Code Metrics - Inspection of "Changed cache interface to be more in line to upco..." - aimeos/aimeos-core - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 815faa...197710 )

by Aimeos

created 2016-12-31 14:10 UTC

DBTest A

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	378
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	10

Importance

Changes

Metric	Value
dl	0
loc	378
rs	10
c	0
b	0
f	0
wmc	26
lcom	1
cbo	10

21 Methods

Rating	Name	Size	Complexity
B	setUpBeforeClass()	34	3
A	tearDownAfterClass()	12	2
A	setUp()	58	2
A	tearDown()	12	2
A	testConstructorNoConfig()	5	1
A	testConstructorNoSql()	8	1
A	testConstructorNoSearch()	8	1
A	testConstructorIncompleteSql()	8	1
A	testConstructorIncompleteSearch()	8	1
A	testCleanup()	12	1
A	testDelete()	18	1
A	testDeleteMultiple()	10	1
A	testDeleteByTags()	18	1
A	testClear()	17	1
A	testGet()	4	1
A	testGetExpired()	4	1
A	testGetMultiple()	4	1
A	testGetMultipleByTags()	4	1
B	testSet()	27	1
A	testSetMultiple()	53	1
A	testSetException()	5	1

<?php

/**
 * @license LGPLv3, http://opensource.org/licenses/LGPL-3.0
 * @copyright Metaways Infosystems GmbH, 2014
 * @copyright Aimeos (aimeos.org), 2015-2016
 */


namespace Aimeos\MW\Cache;


class DBTest extends \PHPUnit_Framework_TestCase
{
	private static $dbm;
	private $config;
	private $object;


	public static function setUpBeforeClass()
	{
		self::$dbm = \TestHelperMw::getDBManager();

		if( !( self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL ) ) {
			return;
		}

		$schema = new \Doctrine\DBAL\Schema\Schema();

		$cacheTable = $schema->createTable( 'mw_cache_test' );
		$cacheTable->addColumn( 'id', 'string', array( 'length' => 255 ) );
		$cacheTable->addColumn( 'siteid', 'integer', array( 'notnull' => false ) );
		$cacheTable->addColumn( 'expire', 'datetime', array( 'notnull' => false ) );
		$cacheTable->addColumn( 'value', 'text', array( 'length' => 0xffff ) );
		$cacheTable->addUniqueIndex( array( 'id', 'siteid' ) );
		$cacheTable->addIndex( array( 'expire' ) );

		$tagTable = $schema->createTable( 'mw_cache_tag_test' );
		$tagTable->addColumn( 'tid', 'string', array( 'length' => 255 ) );
		$tagTable->addColumn( 'tsiteid', 'integer', array( 'notnull' => false ) );
		$tagTable->addColumn( 'tname', 'string', array( 'length' => 255 ) );
		$tagTable->addUniqueIndex( array( 'tid', 'tsiteid', 'tname' ) );
		$tagTable->addForeignKeyConstraint( 'mw_cache_test', array( 'tid', 'tsiteid' ), array( 'id', 'siteid' ), array( 'onDelete' => 'CASCADE' ) );


		$conn = self::$dbm->acquire();

		foreach( $schema->toSQL( $conn->getRawObject()->getDatabasePlatform() ) as $sql ) {
			$conn->create( $sql )->execute()->finish();
		}

		self::$dbm->release( $conn );
	}


	public static function tearDownAfterClass()
	{
		if( self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL )
		{
			$conn = self::$dbm->acquire();

			$conn->create( 'DROP TABLE "mw_cache_tag_test"' )->execute()->finish();
			$conn->create( 'DROP TABLE "mw_cache_test"' )->execute()->finish();

			self::$dbm->release( $conn );
		}
	}


	protected function setUp()
	{
		if( !( self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL ) ) {
			$this->markTestSkipped( 'No DBAL database manager configured' );
		}


		$conn = self::$dbm->acquire();

		$sql = 'INSERT INTO "mw_cache_test" ("id", "siteid", "expire", "value") VALUES (\'t:1\', 1, NULL, \'test 1\')';
		$conn->create( $sql )->execute()->finish();

		$sql = 'INSERT INTO "mw_cache_test" ("id", "siteid", "expire", "value") VALUES (\'t:2\', 1, \'2000-01-01 00:00:00\', \'test 2\')';
		$conn->create( $sql )->execute()->finish();

		$sql = 'INSERT INTO "mw_cache_tag_test" ("tid", "tsiteid", "tname") VALUES (\'t:1\', 1, \'tag:1\')';
		$conn->create( $sql )->execute()->finish();

		self::$dbm->release( $conn );


		$this->config = array( 'siteid' => 1 );

		$this->config['search'] = array(
			'cache.id' => array( 'label' => 'Cache ID', 'code' => 'cache.id', 'internalcode' => 'id', 'type' => 'string', 'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_STR ),
			'cache.siteid' => array( 'label' => 'Cache site ID', 'code' => 'cache.siteid', 'internalcode' => 'siteid', 'type' => 'integer', 'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_INT ),
			'cache.value' => array( 'label' => 'Cached value', 'code' => 'cache.value', 'internalcode' => 'value', 'type' => 'string', 'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_STR ),
			'cache.expire' => array( 'label' => 'Cache expiration date', 'code' => 'cache.expire', 'internalcode' => 'expire', 'type' => 'datetime', 'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_STR ),
			'cache.tag.name' => array( 'label' => 'Cache tag name', 'code' => 'cache.tag.name', 'internalcode' => 'tname', 'type' => 'string', 'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_STR ),
		);

		$this->config['sql'] = array(
			'delete' => '
				DELETE FROM "mw_cache_test" WHERE "siteid" = ? AND :cond
			',
			'deletebytag' => '
				DELETE FROM "mw_cache_test" WHERE "siteid" = ? AND id IN (
					SELECT "tid" FROM "mw_cache_tag_test" WHERE "tsiteid" = ? AND :cond
				)
			',
			'get' => '
				SELECT "id", "value", "expire" FROM "mw_cache_test" WHERE "siteid" = ? AND :cond
			',
			'getbytag' => '
				SELECT "id", "value", "expire" FROM "mw_cache_test"
				JOIN "mw_cache_tag_test" ON "tid" = "id"
				WHERE siteid = ? AND tsiteid = ? AND :cond
			',
			'set' => '
				INSERT INTO "mw_cache_test" ( "id", "siteid", "expire", "value" ) VALUES ( ?, ?, ?, ? )
			',
			'settag' => '
				INSERT INTO "mw_cache_tag_test" ( "tid", "tsiteid", "tname" ) VALUES ( ?, ?, ? )
			',
		);

		$this->object = new \Aimeos\MW\Cache\DB( $this->config, self::$dbm );
	}


	public function tearDown()
	{
		if( self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL )
		{
			$conn = self::$dbm->acquire();

			$conn->create( 'DELETE FROM "mw_cache_tag_test"' )->execute()->finish();
			$conn->create( 'DELETE FROM "mw_cache_test"' )->execute()->finish();

			self::$dbm->release( $conn );
		}
	}


	public function testConstructorNoConfig()
	{
		$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
		new \Aimeos\MW\Cache\DB( array(), self::$dbm );
	}


	public function testConstructorNoSql()
	{
		$config = $this->config;
		unset( $config['sql'] );

		$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
		new \Aimeos\MW\Cache\DB( $config, self::$dbm );
	}


	public function testConstructorNoSearch()
	{
		$config = $this->config;
		unset( $config['search'] );

		$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
		new \Aimeos\MW\Cache\DB( $config, self::$dbm );
	}


	public function testConstructorIncompleteSql()
	{
		$config = $this->config;
		unset( $config['sql']['delete'] );

		$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
		new \Aimeos\MW\Cache\DB( $config, self::$dbm );
	}


	public function testConstructorIncompleteSearch()
	{
		$config = $this->config;
		unset( $config['search']['cache.id'] );

		$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
		new \Aimeos\MW\Cache\DB( $config, self::$dbm );
	}


	public function testCleanup()
	{
		$this->object->cleanup();


		$conn = self::$dbm->acquire();
		$result = $conn->create( 'SELECT "id" FROM "mw_cache_test"' )->execute();
		self::$dbm->release( $conn );

		$this->assertEquals( array( 'id' => 't:1' ), $result->fetch() );
		$this->assertFalse( $result->fetch() );
	}


	public function testDelete()
	{
		$this->object->delete( 't:1' );

		$conn = self::$dbm->acquire();
		$row = $conn->create( 'SELECT * FROM "mw_cache_tag_test"' )->execute()->fetch();
		self::$dbm->release( $conn );

		$this->assertFalse( $row );


		$conn = self::$dbm->acquire();
		$result = $conn->create( 'SELECT "id" FROM "mw_cache_test"' )->execute();
		self::$dbm->release( $conn );

		$this->assertEquals( array( 'id' => 't:2' ), $result->fetch() );
		$this->assertFalse( $result->fetch() );
	}


	public function testDeleteMultiple()
	{
		$this->object->deleteMultiple( array( 't:1', 't:2' ) );
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);

		$conn = self::$dbm->acquire();
		$row = $conn->create( 'SELECT * FROM "mw_cache_test"' )->execute()->fetch();
		self::$dbm->release( $conn );

		$this->assertFalse( $row );
	}


	public function testDeleteByTags()
	{
		$this->object->deleteByTags( array( 'tag:1' ) );

		$conn = self::$dbm->acquire();
		$row = $conn->create( 'SELECT * FROM "mw_cache_tag_test"' )->execute()->fetch();
		self::$dbm->release( $conn );

		$this->assertFalse( $row );


		$conn = self::$dbm->acquire();
		$result = $conn->create( 'SELECT "id" FROM "mw_cache_test"' )->execute();
		self::$dbm->release( $conn );

		$this->assertEquals( array( 'id' => 't:2' ), $result->fetch() );
		$this->assertFalse( $result->fetch() );
	}


	public function testClear()
	{
		$this->object->clear();

		$conn = self::$dbm->acquire();
		$row = $conn->create( 'SELECT * FROM "mw_cache_tag_test"' )->execute()->fetch();
		self::$dbm->release( $conn );

		$this->assertFalse( $row );


		$conn = self::$dbm->acquire();
		$row = $conn->create( 'SELECT "id" FROM "mw_cache_test"' )->execute()->fetch();
		self::$dbm->release( $conn );

		$this->assertFalse( $row );
	}


	public function testGet()
	{
		$this->assertEquals( 'test 1', $this->object->get( 't:1' ) );
	}


	public function testGetExpired()
	{
		$this->assertEquals( null, $this->object->get( 't:2' ) );
	}


	public function testGetMultiple()
	{
		$this->assertEquals( array( 't:1' => 'test 1', 't:2' => null ), $this->object->getMultiple( array( 't:1', 't:2' ) ) );
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
	}


	public function testGetMultipleByTags()
	{
		$this->assertEquals( array( 't:1' => 'test 1' ), $this->object->getMultipleByTags( array( 'tag:1' ) ) );
	}


	public function testSet()
	{
		$this->object->set( 't:3', 'test 3', '2100-01-01 00:00:00', array( 'tag:2', 'tag:3' ) );


		$conn = self::$dbm->acquire();
		$result = $conn->create( 'SELECT "tname" FROM "mw_cache_tag_test" WHERE "tid" = \'t:3\' ORDER BY "tname"' )->execute();
		self::$dbm->release( $conn );

		$this->assertEquals( array( 'tname' => 'tag:2' ), $result->fetch() );
		$this->assertEquals( array( 'tname' => 'tag:3' ), $result->fetch() );
		$this->assertFalse( $result->fetch() );


		$conn = self::$dbm->acquire();
		$result = $conn->create( 'SELECT * FROM "mw_cache_test" WHERE "id" = \'t:3\'' )->execute();
		self::$dbm->release( $conn );

		$expected = array(
			'expire' => '2100-01-01 00:00:00',
			'id' => 't:3',
			'siteid' => 1,
			'value' => 'test 3',
		);
		$this->assertEquals( $expected, $result->fetch() );
		$this->assertFalse( $result->fetch() );
	}


	public function testSetMultiple()
	{
		$pairs = array( 't:3' => 'test 3', 't:2' => 'test 4' );
		$tags = array( 't:3' => array( 'tag:2', 'tag:3' ), 't:2' => array( 'tag:4' ) );
		$expires = array( 't:3' => '2100-01-01 00:00:00' );

		$this->object->setMultiple( $pairs, $expires, $tags );
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);


		$conn = self::$dbm->acquire();
		$result = $conn->create( 'SELECT "tname" FROM "mw_cache_tag_test" WHERE "tid" = \'t:3\' ORDER BY "tname"' )->execute();
		self::$dbm->release( $conn );

		$this->assertEquals( array( 'tname' => 'tag:2' ), $result->fetch() );
		$this->assertEquals( array( 'tname' => 'tag:3' ), $result->fetch() );
		$this->assertFalse( $result->fetch() );


		$conn = self::$dbm->acquire();
		$result = $conn->create( 'SELECT "tname" FROM "mw_cache_tag_test" WHERE "tid" = \'t:2\'' )->execute();
		self::$dbm->release( $conn );

		$this->assertEquals( array( 'tname' => 'tag:4' ), $result->fetch() );
		$this->assertFalse( $result->fetch() );


		$conn = self::$dbm->acquire();
		$result = $conn->create( 'SELECT * FROM "mw_cache_test" WHERE "id" = \'t:3\'' )->execute();
		self::$dbm->release( $conn );

		$expected = array(
			'expire' => '2100-01-01 00:00:00',
			'id' => 't:3',
			'siteid' => 1,
			'value' => 'test 3',
		);
		$this->assertEquals( $expected, $result->fetch() );
		$this->assertFalse( $result->fetch() );


		$conn = self::$dbm->acquire();
		$result = $conn->create( 'SELECT * FROM "mw_cache_test" WHERE "id" = \'t:2\'' )->execute();
		self::$dbm->release( $conn );

		$expected = array(
			'expire' => null,
			'id' => 't:2',
			'siteid' => 1,
			'value' => 'test 4',
		);
		$this->assertEquals( $expected, $result->fetch() );
		$this->assertFalse( $result->fetch() );
	}


	public function testSetException()
	{
		$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
		$this->object->set( array(), '' );
	}

}


1			<?php
2
3			/**
4			* @license LGPLv3, http://opensource.org/licenses/LGPL-3.0
5			* @copyright Metaways Infosystems GmbH, 2014
6			* @copyright Aimeos (aimeos.org), 2015-2016
7			*/
8
9
10			namespace Aimeos\MW\Cache;
11
12
13			class DBTest extends \PHPUnit_Framework_TestCase
14			{
15			private static $dbm;
16			private $config;
17			private $object;
18
19
20			public static function setUpBeforeClass()
21			{
22			self::$dbm = \TestHelperMw::getDBManager();
23
24			if( !( self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL ) ) {
25			return;
26			}
27
28			$schema = new \Doctrine\DBAL\Schema\Schema();
29
30			$cacheTable = $schema->createTable( 'mw_cache_test' );
31			$cacheTable->addColumn( 'id', 'string', array( 'length' => 255 ) );
32			$cacheTable->addColumn( 'siteid', 'integer', array( 'notnull' => false ) );
33			$cacheTable->addColumn( 'expire', 'datetime', array( 'notnull' => false ) );
34			$cacheTable->addColumn( 'value', 'text', array( 'length' => 0xffff ) );
35			$cacheTable->addUniqueIndex( array( 'id', 'siteid' ) );
36			$cacheTable->addIndex( array( 'expire' ) );
37
38			$tagTable = $schema->createTable( 'mw_cache_tag_test' );
39			$tagTable->addColumn( 'tid', 'string', array( 'length' => 255 ) );
40			$tagTable->addColumn( 'tsiteid', 'integer', array( 'notnull' => false ) );
41			$tagTable->addColumn( 'tname', 'string', array( 'length' => 255 ) );
42			$tagTable->addUniqueIndex( array( 'tid', 'tsiteid', 'tname' ) );
43			$tagTable->addForeignKeyConstraint( 'mw_cache_test', array( 'tid', 'tsiteid' ), array( 'id', 'siteid' ), array( 'onDelete' => 'CASCADE' ) );
44
45
46			$conn = self::$dbm->acquire();
47
48			foreach( $schema->toSQL( $conn->getRawObject()->getDatabasePlatform() ) as $sql ) {
49			$conn->create( $sql )->execute()->finish();
50			}
51
52			self::$dbm->release( $conn );
53			}
54
55
56			public static function tearDownAfterClass()
57			{
58			if( self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL )
59			{
60			$conn = self::$dbm->acquire();
61
62			$conn->create( 'DROP TABLE "mw_cache_tag_test"' )->execute()->finish();
63			$conn->create( 'DROP TABLE "mw_cache_test"' )->execute()->finish();
64
65			self::$dbm->release( $conn );
66			}
67			}
68
69
70			protected function setUp()
71			{
72			if( !( self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL ) ) {
73			$this->markTestSkipped( 'No DBAL database manager configured' );
74			}
75
76
77			$conn = self::$dbm->acquire();
78
79			$sql = 'INSERT INTO "mw_cache_test" ("id", "siteid", "expire", "value") VALUES (\'t:1\', 1, NULL, \'test 1\')';
80			$conn->create( $sql )->execute()->finish();
81
82			$sql = 'INSERT INTO "mw_cache_test" ("id", "siteid", "expire", "value") VALUES (\'t:2\', 1, \'2000-01-01 00:00:00\', \'test 2\')';
83			$conn->create( $sql )->execute()->finish();
84
85			$sql = 'INSERT INTO "mw_cache_tag_test" ("tid", "tsiteid", "tname") VALUES (\'t:1\', 1, \'tag:1\')';
86			$conn->create( $sql )->execute()->finish();
87
88			self::$dbm->release( $conn );
89
90
91			$this->config = array( 'siteid' => 1 );
92
93			$this->config['search'] = array(
94			'cache.id' => array( 'label' => 'Cache ID', 'code' => 'cache.id', 'internalcode' => 'id', 'type' => 'string', 'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_STR ),
95			'cache.siteid' => array( 'label' => 'Cache site ID', 'code' => 'cache.siteid', 'internalcode' => 'siteid', 'type' => 'integer', 'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_INT ),
96			'cache.value' => array( 'label' => 'Cached value', 'code' => 'cache.value', 'internalcode' => 'value', 'type' => 'string', 'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_STR ),
97			'cache.expire' => array( 'label' => 'Cache expiration date', 'code' => 'cache.expire', 'internalcode' => 'expire', 'type' => 'datetime', 'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_STR ),
98			'cache.tag.name' => array( 'label' => 'Cache tag name', 'code' => 'cache.tag.name', 'internalcode' => 'tname', 'type' => 'string', 'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_STR ),
99			);
100
101			$this->config['sql'] = array(
102			'delete' => '
103			DELETE FROM "mw_cache_test" WHERE "siteid" = ? AND :cond
104			',
105			'deletebytag' => '
106			DELETE FROM "mw_cache_test" WHERE "siteid" = ? AND id IN (
107			SELECT "tid" FROM "mw_cache_tag_test" WHERE "tsiteid" = ? AND :cond
108			)
109			',
110			'get' => '
111			SELECT "id", "value", "expire" FROM "mw_cache_test" WHERE "siteid" = ? AND :cond
112			',
113			'getbytag' => '
114			SELECT "id", "value", "expire" FROM "mw_cache_test"
115			JOIN "mw_cache_tag_test" ON "tid" = "id"
116			WHERE siteid = ? AND tsiteid = ? AND :cond
117			',
118			'set' => '
119			INSERT INTO "mw_cache_test" ( "id", "siteid", "expire", "value" ) VALUES ( ?, ?, ?, ? )
120			',
121			'settag' => '
122			INSERT INTO "mw_cache_tag_test" ( "tid", "tsiteid", "tname" ) VALUES ( ?, ?, ? )
123			',
124			);
125
126			$this->object = new \Aimeos\MW\Cache\DB( $this->config, self::$dbm );
127			}
128
129
130			public function tearDown()
131			{
132			if( self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL )
133			{
134			$conn = self::$dbm->acquire();
135
136			$conn->create( 'DELETE FROM "mw_cache_tag_test"' )->execute()->finish();
137			$conn->create( 'DELETE FROM "mw_cache_test"' )->execute()->finish();
138
139			self::$dbm->release( $conn );
140			}
141			}
142
143
144			public function testConstructorNoConfig()
145			{
146			$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
147			new \Aimeos\MW\Cache\DB( array(), self::$dbm );
148			}
149
150
151			public function testConstructorNoSql()
152			{
153			$config = $this->config;
154			unset( $config['sql'] );
155
156			$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
157			new \Aimeos\MW\Cache\DB( $config, self::$dbm );
158			}
159
160
161			public function testConstructorNoSearch()
162			{
163			$config = $this->config;
164			unset( $config['search'] );
165
166			$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
167			new \Aimeos\MW\Cache\DB( $config, self::$dbm );
168			}
169
170
171			public function testConstructorIncompleteSql()
172			{
173			$config = $this->config;
174			unset( $config['sql']['delete'] );
175
176			$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
177			new \Aimeos\MW\Cache\DB( $config, self::$dbm );
178			}
179
180
181			public function testConstructorIncompleteSearch()
182			{
183			$config = $this->config;
184			unset( $config['search']['cache.id'] );
185
186			$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
187			new \Aimeos\MW\Cache\DB( $config, self::$dbm );
188			}
189
190
191			public function testCleanup()
192			{
193			$this->object->cleanup();
194
195
196			$conn = self::$dbm->acquire();
197			$result = $conn->create( 'SELECT "id" FROM "mw_cache_test"' )->execute();
198			self::$dbm->release( $conn );
199
200			$this->assertEquals( array( 'id' => 't:1' ), $result->fetch() );
201			$this->assertFalse( $result->fetch() );
202			}
203
204
205			public function testDelete()
206			{
207			$this->object->delete( 't:1' );
208
209			$conn = self::$dbm->acquire();
210			$row = $conn->create( 'SELECT * FROM "mw_cache_tag_test"' )->execute()->fetch();
211			self::$dbm->release( $conn );
212
213			$this->assertFalse( $row );
214
215
216			$conn = self::$dbm->acquire();
217			$result = $conn->create( 'SELECT "id" FROM "mw_cache_test"' )->execute();
218			self::$dbm->release( $conn );
219
220			$this->assertEquals( array( 'id' => 't:2' ), $result->fetch() );
221			$this->assertFalse( $result->fetch() );
222			}
223
224
225			public function testDeleteMultiple()
226			{
227			$this->object->deleteMultiple( array( 't:1', 't:2' ) );
			0 ignored issues – show Documentation introduced 2016-12-31 14:18 UTC by Report Bug Copy Issue Report `array('t:1', 't:2')` is of type `array<integer,string,{"0":"string","1":"string"}>`, but the function expects a `object<Aimeos\MW\Cache\iterable>`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
228
229			$conn = self::$dbm->acquire();
230			$row = $conn->create( 'SELECT * FROM "mw_cache_test"' )->execute()->fetch();
231			self::$dbm->release( $conn );
232
233			$this->assertFalse( $row );
234			}
235
236
237			public function testDeleteByTags()
238			{
239			$this->object->deleteByTags( array( 'tag:1' ) );
240
241			$conn = self::$dbm->acquire();
242			$row = $conn->create( 'SELECT * FROM "mw_cache_tag_test"' )->execute()->fetch();
243			self::$dbm->release( $conn );
244
245			$this->assertFalse( $row );
246
247
248			$conn = self::$dbm->acquire();
249			$result = $conn->create( 'SELECT "id" FROM "mw_cache_test"' )->execute();
250			self::$dbm->release( $conn );
251
252			$this->assertEquals( array( 'id' => 't:2' ), $result->fetch() );
253			$this->assertFalse( $result->fetch() );
254			}
255
256
257			public function testClear()
258			{
259			$this->object->clear();
260
261			$conn = self::$dbm->acquire();
262			$row = $conn->create( 'SELECT * FROM "mw_cache_tag_test"' )->execute()->fetch();
263			self::$dbm->release( $conn );
264
265			$this->assertFalse( $row );
266
267
268			$conn = self::$dbm->acquire();
269			$row = $conn->create( 'SELECT "id" FROM "mw_cache_test"' )->execute()->fetch();
270			self::$dbm->release( $conn );
271
272			$this->assertFalse( $row );
273			}
274
275
276			public function testGet()
277			{
278			$this->assertEquals( 'test 1', $this->object->get( 't:1' ) );
279			}
280
281
282			public function testGetExpired()
283			{
284			$this->assertEquals( null, $this->object->get( 't:2' ) );
285			}
286
287
288			public function testGetMultiple()
289			{
290			$this->assertEquals( array( 't:1' => 'test 1', 't:2' => null ), $this->object->getMultiple( array( 't:1', 't:2' ) ) );
			0 ignored issues – show Documentation introduced 2016-12-31 14:18 UTC by Report Bug Copy Issue Report `array('t:1', 't:2')` is of type `array<integer,string,{"0":"string","1":"string"}>`, but the function expects a `object<Aimeos\MW\Cache\iterable>`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
291			}
292
293
294			public function testGetMultipleByTags()
295			{
296			$this->assertEquals( array( 't:1' => 'test 1' ), $this->object->getMultipleByTags( array( 'tag:1' ) ) );
297			}
298
299
300			public function testSet()
301			{
302			$this->object->set( 't:3', 'test 3', '2100-01-01 00:00:00', array( 'tag:2', 'tag:3' ) );
303
304
305			$conn = self::$dbm->acquire();
306			$result = $conn->create( 'SELECT "tname" FROM "mw_cache_tag_test" WHERE "tid" = \'t:3\' ORDER BY "tname"' )->execute();
307			self::$dbm->release( $conn );
308
309			$this->assertEquals( array( 'tname' => 'tag:2' ), $result->fetch() );
310			$this->assertEquals( array( 'tname' => 'tag:3' ), $result->fetch() );
311			$this->assertFalse( $result->fetch() );
312
313
314			$conn = self::$dbm->acquire();
315			$result = $conn->create( 'SELECT * FROM "mw_cache_test" WHERE "id" = \'t:3\'' )->execute();
316			self::$dbm->release( $conn );
317
318			$expected = array(
319			'expire' => '2100-01-01 00:00:00',
320			'id' => 't:3',
321			'siteid' => 1,
322			'value' => 'test 3',
323			);
324			$this->assertEquals( $expected, $result->fetch() );
325			$this->assertFalse( $result->fetch() );
326			}
327
328
329			public function testSetMultiple()
330			{
331			$pairs = array( 't:3' => 'test 3', 't:2' => 'test 4' );
332			$tags = array( 't:3' => array( 'tag:2', 'tag:3' ), 't:2' => array( 'tag:4' ) );
333			$expires = array( 't:3' => '2100-01-01 00:00:00' );
334
335			$this->object->setMultiple( $pairs, $expires, $tags );
			0 ignored issues – show Documentation introduced 2016-12-31 14:18 UTC by Report Bug Copy Issue Report `$pairs` is of type `array<string,string,{"t:...tring","t:2":"string"}>`, but the function expects a `object<Aimeos\MW\Cache\iterable>`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
336
337
338			$conn = self::$dbm->acquire();
339			$result = $conn->create( 'SELECT "tname" FROM "mw_cache_tag_test" WHERE "tid" = \'t:3\' ORDER BY "tname"' )->execute();
340			self::$dbm->release( $conn );
341
342			$this->assertEquals( array( 'tname' => 'tag:2' ), $result->fetch() );
343			$this->assertEquals( array( 'tname' => 'tag:3' ), $result->fetch() );
344			$this->assertFalse( $result->fetch() );
345
346
347			$conn = self::$dbm->acquire();
348			$result = $conn->create( 'SELECT "tname" FROM "mw_cache_tag_test" WHERE "tid" = \'t:2\'' )->execute();
349			self::$dbm->release( $conn );
350
351			$this->assertEquals( array( 'tname' => 'tag:4' ), $result->fetch() );
352			$this->assertFalse( $result->fetch() );
353
354
355			$conn = self::$dbm->acquire();
356			$result = $conn->create( 'SELECT * FROM "mw_cache_test" WHERE "id" = \'t:3\'' )->execute();
357			self::$dbm->release( $conn );
358
359			$expected = array(
360			'expire' => '2100-01-01 00:00:00',
361			'id' => 't:3',
362			'siteid' => 1,
363			'value' => 'test 3',
364			);
365			$this->assertEquals( $expected, $result->fetch() );
366			$this->assertFalse( $result->fetch() );
367
368
369			$conn = self::$dbm->acquire();
370			$result = $conn->create( 'SELECT * FROM "mw_cache_test" WHERE "id" = \'t:2\'' )->execute();
371			self::$dbm->release( $conn );
372
373			$expected = array(
374			'expire' => null,
375			'id' => 't:2',
376			'siteid' => 1,
377			'value' => 'test 4',
378			);
379			$this->assertEquals( $expected, $result->fetch() );
380			$this->assertFalse( $result->fetch() );
381			}
382
383
384			public function testSetException()
385			{
386			$this->setExpectedException( '\\Aimeos\\MW\\Cache\\Exception' );
387			$this->object->set( array(), '' );
388			}
389
390			}
391

aimeos / aimeos-core

Push — master ( 815faa...197710 )

DBTest A

Complexity

Size/Duplication

Coupling/Cohesion

Importance

21 Methods

Duplication Side-by-Side

Filter issues like