Final Class Yiisoft\Rbac\Db\ItemTreeTraversal\PostgresCteItemTreeTraversal

                public function __construct(
    protected ConnectionInterface $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->getRowsCommand($names, baseOuterQuery: $baseOuterQuery, areParents: false)->queryAll();
}

            

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

            

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

            

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

            

                public function getHierarchy(string $name): array
{
    $baseOuterQuery = (new Query($this->database))->select(['item.*', 'parent_of.children']);
    $cteSelectRelationQuery = (new Query($this->database))
        ->select(['parent', new Expression($this->getTrimConcatChildrenExpression())])
        ->from("$this->childrenTableName AS item_child_recursive")
        ->innerJoin('parent_of', [
            'item_child_recursive.child' => new Expression('{{parent_of}}.[[child_name]]'),
        ]);
    /** @infection-ignore-all FalseValue, union */
    $cteSelectItemQuery = (new Query($this->database))
        ->select(['name', new Expression($this->getEmptyChildrenExpression())])
        ->from($this->tableName)
        ->where(['name' => $name])
        ->union($cteSelectRelationQuery, all: true);
    /** @infection-ignore-all FalseValue, recursive */
    $outerQuery = $baseOuterQuery
        ->withQuery($cteSelectItemQuery, 'parent_of(child_name, children)', recursive: true)
        ->from('parent_of')
        ->leftJoin(
            ['item' => $this->tableName],
            ['item.name' => new Expression('{{parent_of}}.[[child_name]]')],
        );
    /** @psalm-var Hierarchy */
    return $outerQuery->all();
}

            

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

            

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

            

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