Narrowing generic array

[gaborjonas]

Hi,
I'm using Doctrine DBAL to fetch records from DB.

/**
     * @return array<int,array{id: int, name: string, description: ?string}>
     * @throws Exception
     * @throws \Doctrine\DBAL\Driver\Exception
     */
    public function getFromDB(): array
    {
        $statement = $this->getRead()->prepare("SELECT * FROM table");
        $result = $statement->executeQuery();

        return $result->fetchAllAssociative();
    }

PhpStan reports the following issue:

getFromDB() should return array<int, array{id: int, name: string, description: string|null}> but returns array<int, array<string, mixed>>.

I can get around it by duplicating the array shape inside the method, which isn't ideal.

 /** @var array<int,array{id: int, name: string, description: ?string}> $records */
$records = $result->fetchAllAssociative();
return $records;

Is there a simpler way to do this?
Thanks

[mad-briller]

are you using the https://github.com/phpstan/phpstan-doctrine ?

[ondrejmirtes]

I'd say there's more chance of this working with https://github.com/staabm/phpstan-dba

[mad-briller]

not a doctrine user myself so i'll take your word for it 👼