Final Class Yiisoft\Rbac\Db\ItemTreeTraversal\MysqlItemTreeTraversal

                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()->where(['item.type' => Item::TYPE_PERMISSION]);
    /** @psalm-var RawItem[] */
    return $this->getChildrenRowsCommand($names, baseOuterQuery: $baseOuterQuery)->queryAll();
}

            

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

            

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

            

                public function getHierarchy(string $name): array
{
    $sql = "SELECT item.*, hierarchy_base.children FROM (
        SELECT
            child_name,
            MIN(TRIM(BOTH '$this->namesSeparator'
        FROM TRIM(BOTH child_name FROM raw_children))) as children FROM (
            SELECT @r AS child_name, @path := concat(@path, '$this->namesSeparator', @r) as raw_children,
            (SELECT @r := parent FROM $this->childrenTableName WHERE child = child_name LIMIT 1) AS parent
            FROM (SELECT @r := :name, @path := '') val, $this->childrenTableName
        ) raw_hierarchy_base
        GROUP BY child_name
    ) hierarchy_base
    LEFT JOIN $this->tableName AS item ON item.name = hierarchy_base.child_name
    WHERE item.name IS NOT NULL";
    /** @psalm-var Hierarchy */
    return $this
        ->database
        ->createCommand($sql, [':name' => $name])
        ->queryAll();
}

            

                public function getParentRows(string $name): array
{
    $sql = "SELECT DISTINCT item.* FROM (
        SELECT @r AS child_name,
        (SELECT @r := parent FROM $this->childrenTableName WHERE child = child_name LIMIT 1) AS parent
        FROM (SELECT @r := :name) val, $this->childrenTableName
    ) s
    LEFT JOIN $this->tableName AS item ON item.name = s.child_name
    WHERE item.name != :name";
    /** @psalm-var RawItem[] */
    return $this
        ->database
        ->createCommand($sql, [':name' => $name])
        ->queryAll();
}

            

                public function hasChild(string $parentName, string $childName): bool
{
    $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->getChildrenRowsCommand($parentName, baseOuterQuery: $baseOuterQuery)->queryScalar();
    return $result !== false;
}