PHP 클래스 Neos\Flow\Persistence\Doctrine\Query

상속: implements Neos\Flow\Persistence\QueryInterface
파일 보기 프로젝트 열기: neos/flow-development-collection 1 사용 예제들

보호된 프로퍼티들

프로퍼티 타입 설명
$cacheResult boolean
$constraint mixed
$distinct boolean
$entityClassName string
$entityManager Doctrine\ORM\EntityManager
$joinAliasCounter integer
$joins array
$limit integer
$offset integer
$orderings array
$parameterIndex integer
$parameters array
$queryBuilder Doctrine\ORM\QueryBuilder
$settings array
$systemLogger Neos\Flow\Log\SystemLoggerInterface

공개 메소드들

메소드 설명
__clone ( ) Cloning the query clones also the internal QueryBuilder, as they are tightly coupled.
__construct ( string $entityClassName )
__sleep ( ) : array We need to drop the query builder, as it contains a PDO instance deep inside.
__wakeup ( ) : void Recreate query builder and set state again.
addParameters ( array $parameters ) : void Add parameters to the query
contains ( string $propertyName, mixed $operand ) : object Returns a "contains" criterion used for matching objects against a query.
count ( ) : integer Returns the query result count
equals ( string $propertyName, mixed $operand, boolean $caseSensitive = true ) : object Returns an equals criterion used for matching objects against a query.
execute ( boolean $cacheResult = false ) : Neos\Flow\Persistence\QueryResultInterface Executes the query and returns the result.
getConstraint ( ) : Neos\Flow\Persistence\Generic\Qom\Constraint Gets the constraint for this query.
getLimit ( ) : integer Returns the maximum size of the result set to limit.
getOffset ( ) : integer Returns the start offset of the result set.
getOrderings ( ) : array Returns the property names to order the result by, like this: array( 'foo' => \Neos\Flow\Persistence\QueryInterface::ORDER_ASCENDING, 'bar' => \Neos\Flow\Persistence\QueryInterface::ORDER_DESCENDING )
getParameters ( ) : array Gets all defined query parameters for the query being constructed.
getQueryBuilder ( ) : Doctrine\ORM\QueryBuilder
getResult ( ) : array Gets the results of this query as array.
getSql ( ) : array Return the SQL statements representing this Query.
getType ( ) : string Returns the type this query cares for.
greaterThan ( string $propertyName, mixed $operand ) : object Returns a greater than criterion used for matching objects against a query
greaterThanOrEqual ( string $propertyName, mixed $operand ) : object Returns a greater than or equal criterion used for matching objects against a query
in ( string $propertyName, mixed $operand ) : object Returns an "in" criterion used for matching objects against a query. It matches if the property's value is contained in the multivalued operand.
injectEntityManager ( Doctrine\Common\Persistence\ObjectManager $entityManager ) : void
injectSettings ( array $settings ) : void Injects the Flow settings, the persistence part is kept for further use.
isDistinct ( ) : boolean Returns the DISTINCT flag for this query.
isEmpty ( string $propertyName ) : boolean Returns an "isEmpty" criterion used for matching objects against a query.
lessThan ( string $propertyName, mixed $operand ) : object Returns a less than criterion used for matching objects against a query
lessThanOrEqual ( string $propertyName, mixed $operand ) : object Returns a less or equal than criterion used for matching objects against a query
like ( string $propertyName, string $operand, boolean $caseSensitive = true ) : object Returns a like criterion used for matching objects against a query.
logicalAnd ( mixed $constraint1 ) : object Performs a logical conjunction of the two given constraints. The method takes one or more constraints and concatenates them with a boolean AND.
logicalNot ( object $constraint ) : object Performs a logical negation of the given constraint
logicalOr ( mixed $constraint1 ) : object Performs a logical disjunction of the two given constraints. The method takes one or more constraints and concatenates them with a boolean OR.
matching ( object $constraint ) : Neos\Flow\Persistence\QueryInterface The constraint used to limit the result set. Returns $this to allow for chaining (fluid interface)
setDistinct ( boolean $distinct = true ) : Neos\Flow\Persistence\QueryInterface Sets the DISTINCT flag for this query.
setLimit ( integer $limit ) : Neos\Flow\Persistence\QueryInterface Sets the maximum size of the result set to limit. Returns $this to allow for chaining (fluid interface)
setOffset ( integer $offset ) : Neos\Flow\Persistence\QueryInterface Sets the start offset of the result set to offset. Returns $this to allow for chaining (fluid interface)
setOrderings ( array $orderings ) : Neos\Flow\Persistence\QueryInterface Sets the property names to order the result by. Expected like this: array( 'foo' => \Neos\Flow\Persistence\QueryInterface::ORDER_ASCENDING, 'bar' => \Neos\Flow\Persistence\QueryInterface::ORDER_DESCENDING )

보호된 메소드들

메소드 설명
getParamNeedle ( mixed $operand ) : string Get a needle for parameter binding.
getPropertyNameWithAlias ( string $propertyPath ) : string Adds left join clauses along the given property path to the query, if needed.

