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

sphinx\QueryBuilder buildLimit()

buildLimit() public method public string buildLimit ( $limit, $offset )$limit integer $offset integer return string The LIMIT and OFFSET clauses built from \yii\sphinx\query.

sphinx\QueryBuilder buildLikeCondition()

buildLikeCondition() public method Creates an SQL expressions with the LIKE operator. public string buildLikeCondition ( $indexes, $operator, $operands, &$params )$indexes yii\sphinx\IndexSchema[] List of indexes, which affected by query $operator string The operator to use (e.g. LIKE, NOT LIKE, OR LIKE or OR NOT LIKE) $operands array An array of two or three operands The first operand is the column name. The second operand is a single value or an array of values that column val

sphinx\QueryBuilder buildInCondition()

buildInCondition() public method Creates an SQL expressions with the IN operator. public string buildInCondition ( $indexes, $operator, $operands, &$params )$indexes yii\sphinx\IndexSchema[] List of indexes, which affected by query $operator string The operator to use (e.g. IN or NOT IN) $operands array The first operand is the column name. If it is an array a composite IN condition will be generated. The second operand is an array of values that column value should be among. If

sphinx\QueryBuilder buildHaving()

buildHaving() public method public string buildHaving ( $indexes, $condition, &$params )$indexes string[] List of index names, which affected by query $condition string|array $params array The binding parameters to be populated return string The HAVING clause built from yii\sphinx\Query::$having.

sphinx\QueryBuilder buildHashCondition()

buildHashCondition() public method Creates a condition based on column-value pairs. public string buildHashCondition ( $indexes, $condition, &$params )$indexes yii\sphinx\IndexSchema[] List of indexes, which affected by query $condition array The condition specification. $params array The binding parameters to be populated return string The generated SQL expression

sphinx\QueryBuilder buildGroupBy()

buildGroupBy() public method public string buildGroupBy ( $columns, $limit )$columns array Group columns $limit integer Group limit return string The GROUP BY clause

sphinx\QueryBuilder buildFrom()

buildFrom() public method public string buildFrom ( $indexes, &$params )$indexes array $params array The binding parameters to be populated return string The FROM clause built from \yii\sphinx\query.

sphinx\QueryBuilder buildFacets()

buildFacets() protected method protected string buildFacets ( $facets, &$params )$facets array Facet specifications $params array The binding parameters to be populated return string The FACET clause build from \yii\sphinx\query throws yii\base\InvalidConfigException on invalid facet specification.

sphinx\QueryBuilder buildCondition()

buildCondition() public method Parses the condition specification and generates the corresponding SQL expression. public string buildCondition ( $indexes, $condition, &$params )$indexes yii\sphinx\IndexSchema[] List of indexes, which affected by query $condition string|array The condition specification. Please refer to yii\sphinx\Query::where() on how to specify a condition. $params array The binding parameters to be populated return string The generated SQL expression thro