chillerlan\DatabaseTest\Drivers\DriverTestAbstract

Complexity

Total Complexity

19

Size/Duplication

Total Lines	168
Duplicated Lines	20.24 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes	1
Bugs	0	Features	0

17 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	5	1
A	tearDown()	0	3	1
A	resultTest()	10	21	1
A	testInstance()	0	10	1
A	testCreateTable()	0	4	1
A	testTruncate()	0	4	1
A	testRawSQLError()	0	3	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	8	1
A	testMultiCallbackInvalidData()	0	3	1
A	testMultiCallbackInvalidCallback()	0	3	1
A	testMultiCallbackSQLError()	0	3	1
A	testMultiCallback()	8	8	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\DBResult;
use chillerlan\Database\Drivers\DBDriverInterface;
use chillerlan\DatabaseTest\TestAbstract;

abstract class DriverTestAbstract extends TestAbstract{

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


	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 function setUp(){
		parent::setUp();

		$this->DBDriver = (new $this->driver($this->dbOptions))->connect();
	}

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

	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){

This code seems to be duplicated across your project.

			/** @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 testInstance(){
		$this->assertInstanceOf(DBDriverInterface::class, $this->DBDriver);
		$this->assertNotNull($this->DBDriver->getDBResource());

		print_r([
			'driver' => get_class($this->DBDriver),
			'client' => $this->DBDriver->getClientInfo(),
			'server' => $this->DBDriver->getServerInfo(),
		]);
	}

	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);
	}

	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();
	}
}