메소드 상세

__clone() 공개 메소드

Cloning the query clones also the internal QueryBuilder, as they are tightly coupled.
public __clone ( )

__construct() 공개 메소드

public __construct ( string $entityClassName )
$entityClassName string

__sleep() 공개 메소드

We need to drop the query builder, as it contains a PDO instance deep inside.
public __sleep ( ) : array
리턴 array

__wakeup() 공개 메소드

Recreate query builder and set state again.
public __wakeup ( ) : void
리턴 void

addParameters() 공개 메소드

Add parameters to the query
public addParameters ( array $parameters ) : void
$parameters array
리턴 void

contains() 공개 메소드

It matches if the multivalued property contains the given operand. If NULL is given as $operand, there will never be a match!
public contains ( string $propertyName, mixed $operand ) : object
$propertyName string The name of the multivalued property to compare against
$operand mixed The value to compare with
리턴 object

count() 공개 메소드

Returns the query result count
public count ( ) : integer
리턴 integer The query result count

equals() 공개 메소드

It matches if the $operand equals the value of the property named $propertyName. If $operand is NULL a strict check for NULL is done. For strings the comparison can be done with or without case-sensitivity. Note: case-sensitivity is only possible if the database supports it. E.g. if you are using MySQL with a case-insensitive collation you will not be able to test for case-sensitive equality (the other way around works, because we compare lowercased values).
public equals ( string $propertyName, mixed $operand, boolean $caseSensitive = true ) : object
$propertyName string The name of the property to compare against
$operand mixed The value to compare with
$caseSensitive boolean Whether the equality test should be done case-sensitive for strings
리턴 object

execute() 공개 메소드

Executes the query and returns the result.
public execute ( boolean $cacheResult = false ) : Neos\Flow\Persistence\QueryResultInterface
$cacheResult boolean If the Doctrine result cache should be used
리턴 Neos\Flow\Persistence\QueryResultInterface The query result

getConstraint() 공개 메소드

Gets the constraint for this query.
public getConstraint ( ) : Neos\Flow\Persistence\Generic\Qom\Constraint
리턴 Neos\Flow\Persistence\Generic\Qom\Constraint the constraint, or null if none

getLimit() 공개 메소드

Returns the maximum size of the result set to limit.
public getLimit ( ) : integer
리턴 integer

getOffset() 공개 메소드

Returns the start offset of the result set.
public getOffset ( ) : integer
리턴 integer

getOrderings() 공개 메소드

Returns the property names to order the result by, like this: array( 'foo' => \Neos\Flow\Persistence\QueryInterface::ORDER_ASCENDING, 'bar' => \Neos\Flow\Persistence\QueryInterface::ORDER_DESCENDING )
public getOrderings ( ) : array
리턴 array

getParamNeedle() 보호된 메소드

Get a needle for parameter binding.
protected getParamNeedle ( mixed $operand ) : string
$operand mixed
리턴 string

getParameters() 공개 메소드

Gets all defined query parameters for the query being constructed.
public getParameters ( ) : array
리턴 array

getPropertyNameWithAlias() 보호된 메소드

This enables us to set conditions on related objects.
protected getPropertyNameWithAlias ( string $propertyPath ) : string
$propertyPath string The path to a sub property, e.g. property.subProperty.foo, or a simple property name
리턴 string The last part of the property name prefixed by the used join alias, if joins have been added

getQueryBuilder() 공개 메소드

public getQueryBuilder ( ) : Doctrine\ORM\QueryBuilder
리턴 Doctrine\ORM\QueryBuilder

getResult() 공개 메소드

Really executes the query on the database. This should only ever be executed from the QueryResult class.
public getResult ( ) : array
리턴 array result set

getSql() 공개 메소드

Return the SQL statements representing this Query.
public getSql ( ) : array
리턴 array

getType() 공개 메소드

Returns the type this query cares for.
public getType ( ) : string
리턴 string

greaterThan() 공개 메소드

Returns a greater than criterion used for matching objects against a query
public greaterThan ( string $propertyName, mixed $operand ) : object
$propertyName string The name of the property to compare against
$operand mixed The value to compare with
리턴 object

greaterThanOrEqual() 공개 메소드

Returns a greater than or equal criterion used for matching objects against a query
public greaterThanOrEqual ( string $propertyName, mixed $operand ) : object
$propertyName string The name of the property to compare against
$operand mixed The value to compare with
리턴 object

in() 공개 메소드

Returns an "in" criterion used for matching objects against a query. It matches if the property's value is contained in the multivalued operand.
public in ( string $propertyName, mixed $operand ) : object
$propertyName string The name of the property to compare against
$operand mixed The value to compare with, multivalued
리턴 object

injectEntityManager() 공개 메소드

public injectEntityManager ( Doctrine\Common\Persistence\ObjectManager $entityManager ) : void
$entityManager Doctrine\Common\Persistence\ObjectManager
리턴 void

injectSettings() 공개 메소드

Injects the Flow settings, the persistence part is kept for further use.
public injectSettings ( array $settings ) : void
$settings array
리턴 void

