AbterPhp\Admin\Databases\Queries\AdminResourceAuthLoader::loadAll()

Complexity

Conditions	2
Paths	2

Size

Total Lines	17
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function loadAll(): array
    {
        $query = (new QueryBuilder())
            ->select('ug.identifier AS v0', 'ar.identifier AS v1')
            ->from('user_groups_admin_resources', 'ugar')
            ->innerJoin('admin_resources', 'ar', 'ugar.admin_resource_id = ar.id AND ar.deleted_at IS NULL')
            ->innerJoin('user_groups', 'ug', 'ugar.user_group_id = ug.id AND ug.deleted_at IS NULL')
        ;

        $connection = $this->connectionPool->getReadConnection();
        $statement  = $connection->prepare($query->getSql());
        $statement->bindValues($query->getParameters());
        if (!$statement->execute()) {
            throw new Database($statement->errorInfo());
        }

        return $statement->fetchAll(\PDO::FETCH_ASSOC);
    }