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 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

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

buildCompositeInCondition() protected method protected string buildCompositeInCondition ( $indexes, $operator, $columns, $values, &$params )$indexes yii\sphinx\IndexSchema[] List of indexes, which affected by query $operator string The operator to use (e.g. IN or NOT IN) $columns array $values array $params array The binding parameters to be populated return string The generated SQL expression