CIPHPUnitTestDbTestCase

Complexity

Total Complexity

14

Size/Duplication

Total Lines	157
Duplicated Lines	10.19 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	resetInstance()	0	5	1
A	loadDependencies()	0	9	3
A	setUp()	0	4	1
A	tearDown()	0	10	3
A	dontSeeInDatabase()	8	8	1
A	seeInDatabase()	8	8	1
A	grabFromDatabase()	0	9	2
A	hasInDatabase()	0	8	1
A	seeNumRecords()	0	8	1

<?php
/**
 * Part of ci-phpunit-test
 *
 * @author     Kenji Suzuki <https://github.com/kenjis>
 * @license    MIT License
 * @copyright  2016 Kenji Suzuki
 * @link       https://github.com/kenjis/ci-phpunit-test
 */

/**
 * Copyright for Original Code
 * 
 * @author     CodeIgniter Dev Team
 * @copyright  Copyright (c) 2014 - 2016, British Columbia Institute of Technology (http://bcit.ca/)
 * @license    http://opensource.org/licenses/MIT	MIT License
 * @link       http://codeigniter.com
 * 
 * @see        https://github.com/bcit-ci/CodeIgniter4/blob/59e1587a9875141586f8333ff9cc64cdae2173c4/system/Test/CIDatabaseTestCase.php
 */

class CIPHPUnitTestDbTestCase extends CIPHPUnitTestCase

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{
	protected $db;

	/**
	 * Stores information needed to remove any
	 * rows inserted via $this->hasInDatabase();
	 *
	 * @var array
	 */
	protected $insertCache = [];

	public function resetInstance()
	{
		parent::resetInstance();
		$this->loadDependencies();
	}

	protected function loadDependencies()
	{
		if ($this->db === null || $this->db->conn_id === false)
		{
			$CI =& get_instance();
			$CI->load->database();
			$this->db = $CI->db;
		}
	}

	protected function setUp()
	{
		$this->loadDependencies();
	}

	//--------------------------------------------------------------------

	/**
	 * Takes care of any required cleanup after the test, like
	 * removing any rows inserted via $this->hasInDatabase()
	 */
	protected function tearDown()
	{
		if (! empty($this->insertCache))
		{
			foreach ($this->insertCache as $row)
			{
				$this->db->delete($row[0], $row[1]);
			}
		}
	}

	//--------------------------------------------------------------------
	// Database Test Helpers
	//--------------------------------------------------------------------

	/**
	 * Asserts that records that match the conditions in $where do
	 * not exist in the database.
	 *
	 * @param string $table
	 * @param array  $where
	 *
	 * @return bool
	 */
	public function dontSeeInDatabase($table, array $where)

This method seems to be duplicated in your project.

	{
		$this->db->from($table);
		$this->db->where($where);
		$count = $this->db->count_all_results();

		$this->assertTrue($count == 0, 'Row was found in database');
	}
	
	//--------------------------------------------------------------------

	/**
	 * Asserts that records that match the conditions in $where DO
	 * exist in the database.
	 * 
	 * @param string $table
	 * @param array  $where
	 *
	 * @return bool
	 */
	public function seeInDatabase($table, array $where)

This method seems to be duplicated in your project.

	{
		$this->db->from($table);
		$this->db->where($where);
		$count = $this->db->count_all_results();

		$this->assertTrue($count > 0, 'Row not found in database');
	}

	//--------------------------------------------------------------------

	/**
	 * Fetches a single column from a database row with criteria
	 * matching $where.
	 *
	 * @param string $table
	 * @param string $column
	 * @param array  $where
	 *
	 * @return bool
	 */
	public function grabFromDatabase($table, $column, array $where)
	{
		$this->db->select($column);
		$this->db->where($where);
		$query = $this->db->get($table);
		$row = $query->row();

		return isset($row->$column) ? $row->$column : false;
	}
	
	//--------------------------------------------------------------------

	/**
	 * Inserts a row into to the database. This row will be removed
	 * after the test has run.
	 *
	 * @param string $table
	 * @param array  $data
	 *
	 */
	public function hasInDatabase($table, array $data)
	{
		$this->insertCache[] = [
			$table, $data
		];

		$this->db->insert($table, $data);
	}

	//--------------------------------------------------------------------

	/**
	 * Asserts that the number of rows in the database that match $where
	 * is equal to $expected.
	 *
	 * @param int    $expected
	 * @param string $table
	 * @param array  $where
	 *
	 * @return bool
	 */
	public function seeNumRecords($expected, $table, array $where = [])
	{
		$this->db->from($table);
		$this->db->where($where);
		$count = $this->db->count_all_results();

		$this->assertEquals($expected, $count, 'Wrong number of matching rows in database.');
	}
	
	//--------------------------------------------------------------------
	
}