Analyzing multiple connections

[aszenz]

We use two db connections in the app, is their a way to analyze them both, i only see an option to add one pdo mysql db

[staabm]

You can use https://github.com/staabm/phpstan-dba/blob/main/src/QueryReflection/ChainedReflector.php to combine several pdo or mysql,... reflectors

[aszenz]

Perfect, works great.
I see it now in docs too https://github.com/staabm/phpstan-dba/blob/main/docs/reflectors.md, hence closing this issue

[aszenz]

How does phpstan-dba know which reflector to use for each file like a repository, i see some errors where it uses an incorrect reflector on the repository file and throws errors like table central.foo doesn't exist, while it should actually check demo.foo

[staabm]

the chain just works thru the list of reflectors. the first one which returns a type, is used:

phpstan-dba/src/QueryReflection/ChainedReflector.php

Lines 54 to 60 in 31c4de9

	foreach ($this->reflectors as $reflector) {
	$reflectorResult = $reflector->getResultType($queryString, $fetchType);
	if (null !== $reflectorResult) {
	return $reflectorResult;
	}
	}

I guess this might lead to problems, e.g. when you have queries which can be executed successfully on several reflectors

[aszenz]

Hmm, my query should work on only one reflector, but it's not using that reflector

[staabm]

please open a new issue with code which reproduces your problem.
it might be useful to create a small example repo.