sphinx\QueryBuilder callKeywords()

callKeywords() public method Builds a SQL statement for returning tokenized and normalized forms of the keywords, and, optionally, keyword statistics. public string callKeywords ( $index, $text, $fetchStatistic, &$params )$index string The name of the index from which to take the text processing settings $text string The text to break down to keywords. $fetchStatistic boolean Whether to return document and hit occurrence statistics $params array The binding parameters that will

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 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 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 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 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 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 buildOrderBy()

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

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 buildNotCondition()

buildNotCondition() public method Inverts an SQL expressions with NOT operator. public string buildNotCondition ( $indexes, $operator, $operands, &$params )$indexes yii\sphinx\IndexSchema[] List of indexes, which affected by query $operator string The operator to use for connecting the given operands $operands array The SQL expressions to connect. $params array The binding parameters to be populated return string The generated SQL expression throws yii\base\InvalidParamExce