chillerlan\DatabaseTest\Drivers\DriverTestAbstract

Complexity

Total Complexity

22

Size/Duplication

Total Lines	247
Duplicated Lines	9.72 %

Coupling/Cohesion

Components	1
Dependencies	7

Importance

Changes	1
Bugs	0	Features	0

20 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	6	1
A	tearDown()	0	3	1
A	testInstance()	0	13	1
A	testConnectDBconnectError()	0	5	1
A	testEscape()	0	3	1
A	testCreateTable()	0	4	1
A	testTruncate()	0	4	1
A	testRawSQLError()	0	3	1
B	resultTest()	0	25	1
A	testRaw()	0	9	2
A	testPreparedSQLError()	0	3	1
A	testPrepared()	8	8	2
A	testMultiInvalidData()	0	3	1
A	testMultiSQLError()	0	3	1
A	testMulti()	8	14	1
A	testMultiCallbackInvalidData()	0	5	1
A	testMultiCallbackInvalidCallback()	0	3	1
A	testMultiCallbackSQLError()	0	6	1
A	testMultiCallback()	8	9	1
B	testCached()	0	36	1

<?php
/**
 * Class DriverTestAbstract
 *
 * @filesource   DriverTestAbstract.php
 * @created      29.05.2017
 * @package      chillerlan\DatabaseTest\Drivers
 * @author       Smiley <smiley@chillerlan.net>
 * @copyright    2017 Smiley
 * @license      MIT
 */

namespace chillerlan\DatabaseTest\Drivers;

use chillerlan\Database\Drivers\DBDriverInterface;
use chillerlan\DatabaseTest\TestAbstract;
use chillerlan\SimpleCache\Cache;
use chillerlan\SimpleCache\Drivers\MemoryCacheDriver;
use Psr\SimpleCache\CacheInterface;

abstract class DriverTestAbstract extends TestAbstract{

	/**
	 * @var \chillerlan\Database\Drivers\DBDriverInterface
	 */
	protected $DBDriver;

	/**
	 * @var \Psr\SimpleCache\CacheInterface
	 */
	protected $Cache;

	protected $driver;

	protected $SQL_RAW_TRUNCATE   = 'DELETE FROM test';
	protected $SQL_RAW_SELECT_ALL = 'SELECT * FROM test';
	protected $SQL_RAW_DROP       = 'DROP TABLE IF EXISTS test';
	protected $SQL_RAW_CREATE     = 'CREATE TABLE IF NOT EXISTS test (id INTEGER NOT NULL, hash VARCHAR(32) NOT NULL)';
	protected $SQL_RAW_INSERT     = 'INSERT INTO test (id, hash) VALUES (%1$d, \'%2$s\')';
	protected $SQL_RAW_ERROR      = '-';

	protected $SQL_PREPARED_INSERT = 'INSERT INTO test (id, hash) VALUES (?, ?)';

	protected $SQL_INDEX_COL = 'id';
	protected $SQL_DATA_COL  = 'hash';

	protected $SQL_ESCAPED;

	protected function setUp(){
		parent::setUp();

		$this->Cache = new Cache(new MemoryCacheDriver);
		$this->DBDriver = (new $this->driver($this->DBOptions, $this->Cache))->connect();
	}

	protected function tearDown(){
		$this->assertTrue($this->DBDriver->disconnect());
	}

	public function testInstance(){
		$this->assertInstanceOf(DBDriverInterface::class, $this->DBDriver);
		$this->assertInstanceOf(CacheInterface::class, $this->Cache);
		$this->assertSame($this->DBDriver, $this->DBDriver->connect());
		$this->assertNotNull($this->DBDriver->getDBResource());
#/*
		print_r([
			'driver' => get_class($this->DBDriver),
			'client' => $this->DBDriver->getClientInfo(),
			'server' => $this->DBDriver->getServerInfo(),
		]);
#*/
	}

	/**
	 * @expectedException \chillerlan\Database\DBException
	 * @expectedExceptionMessage db error:
	 */
	public function testConnectDBconnectError(){
		$this->DBOptions->host     = '...';
		$this->DBOptions->database = '...';
		(new $this->driver($this->DBOptions))->connect();
	}

	// coverage
	public function testEscape(){
		$this->assertSame($this->SQL_ESCAPED, $this->DBDriver->escape("'\\\''"));
	}

