Exemple #1
0
 /**
  * Special handling for PDO query().
  * All bind parameter names must begin with ':'
  *
  * @param string|Zend_Db_Select $sql The SQL statement with placeholders.
  * @param array $bind An array of data to bind to the placeholders.
  * @return Zend_Db_Statement_Pdo
  * @throws Zend_Db_Adapter_Exception To re-throw PDOException.
  */
 public function query($sql, $bind = array())
 {
     if (empty($bind) && $sql instanceof Zend_Db_Select) {
         $bind = $sql->getBind();
     }
     if (!empty($bind)) {
         foreach ($bind as $name => $value) {
             if ($value instanceof Zend_Date) {
                 $bind[$name] = $value->toString('yyyy-MM-dd HH:mm:ss');
             }
         }
     }
     return parent::query($sql, $bind);
 }
Exemple #2
0
 /**
  * Special handling for PDO query().
  * All bind parameter names must begin with ':'
  *
  * @param string|Zend_Db_Select $sql The SQL statement with placeholders.
  * @param array $bind An array of data to bind to the placeholders.
  * @return Zend_Db_Statement_Pdo
  * @throws Zend_Db_Adapter_Exception To re-throw PDOException.
  */
 public function query($sql, $bind = array())
 {
     if (empty($bind) && $sql instanceof Zend_Db_Select) {
         $bind = $sql->getBind();
     }
     if (is_array($bind)) {
         foreach ($bind as $name => $value) {
             if (!is_int($name) && !preg_match('/^:/', $name)) {
                 $newName = ":{$name}";
                 unset($bind[$name]);
                 $bind[$newName] = $value;
             }
         }
     }
     try {
         return parent::query($sql, $bind);
     } catch (PDOException $e) {
         /**
          * @see Zend_Db_Statement_Exception
          */
         require_once 'Zend/Db/Statement/Exception.php';
         throw new Zend_Db_Statement_Exception($e->getMessage(), $e->getCode(), $e);
     }
 }
Exemple #3
0
 /**
  * Special handling for PDO query().
  * All bind parameter names must begin with ':'
  *
  * @param string|Zend_Db_Select $sql The SQL statement with placeholders.
  * @param array $bind An array of data to bind to the placeholders.
  * @return Zend_Db_Statement_Pdo
  * @throws Zend_Db_Adapter_Exception To re-throw PDOException.
  */
 public function query($sql, $bind = array())
 {
     if (empty($bind) && $sql instanceof Zend_Db_Select) {
         $bind = $sql->getBind();
     }
     if (is_array($bind)) {
         foreach ($bind as $name => $value) {
             if (!is_int($name) && !preg_match('/^:/', $name)) {
                 $newName = ":{$name}";
                 unset($bind[$name]);
                 $bind[$newName] = $value;
             }
         }
     }
     // Bubble_Debug start
     $start = microtime(true);
     $result = parent::query($sql, $bind);
     if (class_exists('Mage')) {
         Mage::dispatchEvent('bubble_debug_sql_query_before', array('adapter' => $this, 'query' => $sql, 'bind' => $bind, 'took' => microtime(true) - $start));
     }
     return $result;
     // Bubble_Debug end
     try {
         return parent::query($sql, $bind);
     } catch (PDOException $e) {
         /**
          * @see Zend_Db_Statement_Exception
          */
         #require_once 'Zend/Db/Statement/Exception.php';
         throw new Zend_Db_Statement_Exception($e->getMessage(), $e->getCode(), $e);
     }
 }