PHP 클래스 yii\elasticsearch\QueryBuilder

부터: 2.0

저자: Carsten Brandt ([email protected])

상속: extends yii\base\Object

공개 프로퍼티들

프로퍼티	타입	설명
$db		the database connection.

메소드	설명
__construct ( Connection $connection, array $config = [] )	Constructor.
build ( Query $query ) : array	Generates query from a Query object.
buildCondition ( string \| array $condition ) : string	Parses the condition specification and generates the corresponding SQL expression.
buildOrderBy ( $columns )	adds order by condition to the query

메소드	설명
buildCompositeInCondition ( $operator, $columns, $values )

메소드	설명
buildAndCondition ( $operator, $operands )
buildBetweenCondition ( $operator, $operands )
buildHalfBoundedRangeCondition ( string $operator, array $operands ) : array	Builds a half-bounded range condition (for "gt", ">", "gte", ">=", "lt", "<", "lte", "<=" operators)
buildHashCondition ( $condition )
buildInCondition ( $operator, $operands )
buildLikeCondition ( $operator, $operands )
buildNotCondition ( $operator, $operands )

Constructor.

public __construct ( Connection $connection, array $config = [] )
$connection	Connection	the database connection.
$config	array	name-value pairs that will be used to initialize the object properties

Generates query from a Query object.

public build ( Query $query ) : array
$query	Query	the [[Query]] object from which the query will be generated
리턴	array	the generated SQL statement (the first array element) and the corresponding parameters to be bound to the SQL statement (the second array element).

protected buildCompositeInCondition ( $operator, $columns, $values )

Parses the condition specification and generates the corresponding SQL expression.

public buildCondition ( string \| array $condition ) : string
$condition	string \| array	the condition specification. Please refer to [[Query::where()]] on how to specify a condition.
리턴	string	the generated SQL expression

adds order by condition to the query

public buildOrderBy ( $columns )

the database connection.

public $db