Germania\UserRoles\PdoUserRoles

Complexity

Total Complexity

4

Size/Duplication

Total Lines	51
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Test Coverage

Coverage

100%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	13	2
A	__invoke()	0	11	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 );

It seems like $pdo->prepare($sql) of type object<PDOStatement> is incompatible with the declared type object<Germania\UserRoles\PDOStatement> of property $stmt.

    }


    /**
     * @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");
    }

}