Total Complexity | 2 |
Total Lines | 20 |
Duplicated Lines | 0 % |
Coverage | 100% |
Changes | 0 |
1 | <?php |
||
9 | readonly 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 array|false |
||
21 | */ |
||
22 | 1 | public function getUserRoles(int $userId): array|false |
|
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 | } |
||
31 |