BaseIntegrationSpec::setUpBeforeClass() - Code Metrics - Inspection of "Minor cleanup in tests, docs, and interfaces" - smrealms/smr - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Pull Request — master (#1017)

by Dan

created 2021-03-12 21:22 UTC

BaseIntegrationSpec::setUpBeforeClass() A

↳ Parent: BaseIntegrationSpec

Complexity

Conditions	2
Paths	2

Size

Total Lines	9
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	0	Features	0

Metric	Value
cc	2
eloc	8
nc	2
nop	0
dl	0
loc	9
rs	10
c	3
b	0
f	0

<?php declare(strict_types=1);

namespace SmrTest;

use mysqli;
use PHPUnit\Framework\TestCase;
use Smr\Container\DiContainer;
use Smr\MySqlProperties;
use Throwable;

class BaseIntegrationSpec extends TestCase {
	protected static mysqli $conn;
	private static $defaultPopulatedTables = array();

	public static function setUpBeforeClass(): void {
		if (!isset(self::$conn)) {
			$mysqlProperties = DiContainer::get(MySqlProperties::class);

			self::$conn = DiContainer::make(mysqli::class);
			$query = "SELECT table_name FROM information_schema.tables WHERE table_rows > 0 AND TABLE_SCHEMA='smr_live'";
			$rs = self::$conn->query($query);
			$all = $rs->fetch_all();
			array_walk_recursive($all, function($a) {
				self::$defaultPopulatedTables[] = "'" . $a . "'";
			});
		}
	}

	protected function onNotSuccessfulTest(Throwable $t): void {
		$this->cleanUp();
		throw $t;
	}

	protected function tearDown(): void {
		$this->cleanUp();
	}

	protected function cleanUp() {
		$implode = implode(",", self::$defaultPopulatedTables);
		$query = "SELECT Concat('TRUNCATE TABLE ', TABLE_NAME, ';') FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'smr_live' and TABLE_NAME not in (${implode})";
		$rs = self::$conn->query($query);
		$all = $rs->fetch_all();
		foreach ($all as $truncate) {
			self::$conn->query($truncate[0]);
		}
	}
}


1			<?php declare(strict_types=1);
2
3			namespace SmrTest;
4
5			use mysqli;
6			use PHPUnit\Framework\TestCase;
7			use Smr\Container\DiContainer;
8			use Smr\MySqlProperties;
9			use Throwable;
10
11			class BaseIntegrationSpec extends TestCase {
12			protected static mysqli $conn;
13			private static $defaultPopulatedTables = array();
14
15			public static function setUpBeforeClass(): void {
16			if (!isset(self::$conn)) {
17			$mysqlProperties = DiContainer::get(MySqlProperties::class);
			0 ignored issues – show Unused Code introduced 2021-03-12 21:26 UTC by Report Bug Copy Issue Report The assignment to `$mysqlProperties` is dead and can be removed. Loading history...
18			self::$conn = DiContainer::make(mysqli::class);
19			$query = "SELECT table_name FROM information_schema.tables WHERE table_rows > 0 AND TABLE_SCHEMA='smr_live'";
20			$rs = self::$conn->query($query);
21			$all = $rs->fetch_all();
22			array_walk_recursive($all, function($a) {
23			self::$defaultPopulatedTables[] = "'" . $a . "'";
24			});
25			}
26			}
27
28			protected function onNotSuccessfulTest(Throwable $t): void {
29			$this->cleanUp();
30			throw $t;
31			}
32
33			protected function tearDown(): void {
34			$this->cleanUp();
35			}
36
37			protected function cleanUp() {
38			$implode = implode(",", self::$defaultPopulatedTables);
39			$query = "SELECT Concat('TRUNCATE TABLE ', TABLE_NAME, ';') FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'smr_live' and TABLE_NAME not in (${implode})";
40			$rs = self::$conn->query($query);
41			$all = $rs->fetch_all();
42			foreach ($all as $truncate) {
43			self::$conn->query($truncate[0]);
44			}
45			}
46			}
47

smrealms / smr

Scrutinizer GitHub App not installed

Pull Request — master (#1017)

BaseIntegrationSpec::setUpBeforeClass() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like