QQueryBuilder Class Reference

Inherits QBaseClass.

Inherited by QPartialQueryBuilder.

Collaboration diagram for QQueryBuilder:

[legend]

List of all members.

Public Member Functions

• AddSelectItem ($strTableName, $strColumnName, $strFullAlias)
• AddSelectFunction ($strFunctionName, $strColumnName, $strFullAlias)
• AddFromItem ($strTableName)
• GetTableAlias ($strTableName)
• AddJoinItem ($strJoinTableName, $strJoinTableAlias, $strTableName, $strColumnName, $strLinkedColumnName, QQCondition $objJoinCondition=null)
• AddJoinCustomItem ($strJoinTableName, $strJoinTableAlias, QQCondition $objJoinCondition)
• AddJoinCustomSqlItem ($strSql)
• AddWhereItem ($strItem)
• AddOrderByItem ($strItem)
• AddGroupByItem ($strItem)
• SetLimitInfo ($strLimitInfo)
• SetDistinctFlag ()
• SetCountOnlyFlag ()
• SetVirtualNode ($strName, QQSubQueryNode $objNode)
• GetVirtualNode ($strName)
• AddExpandAsArrayNode ($objNode)
• __construct (QDatabaseBase $objDatabase, $strRootTableName)
• GetStatement ()
• __get ($strName)

Protected Attributes

• $strSelectArray
• $strColumnAliasArray
• $intColumnAliasCount = 0
• $strTableAliasArray
• $intTableAliasCount = 0
• $strFromArray
• $strJoinArray
• $strJoinConditionArray
• $strWhereArray
• $strOrderByArray
• $strGroupByArray
• $objVirtualNodeArray
• $strLimitInfo
• $blnDistinctFlag
• $strExpandAsArrayNodes
• $blnCountOnlyFlag
• $objDatabase
• $strRootTableName
• $strEscapeIdentifierBegin
• $strEscapeIdentifierEnd

---

Constructor & Destructor Documentation

QQueryBuilder::__construct	(	QDatabaseBase $	objDatabase,
		$	strRootTableName
	)

References $strRootTableName.

---

Member Function Documentation

QQueryBuilder::__get

(

$

strName

)

Override method to perform a property "Get" This will get the value of $strName All inhereted objects that call __get() should always fall through to calling parent::__get() in a try/catch statement catching for CallerExceptions.

Parameters:

string

$strName Name of the property to get

Returns:

mixed the returned property

Reimplemented from QBaseClass.

References QCallerException::IncrementOffset().

QQueryBuilder::AddExpandAsArrayNode

(

$

objNode

)

Referenced by QQExpandAsArray::UpdateQueryBuilder().

QQueryBuilder::AddFromItem

(

$

strTableName

)

References GetTableAlias().

QQueryBuilder::AddGroupByItem

(

$

strItem

)

Referenced by QQGroupBy::UpdateQueryBuilder().

QQueryBuilder::AddJoinCustomItem	(	$	strJoinTableName,
		$	strJoinTableAlias,
		QQCondition $	objJoinCondition
	)

References GetTableAlias(), QQCondition::GetWhereClause(), and QCallerException::IncrementOffset().

QQueryBuilder::AddJoinCustomSqlItem

(

$

strSql

)

QQueryBuilder::AddJoinItem	(	$	strJoinTableName,
		$	strJoinTableAlias,
		$	strTableName,
		$	strColumnName,
		$	strLinkedColumnName,
		QQCondition $	objJoinCondition = null
	)

References GetTableAlias(), and QCallerException::IncrementOffset().

Referenced by QQAssociationNode::GetColumnAlias(), QQReverseReferenceNode::GetColumnAlias(), QQNode::GetColumnAlias(), QQAssociationNode::GetColumnAliasHelper(), QQReverseReferenceNode::GetColumnAliasHelper(), and QQNode::GetColumnAliasHelper().

QQueryBuilder::AddOrderByItem

(

$

strItem

)

Referenced by QQOrderBy::UpdateQueryBuilder().

QQueryBuilder::AddSelectFunction	(	$	strFunctionName,
		$	strColumnName,
		$	strFullAlias
	)

Referenced by QQAggregationClause::UpdateQueryBuilder(), and QQExpandVirtualNode::UpdateQueryBuilder().

QQueryBuilder::AddSelectItem	(	$	strTableName,
		$	strColumnName,
		$	strFullAlias
	)

References GetTableAlias().

QQueryBuilder::AddWhereItem

(

$

strItem

)

Referenced by QQConditionNotEqual::UpdateQueryBuilder(), QQConditionEqual::UpdateQueryBuilder(), QQConditionNotBetween::UpdateQueryBuilder(), QQConditionBetween::UpdateQueryBuilder(), QQConditionNotLike::UpdateQueryBuilder(), QQConditionLike::UpdateQueryBuilder(), QQConditionNotIn::UpdateQueryBuilder(), QQConditionIn::UpdateQueryBuilder(), QQConditionIsNotNull::UpdateQueryBuilder(), QQConditionIsNull::UpdateQueryBuilder(), QQConditionComparison::UpdateQueryBuilder(), QQConditionNot::UpdateQueryBuilder(), QQConditionLogical::UpdateQueryBuilder(), QQConditionNone::UpdateQueryBuilder(), and QQConditionAll::UpdateQueryBuilder().

QQueryBuilder::GetStatement

(

)

QQueryBuilder::GetTableAlias

(

$

strTableName

)

Referenced by AddFromItem(), AddJoinCustomItem(), AddJoinItem(), AddSelectItem(), and QQNode::GetColumnAlias().

QQueryBuilder::GetVirtualNode

(

$

strName

)

Referenced by QQVirtualNode::GetColumnAlias().

QQueryBuilder::SetCountOnlyFlag

(

)

QQueryBuilder::SetDistinctFlag

(

)

Referenced by QQDistinct::UpdateQueryBuilder().

QQueryBuilder::SetLimitInfo

(

$

strLimitInfo

)

References $strLimitInfo.

Referenced by QQLimitInfo::UpdateQueryBuilder().

QQueryBuilder::SetVirtualNode	(	$	strName,
		QQSubQueryNode $	objNode
	)

Referenced by QQVirtualNode::GetColumnAlias().

---

Member Data Documentation

QQueryBuilder::$blnCountOnlyFlag [protected]

QQueryBuilder::$blnDistinctFlag [protected]

QQueryBuilder::$intColumnAliasCount = 0 [protected]

QQueryBuilder::$intTableAliasCount = 0 [protected]

QQueryBuilder::$objDatabase [protected]

QQueryBuilder::$objVirtualNodeArray [protected]

QQueryBuilder::$strColumnAliasArray [protected]

QQueryBuilder::$strEscapeIdentifierBegin [protected]

QQueryBuilder::$strEscapeIdentifierEnd [protected]

QQueryBuilder::$strExpandAsArrayNodes [protected]

QQueryBuilder::$strFromArray [protected]

QQueryBuilder::$strGroupByArray [protected]

QQueryBuilder::$strJoinArray [protected]

QQueryBuilder::$strJoinConditionArray [protected]

QQueryBuilder::$strLimitInfo [protected]

Referenced by SetLimitInfo().

QQueryBuilder::$strOrderByArray [protected]

QQueryBuilder::$strRootTableName [protected]

Referenced by __construct().

QQueryBuilder::$strSelectArray [protected]

QQueryBuilder::$strTableAliasArray [protected]

QQueryBuilder::$strWhereArray [protected]

---

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

• qcodo/_core/framework/QQuery.class.php