Inherits from NSObject
Declared in KNYQuery.h

Overview

Query builder class

Tasks

Instance Methods

SetDistinct:

Sets the distinct clause to the query

- (id)SetDistinct:(BOOL)isDistinct

Parameters

isDistinct

isDistinct

Return Value

current instance of KNYQuery chaining the calls

Discussion

Sets the distinct clause to the query

Declared In

KNYQuery.h

addGroupByColumn:

Adds the group by columns to the query

- (id)addGroupByColumn:(NSArray *)columns

Parameters

columns

columns

Return Value

current instance of KNYQuery chaining the calls

Discussion

Adds the group by columns to the query

Declared In

KNYQuery.h

addOrderByColumn:

Adds the order by clause to the query

- (id)addOrderByColumn:(NSArray *)columns

Parameters

columns

columns

Return Value

current instance of KNYQuery chaining the calls

Discussion

Adds the order by clause to the query

Declared In

KNYQuery.h

addOrderByColumnDescending:

Adds the order by descending clause to the query

- (id)addOrderByColumnDescending:(NSArray *)columns

Parameters

columns

columns

Return Value

current instance of KNYQuery chaining the calls

Discussion

Adds the order by descending clause to the query

Declared In

KNYQuery.h

addSelectColumn:

Sets the column names to be selected. If this method is not called by the user then all the columns will be retrieved.

- (id)addSelectColumn:(NSArray *)columns

Parameters

columns

arrayOfColumnNames

Return Value

current instance of KNYQuery chaining the calls

Discussion

Sets the column names to be selected. If this method is not called by the user then all the columns will be retrieved.

Declared In

KNYQuery.h

addWhereClause:

Sets the where clause to the query

- (id)addWhereClause:(NSString *)whereClause

Parameters

whereClause

whereClause

Return Value

current instance of KNYQuery chaining the calls

Discussion

Sets the where clause to the query

Declared In

KNYQuery.h

from:

Sets the table name

- (id)from:(NSString *)tableName

Parameters

tableName

tableName

Return Value

current instance of KNYQuery chaining the calls

Discussion

Sets the table name

Declared In

KNYQuery.h

init

- (id)init

initWithSyncObject:

Query builder class

- (id)initWithSyncObject:(Class)knyClass

Parameters

knySyncObj

KNYSyncObject

Return Value

instance of KNYQuery

Discussion

Query builder class

Declared In

KNYQuery.h

prepareSQL

Prepares the SQL from the Query parameters

- (NSString *)prepareSQL

Return Value

sql query

Discussion

Prepares the SQL from the Query parameters

Declared In

KNYQuery.h

setHavingClause:

Sets the having clause to the query

- (id)setHavingClause:(NSString *)havingClause

Parameters

havingClause

havingClause

Return Value

current instance of KNYQuery chaining the calls

Discussion

Sets the having clause to the query

Declared In

KNYQuery.h

setLimit:

Sets the limit to the query

- (id)setLimit:(int)limit

Parameters

limit

limit

Return Value

current instance of KNYQuery chaining the calls

Discussion

Sets the limit to the query

Declared In

KNYQuery.h

setOffset:

Sets the offset to the query

- (id)setOffset:(int)offset

Parameters

offset

offset

Return Value

current instance of KNYQuery chaining the calls

Discussion

Sets the offset to the query

Declared In

KNYQuery.h

syncObject

returns class for corresponding SyncObject

- (Class)syncObject

Return Value

Class of corresponding SyncObject

Discussion

returns class for corresponding SyncObject

Declared In

KNYQuery.h