Final Class Yiisoft\Rbac\Cycle\ItemTreeTraversal\PostgresCteItemTreeTraversal

                public function __construct(
    protected DatabaseInterface $database,
    protected string $tableName,
    protected string $childrenTableName,
    protected string $namesSeparator,
) {
}

            

                public function getChildPermissionRows(string|array $names): array
{
    $baseOuterQuery = $this->getChildrenBaseOuterQuery($names)->andWhere(['item.type' => Item::TYPE_PERMISSION]);
    /** @psalm-var RawItem[] */
    return $this->getRowsStatement($names, baseOuterQuery: $baseOuterQuery, areParents: false)->fetchAll();
}

            

                public function getChildRoleRows(string|array $names): array
{
    $baseOuterQuery = $this->getChildrenBaseOuterQuery($names)->andWhere(['item.type' => Item::TYPE_ROLE]);
    /** @psalm-var RawItem[] */
    return $this->getRowsStatement($names, baseOuterQuery: $baseOuterQuery, areParents: false)->fetchAll();
}

            

                public function getChildrenRows(string|array $names): array
{
    $baseOuterQuery = $this->getChildrenBaseOuterQuery($names);
    /** @psalm-var RawItem[] */
    return $this->getRowsStatement($names, baseOuterQuery: $baseOuterQuery, areParents: false)->fetchAll();
}

            

                protected function getEmptyChildrenExpression(): string
{
    return "''";
}

            

                public function getHierarchy(string $name): array
{
    $baseOuterQuery = $this->database->select(['item.*', 'parent_of.children']);
    $cteSelectItemQuery = $this
        ->database
        ->select(['name', new Fragment($this->getEmptyChildrenExpression())])
        ->from($this->tableName)
        ->where(['name' => $name]);
    $cteSelectRelationQuery = $this
        ->database
        ->select(['parent', new Fragment($this->getTrimConcatChildrenExpression())])
        ->from("$this->childrenTableName AS item_child_recursive")
        ->innerJoin('parent_of')
        ->on('item_child_recursive.child', 'parent_of.child_name');
    $outerQuery = $baseOuterQuery
        ->from('parent_of')
        ->leftJoin($this->tableName, 'item')
        ->on('item.name', 'parent_of.child_name');
    $sql = "{$this->getWithExpression()} parent_of(child_name, children) AS (
        $cteSelectItemQuery
        UNION ALL
        $cteSelectRelationQuery
    )
    $outerQuery";
    /** @psalm-var Hierarchy */
    return $this->database->query($sql)->fetchAll();
}

            

                public function getParentRows(string $name): array
{
    $baseOuterQuery = $this->database->select('item.*')->where('item.name', '!=', $name);
    /** @psalm-var RawItem[] */
    return $this->getRowsStatement($name, baseOuterQuery: $baseOuterQuery)->fetchAll();
}

            

                protected function getTrimConcatChildrenExpression(): string
{
    return "TRIM('$this->namesSeparator' FROM CONCAT(children, '$this->namesSeparator', " .
        'item_child_recursive.child))';
}

            

                protected function getWithExpression(): string
{
    return 'WITH RECURSIVE';
}

            

                public function hasChild(string $parentName, string $childName): bool
{
    /**
     * @infection-ignore-all
     * - ArrayItemRemoval, select.
     */
    $baseOuterQuery = $this
        ->database
        ->select([new Fragment('1 AS item_child_exists')])
        ->andWhere(['item.name' => $childName]);
    /** @psalm-var array<0, 1>|false $result */
    $result = $this->getRowsStatement($parentName, baseOuterQuery: $baseOuterQuery, areParents: false)->fetch();
    return $result !== false;
}