SICClause Class Reference

Inherits from	NSObject
Conforms to	SICIAverageClause SICICountClause SICIDeleteClause SICIGroupConcatClause SICIMaxClause SICIMinClause SICISelectClause SICISumClause SICITotalClause
Declared in	SICClause.h SICClause.m

Overview

It is used to create where clause used in database query. It implements all the Clauses which are used to in the where clause.

`– initWithWhereClass:`

Clause Constructor

- (id)initWithWhereClass:(SICWhere *)whereClass

Parameters

`whereClass`	Where class

Discussion

Clause Constructor

Declared In

SICClause.h

`– addCol:`

Add column

- (void)addCol:(NSString *)column

Parameters

`column`	Name of column

Discussion

Add column

Declared In

SICClause.h

`– equalTo:`

Used to specify EQUAL TO (=)condition.

- (SICWhere *)equalTo:(id)value

Parameters

`value`	Value for which EQUAL TO (=)condition will be applied.

Return Value

Where object.

Discussion

Used to specify EQUAL TO (=)condition.

Declared In

SICClause.h

`– notEqualTo:`

Used to specify NOT EQUAL TO (!=)condition.

- (SICWhere *)notEqualTo:(id)value

Parameters

`value`	Value for which NOT EQUAL TO (=)condition will be applied.

Return Value

Where object.

Discussion

Used to specify NOT EQUAL TO (!=)condition.

Declared In

SICClause.h

`– greaterThan:`

Used to specify GREATER THAN (>)condition.

- (SICWhere *)greaterThan:(id)value

Parameters

`value`	Value for while GREATER THAN (>)condition will be specified.

Return Value

Where object.

Discussion

Used to specify GREATER THAN (>)condition.

Declared In

SICClause.h

`– greaterThanEqual:`

Used to specify GREATER THAN EQUAL (>=)condition.

- (SICWhere *)greaterThanEqual:(id)value

Parameters

`value`	Value for which GREATER THAN EQUAL (>=)condition will be specified.

Return Value

Where object.

Discussion

Used to specify GREATER THAN EQUAL (>=)condition.

Declared In

SICClause.h

`– lessThan:`

Used to specify LESS THAN (<)condition.

- (SICWhere *)lessThan:(id)value

Parameters

`value`	Value for which LESS THAN (<)condition will be specified.

Return Value

Where object.

Discussion

Used to specify LESS THAN (<)condition.

Declared In

SICClause.h

`– lessThanEqual:`

Used to specify LESS THAN EQUAL (<=)condition.

- (SICWhere *)lessThanEqual:(id)value

Parameters

`value`	Value for which LESS THAN EQUAL (<=)condition will be specified.

Return Value

Where object.

Discussion

Used to specify LESS THAN EQUAL (<=)condition.

Declared In

SICClause.h

`– between:end:`

Used to specify BETWEEN condition.

- (SICWhere *)between:(id)start end:(id)end

Parameters

`start`	Start Range.
`end`	End Range.

Return Value

Where object.

Discussion

Used to specify BETWEEN condition.

Declared In

SICClause.h

`– like:`

Used to specify LIKE condition.

- (SICWhere *)like:(id)like

Parameters

`like`	LIKE condition.

Return Value

Where object.

Discussion

Used to specify LIKE condition.

Declared In

SICClause.h

`– in:`

Used to specify IN condition.

- (SICWhere *)in:(NSArray *)values

Parameters

`values`	Values for IN condition.

Return Value

Where object.

Discussion

Used to specify IN condition.

Declared In

SICClause.h

`– and:`

Used to specify AND condition between where clause.

- (void)and:(NSString *)column

Parameters

`column`	Name of column on which condition need to be specified.

Discussion

Used to specify AND condition between where clause.

Declared In

SICClause.h

`– or:`

Used to specify OR condition between where clause.

- (void)or:(NSString *)column

Parameters

`column`	Name of column on which condition need to be specified.

Discussion

Used to specify OR condition between where clause.

Declared In

SICClause.h

`– toString`

It returns the where clause.

- (NSString *)toString

Return Value

String where clause.

Discussion

It returns the where clause.

Declared In

SICClause.h