SIHDatabaseHandler Class Reference

Inherits from NSObject
Conforms to SIHIAdapter
Declared in SIHDatabaseHandler.h
SIHDatabaseHandler.m

Overview

It handles all request related to database. LIKE: save, update, saveOrUpdate, delete.

– save:

Handles Database Save Request From Hybrid.

- (void)save:(NSString *)data

Parameters

data

Data Need To Be Save In Database. @throws DatabaseException If any exception occur while saving data in Database.

Discussion

Handles Database Save Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– update:

Handles Database Update Request From Hybrid.

- (void)update:(NSString *)data

Parameters

data

Data Need To Be Update In Database. @throws DatabaseException If any exception occur while updating data in Database.

Discussion

Handles Database Update Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– saveOrUpdate:

Handles Database Save Or Update Request From Hybrid.

- (void)saveOrUpdate:(NSString *)data

Parameters

data

Data Need To Be Save Or Update In Database. @throws DatabaseException If any exception occur while saving or updating data in Database.

Discussion

Handles Database Save Or Update Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– delete:whereClause:data:

Handles Database Delete Request From Hybrid.

- (void)delete:(NSString *)className whereClause:(NSString *)whereClause data:(NSString *)data

Parameters

className

Hybrid Model Class Name of which delete request is sent.
whereClause

Based on which tuple will be deleted from table.
data

Data Need To Be Delete In Database. @throws DatabaseException If any exception occur while deleting data in Database.

Discussion

Handles Database Delete Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– select:distinct:whereClause:columnNames:groupBys:havingClause:orderBy:whichOrderBy:limit:

Handles Database Select Request From Hybrid.

- (NSString *)select:(NSString *)className distinct:(NSString *)distinct whereClause:(NSString *)whereClause columnNames:(NSEnumerator *)columnNames groupBys:(NSEnumerator *)groupBys havingClause:(NSString *)havingClause orderBy:(NSEnumerator *)orderBy whichOrderBy:(NSString *)whichOrderBy limit:(NSString *)limit

Parameters

className

Hybrid Model Function Name.
distinct

Distinct tuples need to be fetched or not.
whereClause

Where Clause based on which tuples will be fetched from table.
columnNames

Name of Columns for which data needs to be fetched.
havingClause

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

Used to specify ORDER BY keyword to sort the result-set.
whichOrderBy

Used to specify ORDER BY ASC OR DESC keyword to sort the result-set in ascending order.
limit

Used to specify the range of data need to fetch from table.
groupBy

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

Return Value

Return Tuples Fetched From Table. @throws DatabaseException If any exception occur while selecting data in Database.

Discussion

Handles Database Select Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– beginTransaction:

Handles Database Begin Transaction Request From Hybrid.

- (void)beginTransaction:(NSString *)databaseDescriptorName

Parameters

databaseDescriptorName

Name of Database Descriptor. @throws DatabaseException If any exception occur while beginning transaction.

Discussion

Handles Database Begin Transaction Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– commitTransaction:

Handles Database Commit Transaction Request From Hybrid.

- (void)commitTransaction:(NSString *)databaseDescriptorName

Parameters

databaseDescriptorName

Name of Database Descriptor. @throws DatabaseException If any error occur while committing transaction.

Discussion

Handles Database Commit Transaction Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– endTransaction:

Handles Database End Transaction Request From Hybrid.

- (void)endTransaction:(NSString *)databaseDescriptorName

Parameters

databaseDescriptorName

Name of Database Descriptor. @throws DatabaseException If any error occur while ending transaction.

Discussion

Handles Database End Transaction Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– count:column:distinct:whereClause:groupBys:having:

Handles Database Count Request From Hybrid.

- (NSString *)count:(NSString *)className column:(NSString *)column distinct:(NSString *)distinct whereClause:(NSString *)whereClause groupBys:(NSEnumerator *)groupBys having:(NSString *)having

Parameters

className

Hybrid Model Class Name.
column

Name of Column For Which Count Needs To Be Find.
distinct

Distinct tuples needs to be calculated or not.
whereClause

Where Clause based on which Count needs to be found.
groupBys

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

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

Return Value

Count Of Tuples. @throws DatabaseException If any error occur while getting count.

Discussion

Handles Database Count Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– avg:columnName:whereClause:groupBys:having:

Handles Database Average Request From Hybrid.

- (NSString *)avg:(NSString *)className columnName:(NSString *)columnName whereClause:(NSString *)whereClause groupBys:(NSEnumerator *)groupBys having:(NSString *)having

Parameters

className

Hybrid Model Class Name.
whereClause

Where Clause based on which Average needs to be found.
groupBys

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

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

Name of Column For Which Average Needs To Be Find.

Return Value

Average Of Tuples. @throws DatabaseException If any error occur while getting count.

Discussion

Handles Database Average Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– sum:columnName:whereClause:groupBys:having:

Handles Database Sum Request From Hybrid.

- (NSString *)sum:(NSString *)className columnName:(NSString *)columnName whereClause:(NSString *)whereClause groupBys:(NSEnumerator *)groupBys having:(NSString *)having

Parameters

className

Hybrid Model Class Name.
whereClause

Where Clause based on which Sum needs to be found.
groupBys

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

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

