Re: [fw-db] Adding SQL and bound parameters info to a DB exception?

You've already looked at Zend_Db_Profiler?

On Fri, Sep 4, 2009 at 8:00 AM, william0275 <nabble@metayer.info> wrote:

At work we use bound parameters a lot. Not the basic string replacement like
('client_id = ?', 12) but like (client_id = :CLIENT_ID, 12) then it's
prepared on the server and executed, thus using the database server prepared
query mecanism.

The problem with this is that, by default, when you get a DB exception, you
only get the SQL and the :VALUE1, :VALUE2 but you don't know what those
values are, and it makes it very hard to test in a SQL console. I came up
with my own Db_Statement_Pdo but I was wondering if there were any built-in
support for what I'm trying to do? I also created a DB exception that can
hold an SQL statement and a list of params. If there's any built-in
functionality in the framework, I'd like to bypass this class, but do I have
any other choice?

Here's the class:

<?php
class MyCompany_Db_Statement_Pdo extends Zend_Db_Statement_Pdo {
   private $sql = null;

   /**
    * Binds a value to a parameter.
    *
    * @param mixed $parameter Name the parameter, either integer or string.
    * @param mixed $value     Scalar value to bind to the parameter.
    * @param mixed $type      OPTIONAL Datatype of the parameter.
    * @return bool
    * @throws Zend_Db_Statement_Exception
    */
   public function bindValue($parameter, $value, $type = null) {
       $this->_bindParam[$parameter] = $value;
       return parent::bindValue($parameter, $value, $type);
   }

   /**
    * Prepare a string SQL statement and create a statement object.
    *
    * @param string $sql
    * @return void
    * @throws Zend_Db_Statement_Exception
    */
   protected function _prepare($sql) {
       $this->sql = $sql;
       return parent::_prepare($sql);
   }

   /**
    * Executes a prepared statement.
    *
    * @param array $params OPTIONAL Values to bind to parameter
placeholders.
    * @return bool
    */
   public function execute(array $params = null) {
       if (is_array($params)) {
           $this->_bindParam = $params;
       }
       try {
           return parent::execute($params);
       }
       catch (Exception $e) {
           $exDb = new MyCompany_Db_Exception($e->getMessage(),
$e->getCode());
           $exDb->setArrayBindValues($this->_bindParam);
           $exDb->setSqlQuery($this->sql);
           throw $exDb;
       }
   }
}
?>
--
View this message in context: http://www.nabble.com/Adding-SQL-and-bound-parameters-info-to-a-DB-exception--tp25296021p25296021.html
Sent from the Zend DB mailing list archive at Nabble.com.