for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
declare(strict_types=1);
namespace Yiisoft\Db\Pgsql;
use Exception;
use Throwable;
use Yiisoft\Db\Driver\PDO\AbstractCommandPDO;
use Yiisoft\Db\Driver\PDO\ConnectionPDOInterface;
use Yiisoft\Db\Exception\ConvertException;
use Yiisoft\Db\QueryBuilder\QueryBuilderInterface;
/**
* Implements a database command that can be executed with a PDO (PHP Data Object) database connection for PostgreSQL
* Server.
*/
final class Command extends AbstractCommandPDO
{
public function showDatabases(): array
$sql = <<<SQL
SELECT datname FROM pg_database WHERE datistemplate = false AND datname NOT IN ('postgres', 'template0', 'template1')
SQL;
return $this->setSql($sql)->queryColumn();
}
protected function getQueryBuilder(): QueryBuilderInterface
return $this->db->getQueryBuilder();
* @psalm-suppress UnusedClosureParam
*
* @throws \Yiisoft\Db\Exception\Exception
* @throws Throwable
protected function internalExecute(string|null $rawSql): void
$attempt = 0;
while (true) {
try {
if (
++$attempt === 1
&& $this->isolationLevel !== null
&& $this->db->getTransaction() === null
) {
$this->db->transaction(
fn (ConnectionPDOInterface $db) => $this->internalExecute($rawSql),
$db
If this is a false-positive, you can also ignore this issue in your code via the ignore-unused annotation
ignore-unused
fn (/** @scrutinizer ignore-unused */ ConnectionPDOInterface $db) => $this->internalExecute($rawSql),
This check looks for parameters that have been defined for a function or method, but which are not used in the method body.
$this->isolationLevel
);
} else {
$this->pdoStatement?->execute();
break;
} catch (Exception $e) {
$rawSql = $rawSql ?: $this->getRawSql();
$e = (new ConvertException($e, $rawSql))->run();
if ($this->retryHandler === null || !($this->retryHandler)($e, $attempt)) {
throw $e;
yiisoft /
db-pgsql
This check looks for parameters that have been defined for a function or method, but which are not used in the method body.