SelectQuery Class Reference
[Dynamic query builder]

Inheritance diagram for SelectQuery:

[legend]

List of all members.

Public Member Functions
	__construct ()
	__clone ()
	hasAliasInside ($alias)
	getAlias ()
	getName ()
	setName ($name)
	distinct ()
	isDistinct ()
	unDistinct ()
	hasJoinedTable ($table)
	join ($table, LogicalObject $logic, $alias=null)
	leftJoin ($table, LogicalObject $logic, $alias=null)
	setOrderChain (OrderChain $chain)
	orderBy ($field, $table=null)
	prependOrderBy ($field, $table=null)
	desc ()
	asc ()
	groupBy ($field, $table=null)
	having (LogicalObject $exp)
	getLimit ()
	getOffset ()
	limit ($limit=null, $offset=null)
	from ($table, $alias=null)
	get ($field, $alias=null)
	BOVM: achtung!
	multiGet ()
	arrayGet ($array, $prefix=null)
	getFieldsCount ()
	getTablesCount ()
	getFieldNames ()
	toDialectString (Dialect $dialect)
	dropFields ()
	dropOrder ()
Private Member Functions
	getLastTable ($table=null)
	makeOrder ($field, $table=null)
Private Attributes
	$distinct = false
	$name = null
	$joiner = null
	$limit = null
	$offset = null
	$fields = array()
	$order = null
	$group = array()
	$having = null
	$aliases = array()

---

Detailed Description

Definition at line 16 of file SelectQuery.class.php.

---

Constructor & Destructor Documentation

SelectQuery::__construct

(

)

Definition at line 39 of file SelectQuery.class.php.

---

Member Function Documentation

SelectQuery::__clone

(

)

Definition at line 45 of file SelectQuery.class.php.

SelectQuery::hasAliasInside

(

$

alias

)

Definition at line 51 of file SelectQuery.class.php.

SelectQuery::getAlias

(

)

Implements Aliased.

Definition at line 56 of file SelectQuery.class.php.

Referenced by arrayGet(), and getFieldNames().

SelectQuery::getName

(

)

Implements Named.

Definition at line 61 of file SelectQuery.class.php.

Referenced by arrayGet(), and toDialectString().

SelectQuery::setName

(

$

name

)

Returns:

SelectQuery

Implements Named.

Definition at line 69 of file SelectQuery.class.php.

References $name.

SelectQuery::distinct

(

)

Returns:

SelectQuery

Definition at line 80 of file SelectQuery.class.php.

Referenced by Criteria::fillSelectQuery(), isDistinct(), and unDistinct().

SelectQuery::isDistinct

(

)

Definition at line 86 of file SelectQuery.class.php.

References distinct().

Here is the call graph for this function:

SelectQuery::unDistinct

(

)

Returns:

SelectQuery

Definition at line 94 of file SelectQuery.class.php.

References distinct().

Here is the call graph for this function:

SelectQuery::hasJoinedTable

(

$

table

)

Implements JoinCapableQuery.

Definition at line 100 of file SelectQuery.class.php.

SelectQuery::join	(	$	table,
		LogicalObject $	logic,
		$	alias = null
	)

Returns:

SelectQuery

Implements JoinCapableQuery.

Definition at line 108 of file SelectQuery.class.php.

Referenced by Criteria::joinProperties().

SelectQuery::leftJoin	(	$	table,
		LogicalObject $	logic,
		$	alias = null
	)

Returns:

SelectQuery

Implements JoinCapableQuery.

Definition at line 119 of file SelectQuery.class.php.

Referenced by Criteria::joinProperties().

SelectQuery::setOrderChain

(

OrderChain $

chain

)

Returns:

SelectQuery

Definition at line 130 of file SelectQuery.class.php.

Referenced by Criteria::fillSelectQuery().

SelectQuery::orderBy	(	$	field,
		$	table = null
	)

Returns:

SelectQuery

Definition at line 140 of file SelectQuery.class.php.

References makeOrder().

Here is the call graph for this function:

SelectQuery::prependOrderBy	(	$	field,
		$	table = null
	)

Returns:

SelectQuery

Definition at line 150 of file SelectQuery.class.php.

References makeOrder().

Here is the call graph for this function:

SelectQuery::desc

(

)

Exceptions:

WrongStateException

Returns:

SelectQuery

Definition at line 161 of file SelectQuery.class.php.

SelectQuery::asc

(

)

Exceptions:

WrongStateException

Returns:

