dbal
dbal copied to clipboard
DBAL-933: Get Statement Column Metadata
Jira issue originally created by user bburnichon:
It would be nice to have a utility method in \Doctrine\Dbal\Driver\ResultStatement to properly retrieve the result column names.
Currently, we have to rely on somthing like $columnNames = array_keys($statement->fetch(\PDO::FETCH_ASSOC));
Problem: It does not work with empty result-sets, and more checks should be performed to handle these.
With PDO, http://www.php.net/manual/en/pdostatement.getcolumnmeta.php could be used to properly retrieve names.
For Sqlite3 it is easy, http://www.php.net/manual/en/sqlite3result.columnname.php
For Mysql, http://www.php.net/manual/en/mysqli-result.fetch-fields.php would do the trick
We cannot change this in 2.x as this would require an interface change. Scheduling this to be discussed for 3.0
.
Isn't adding a new public method to the ResultStatement object a backwards compatible change? Why can't this be done in 2.x? The method is part of the PDOStatement API, which the ResultStatement API otherwise appears to mimic.
Isn't adding a new public method to the ResultStatement object a backwards compatible change?
It is not. ResultStatement is an interface, any new methods introduced in interfaces are subject to BC breaks.
This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.