ORADBManager Class Reference
| Inherits from | NSObject |
|---|---|
| Declared in | ORADBManager.h |
Overview
ORADBManager main purpose is to provide Database operation like create table, insert, update, delete & etc
-- insertOrReplaceDataInto:withContentValues:
Insert or Replace the given dictionary data into the table
- (BOOL)insertOrReplaceDataInto:(NSString *)tableName withContentValues:(NSDictionary *)contentValues
Parameters
tableName
|
The name of table |
|---|---|
contentValues
|
The Dictionary which contains column name as key and it's value (Supports NSString, NSData and NSNumber) |
Return Value
Yes, if data inserted / replaced or No, if not
Declared In
ORADBManager.h
-- getData:whereColumn:columnValue:
Get table data as an array for the table name with column name and value
- (NSArray *)getData:(NSString *)tableName whereColumn:(NSString *)columnName columnValue:(NSString *)columnValue
Parameters
tableName
|
The name of table |
|---|---|
columnName
|
The column name to filter |
columnValue
|
The culumn value to filter |
Return Value
An array of rows
Declared In
ORADBManager.h
-- getData:whereColumn:valueRange:
Get table data as an array for the table name with column name and value range
- (NSArray *)getData:(NSString *)tableName whereColumn:(NSString *)columnName valueRange:(NSArray *)range
Parameters
tableName
|
The name of table |
|---|---|
columnName
|
The column name to filter |
range
|
The two column values in array pattern. Ex. To return rows with eventIDs from 1 to 10, the array will be ["1", "10"] |
Return Value
An array of rows
Declared In
ORADBManager.h
-- deleteData:columnName:columnValue:
Delete table data for a given table name, column name and column value
- (BOOL)deleteData:(NSString *)tableName columnName:(NSString *)columnName columnValue:(NSString *)columnValue
Parameters
tableName
|
The name of table |
|---|---|
columnName
|
The name of column |
columnValue
|
The column value |
Return Value
Yes, if the table data is deleted. No, otherwise
Declared In
ORADBManager.h
-- deleteData:columnName:valueRange:
Delete table data for a given table name, column name and column value
- (BOOL)deleteData:(NSString *)tableName columnName:(NSString *)columnName valueRange:(NSArray *)range
Parameters
tableName
|
The name of table |
|---|---|
columnName
|
The name of column |
range
|
The two column values in array pattern. Ex. To delete rows with eventIDs from 1 to 10, the array will be ["1", "10"] |
Return Value
Yes, if the table data is deleted. No, otherwise
Declared In
ORADBManager.h