sphinx\QueryBuilder buildWhere()

buildWhere() public method public string buildWhere ( $indexes, $condition, &$params, $match = null )$indexes string[] List of index names, which affected by query $condition string|array $params array The binding parameters to be populated $match string|yii\db\Expression|null return string The WHERE clause built from \yii\sphinx\query.

sphinx\QueryBuilder buildWithin()

buildWithin() public method public string buildWithin ( $columns )$columns array return string The ORDER BY clause built from \yii\sphinx\query.

sphinx\QueryBuilder callSnippets()

callSnippets() public method Builds a SQL statement for call snippet from provided data and query, using specified index settings. public string callSnippets ( $index, $source, $match, $options, &$params )$index string Name of the index, from which to take the text processing settings. $source string|array Is the source data to extract a snippet from. It could be either a single string or array of strings. $match string The full-text query to build snippets for. $options array

sphinx\QueryBuilder buildSelect()

buildSelect() public method public string buildSelect ( $columns, &$params, $distinct = false, $selectOption = null )$columns array $params array The binding parameters to be populated $distinct boolean $selectOption string return string The SELECT clause built from \yii\sphinx\query.

sphinx\QueryBuilder buildShowMeta()

buildShowMeta() protected method Builds SHOW META query. protected string buildShowMeta ( $showMeta, &$params )$showMeta boolean|string|yii\db\Expression Show meta specification. $params array The binding parameters to be populated return string SHOW META query, if it does not required - empty string.

sphinx\QueryBuilder buildSimpleCondition()

buildSimpleCondition() public method Creates an SQL expressions like "column" operator value. public string buildSimpleCondition ( $indexes, $operator, $operands, &$params )$indexes yii\sphinx\IndexSchema[] List of indexes, which affected by query $operator string The operator to use. Anything could be used e.g. >, <=, etc. $operands array Contains two column names. $params array The binding parameters to be populated return string The generated SQL expression throws

sphinx\QueryBuilder buildOrderByAndLimit()

buildOrderByAndLimit() public method Builds the ORDER BY and LIMIT/OFFSET clauses and appends them to the given SQL. public string buildOrderByAndLimit ( $sql, $orderBy, $limit, $offset )$sql string The existing SQL (without ORDER BY/LIMIT/OFFSET) $orderBy array The order by columns. See yii\sphinx\Query::orderBy() for more details on how to specify this parameter. $limit integer The limit number. See yii\sphinx\Query::limit() for more details. $offset integer The offset number. Se

sphinx\QueryBuilder buildOption()

buildOption() public method public string buildOption ( $options, &$params )$options array Query options in format: optionName => optionValue $params array The binding parameters to be populated return string The OPTION clause build from \yii\sphinx\query

sphinx\QueryBuilder buildOrderBy()

buildOrderBy() public method public string buildOrderBy ( $columns )$columns array return string The ORDER BY clause built from \yii\sphinx\query.

sphinx\QueryBuilder buildMatch()

buildMatch() public method public string buildMatch ( $match, &$params )$match string|yii\db\Expression|yii\sphinx\MatchExpression Match condition $params array The binding parameters to be populated return string Generated MATCH expression