Passed
Push — master ( 0827b7...6b1c34 )
by K
12:49
created

UserRolesRepository::getUserRoles()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 7
Code Lines 3

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 5
CRAP Score 1

Importance

Changes 0
Metric Value
cc 1
eloc 3
nc 1
nop 1
dl 0
loc 7
ccs 5
cts 5
cp 1
crap 1
rs 10
c 0
b 0
f 0
1
<?php
2
3
declare(strict_types=1);
4
5
namespace PerfectApp\RBAC;
6
7
use PDO;
8
9
class UserRolesRepository
10
{
11
    /**
12
     * @param PDO $pdo
13
     */
14 1
    public function __construct(private PDO $pdo)
15
    {
16 1
    }
17
18
    /**
19
     * @param int $userId
20
     * @return mixed
21
     */
22 1
    public function getUserRoles(int $userId): mixed
23
    {
24 1
        $stmt = $this->pdo->prepare('SELECT r.role_name FROM user_roles ur
25
                                    JOIN roles r ON ur.role_id = r.role_id
26 1
                                    WHERE ur.user_id = ?');
27 1
        $stmt->execute([$userId]);
28 1
        return $stmt->fetchAll(PDO::FETCH_COLUMN, 0);
29
    }
30
}
31