database icon indicating copy to clipboard operation
database copied to clipboard

Helpers::dumpSql() should parse named params

Open insekticid opened this issue 10 years ago • 0 comments

In PDO you can bind named params bindValue('something', 1, PDO::TYPE);

So you can use ResultSet like this

$query = 'SELECT * FROM table WHERE id = :something';
$params[':something'] = 1;
$resultSet = new ResultSet($connection, $query, $params);
$connection->onQuery($connection, $resultSet);// log binded param query to Tracy

Problem is in Nette\Bridges\DatabaseTracy\ConnectionPanel template which invoke Helpers::dumpSql()

This helper does not support named parameters. Tracy result is:

SELECT * FROM table WHERE id = :something

Expected

SELECT * FROM table WHERE id = 1

insekticid avatar Jul 15 '15 14:07 insekticid