PerfectApp\RBAC\UserRolesRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	20
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	2	1
A	getUserRoles()	0	7	1

<?php

declare(strict_types=1);

namespace PerfectApp\RBAC;

use PDO;

class UserRolesRepository
{
    /**
     * @param PDO $pdo
     */
    public function __construct(private PDO $pdo)
    {
    }

    /**
     * @param int $userId
     * @return array|false
     */
    public function getUserRoles(int $userId): array|false
    {
        $stmt = $this->pdo->prepare('SELECT r.role_name FROM user_roles ur
                                    JOIN roles r ON ur.role_id = r.role_id
                                    WHERE ur.user_id = ?');
        $stmt->execute([$userId]);
        return $stmt->fetchAll(PDO::FETCH_COLUMN, 0);
    }
}