sbSQLBuilderBase Class Reference

#include <sbSQLBuilderBase.h>

Inheritance diagram for sbSQLBuilderBase:
[legend]
Collaboration diagram for sbSQLBuilderBase:
[legend]

Classes

struct  sbColumnInfo
 
struct  sbJoinInfo
 
struct  sbSubqueryInfo
 

Public Member Functions

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...
 

Protected Attributes

PRInt32 mLimit
 
PRBool mLimitIsParameter
 
PRInt32 mOffset
 
PRBool mOffsetIsParameter
 
nsTArray< sbJoinInfomJoins
 
nsTArray< sbSubqueryInfomSubqueries
 

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 54 of file sbSQLBuilderBase.h.

Constructor & Destructor Documentation

sbSQLBuilderBase::sbSQLBuilderBase ( )

Definition at line 36 of file sbSQLBuilderBase.cpp.

sbSQLBuilderBase::~sbSQLBuilderBase ( )
virtual

Definition at line 45 of file sbSQLBuilderBase.cpp.

Member Data Documentation

nsTArray<sbJoinInfo> sbSQLBuilderBase::mJoins
protected

Definition at line 94 of file sbSQLBuilderBase.h.

PRInt32 sbSQLBuilderBase::mLimit
protected

Definition at line 90 of file sbSQLBuilderBase.h.

PRBool sbSQLBuilderBase::mLimitIsParameter
protected

Definition at line 91 of file sbSQLBuilderBase.h.

PRInt32 sbSQLBuilderBase::mOffset
protected

Definition at line 92 of file sbSQLBuilderBase.h.

PRBool sbSQLBuilderBase::mOffsetIsParameter
protected

Definition at line 93 of file sbSQLBuilderBase.h.

nsTArray<sbSubqueryInfo> sbSQLBuilderBase::mSubqueries
protected

Definition at line 95 of file sbSQLBuilderBase.h.


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