PdoUserRoles::__construct() - Code Metrics - GermaniaKG/UserRoles - Measure and Improve Code Quality continuously with Scrutinizer

PdoUserRoles::__construct() A
last analyzed 2019-04-08 14:23 UTC

↳ Parent: PdoUserRoles

Complexity

Conditions	2
Paths	2

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	6
CRAP Score	2

Importance

Changes

Metric	Value
dl	0
loc	13
ccs	6
cts	6
cp	1
rs	9.8333
c	0
b	0
f	0
cc	2
nc	2
nop	2
crap	2

<?php
namespace Germania\UserRoles;

class PdoUserRoles
{

    /**
     * @var string
     */
    public $table = 'users_roles_mm';


    /**
     * @var PDOStatement
     */
    public $stmt;


    /**
     * @param PDO           $pdo
     * @param string        $table  Optional: Users table name
     */
    public function __construct( \PDO $pdo, $table = null  )
    {
        $this->table = $table ?: $this->table;

        // ID is listed twice here in order to use it with FETCH_UNIQUE as array key
        $sql = "SELECT
        role_id
        FROM {$this->table}
        WHERE client_id = :user_id";

        // Store for later use
        $this->stmt = $pdo->prepare( $sql );

    }


    /**
     * @param  int   $user_id User ID
     * @return int[] Array of Role IDs
     */
    public function __invoke( $user_id ) {
        $result = $this->stmt->execute([
            'user_id' => $user_id
        ]);

        if ($result) {
            return $this->stmt->fetchAll(\PDO::FETCH_COLUMN);
        }

        throw new \RuntimeException( "PDOStatement execution on table " . $this->table . " returned FALSE");
    }

}



1		<?php
2		namespace Germania\UserRoles;
3
4		class PdoUserRoles
5		{
6
7		/**
8		* @var string
9		*/
10		public $table = 'users_roles_mm';
11
12
13		/**
14		* @var PDOStatement
15		*/
16		public $stmt;
17
18
19		/**
20		* @param PDO $pdo
21		* @param string $table Optional: Users table name
22		*/
23	20	public function __construct( \PDO $pdo, $table = null )
24		{
25	20	$this->table = $table ?: $this->table;
26
27		// ID is listed twice here in order to use it with FETCH_UNIQUE as array key
28		$sql = "SELECT
29		role_id
30	20	FROM {$this->table}
31	4	WHERE client_id = :user_id";
32
33		// Store for later use
34	20	$this->stmt = $pdo->prepare( $sql );
		0 ignored issues – show Documentation Bug introduced 2017-08-31 07:28 UTC by Report Bug Copy Issue Report It seems like `$pdo->prepare($sql)` of type `object<PDOStatement>` is incompatible with the declared type `object<Germania\UserRoles\PDOStatement>` of property `$stmt`. Our type inference engine has found an assignment to a property that is incompatible with the declared type of that property. Either this assignment is in error or the assigned type should be added to the documentation/type hint for that property.. Loading history...
35	20	}
36
37
38		/**
39		* @param int $user_id User ID
40		* @return int[] Array of Role IDs
41		*/
42	20	public function __invoke( $user_id ) {
43	20	$result = $this->stmt->execute([
44	16	'user_id' => $user_id
45	4	]);
46
47	20	if ($result) {
48	10	return $this->stmt->fetchAll(\PDO::FETCH_COLUMN);
49		}
50
51	10	throw new \RuntimeException( "PDOStatement execution on table " . $this->table . " returned FALSE");
52		}
53
54		}
55
56

GermaniaKG / UserRoles

PdoUserRoles::__construct() A last analyzed 2019-04-08 14:23 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

PdoUserRoles::__construct() A
last analyzed 2019-04-08 14:23 UTC