Interface for building INSERT statements. More...
import"sbISQLBuilder.idl";
Public Member Functions | |
| 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... | |
 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 Attributes | |
| 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... | |
| 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 |
Interface for building INSERT statements.
Definition at line 375 of file sbISQLBuilder.idl.
| void sbISQLInsertBuilder::addColumn | ( | in AString | aColumnName | ) |
Add a column to the insert list.
| aColumnName | The name of the column to add to the list |
| void sbISQLInsertBuilder::addValueLong | ( | in long | aValue | ) |
Add a long value to the value list.
| aValue | Long value to add |
| void sbISQLInsertBuilder::addValueNull | ( | ) |
Add a null to the value list.
| void sbISQLInsertBuilder::addValueParameter | ( | ) |
Add a parameter to the value list.
| void sbISQLInsertBuilder::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.
| void sbISQLInsertBuilder::addValueString | ( | in AString | aValue | ) |
Add a string value to the value list.
| aValue | String value to add |
| attribute AString sbISQLInsertBuilder::intoTableName |
Table to insert into.
Definition at line 415 of file sbISQLBuilder.idl.
| attribute sbISQLSelectBuilder sbISQLInsertBuilder::select |
Select statement to use as the source of data for the insert. This can be used in place of the value list.
Definition at line 421 of file sbISQLBuilder.idl.
