PHP SelectInterface::getExpressions方法代码示例

 /**
  * Preprocesses and validates the query.
  *
  * @return bool
  *   TRUE if the validation was successful, FALSE if not.
  *
  * @throws \Drupal\Core\Database\Query\FieldsOverlapException
  * @throws \Drupal\Core\Database\Query\NoFieldsException
  */
 protected function preExecute()
 {
     // Confirm that the user did not try to specify an identical
     // field and default field.
     if (array_intersect($this->insertFields, $this->defaultFields)) {
         throw new FieldsOverlapException('You may not specify the same field to have a value and a schema-default value.');
     }
     if (!empty($this->fromQuery)) {
         // We have to assume that the used aliases match the insert fields.
         // Regular fields are added to the query before expressions, maintain the
         // same order for the insert fields.
         // This behavior can be overridden by calling fields() manually as only the
         // first call to fields() does have an effect.
         $this->fields(array_merge(array_keys($this->fromQuery->getFields()), array_keys($this->fromQuery->getExpressions())));
     } else {
         // Don't execute query without fields.
         if (count($this->insertFields) + count($this->defaultFields) == 0) {
             throw new NoFieldsException('There are no fields available to insert with.');
         }
     }
     // If no values have been added, silently ignore this query. This can happen
     // if values are added conditionally, so we don't want to throw an
     // exception.
     if (!isset($this->insertValues[0]) && count($this->insertFields) > 0 && empty($this->fromQuery)) {
         return FALSE;
     }
     return TRUE;
 }

 public function &getExpressions()
 {
     return $this->query->getExpressions();
 }

 /**
  * Creates a temporary table from a select query.
  *
  * Will return the name of a table containing the item IDs of all results, or
  * FALSE on failure.
  *
  * @param \Drupal\Core\Database\Query\SelectInterface $db_query
  *   The select query whose results should be stored in the temporary table.
  *
  * @return string|false
  *   The name of the temporary table, or FALSE on failure.
  */
 protected function getTemporaryResultsTable(SelectInterface $db_query) {
   // We only need the id field, not the score.
   $fields = &$db_query->getFields();
   unset($fields['score']);
   if (count($fields) != 1 || !isset($fields['item_id'])) {
     $this->getLogger()->warning('Error while adding facets: only "item_id" field should be used, used are: @fields.', array('@fields' => implode(', ', array_keys($fields))));
     return FALSE;
   }
   $expressions = &$db_query->getExpressions();
   $expressions = array();
   $db_query->distinct();
   if (!$db_query->preExecute()) {
     return FALSE;
   }
   $args = $db_query->getArguments();
   return $this->database->queryTemporary((string) $db_query, $args);
 }

 /**
  * Creates a temporary table from a select query.
  *
  * Will return the name of a table containing the item IDs of all results, or
  * FALSE on failure.
  *
  * @param \Drupal\Core\Database\Query\SelectInterface $db_query
  *   The select query whose results should be stored in the temporary table.
  *
  * @return string|false
  *   The name of the temporary table, or FALSE on failure.
  */
 protected function getTemporaryResultsTable(SelectInterface $db_query)
 {
     // We only need the id field, not the score.
     $fields =& $db_query->getFields();
     unset($fields['score']);
     if (count($fields) != 1 || !isset($fields['item_id'])) {
         $this->getLogger()->warning('Error while adding facets: only "item_id" field should be used, used are: @fields.', array('@fields' => implode(', ', array_keys($fields))));
         return FALSE;
     }
     $expressions =& $db_query->getExpressions();
     $expressions = array();
     // If there's a GROUP BY for item_id, we leave that, all others need to be
     // discarded.
     $group_by =& $db_query->getGroupBy();
     $group_by = array_intersect_key($group_by, array('t.item_id' => TRUE));
     $db_query->distinct();
     if (!$db_query->preExecute()) {
         return FALSE;
     }
     $args = $db_query->getArguments();
     try {
         $result = $this->database->queryTemporary((string) $db_query, $args);
     } catch (\PDOException $e) {
         watchdog_exception('search_api', $e, '%type while trying to create a temporary table: @message in %function (line %line of %file).');
         return FALSE;
     }
     return $result;
 }