Using with doctrine/dbal about phpstan-dba HOT 8 OPEN

Did you setup a database server in CI and imported a db schema into a database?

Could you reproduce your problem in a small example repository?

from phpstan-dba.

No, but I manage that I don't need do that because I use cache from https://github.com/staabm/phpstan-dba/blob/main/docs/record-and-replay.md

from phpstan-dba.

ok this means we can close here?

from phpstan-dba.

So I need to setup db? What about this https://github.com/staabm/phpstan-dba/blob/main/docs/record-and-replay.md ?

from phpstan-dba.

ohh I missunderstood your previous comment.

record-and-replay can be used for cases when you really cannot setup a DB in CI.
you would commit the recorded files into the repo and it should work then.

having a real db and a real schema might be more work, but is more accurate for the analysis - in case you managed a good dev process how you handle db migrations etc.

from phpstan-dba.

For me works like you mentioned, but looks like just Doctrine\DBAL\Connection::delete or Doctrine\DBAL\Connection::insert didn't work when run on CI without DB with record-and-replay. There are not errors with missing table or connection when analyse raw SQL queries.

from phpstan-dba.

would be great if you would post a full example, which shows what does not work and what you expect

from phpstan-dba.

I have simplified code.

final readonly class Db
{
    public function __construct(private \Doctrine\DBAL\Connection $connection)
    {
    }

    public function save(
        string $id,
    ): string {
        $this->connection->insert('table', [
            'id' => $id,
        ]);
        return $this->connection->executeQuery('SELECT id FROM id = :id', [
            'id' => $id,
        ])->fetchOne();
    }
}

When I run on local with db with all correct loaded schema, then I use ReplayAndRecordingQueryReflector and phpstan analyse pass.

When I run on CI without db, then I use ReplayQueryReflector and phpstan analyse fail only on insert (Query error: Table "table" does not exist). Analyse on executeQuery looks like working with cache. Cache from dev env is commited to be using on CI.

I always run with bootstrap file from first message. $isCi choose a correct QueryReflector.

from phpstan-dba.