SelectQuery

Definition at line 175 of file SelectQuery.class.php.

SelectQuery::groupBy	(	$	field,
		$	table = null
	)

Returns:

SelectQuery

Definition at line 188 of file SelectQuery.class.php.

References getLastTable().

Here is the call graph for this function:

SelectQuery::having

(

LogicalObject $

exp

)

Returns:

SelectQuery

Definition at line 202 of file SelectQuery.class.php.

Referenced by toDialectString().

SelectQuery::getLimit

(

)

Definition at line 209 of file SelectQuery.class.php.

References limit().

Here is the call graph for this function:

SelectQuery::getOffset

(

)

Definition at line 214 of file SelectQuery.class.php.

SelectQuery::limit	(	$	limit = null,
		$	offset = null
	)

Exceptions:

WrongArgumentException

Returns:

SelectQuery

Definition at line 223 of file SelectQuery.class.php.

References $limit, $offset, Assert::isInteger(), and Assert::isPositiveInteger().

Referenced by getLimit(), and toDialectString().

Here is the call graph for this function:

SelectQuery::from	(	$	table,
		$	alias = null
	)

Returns:

SelectQuery

Implements JoinCapableQuery.

Definition at line 240 of file SelectQuery.class.php.

SelectQuery::get	(	$	field,
		$	alias = null
	)

BOVM: achtung!

Exceptions:

WrongArgumentException

Returns:

SelectQuery

Definition at line 255 of file SelectQuery.class.php.

References getLastTable().

Referenced by Criteria::joinProperties().

Here is the call graph for this function:

SelectQuery::multiGet

(

)

Returns:

SelectQuery

Definition at line 305 of file SelectQuery.class.php.

References $args.

SelectQuery::arrayGet	(	$	array,
		$	prefix = null
	)

Returns:

SelectQuery

Definition at line 319 of file SelectQuery.class.php.

References getAlias(), and getName().

Here is the call graph for this function:

SelectQuery::getFieldsCount

(

)

Definition at line 354 of file SelectQuery.class.php.

SelectQuery::getTablesCount

(

)

Definition at line 359 of file SelectQuery.class.php.

SelectQuery::getFieldNames

(

)

Definition at line 364 of file SelectQuery.class.php.

References getAlias().

Here is the call graph for this function:

SelectQuery::toDialectString

(

Dialect $

dialect

)

Reimplemented from QuerySkeleton.

Definition at line 381 of file SelectQuery.class.php.

References $group, getName(), having(), Assert::isTrue(), limit(), and Dialect::quoteField().

Here is the call graph for this function:

SelectQuery::dropFields

(

)

Returns:

SelectQuery

Definition at line 437 of file SelectQuery.class.php.

SelectQuery::dropOrder

(

)

Returns:

SelectQuery

Definition at line 446 of file SelectQuery.class.php.

SelectQuery::getLastTable

(

$

table = null

)

[private]

Definition at line 452 of file SelectQuery.class.php.

Referenced by get(), groupBy(), and makeOrder().

SelectQuery::makeOrder	(	$	field,
		$	table = null
	)			[private]

Returns:

OrderBy

Definition at line 463 of file SelectQuery.class.php.

References getLastTable().

Referenced by orderBy(), and prependOrderBy().

Here is the call graph for this function:

---

Member Data Documentation

SelectQuery::$distinct = false [private]

Definition at line 20 of file SelectQuery.class.php.

SelectQuery::$name = null [private]

Definition at line 22 of file SelectQuery.class.php.

Referenced by setName().

SelectQuery::$joiner = null [private]

Definition at line 24 of file SelectQuery.class.php.

SelectQuery::$limit = null [private]

Definition at line 26 of file SelectQuery.class.php.

Referenced by limit().

SelectQuery::$offset = null [private]

Definition at line 27 of file SelectQuery.class.php.

Referenced by limit().

SelectQuery::$fields = array() [private]

Definition at line 29 of file SelectQuery.class.php.

SelectQuery::$order = null [private]

Definition at line 31 of file SelectQuery.class.php.

SelectQuery::$group = array() [private]

Definition at line 33 of file SelectQuery.class.php.

Referenced by toDialectString().

SelectQuery::$having = null [private]

Definition at line 35 of file SelectQuery.class.php.

SelectQuery::$aliases = array() [private]

Definition at line 37 of file SelectQuery.class.php.

---

The documentation for this class was generated from the following file:

• core/OSQL/SelectQuery.class.php