#include <sbSQLUpdateBuilder.h>

Inheritance diagram for sbSQLUpdateBuilder:

Collaboration diagram for sbSQLUpdateBuilder:

Public Member Functions
NS_DECL_ISUPPORTS_INHERITED NS_IMETHOD	GetLimit (PRInt32 *aLimit)

NS_IMETHOD	SetLimit (PRInt32 aLimit)

NS_IMETHOD	GetLimitIsParameter (PRBool *aLimitIsParameter)

NS_IMETHOD	SetLimitIsParameter (PRBool aLimitIsParameter)

NS_IMETHOD	GetOffset (PRInt32 *aOffset)

NS_IMETHOD	SetOffset (PRInt32 aOffset)

NS_IMETHOD	GetOffsetIsParameter (PRBool *aOffsetIsParameter)

NS_IMETHOD	SetOffsetIsParameter (PRBool aOffsetIsParameter)

NS_IMETHOD	AddJoin (PRUint32 aJoinType, const nsAString &aJoinedTableName, const nsAString &aJoinedTableAlias, const nsAString &aJoinedColumnName, const nsAString &aJoinToTableName, const nsAString &aJoinToColumnName)

NS_IMETHOD	AddJoinWithIndexHint (PRUint32 aJoinType, const nsAString &aJoinedTableName, const nsAString &aJoinedTableAlias, const nsAString &aJoinedColumnName, const nsAString &aJoinToTableName, const nsAString &aJoinToColumnName, PRBool aRequiresFromTableIndexHint, PRBool aRequiresToTableIndexHint)

NS_IMETHOD	AddSubqueryJoin (PRUint32 aJoinType, sbISQLSelectBuilder *aJoinedSubquery, const nsAString &aJoinedTableAlias, const nsAString &aJoinedColumnName, const nsAString &aJoinToTableName, const nsAString &aJoinToColumnName)

NS_IMETHOD	AddJoinWithCriterion (PRUint32 aJoinType, const nsAString &aJoinedTableName, const nsAString &aJoinedTableAlias, sbISQLBuilderCriterion *aCriterion)

NS_IMETHOD	AddSubquery (sbISQLSelectBuilder *aSubquery, const nsAString &aAlias)

NS_DECL_SBISQLUPDATEBUILDER NS_IMETHOD	ToString (nsAString &_result)

NS_IMETHOD	Reset ()

	sbSQLUpdateBuilder ()

Public Member Functions inherited from sbSQLWhereBuilder
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...

Public Member Functions inherited from sbISQLUpdateBuilder
void	addAssignmentString (in AString aColumnName, in AString aValue)
	Add a string assignment to the set clause. More...

void	addAssignmentParameter (in AString aColumnName)
	Add a parameter assignment to the set clause. More...

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

Public Attributes inherited from sbISQLUpdateBuilder
attribute AString	tableName
	Table to update. More...

Protected Member Functions inherited from sbSQLWhereBuilder
NS_IMETHOD	Reset ()

nsresult	AppendWhere (nsAString &aBuffer)

Protected Attributes inherited from sbSQLWhereBuilder
nsCOMArray < sbISQLBuilderCriterion >	mCritera

Protected Attributes inherited from sbSQLBuilderBase
PRInt32	mLimit

PRBool	mLimitIsParameter

PRInt32	mOffset

PRBool	mOffsetIsParameter

nsTArray< sbJoinInfo >	mJoins

nsTArray< sbSubqueryInfo >	mSubqueries

Detailed Description

Definition at line 38 of file sbSQLUpdateBuilder.h.

Constructor & Destructor Documentation

sbSQLUpdateBuilder::sbSQLUpdateBuilder ( )

Member Function Documentation

NS_IMETHOD sbSQLUpdateBuilder::AddJoin	(	PRUint32	aJoinType,
		const nsAString &	aJoinedTableName,
		const nsAString &	aJoinedTableAlias,
		const nsAString &	aJoinedColumnName,
		const nsAString &	aJoinToTableName,
		const nsAString &	aJoinToColumnName
	)

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHOD sbSQLUpdateBuilder::AddJoinWithCriterion	(	PRUint32	aJoinType,
		const nsAString &	aJoinedTableName,
		const nsAString &	aJoinedTableAlias,
		sbISQLBuilderCriterion *	aCriterion
	)

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHOD sbSQLUpdateBuilder::AddJoinWithIndexHint	(	PRUint32	aJoinType,
		const nsAString &	aJoinedTableName,
		const nsAString &	aJoinedTableAlias,
		const nsAString &	aJoinedColumnName,
		const nsAString &	aJoinToTableName,
		const nsAString &	aJoinToColumnName,
		PRBool	aRequiresFromTableIndexHint,
		PRBool	aRequiresToTableIndexHint
	)

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHOD sbSQLUpdateBuilder::AddSubquery	(	sbISQLSelectBuilder *	aSubquery,
		const nsAString &	aAlias
	)

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHOD sbSQLUpdateBuilder::AddSubqueryJoin	(	PRUint32	aJoinType,
		sbISQLSelectBuilder *	aJoinedSubquery,
		const nsAString &	aJoinedTableAlias,
		const nsAString &	aJoinedColumnName,
		const nsAString &	aJoinToTableName,
		const nsAString &	aJoinToColumnName
	)

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_DECL_ISUPPORTS_INHERITED NS_IMETHOD sbSQLUpdateBuilder::GetLimit ( PRInt32 * aLimit )

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHOD sbSQLUpdateBuilder::GetLimitIsParameter ( PRBool * aLimitIsParameter )

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHOD sbSQLUpdateBuilder::GetOffset ( PRInt32 * aOffset )

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHOD sbSQLUpdateBuilder::GetOffsetIsParameter ( PRBool * aOffsetIsParameter )

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHODIMP sbSQLUpdateBuilder::Reset ( )

Definition at line 78 of file sbSQLUpdateBuilder.cpp.

Here is the call graph for this function:

NS_IMETHOD sbSQLUpdateBuilder::SetLimit ( PRInt32 aLimit )

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHOD sbSQLUpdateBuilder::SetLimitIsParameter ( PRBool aLimitIsParameter )

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHOD sbSQLUpdateBuilder::SetOffset ( PRInt32 aOffset )

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHOD sbSQLUpdateBuilder::SetOffsetIsParameter ( PRBool aOffsetIsParameter )

inline

Definition at line 43 of file sbSQLUpdateBuilder.h.

NS_IMETHODIMP sbSQLUpdateBuilder::ToString ( nsAString & _result )

Definition at line 87 of file sbSQLUpdateBuilder.cpp.

Here is the call graph for this function:

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

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

Public Member Functions

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation