コード例 #1
0
 /**
  * Inserts a table row with specified data.
  *
  * @param EhrlichAndreas_AbstractCms_Abstract_Adapter_Abstract|EhrlichAndreas_Db_Adapter_Abstract|Zend_Db_Adapter_Abstract $adapter
  * @param string $table
  * @param array $param
  *            Column-value pairs.
  * @param string $returnAsString
  *            Return the computed query as string.
  * @return int number of affected rows.
  * @throws Exception
  */
 public function insert($adapter, $table, $params = array(), $returnAsString = false)
 {
     $db = EhrlichAndreas_AbstractCms_Abstract_Model::getConnection($adapter);
     if (is_string($params)) {
         $query = $params;
     } elseif (!EhrlichAndreas_Util_Object::isInstanceOf($params, 'EhrlichAndreas_Db_Insert')) {
         $query = new EhrlichAndreas_Db_Insert($db);
         foreach ($params as $key => $value) {
             $escape = true;
             if (is_array($value)) {
                 if (array_key_exists('escape', $value) && !is_null($value['escape'])) {
                     $escape = $value['escape'];
                 } elseif (count($value) == 2 && array_key_exists(0, $value) && array_key_exists(1, $value) && !is_null($value[1]) && is_bool($value[1])) {
                     $escape = $value[1];
                 }
                 if (isset($value['value'])) {
                     $value = $value['value'];
                 } elseif (array_key_exists(0, $value)) {
                     $value = $value[0];
                 } else {
                     $value = array_shift($value);
                 }
             } elseif (is_object($value) && method_exists($value, '__toString')) {
                 $value = $value->__toString();
                 $escape = false;
             }
             $escape = (bool) intval($escape);
             if (!$escape) {
                 $value = new EhrlichAndreas_Db_Expr($value);
             }
             $query->insert($key, $value);
         }
     } else {
         $query = $params;
     }
     if (!is_string($query)) {
         $query->into($table);
         $query = $query->assemble();
     }
     if ($returnAsString) {
         return $query;
     }
     $stmt = $db->query($query);
     $return = $db->lastInsertId($table);
     $stmt->closeCursor();
     return $return;
 }
コード例 #2
0
 /**
  * 
  * @param Zend_Db_Adapter_Abstract $dbAdapter
  * @param string $tableVersion
  * @param string $version
  * @return type
  */
 protected function _setVersion($dbAdapter, $tableVersion, $version = 0)
 {
     $query = new EhrlichAndreas_Db_Insert($dbAdapter);
     $query->into($tableVersion);
     $query->insert('num', $version);
     $sql = $query->assemble();
     try {
         $stmt = $dbAdapter->query($sql);
         $result = $stmt->rowCount();
     } catch (Exception $e) {
         $result = false;
     }
     if ($result) {
         $this->version = $version;
     }
     return $result;
 }