isDistinct() 공개 메소드

Returns the DISTINCT flag for this query.
public isDistinct ( ) : boolean
리턴 boolean

isEmpty() 공개 메소드

It matches if the multivalued property contains no values or is NULL.
public isEmpty ( string $propertyName ) : boolean
$propertyName string The name of the multivalued property to compare against
리턴 boolean

lessThan() 공개 메소드

Returns a less than criterion used for matching objects against a query
public lessThan ( string $propertyName, mixed $operand ) : object
$propertyName string The name of the property to compare against
$operand mixed The value to compare with
리턴 object

lessThanOrEqual() 공개 메소드

Returns a less or equal than criterion used for matching objects against a query
public lessThanOrEqual ( string $propertyName, mixed $operand ) : object
$propertyName string The name of the property to compare against
$operand mixed The value to compare with
리턴 object

like() 공개 메소드

Matches if the property named $propertyName is like the $operand, using standard SQL wildcards.
public like ( string $propertyName, string $operand, boolean $caseSensitive = true ) : object
$propertyName string The name of the property to compare against
$operand string The value to compare with
$caseSensitive boolean Whether the matching should be done case-sensitive
리턴 object

logicalAnd() 공개 메소드

It also accepts a single array of constraints to be concatenated.
public logicalAnd ( mixed $constraint1 ) : object
$constraint1 mixed The first of multiple constraints or an array of constraints.
리턴 object

logicalNot() 공개 메소드

Performs a logical negation of the given constraint
public logicalNot ( object $constraint ) : object
$constraint object Constraint to negate
리턴 object

logicalOr() 공개 메소드

It also accepts a single array of constraints to be concatenated.
public logicalOr ( mixed $constraint1 ) : object
$constraint1 mixed The first of multiple constraints or an array of constraints.
리턴 object

matching() 공개 메소드

The constraint used to limit the result set. Returns $this to allow for chaining (fluid interface)
public matching ( object $constraint ) : Neos\Flow\Persistence\QueryInterface
$constraint object Some constraint, depending on the backend
리턴 Neos\Flow\Persistence\QueryInterface

setDistinct() 공개 메소드

Sets the DISTINCT flag for this query.
public setDistinct ( boolean $distinct = true ) : Neos\Flow\Persistence\QueryInterface
$distinct boolean
리턴 Neos\Flow\Persistence\QueryInterface

setLimit() 공개 메소드

Sets the maximum size of the result set to limit. Returns $this to allow for chaining (fluid interface)
public setLimit ( integer $limit ) : Neos\Flow\Persistence\QueryInterface
$limit integer
리턴 Neos\Flow\Persistence\QueryInterface

setOffset() 공개 메소드

Sets the start offset of the result set to offset. Returns $this to allow for chaining (fluid interface)
public setOffset ( integer $offset ) : Neos\Flow\Persistence\QueryInterface
$offset integer
리턴 Neos\Flow\Persistence\QueryInterface

setOrderings() 공개 메소드

Sets the property names to order the result by. Expected like this: array( 'foo' => \Neos\Flow\Persistence\QueryInterface::ORDER_ASCENDING, 'bar' => \Neos\Flow\Persistence\QueryInterface::ORDER_DESCENDING )
public setOrderings ( array $orderings ) : Neos\Flow\Persistence\QueryInterface
$orderings array The property names to order by
리턴 Neos\Flow\Persistence\QueryInterface

프로퍼티 상세

$cacheResult 보호되어 있는 프로퍼티

protected bool $cacheResult
리턴 boolean

$constraint 보호되어 있는 프로퍼티

protected mixed $constraint
리턴 mixed

$distinct 보호되어 있는 프로퍼티

protected bool $distinct
리턴 boolean

$entityClassName 보호되어 있는 프로퍼티

protected string $entityClassName
리턴 string

$entityManager 보호되어 있는 프로퍼티

protected EntityManager,Doctrine\ORM $entityManager
리턴 Doctrine\ORM\EntityManager

$joinAliasCounter 보호되어 있는 프로퍼티

protected int $joinAliasCounter
리턴 integer

$joins 보호되어 있는 프로퍼티

protected array $joins
리턴 array

$limit 보호되어 있는 프로퍼티

protected int $limit
리턴 integer

$offset 보호되어 있는 프로퍼티

protected int $offset
리턴 integer

$orderings 보호되어 있는 프로퍼티

protected array $orderings
리턴 array

$parameterIndex 보호되어 있는 프로퍼티

protected int $parameterIndex
리턴 integer

$parameters 보호되어 있는 프로퍼티

protected array $parameters
리턴 array

$queryBuilder 보호되어 있는 프로퍼티

protected QueryBuilder,Doctrine\ORM $queryBuilder
리턴 Doctrine\ORM\QueryBuilder

$settings 보호되어 있는 프로퍼티

protected array $settings
리턴 array

$systemLogger 보호되어 있는 프로퍼티

protected SystemLoggerInterface,Neos\Flow\Log $systemLogger
리턴 Neos\Flow\Log\SystemLoggerInterface