SICICount Protocol Reference

Conforms to NSObject
Declared in SICICount.h

Overview

Exposes API’s to get count of the number of times that X is not NULL in a group.

The count(*)function (with no arguments)returns the total number of rows in the group.

– distinct required method

Used to specify DISTINCT condition.

- (id<SICICount>)distinct

Return Value

SICICount Interface.

Discussion

Used to specify DISTINCT condition.

Declared In

SICICount.h

– where: required method

Column name of which condition will be specified.

- (id<SICICountClause>)where:(NSString *)column

Parameters

column

Name of column.

Return Value

SICICountClause Interface.

Discussion

Column name of which condition will be specified.

Declared In

SICICount.h

– whereClause: required method

Used to provide manually created Where clause, instead of using API’s.

- (id<SICICount>)whereClause:(NSString *)whereClause

Parameters

whereClause

Manually created where clause.

Return Value

SICICount Interface.

Discussion

Used to provide manually created Where clause, instead of using API’s.

Declared In

SICICount.h

– and: required method

Used to specify AND condition between where clause.

- (id<SICICountClause>)and:(NSString *)column

Parameters

column

Name of column on which condition need to be specified.

Return Value

SICICountClause Interface.

Discussion

Used to specify AND condition between where clause.

Declared In

SICICount.h

– or: required method

Used to specify OR condition between where clause.

- (id<SICICountClause>)or:(NSString *)column

Parameters

column

Name of column on which condition need to be specified.

Return Value

SICICountClause Interface.

Discussion

Used to specify OR condition between where clause.

Declared In

SICICount.h

– groupBy: required method

Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns.

- (id<SICICount>)groupBy:(NSArray *)columns

Parameters

columns

Name of columns.

Return Value

SICICount Interface.

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

SICICount.h

– having: required method

Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.

- (id<SICICountClause>)having:(NSString *)column

Parameters

column

Name of column on which condition need to be applied.

Return Value

SICICountClause Interface.

Discussion

Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.

Declared In

SICICount.h

– havingClause: required method

Used to provide manually created Where clause, instead of using API’s.

- (id<SICICount>)havingClause:(NSString *)havingClause

Parameters

havingClause

Where clause.

Return Value

SICICount Interface.

Discussion

Used to provide manually created Where clause, instead of using API’s.

Declared In

SICICount.h

– column: required method

Used to provide name of column for which count will be calculated.

- (id<SICICount>)column:(NSString *)column

Parameters

column

Name of column.

Return Value

SICICount Interface.

Discussion

Used to provide name of column for which count will be calculated.

Declared In

SICICount.h

– execute required method

Used to get count, this method should be called in last to calculate count.

- (id)execute

Return Value

Return count.

Discussion

Used to get count, this method should be called in last to calculate count.

Exceptions

SICDatabaseException

Throws exception if any error occur while calculating count.

Declared In

SICICount.h