SQLTrait::createTable() - Code Metrics - Inspection of "Refactoring" - VIPnytt/RobotsTxtParser - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Branch — 2.0-dev (d250b8)

by Jan-Petter

created 2016-05-29 19:53 UTC

SQLTrait::createTable() A

↳ Parent: SQLTrait

Complexity

Conditions	3
Paths	3

Size

Total Lines	12
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	12
rs	9.4285
cc	3
eloc	8
nc	3
nop	3

<?php
namespace vipnytt\RobotsTxtParser\Client\SQL;

use PDO;
use PDOException;

/**
 * Class SQLTrait
 *
 * @package vipnytt\RobotsTxtParser\Client\SQL
 */
trait SQLTrait
{
    /**
     * Initialize PDO connection
     *
     * @param PDO $pdo
     * @return PDO
     */
    private function pdoInitialize(PDO $pdo)
    {
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
        return $pdo;
    }

    /**
     * Create table
     *
     * @param PDO $pdo
     * @param string $table
     * @param string $query
     * @return bool
     */
    private function createTable(PDO $pdo, $table, $query)
    {
        if ($this->tableExists($pdo, $table)) {
            return true;
        }
        try {
            $pdo->query($query);
        } catch (PDOException $Exception) {
            return FALSE;
        }
        return $this->tableExists($pdo, $table);
    }

    /**
     * Check if the table exists
     *
     * @param PDO $pdo
     * @param string $table
     * @return bool
     */
    private function tableExists(PDO $pdo, $table)
    {
        try {
            $result = $pdo->query("SELECT 1 FROM $table LIMIT 1;");
        } catch (PDOException $Exception) {
            return FALSE;
        }
        return $result !== FALSE;
    }
}


1			<?php
2			namespace vipnytt\RobotsTxtParser\Client\SQL;
3
4			use PDO;
5			use PDOException;
6
7			/**
8			* Class SQLTrait
9			*
10			* @package vipnytt\RobotsTxtParser\Client\SQL
11			*/
12			trait SQLTrait
13			{
14			/**
15			* Initialize PDO connection
16			*
17			* @param PDO $pdo
18			* @return PDO
19			*/
20			private function pdoInitialize(PDO $pdo)
21			{
22			$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
23			return $pdo;
24			}
25
26			/**
27			* Create table
28			*
29			* @param PDO $pdo
30			* @param string $table
31			* @param string $query
32			* @return bool
33			*/
34			private function createTable(PDO $pdo, $table, $query)
35			{
36			if ($this->tableExists($pdo, $table)) {
37			return true;
38			}
39			try {
40			$pdo->query($query);
41			} catch (PDOException $Exception) {
42			return FALSE;
43			}
44			return $this->tableExists($pdo, $table);
45			}
46
47			/**
48			* Check if the table exists
49			*
50			* @param PDO $pdo
51			* @param string $table
52			* @return bool
53			*/
54			private function tableExists(PDO $pdo, $table)
55			{
56			try {
57			$result = $pdo->query("SELECT 1 FROM $table LIMIT 1;");
58			} catch (PDOException $Exception) {
59			return FALSE;
60			}
61			return $result !== FALSE;
62			}
63			}
64

VIPnytt / RobotsTxtParser

Branch — 2.0-dev (d250b8)

SQLTrait::createTable() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like