#include <sbSQLWhereBuilder.h>

Inheritance diagram for sbSQLWhereBuilder:

Collaboration diagram for sbSQLWhereBuilder:

Public Member Functions
NS_DECL_ISUPPORTS_INHERITED NS_DECL_SBISQLWHEREBUILDER	sbSQLWhereBuilder ()

virtual	~sbSQLWhereBuilder ()

Public Member Functions inherited from sbSQLBuilderBase
NS_DECL_ISUPPORTS NS_DECL_SBISQLBUILDER	sbSQLBuilderBase ()

virtual	~sbSQLBuilderBase ()

Public Member Functions inherited from sbISQLBuilder
void	addJoin (in unsigned long aJoinType, in AString aJoinedTableName, in AString aJoinedTableAlias, in AString aJoinedColumnName, in AString aJoinToTableName, in AString aJoinToColumnName)
	Add a join to the query. More...

void	addJoinWithIndexHint (in unsigned long aJoinType, in AString aJoinedTableName, in AString aJoinedTableAlias, in AString aJoinedColumnName, in AString aJoinToTableName, in AString aJoinToColumnName, in boolean aRequiresFromTableIndexHint, in boolean aRequiresToTableIndexHint)
	Add a join to the query. More...

void	addSubqueryJoin (in unsigned long aJoinType, in sbISQLSelectBuilder aJoinedSubquery, in AString aJoinedTableAlias, in AString aJoinedColumnName, in AString aJoinToTableName, in AString aJoinToColumnName)
	Add a subquery join join to the query. More...

void	addJoinWithCriterion (in unsigned long aJoinType, in AString aJoinedTableName, in AString aJoinedTableAlias, in sbISQLBuilderCriterion aCriterion)
	Add a join to the query with a critera object specifcying the join constraints. More...

void	addSubquery (in sbISQLSelectBuilder aSubquery, in AString aAlias)
	Add a subquery to the from clause. More...

void	reset ()
	Clears out query configuration to this instance can be reused. More...

AString	toString ()
	Return the generated SQL statement for the query. More...

Public Member Functions inherited from sbISQLWhereBuilder
void	addCriterion (in sbISQLBuilderCriterion aCriterion)
	Add a criteria constraint to the query. More...

void	removeCriterion (in sbISQLBuilderCriterion aCriterion)
	Remve a criteria constraint from the query. More...

sbISQLBuilderCriterion	createMatchCriterionString (in AString aTableName, in AString aSrcColumnName, in unsigned long aMatchType, in AString aValue)
	Create a match criterion with an AString datatype. More...

sbISQLBuilderCriterion	createMatchCriterionBetweenString (in AString aTableName, in AString aSrcColumnName, in AString aLeftValue, in AString aRightValue)

sbISQLBuilderCriterion	createMatchCriterionNotBetweenString (in AString aTableName, in AString aSrcColumnName, in AString aLeftValue, in AString aRightValue)

sbISQLBuilderCriterion	createMatchCriterionLong (in AString aTableName, in AString aSrcColumnName, in unsigned long aMatchType, in long aValue)
	Create a match criterion with a long (32 bit) datatype. More...

sbISQLBuilderCriterion	createMatchCriterionLongLong (in AString aTableName, in AString aSrcColumnName, in unsigned long aMatchType, in long long aValue)
	Create a match criterion with a long long (64 bit) datatype. More...

sbISQLBuilderCriterion	createMatchCriterionNull (in AString aTableName, in AString aSrcColumnName, in unsigned long aMatchType)
	Create a match criterion that tests against the null value. More...

sbISQLBuilderCriterion	createMatchCriterionTable (in AString aLeftTableName, in AString aLeftColumnName, in unsigned long aMatchType, in AString aRightTableName, in AString aRightColumnName)
	Create a match criterion that tests against a table column. More...

sbISQLBuilderCriterionIn	createMatchCriterionIn (in AString aTableName, in AString aSrcColumnName)
	Create a match criterion using the IN() operator. More...

sbISQLBuilderCriterion	createMatchCriterionParameter (in AString aTableName, in AString aSrcColumnName, in unsigned long aMatchType)
	Create a match criterion that tests against a parameter placeholder. More...

sbISQLBuilderCriterion	createAndCriterion (in sbISQLBuilderCriterion aLeft, in sbISQLBuilderCriterion aRight)
	Create a match criterion that is the logical AND of two critera. More...

sbISQLBuilderCriterion	createOrCriterion (in sbISQLBuilderCriterion aLeft, in sbISQLBuilderCriterion aRight)
	Create a match criterion that is the logical OR of two critera. More...

Protected Member Functions
NS_IMETHOD	Reset ()

nsresult	AppendWhere (nsAString &aBuffer)

Protected Attributes
nsCOMArray < sbISQLBuilderCriterion >	mCritera

Protected Attributes inherited from sbSQLBuilderBase
PRInt32	mLimit

PRBool	mLimitIsParameter

PRInt32	mOffset

PRBool	mOffsetIsParameter

nsTArray< sbJoinInfo >	mJoins

nsTArray< sbSubqueryInfo >	mSubqueries

Additional Inherited Members
Public Attributes inherited from sbISQLBuilder
const unsigned long	MATCH_EQUALS = 0

const unsigned long	MATCH_NOTEQUALS = 1

const unsigned long	MATCH_GREATER = 2

const unsigned long	MATCH_GREATEREQUAL = 3

const unsigned long	MATCH_LESS = 4

const unsigned long	MATCH_LESSEQUAL = 5

const unsigned long	MATCH_LIKE = 6

const unsigned long	MATCH_NOTLIKE = 7

const unsigned long	MATCH_MATCH = 8

attribute long	limit
	Value for the limit clause. More...

attribute boolean	limitIsParameter
	Is the limit clause a parameter? More...

attribute long	offset
	Value for the offset clause. More...

attribute boolean	offsetIsParameter
	Is the offset clause a parameter? More...

const unsigned long	JOIN_INNER = 0

const unsigned long	JOIN_LEFT = 1

const unsigned long	JOIN_LEFT_OUTER = 2

Detailed Description

Definition at line 37 of file sbSQLWhereBuilder.h.

Constructor & Destructor Documentation

NS_DECL_ISUPPORTS_INHERITED NS_DECL_SBISQLWHEREBUILDER sbSQLWhereBuilder::sbSQLWhereBuilder ( )

sbSQLWhereBuilder::~sbSQLWhereBuilder ( )

virtual

Definition at line 40 of file sbSQLWhereBuilder.cpp.

Member Function Documentation

nsresult sbSQLWhereBuilder::AppendWhere ( nsAString & aBuffer )

protected

Definition at line 263 of file sbSQLWhereBuilder.cpp.

Here is the caller graph for this function:

NS_IMETHODIMP sbSQLWhereBuilder::Reset ( )

protected

Definition at line 255 of file sbSQLWhereBuilder.cpp.

Here is the caller graph for this function:

Member Data Documentation

nsCOMArray<sbISQLBuilderCriterion> sbSQLWhereBuilder::mCritera

protected

Definition at line 51 of file sbSQLWhereBuilder.h.

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

/home/martin/dev/nightingale-hacking/components/sqlbuilder/src/sbSQLWhereBuilder.h
/home/martin/dev/nightingale-hacking/components/sqlbuilder/src/sbSQLWhereBuilder.cpp

Public Member Functions

Protected Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation