PHP Horde_Db_Adapter::columns方法代码示例

 /**
  */
 public function get($key, $lifetime = 0)
 {
     $okey = $key;
     $key = hash('md5', $key);
     $timestamp = time();
     $maxage = $timestamp - $lifetime;
     /* Build SQL query. */
     $query = 'SELECT cache_data FROM ' . $this->_params['table'] . ' WHERE cache_id = ?';
     $values = array($key);
     // 0 lifetime checks for objects which have no expiration
     if ($lifetime != 0) {
         $query .= ' AND cache_timestamp >= ?';
         $values[] = $maxage;
     }
     try {
         $result = $this->_db->selectValue($query, $values);
         $columns = $this->_db->columns($this->_params['table']);
     } catch (Horde_Db_Exception $e) {
         return false;
     }
     if (!$result) {
         /* No rows were found - cache miss */
         if ($this->_logger) {
             $this->_logger->log(sprintf('Cache miss: %s (Id %s newer than %d)', $okey, $key, $maxage), 'DEBUG');
         }
         return false;
     }
     if ($this->_logger) {
         $this->_logger->log(sprintf('Cache hit: %s (Id %s newer than %d)', $okey, $key, $maxage), 'DEBUG');
     }
     return $columns['cache_data']->binaryToString($result);
 }

 /**
  */
 public function getMetaData($mailbox, $uidvalid, $entries)
 {
     $query = $this->_baseSql($mailbox, self::MD_TABLE);
     $query[0] = 'SELECT t.field, t.data ' . $query[0];
     if (!empty($entries)) {
         $entries[] = 'uidvalid';
         $entry_query = array();
         foreach (array_unique($entries) as $val) {
             $entry_query[] = 't.field = ?';
             $query[1][] = $val;
         }
         $query[0] .= ' AND (' . implode(' OR ', $entry_query) . ')';
     }
     try {
         if ($res = $this->_db->selectAssoc($query[0], $query[1])) {
             $columns = $this->_db->columns(self::MD_TABLE);
             foreach ($res as $key => $val) {
                 switch ($key) {
                     case 'uidvalid':
                         $res[$key] = $columns['data']->binaryToString($val);
                         break;
                     default:
                         $res[$key] = @unserialize($columns['data']->binaryToString($val));
                         break;
                 }
             }
             if (is_null($uidvalid) || !isset($res['uidvalid']) || $res['uidvalid'] == $uidvalid) {
                 return $res;
             }
             $this->deleteMailbox($mailbox);
         }
     } catch (Horde_Db_Exception $e) {
     }
     return array();
 }

 /**
  * Converts results from TEXT columns to strings.
  *
  * @param string $column  A column name.
  * @param mixed $value    A TEXT column value.
  *
  * @return string  The column value as plain string.
  */
 protected function _convertBinary($column, $value)
 {
     try {
         $columns = $this->_db->columns($this->_params['table']);
     } catch (Horde_Db_Exception $e) {
         throw new Horde_Alarm_Exception(Horde_Alarm_Translation::t("Server error when querying database."));
     }
     return $columns[$column]->binaryToString($value);
 }

 /**
  */
 public function get($scope_ob)
 {
     $charset = $this->_db->getOption('charset');
     $query = 'SELECT pref_name, pref_value FROM ' . $this->_params['table'] . ' ' . 'WHERE pref_uid = ? AND pref_scope = ?';
     $values = array($this->_params['user'], $scope_ob->scope);
     try {
         $result = $this->_db->selectAll($query, $values);
         $columns = $this->_db->columns($this->_params['table']);
     } catch (Horde_Db_Exception $e) {
         throw new Horde_Prefs_Exception($e);
     }
     foreach ($result as $row) {
         $name = trim($row['pref_name']);
         $value = $columns['pref_value']->binaryToString($row['pref_value']);
         $scope_ob->set($name, Horde_String::convertCharset($value, $charset, 'UTF-8'));
     }
     return $scope_ob;
 }

 /**
  * Convert clob data to string.
  *
  * @param array &$data  An array of share data.
  */
 protected function _convertClobs(&$data)
 {
     $columns = $this->_db->columns($this->_table);
     foreach ($data as $row => &$value) {
         if (in_array($row, $this->_getClobFields())) {
             $value = $columns[$row]->binaryToString($value);
         }
     }
 }

 /**
  * Attempts to open a connection to the SQL server.
  *
  * @throws Kronolith_Exception
  */
 public function initialize()
 {
     if (empty($this->_params['db'])) {
         throw new InvalidArgumentException('Missing required Horde_Db_Adapter instance');
     }
     try {
         $this->_db = $this->_params['db'];
     } catch (Horde_Exception $e) {
         throw new Kronolith_Exception($e);
     }
     $this->_columns = $this->_db->columns('kronolith_events');
 }

 /**
  */
 protected function _getHash(array $alarm)
 {
     try {
         $columns = $this->_db->columns($this->_params['table']);
     } catch (Horde_Db_Exception $e) {
         throw new Horde_Alarm_Exception(Horde_Alarm_Translation::t("Server error when querying database."));
     }
     $alarm['alarm_params'] = $columns['alarm_params']->binaryToString($alarm['alarm_params']);
     $params = base64_decode($alarm['alarm_params']);
     if (!strlen($params) && strlen($alarm['alarm_params'])) {
         $params = $alarm['alarm_params'];
     }
     return array('id' => $alarm['alarm_id'], 'user' => $alarm['alarm_uid'], 'start' => new Horde_Date($alarm['alarm_start'], 'UTC'), 'end' => empty($alarm['alarm_end']) ? null : new Horde_Date($alarm['alarm_end'], 'UTC'), 'methods' => @unserialize($alarm['alarm_methods']), 'params' => @unserialize($params), 'title' => $this->_fromDriver($alarm['alarm_title']), 'text' => $this->_fromDriver($alarm['alarm_text']), 'snooze' => empty($alarm['alarm_snooze']) ? null : new Horde_Date($alarm['alarm_snooze'], 'UTC'), 'internal' => empty($alarm['alarm_internal']) ? null : @unserialize($alarm['alarm_internal']));
 }

 /**
  */
 public function read($id)
 {
     /* Begin a transaction. */
     // TODO: Rowlocking in Mysql
     if (!$this->_db->transactionStarted()) {
         $this->_db->beginDbTransaction();
     }
     /* Build query. */
     $query = sprintf('SELECT session_data FROM %s WHERE session_id = ?', $this->_params['table']);
     $values = array($id);
     /* Execute the query. */
     try {
         $columns = $this->_db->columns($this->_params['table']);
         return $columns['session_data']->binaryToString($this->_db->selectValue($query, $values));
     } catch (Horde_Db_Exception $e) {
         return '';
     }
 }

 /**
  * Return the sync cache.
  *
  * @param string $devid  The device id.
  * @param string $user   The user id.
  * @param array $fields  An array of fields to return. Default is to return
  *                       the full cache.  @since 2.9.0
  *
  * @return array  The current sync cache for the user/device combination.
  * @throws Horde_ActiveSync_Exception
  */
 public function getSyncCache($devid, $user, array $fields = null)
 {
     $sql = 'SELECT cache_data FROM ' . $this->_syncCacheTable . ' WHERE cache_devid = ? AND cache_user = ?';
     try {
         $data = $this->_db->selectValue($sql, array($devid, $user));
         $columns = $this->_db->columns($this->_syncCacheTable);
         $data = $columns['cache_data']->binaryToString($data);
     } catch (Horde_Db_Exception $e) {
         throw new Horde_ActiveSync_Exception($e);
     }
     if (!($data = unserialize($data))) {
         $data = array('confirmed_synckeys' => array(), 'lasthbsyncstarted' => false, 'lastsyncendnormal' => false, 'timestamp' => false, 'wait' => false, 'hbinterval' => false, 'folders' => array(), 'hierarchy' => false, 'collections' => array(), 'pingheartbeat' => false, 'synckeycounter' => array());
     }
     if (!is_null($fields)) {
         $data = array_intersect_key($data, array_flip($fields));
     }
     return $data;
 }

 protected function _parseRead($blobFields, $result, $dateFields = array())
 {
     $results = array();
     foreach ($result as $row) {
         $entry = array();
         foreach ($row as $field => $val) {
             if (isset($blobFields[$field])) {
                 if (!isset($columns)) {
                     $columns = $this->_db->columns($this->_params['table']);
                 }
                 $entry[$field] = $columns[$field]->binaryToString($val);
             } elseif (isset($dateFields[$field]) && !empty($val)) {
                 $d = new Horde_Date($val);
                 $entry[$field] = $this->_convertFromDriver($d->strftime($GLOBALS['attributes'][array_search($field, $this->map)]['params']['format_in']));
             } else {
                 $entry[$field] = $this->_convertFromDriver($val);
             }
         }
         $results[] = $entry;
     }
     return $results;
 }

 /**
  * Returns a list of Ansel_Images of the most recently added images for the
  * current user.
  *
  * @param array $galleries  An array of gallery ids to search in. If
  *                          left empty, will search all galleries
  *                          with Horde_Perms::SHOW.
  * @param integer $limit    The maximum number of images to return
  * @param string $slugs     An array of gallery slugs.
  * @param string $where     Additional where clause
  *
  * @return array An array of Ansel_Image objects
  * @throws Ansel_Exception
  */
 public function getRecentImages(array $galleries = array(), $limit = 10, array $slugs = array())
 {
     $results = array();
     if (!count($galleries) && !count($slugs)) {
         // Don't need the Ansel_Gallery object, so save some resources and
         // only query the share system.
         foreach ($this->_shares->listShares($GLOBALS['registry']->getAuth()) as $share) {
             $galleries[] = $share->getId();
         }
         if (empty($galleries)) {
             return array();
         }
     }
     if (!count($slugs)) {
         // Searching by gallery_id
         $sql = 'SELECT ' . $this->_getImageFields() . ' FROM ansel_images ' . 'WHERE gallery_id IN (' . str_repeat('?, ', count($galleries) - 1) . '?) ';
         $criteria = $galleries;
     } elseif (count($slugs)) {
         // Searching by gallery_slug so we need to join the share table
         $sql = 'SELECT ' . $this->_getImageFields() . ' FROM ansel_images LEFT JOIN ' . $this->_shares->getTable() . ' ON ansel_images.gallery_id = ' . $this->_shares->getTable() . '.share_id ' . 'WHERE attribute_slug IN (' . str_repeat('?, ', count($slugs) - 1) . '?) ';
         $criteria = $slugs;
     }
     $sql .= ' ORDER BY image_uploaded_date DESC';
     if ($limit > 0) {
         $sql = $this->_db->addLimitOffset($sql, array('limit' => (int) $limit));
     }
     try {
         $images = $this->_db->select($sql, $criteria);
     } catch (Horde_Db_Exception $e) {
         throw new Ansel_Exception($e);
     }
     $columns = $this->_db->columns('ansel_images');
     foreach ($images as $image) {
         $image['image_filename'] = Horde_String::convertCharset($image['image_filename'], $GLOBALS['conf']['sql']['charset'], 'UTF-8');
         $image['image_caption'] = Horde_String::convertCharset($columns['image_caption']->binaryToString($image['image_caption']), $GLOBALS['conf']['sql']['charset'], 'UTF-8');
         $results[] = new Ansel_Image($image);
     }
     return $results;
 }