/**
* 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;
}