	public function testCreateTable(){
		$this->assertTrue($this->DBDriver->raw($this->SQL_RAW_DROP));

It seems like $this->DBDriver->raw($this->SQL_RAW_DROP) targeting chillerlan\Database\Drivers\DBDriverInterface::raw() can also be of type object<chillerlan\Database\DBResult>; however, PHPUnit\Framework\Assert::assertTrue() does only seem to accept boolean, maybe add an additional type check?

		$this->assertTrue($this->DBDriver->raw($this->SQL_RAW_CREATE));

It seems like $this->DBDriver->raw($this->SQL_RAW_CREATE) targeting chillerlan\Database\Drivers\DBDriverInterface::raw() can also be of type object<chillerlan\Database\DBResult>; however, PHPUnit\Framework\Assert::assertTrue() does only seem to accept boolean, maybe add an additional type check?

	}

	public function testTruncate(){
		$this->assertTrue($this->DBDriver->raw($this->SQL_RAW_TRUNCATE));

It seems like $this->DBDriver->raw($this->SQL_RAW_TRUNCATE) targeting chillerlan\Database\Drivers\DBDriverInterface::raw() can also be of type object<chillerlan\Database\DBResult>; however, PHPUnit\Framework\Assert::assertTrue() does only seem to accept boolean, maybe add an additional type check?

		$this->assertTrue($this->DBDriver->raw($this->SQL_RAW_SELECT_ALL));

It seems like $this->DBDriver->raw($this->SQL_RAW_SELECT_ALL) targeting chillerlan\Database\Drivers\DBDriverInterface::raw() can also be of type object<chillerlan\Database\DBResult>; however, PHPUnit\Framework\Assert::assertTrue() does only seem to accept boolean, maybe add an additional type check?

	}

	/**
	 * @expectedException \chillerlan\Database\DBException
	 * @expectedExceptionMessage sql error:
	 */
	public function testRawSQLError(){
		$this->DBDriver->raw($this->SQL_RAW_ERROR);
	}

	protected function resultTest(){
		$DBResult         = $this->DBDriver->raw($this->SQL_RAW_SELECT_ALL, $this->SQL_INDEX_COL);
		$DBResultPrepared = $this->DBDriver->prepared($this->SQL_RAW_SELECT_ALL, [], $this->SQL_INDEX_COL); // coverage

		$this->assertEquals($DBResult, $DBResultPrepared);

		$this->assertCount(10, $DBResult);

		$DBResult->__each(
			function($row, $i){
				/** @var \chillerlan\Database\DBResultRow $row */
				$this->assertEquals($row->{$this->SQL_INDEX_COL}, $i);
				$this->assertSame(md5($row->{$this->SQL_INDEX_COL}), $row->{$this->SQL_DATA_COL}());

				$row->__each(
					function($v, $j) use ($row){
						$this->assertEquals($row->{$j}, $v);
						$this->assertEquals($row[$j], $v);
					}
				);
			}
		);

		$this->assertTrue($this->DBDriver->raw($this->SQL_RAW_TRUNCATE));

It seems like $this->DBDriver->raw($this->SQL_RAW_TRUNCATE) targeting chillerlan\Database\Drivers\DBDriverInterface::raw() can also be of type object<chillerlan\Database\DBResult>; however, PHPUnit\Framework\Assert::assertTrue() does only seem to accept boolean, maybe add an additional type check?

	}

	public function testRaw(){

		// don't try this at home!
		foreach(range(0, 9) as $k){
			$this->assertTrue($this->DBDriver->raw(sprintf($this->SQL_RAW_INSERT, $k, md5($k))));

It seems like $this->DBDriver->raw(sprintf($this->SQL_RAW_INSERT, $k, md5($k))) targeting chillerlan\Database\Drivers\DBDriverInterface::raw() can also be of type object<chillerlan\Database\DBResult>; however, PHPUnit\Framework\Assert::assertTrue() does only seem to accept boolean, maybe add an additional type check?

		}

		$this->resultTest();
	}

	/**
	 * @expectedException \chillerlan\Database\DBException
	 * @expectedExceptionMessage sql error:
	 */
	public function testPreparedSQLError(){
		$this->DBDriver->prepared($this->SQL_RAW_ERROR);
	}

