SQLite::createTableIfNotExists() - Code Metrics - Inspection of "Reorganize code, database ones perform inserts at..." - Lloople/phpunit-extensions - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 501416...580ac7 )

by David

created 2020-01-04 20:55 UTC

SQLite::createTableIfNotExists() A

↳ Parent: SQLite

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	12
rs	9.8666
c	0
b	0
f	0
cc	1
nc	1
nop	0

<?php

namespace Lloople\PHPUnitExtensions\Runners\SlowestTests;

use PDO;

class SQLite extends MySQL
{

    protected $credentials = [
        'database' => 'phpunit_results.db',
        'table' => 'default',
    ];

    protected function connect(): void
    {
        $this->connection = new PDO("sqlite:{$this->credentials['database']}");
        
        $this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }

    protected function createTableIfNotExists(): void
    {
        $this->connection->prepare(
            "CREATE TABLE IF NOT EXISTS `{$this->credentials['table']}` (
                `time` float DEFAULT NULL,
                `name` varchar(255) NOT NULL,
                `method` varchar(255) DEFAULT NULL,
                `class` varchar(255) DEFAULT NULL,
                PRIMARY KEY (`name`)
            );"
        )->execute();
    }

    protected function insert(string $test, string $time): void
    {
        [$class, $method] = explode('::', $test);


        $this->connection
            ->prepare(
                "INSERT INTO `{$this->credentials['table']}` (time, method, class, name) 
                VALUES(:time, :method, :class, :name) 
                ON CONFLICT(name) DO UPDATE SET time = :time;"
            )
            ->execute([
                'time' => $time,
                'method' => $method,
                'class' => $class,
                'name' => $test,
            ]);
    }
}


1			<?php
2
3			namespace Lloople\PHPUnitExtensions\Runners\SlowestTests;
4
5			use PDO;
6
7			class SQLite extends MySQL
8			{
9
10			protected $credentials = [
11			'database' => 'phpunit_results.db',
12			'table' => 'default',
13			];
14
15			protected function connect(): void
16			{
17			$this->connection = new PDO("sqlite:{$this->credentials['database']}");
18
19			$this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
20			}
21
22			protected function createTableIfNotExists(): void
23			{
24			$this->connection->prepare(
25			"CREATE TABLE IF NOT EXISTS `{$this->credentials['table']}` (
26			`time` float DEFAULT NULL,
27			`name` varchar(255) NOT NULL,
28			`method` varchar(255) DEFAULT NULL,
29			`class` varchar(255) DEFAULT NULL,
30			PRIMARY KEY (`name`)
31			);"
32			)->execute();
33			}
34
35			protected function insert(string $test, string $time): void
36			{
37			[$class, $method] = explode('::', $test);
			0 ignored issues – show Bug introduced 2020-01-04 20:57 UTC by Report Bug Copy Issue Report The variable `$class` does not exist. Did you forget to declare it? This check marks access to variables or properties that have not been declared yet. While PHP has no explicit notion of declaring a variable, accessing it before a value is assigned to it is most likely a bug. Loading history... Bug introduced 2020-01-04 20:57 UTC by Report Bug Copy Issue Report The variable `$method` does not exist. Did you forget to declare it? This check marks access to variables or properties that have not been declared yet. While PHP has no explicit notion of declaring a variable, accessing it before a value is assigned to it is most likely a bug. Loading history...
38
39			$this->connection
40			->prepare(
41			"INSERT INTO `{$this->credentials['table']}` (time, method, class, name)
42			VALUES(:time, :method, :class, :name)
43			ON CONFLICT(name) DO UPDATE SET time = :time;"
44			)
45			->execute([
46			'time' => $time,
47			'method' => $method,
48			'class' => $class,
49			'name' => $test,
50			]);
51			}
52			}
53

Lloople / phpunit-extensions

Push — master ( 501416...580ac7 )

SQLite::createTableIfNotExists() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like