Name of Column For Which Sum Needs To Be Find.

Return Value

Sum Of Tuples. @throws DatabaseException If any error occur while getting sum.

Discussion

Handles Database Sum Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– total:columnName:whereClause:groupBys:having:

Handles Database Total Request From Hybrid.

- (NSString *)total:(NSString *)className columnName:(NSString *)columnName whereClause:(NSString *)whereClause groupBys:(NSEnumerator *)groupBys having:(NSString *)having

Parameters

className

Hybrid Model Class Name.
whereClause

Where Clause based on which Total needs to be found.
groupBys

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

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

Name of Column For Which Total Needs To Be Find.

Return Value

Total Of Tuples. @throws DatabaseException If any error occur while getting total.

Discussion

Handles Database Total Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– min:columnName:whereClause:groupBys:having:

Handles Database Minimum Request From Hybrid.

- (NSString *)min:(NSString *)className columnName:(NSString *)columnName whereClause:(NSString *)whereClause groupBys:(NSEnumerator *)groupBys having:(NSString *)having

Parameters

className

Hybrid Model Class Name.
whereClause

Where Clause based on which Minimum needs to be found.
groupBys

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

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

Name of Column For Which Minimum Needs To Be Find.

Return Value

Minimum Of Tuples. @throws DatabaseException If any error occur while getting minimum.

Discussion

Handles Database Minimum Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– max:columnName:whereClause:groupBys:having:

Handles Database Maximum Request From Hybrid.

- (NSString *)max:(NSString *)className columnName:(NSString *)columnName whereClause:(NSString *)whereClause groupBys:(NSEnumerator *)groupBys having:(NSString *)having

Parameters

className

Hybrid Model Class Name.
whereClause

Where Clause based on which Maximum needs to be found.
groupBys

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

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

Name of Column For Which Maximum Needs To Be Find.

Return Value

Maximum Of Tuples. @throws DatabaseException If any error occur while getting maximum.

Discussion

Handles Database Maximum Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– groupConcat:columnName:delimiter:whereClause:groupBys:having:

Handles Database Group Concat Request From Hybrid.

- (NSString *)groupConcat:(NSString *)className columnName:(NSString *)columnName delimiter:(NSString *)delimiter whereClause:(NSString *)whereClause groupBys:(NSEnumerator *)groupBys having:(NSString *)having

Parameters

className

Hybrid Model Class Name.
whereClause

Where Clause based on which Group Concat needs to be found.
groupBys

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

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

Name of Column For Which Group Concat Needs To Be Find.

Return Value

Group Concat Of Tuples. @throws DatabaseException If any error occur while getting Group Concat.

Discussion

Handles Database Group Concat Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– getTableName:

Handles Database Get Table Name Request From Hybrid.

- (NSString *)getTableName:(NSString *)className

Parameters

className

Hybrid Model Class Name.

Return Value

Table Name. @throws DatabaseException If any error occur while get table name mapped to hybrid model class name.

Discussion

Handles Database Get Table Name Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– getColumnNames:

Handles Database Get Columns Names Request From Hybrid.

- (NSString *)getColumnNames:(NSString *)className

Parameters

className

Hybrid Model Class Name.

Return Value

Column Names. @throws DatabaseException If any error occur while getting column names mapped to hybrid model class name.

Discussion

Handles Database Get Columns Names Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– getColumnTypes:

Handles Database Get Columns Types Request From Hybrid.

- (NSString *)getColumnTypes:(NSString *)className

Parameters

className

Hybrid Model Class Name.

Return Value

Column Types. @throws DatabaseException If any error occur while getting column types mapped to hybrid model class name.

Discussion

Handles Database Get Columns Types Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– getPrimaryKeys:

Handles Database Get Primary Column Names Request From Hybrid.

- (NSString *)getPrimaryKeys:(NSString *)className

Parameters

className

Hybrid Model Class Name.

Return Value

Primary Column Names. @throws DatabaseException If any error occur while get primary column names mapped to hybrid model class name.

Discussion

Handles Database Get Primary Column Names Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– getMandatoryFields:

Handles Database Get Mandatory Column Names Request From Hybrid.

- (NSString *)getMandatoryFields:(NSString *)className

Parameters

className

Hybrid Model Class Name.

Return Value

Mandatory Names. @throws DatabaseException If any error occur while getting mandatory column names mapped to hybrid model class name.

Discussion

Handles Database Get Mandatory Column Names Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– getUniqueFields:

Handles Database Get Unique Column Names Request From Hybrid.

- (NSString *)getUniqueFields:(NSString *)className

Parameters

className

Hybrid Model Class Name.

Return Value

Unique Column Names. @throws DatabaseException If any error occur while getting unique column names.

Discussion

Handles Database Get Unique Column Names Request From Hybrid.

Declared In

SIHDatabaseHandler.h

– getForeignKeys:

Handle Database Get Foreign Column Names Request From Hybrid.

- (NSString *)getForeignKeys:(NSString *)className

Parameters

className

Hybrid Model Class Name.

Return Value

Foreign Column Names. @throws DatabaseException If any error occur while getting foreign column names.

Discussion

Handle Database Get Foreign Column Names Request From Hybrid.

Declared In

SIHDatabaseHandler.h