	public function testPrepared(){

This method seems to be duplicated in your project.

		foreach(range(0, 9) as $k){
			$this->assertTrue($this->DBDriver->prepared($this->SQL_PREPARED_INSERT, [$k, md5($k)]));

It seems like $this->DBDriver->prepared($this->SQL_PREPARED_INSERT, array($k, md5($k))) targeting chillerlan\Database\Drivers\DBDriverInterface::prepared() can also be of type object<chillerlan\Database\DBResult>; however, PHPUnit\Framework\Assert::assertTrue() does only seem to accept boolean, maybe add an additional type check?

		}

		$this->resultTest();
	}

	/**
	 * @expectedException \chillerlan\Database\DBException
	 * @expectedExceptionMessage invalid data
	 */
	public function testMultiInvalidData(){
		$this->DBDriver->multi($this->SQL_RAW_ERROR, []);
	}

	/**
	 * @expectedException \chillerlan\Database\DBException
	 * @expectedExceptionMessage sql error:
	 */
	public function testMultiSQLError(){
		$this->DBDriver->multi($this->SQL_RAW_ERROR, [[0]]);
	}

	public function testMulti(){

This method seems to be duplicated in your project.

		$this->assertTrue(
			$this->DBDriver->multi(
				$this->SQL_PREPARED_INSERT, array_map(
				function($k){
					return [$k, md5($k)];
				}, range(0, 9)
			)
			)
		);

		$this->resultTest();
	}

	/**
	 * @expectedException \chillerlan\Database\DBException
	 * @expectedExceptionMessage invalid data
	 */
	public function testMultiCallbackInvalidData(){
		$this->DBDriver->multi_callback(
			$this->SQL_RAW_ERROR, [], function(){
		});
	}

	/**
	 * @expectedException \chillerlan\Database\DBException
	 * @expectedExceptionMessage invalid callback
	 */
	public function testMultiCallbackInvalidCallback(){
		$this->DBDriver->multi_callback($this->SQL_RAW_ERROR, [[0]], '');
	}

	/**
	 * @expectedException \chillerlan\Database\DBException
	 * @expectedExceptionMessage sql error:
	 */
	public function testMultiCallbackSQLError(){
		$this->DBDriver->multi_callback(
			$this->SQL_RAW_ERROR, [[0]], function(){
			return [];
		});
	}

	public function testMultiCallback(){

This method seems to be duplicated in your project.

		$this->assertTrue($this->DBDriver->multi_callback(
			$this->SQL_PREPARED_INSERT, range(0, 9), function($k){
			return [$k, md5($k)];
		}));

		$this->resultTest();
	}

	public function testCached(){

		$this->assertTrue($this->DBDriver->multi_callback(
			$this->SQL_PREPARED_INSERT, range(0, 9), function($k){
			return [$k, md5($k)];
		}));

		$cacheKey = $this->DBDriver->cacheKey($this->SQL_RAW_SELECT_ALL, [], $this->SQL_INDEX_COL);

		// uncached
		$this->assertFalse($this->Cache->has($cacheKey));
		$this->DBDriver->rawCached($this->SQL_RAW_SELECT_ALL, $this->SQL_INDEX_COL, true, 2);

		// cached
		$this->assertTrue($this->Cache->has($cacheKey));
		$this->DBDriver->rawCached($this->SQL_RAW_SELECT_ALL, $this->SQL_INDEX_COL, true, 2);

		sleep(3);

		$this->Cache->clear();

		// prepared uncached
		$this->assertFalse($this->Cache->has($cacheKey));
		$this->DBDriver->preparedCached($this->SQL_RAW_SELECT_ALL, [], $this->SQL_INDEX_COL, true, 2);

		// prepared cached
		$this->assertTrue($this->Cache->has($cacheKey));
		$this->DBDriver->preparedCached($this->SQL_RAW_SELECT_ALL, [], $this->SQL_INDEX_COL, true, 2);

		sleep(3);
		$this->Cache->clear();

		$this->assertFalse($this->Cache->has($cacheKey));

		$this->assertTrue($this->DBDriver->raw($this->SQL_RAW_TRUNCATE));

It seems like $this->DBDriver->raw($this->SQL_RAW_TRUNCATE) targeting chillerlan\Database\Drivers\DBDriverInterface::raw() can also be of type object<chillerlan\Database\DBResult>; however, PHPUnit\Framework\Assert::assertTrue() does only seem to accept boolean, maybe add an additional type check?

	}

}