SICQueryBuilder Class Reference
| Inherits from | NSObject |
|---|---|
| Conforms to | SICIQueryBuilder |
| Declared in | SICQueryBuilder.h SICQueryBuilder.m |
– formTableInfoQuery:
Form Table Info Query
- (NSString *)formTableInfoQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Table Info Query.
Discussion
Form Table Info Query
Build query to get table info.
Declared In
SICIQueryBuilder.h
– formFetchDatabaseVersionQuery:
Form Fetch Database Version Query
- (NSString *)formFetchDatabaseVersionQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Fetch Database Version Query.
Discussion
Form Fetch Database Version Query
Build query to get database version.
Declared In
SICIQueryBuilder.h
– formUpdateDatabaseVersionQuery:
Form Update Database Version Query.
- (NSString *)formUpdateDatabaseVersionQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Update Database Version Query.
Discussion
Form Update Database Version Query.
Build query to update database version.
Declared In
SICIQueryBuilder.h
– formAlterAddColumnQuery:
Form Alter Add Column Query
- (NSString *)formAlterAddColumnQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Alter Add New Column Query.
Discussion
Form Alter Add Column Query
Build query to alter add new column to table.
Declared In
SICIQueryBuilder.h
– formTableNames:
Form Table Names
- (NSString *)formTableNames:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Table Names Query.
Discussion
Form Table Names
Build query to get all table names exists in database.
Declared In
SICIQueryBuilder.h
– formCreateTableQuery:
Form Create Table Query
- (NSString *)formCreateTableQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Create Table Query.
Discussion
Form Create Table Query
Build query to create table.
Declared In
SICIQueryBuilder.h
– formCreateIndexQuery:
Form Create Index Query
- (NSString *)formCreateIndexQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Create Index Query.
Discussion
Form Create Index Query
Build query to create index.
Declared In
SICIQueryBuilder.h
– formDropTableQuery:
Form Drop Table Query
- (NSString *)formDropTableQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Drop Table Query.
Discussion
Form Drop Table Query
Build query to drop table.
Declared In
SICIQueryBuilder.h
– formDropIndexQuery:
Form Drop Index Query
- (NSString *)formDropIndexQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Drop Index Query.
Discussion
Form Drop Index Query
Build query to drop index from table.
Declared In
SICIQueryBuilder.h
– formSelectQuery:
Form Select Query
- (NSString *)formSelectQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Select Query.
Discussion
Form Select Query
Build query to fetch tuples from table.
Declared In
SICIQueryBuilder.h
– formSaveBindQuery:
Form Save Bind Query
- (NSString *)formSaveBindQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Save Query.
Discussion
Form Save Bind Query
Build query to insert data into table.
Declared In
SICIQueryBuilder.h
– formUpdateBindQuery:
Form Update Bind Query
- (NSString *)formUpdateBindQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Update Query.
Discussion
Form Update Bind Query
Build query to update tuples.
Declared In
SICIQueryBuilder.h
– formDeleteQuery:
Form Delete Query
- (NSString *)formDeleteQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Delete Query.
Discussion
Form Delete Query
Build query to delete tuples.
Declared In
SICIQueryBuilder.h
– formCountQuery:
Form Count Query
- (NSString *)formCountQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Count Query.
Discussion
Form Count Query
Build query to get count of tuples.
Declared In
SICIQueryBuilder.h
– formAvgQuery:
Form Average Query.
- (NSString *)formAvgQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Average Query.
Discussion
Form Average Query.
Build query to get Average.
Declared In
SICIQueryBuilder.h
– formSumQuery:
Form Sum Query.
- (NSString *)formSumQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Sum Query
Discussion
Form Sum Query.
Build query to get Sum.
Declared In
SICIQueryBuilder.h
– formTotalQuery:
Form Total Query
- (NSString *)formTotalQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Total Query.
Discussion
Form Total Query
Build query to get total.
Declared In
SICIQueryBuilder.h
– formMaxQuery:
Form Max Query.
- (NSString *)formMaxQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Max Query.
Discussion
Form Max Query.
Build query to get Max.
Declared In
SICIQueryBuilder.h
– formMinQuery:
Form Minimum Query
- (NSString *)formMinQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Minimum Query.
Discussion
Form Minimum Query
Build query to get Minimum Query.
Declared In
SICIQueryBuilder.h
– formGroupConcatQuery:
Form Group Concat Query
- (NSString *)formGroupConcatQuery:(NSMutableDictionary *const)parametersParameters
parameters |
Required to build query. |
|---|
Return Value
Group Concat Query.
Discussion
Form Group Concat Query
Build query to get group concat.
Declared In
SICIQueryBuilder.h
– formForeignKeyQuery:
Form Foreign Keys Query
- (NSString *)formForeignKeyQuery:(NSMutableDictionary *const)parametersParameters
entityDescriptor |
Database Descriptor Object. |
|---|
Return Value
Generated Query.
Discussion
Form Foreign Keys Query
Build query to generate foreign keys of table.
Declared In
SICIQueryBuilder.h