ZF2 log SQL string with driver-support

ZF2_log-SQL-string-with-driver-support.php

<?php

namespace BitkornShop\Table\Basket;

use Zend\Db\Adapter\Adapter;
use Zend\Db\ResultSet\HydratingResultSet;
use Zend\Db\TableGateway\AbstractTableGateway;
use Zend\Db\Adapter\AdapterAwareInterface;

/**
 *
 * @author allapow
 */
class SomeTable extends AbstractTableGateway implements AdapterAwareInterface
{

    /**
     *
     * @var string
     */
    protected $table = 'table_name';

    /**
     *
     * @var \Zend\Log\Logger
     */
    protected $logger;

    public function setDbAdapter(Adapter $adapter)
    {
        $this->adapter = $adapter;
        $this->resultSetPrototype = new HydratingResultSet();
        $this->initialize();
    }

    public function setLogger(\Zend\Log\Logger $logger)
    {
        $this->logger = $logger;
    }

    protected function log(\Exception $ex)
    {
        $this->logger->err($ex->getMessage());
        $this->logger->err($ex->getFile() . ' at line: ' . $ex->getLine());
    }

    /**
     * 
     * @return array
     */
    public function getSomeFromDb()
    {
        $select = $this->sql->select();
        try {
            /*
             * Log the SQL string.
             * Sometimes in complex queries we need to quote else the following throws:
             * Notice: Attempting to quote a value without specific driver level support can introduce security vulnerabilities in a production environment. 
             * in /var/www/html/systemgurt/vendor/zendframework/zend-db/src/Adapter/Platform/Sql92.php on line 29
             */
            $this->logger->debug($select->getSqlString($this->adapter->getPlatform()));
            $resultset = $this->selectWith($select);
            if ($resultset->valid() && $resultset->count() > 0) {
                return $resultset->toArray();
            }
        } catch (\RuntimeException $ex) {
            $this->log($ex);
        }
        return [];
    }

}