SICWhere Class Reference
Inherits from | NSObject |
---|---|
Conforms to | SICIAverage SICICount SICIDelete SICIGroupConcat SICIMax SICIMin SICISelect SICISum SICITotal |
Declared in | SICWhere.h SICWhere.m |
– initWithoutReferObject:interfaceName:
Where Constructor
- (id)initWithoutReferObject:(SICEntityDescriptor *const)entitydescriptor interfaceName:(NSString *const)interfacename
Parameters
entitydescriptor |
Entity Descriptor instance |
---|---|
interfacename |
Name of interface |
Discussion
Where Constructor
Declared In
SICWhere.h
– initWithReferObject:interfaceName:referObject:
Where Constructor
- (id)initWithReferObject:(SICEntityDescriptor *const)entitydescriptor interfaceName:(NSString *const)interfacename referObject:(id const)referobject
Parameters
entitydescriptor |
Entity Descriptor instance |
---|---|
interfacename |
Name of interface |
referobject |
Refered Object instance |
Discussion
Where Constructor
Declared In
SICWhere.h
– distinct
Used to specify DISTINCT condition.
- (SICWhere *)distinct
Return Value
Where Where instance object.
Discussion
Used to specify DISTINCT condition.
Declared In
SICWhere.h
– where:
Column name of which condition will be specified.
- (SICClause *)where:(NSString *)columnName
Parameters
columnName |
Name of column. |
---|
Return Value
Clause Clause instance object.
Discussion
Column name of which condition will be specified.
Declared In
SICWhere.h
– whereClause:
Used to provide manually created Where clause, instead of using API’s.
- (SICWhere *)whereClause:(NSString *)whereclause
Parameters
whereclause |
Manually created where clause. |
---|
Return Value
Where Where instance object.
Discussion
Used to provide manually created Where clause, instead of using API’s.
Declared In
SICWhere.h
– and:
Used to specify AND condition between where clause.
- (SICClause *)and:(NSString *)columnName
Parameters
columnName |
Name of column on which condition need to be specified. |
---|
Return Value
Clause instance object.
Discussion
Used to specify AND condition between where clause.
Declared In
SICWhere.h
– or:
Used to specify OR condition between where clause.
- (SICClause *)or:(NSString *)columnName
Parameters
columnName |
Name of column on which condition need to be specified. |
---|
Return Value
Clause Clause instance object.
Discussion
Used to specify OR condition between where clause.
Declared In
SICWhere.h
– orderBy:
Used to specify ORDER BY keyword to sort the result-set.
- (SICWhere *)orderBy:(NSArray *)columnsArray
Parameters
columnsArray |
Name of columns which need to be sorted. |
---|
Return Value
Where Where instance object.
Discussion
Used to specify ORDER BY keyword to sort the result-set.
Declared In
SICWhere.h
– ascendingOrderBy:
Used to specify ORDER BY ASC keyword to sort the result-set in ascending order.
- (SICWhere *)ascendingOrderBy:(NSArray *)columnsArray
Parameters
columnsArray |
Name of columns which need to be sorted. |
---|
Return Value
Where Where instance object.
Discussion
Used to specify ORDER BY ASC keyword to sort the result-set in ascending order.
Declared In
SICWhere.h
– descendingOrderBy:
Used to specify ORDER BY DESC keyword to sort the result-set in descending order.
- (SICWhere *)descendingOrderBy:(NSArray *)columnsArray
Parameters
columnsArray |
Name of columns which need to be sorted. |
---|
Return Value
Where Where instance object.
Discussion
Used to specify ORDER BY DESC keyword to sort the result-set in descending order.
Declared In
SICWhere.h
– limit:
Used to specify the range of data need to fetch from table.
- (SICWhere *)limit:(int)limitValue
Parameters
limitValue |
LIMIT of data. |
---|
Return Value
Where Where instance object.
Discussion
Used to specify the range of data need to fetch from table.
Declared In
SICWhere.h
– groupBy:
Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns.
- (SICClause *)groupBy:(NSArray *)columnsArray
Parameters
columnsArray |
Name of columns. |
---|
Return Value
Where Where instance object.
Discussion
Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns.
Declared In
SICWhere.h
– having:
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.
- (SICWhere *)having:(NSString *)columnName
Parameters
columnName |
Name of column on which condition need to be applied. |
---|
Return Value
Clause Clause instance object.
Discussion
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.
Declared In
SICWhere.h
– havingClause:
Used to provide manually created Where clause, instead of using API’s.
- (SICWhere *)havingClause:(NSString *)havingclause
Parameters
havingclause |
Where clause. |
---|
Return Value
Where Where instance object.
Discussion
Used to provide manually created Where clause, instead of using API’s.
Declared In
SICWhere.h
– column:
Used to add column
- (SICWhere *)column:(NSString *)columnName
Parameters
columnName |
Name of the column |
---|
Return Value
Where Where instance object
Discussion
Used to add column
Declared In
SICWhere.h
– columns:
Used to provide name of columns only for which data will be fetched.
- (SICWhere *)columns:(NSArray *)columnsArray
Parameters
columnsArray |
Name of columns. |
---|
Return Value
Where Where instance object.
Discussion
Used to provide name of columns only for which data will be fetched.
Declared In
SICWhere.h
– delimiter:
Used to provide name of column for which average will be calculated.
- (SICWhere *)delimiter:(NSString *)delimiterString
Parameters
delimiterString |
Name of Delimiter. |
---|
Return Value
Where Where instance object.
Discussion
Used to provide name of column for which average will be calculated.
Declared In
SICWhere.h
– execute
Executes the request
- (id)execute
Return Value
Request Output
Discussion
Executes the request
Declared In
SICWhere.h