#include <sbSQLInsertBuilder.h>

Inheritance diagram for sbSQLInsertBuilder:

Collaboration diagram for sbSQLInsertBuilder:

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_SBISQLINSERTBUILDER NS_IMETHOD	ToString (nsAString &_retval)

NS_IMETHOD	Reset ()

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 sbISQLInsertBuilder
void	addColumn (in AString aColumnName)
	Add a column to the insert list. More...

void	addValueString (in AString aValue)
	Add a string value to the value list. More...

void	addValueLong (in long aValue)
	Add a long value to the value list. More...

void	addValueNull ()
	Add a null to the value list. More...

void	addValueParameter ()
	Add a parameter to the value list. More...

void	addValueRaw (in AString aValue)
	Add a raw string the value list. Note that this does not do any escaping of the value so please only use this if you know what you are doing. 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 sbISQLInsertBuilder
attribute AString	intoTableName
	Table to insert into. More...

attribute sbISQLSelectBuilder	select
	Select statement to use as the source of data for the insert. This can be used in place of the value list. More...

Protected Attributes inherited from sbSQLBuilderBase
PRInt32	mLimit

PRBool	mLimitIsParameter

PRInt32	mOffset

PRBool	mOffsetIsParameter

nsTArray< sbJoinInfo >	mJoins

nsTArray< sbSubqueryInfo >	mSubqueries

Detailed Description

Definition at line 36 of file sbSQLInsertBuilder.h.

Member Function Documentation

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

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

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

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

NS_IMETHOD sbSQLInsertBuilder::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 42 of file sbSQLInsertBuilder.h.

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

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

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

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

NS_DECL_ISUPPORTS_INHERITED NS_IMETHOD sbSQLInsertBuilder::GetLimit ( PRInt32 * aLimit )

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

NS_IMETHOD sbSQLInsertBuilder::GetLimitIsParameter ( PRBool * aLimitIsParameter )

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

NS_IMETHOD sbSQLInsertBuilder::GetOffset ( PRInt32 * aOffset )

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

NS_IMETHOD sbSQLInsertBuilder::GetOffsetIsParameter ( PRBool * aOffsetIsParameter )

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

NS_IMETHODIMP sbSQLInsertBuilder::Reset ( )

Definition at line 130 of file sbSQLInsertBuilder.cpp.

NS_IMETHOD sbSQLInsertBuilder::SetLimit ( PRInt32 aLimit )

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

NS_IMETHOD sbSQLInsertBuilder::SetLimitIsParameter ( PRBool aLimitIsParameter )

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

NS_IMETHOD sbSQLInsertBuilder::SetOffset ( PRInt32 aOffset )

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

NS_IMETHOD sbSQLInsertBuilder::SetOffsetIsParameter ( PRBool aOffsetIsParameter )

inline

Definition at line 42 of file sbSQLInsertBuilder.h.

NS_IMETHODIMP sbSQLInsertBuilder::ToString ( nsAString & _retval )

Definition at line 139 of file sbSQLInsertBuilder.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/sbSQLInsertBuilder.h
/home/martin/dev/nightingale-hacking/components/sqlbuilder/src/sbSQLInsertBuilder.cpp

Public Member Functions

Additional Inherited Members

Detailed Description

Member Function Documentation