Produced by Siminov Software Solution LLP

siminov.orm.database.sqlite
Class QueryBuilder

java.lang.Object
  extended by siminov.orm.database.sqlite.QueryBuilder
All Implemented Interfaces:
Constants, IQueryBuilder

public class QueryBuilder
extends java.lang.Object
implements Constants, IQueryBuilder


Field Summary
 
Fields inherited from interface siminov.orm.Constants
ANDROID_METADATA_TABLE_NAME, ANNOTATION_DATABASE_MAPPING_COLUMN_PROPERTIES_METHOD_GET_PROPERTIES, ANNOTATION_DATABASE_MAPPING_COLUMN_PROPERTY_CHECK, ANNOTATION_DATABASE_MAPPING_COLUMN_PROPERTY_DEFAULT, ANNOTATION_DATABASE_MAPPING_COLUMN_PROPERTY_METHOD_GET_NAME, ANNOTATION_DATABASE_MAPPING_COLUMN_PROPERTY_METHOD_GET_VALUE, ANNOTATION_DATABASE_MAPPING_COLUMN_PROPERTY_NOT_NULL, ANNOTATION_DATABASE_MAPPING_COLUMN_PROPERTY_PRIMARY_KEY, ANNOTATION_DATABASE_MAPPING_COLUMN_PROPERTY_UNIQUE, ANNOTATION_DATABASE_MAPPING_INDEX_COLUMN_METHOD_GET_COLUMN, ANNOTATION_DATABASE_MAPPING_INDEX_METHOD_GET_IS_UNIQUE, ANNOTATION_DATABASE_MAPPING_INDEX_METHOD_GET_NAME, ANNOTATION_DATABASE_MAPPING_INDEX_METHOD_GET_VALUE, ANNOTATION_DATABASE_MAPPING_INDEXES_METHOD_GET_VALUES, ANNOTATION_DATABASE_MAPPING_METHOD_GET_COLUMN_NAME, ANNOTATION_DATABASE_MAPPING_METHOD_GET_TABLE_NAME, ANNOTATION_DATABASE_MAPPING_RELATIONSHIP_ON_DELETE_ATTRIBUTE, ANNOTATION_DATABASE_MAPPING_RELATIONSHIP_ON_UPDATE_ATTRIBUTE, ANNOTATION_DATABASE_MAPPING_RELATIONSHIP_PROPERTIES_METHOD_GET_PROPERTIES, ANNOTATION_DATABASE_MAPPING_RELATIONSHIP_PROPERTY_LOAD, ANNOTATION_DATABASE_MAPPING_RELATIONSHIP_PROPERTY_METHOD_GET_NAME, ANNOTATION_DATABASE_MAPPING_RELATIONSHIP_PROPERTY_METHOD_GET_VALUE, APPLICATION_DESCRIPTOR_DATABASE_DESCRIPTOR, APPLICATION_DESCRIPTOR_DATABASE_DESCRIPTORS, APPLICATION_DESCRIPTOR_DESCRIPTION, APPLICATION_DESCRIPTOR_EVENT_HANDLER, APPLICATION_DESCRIPTOR_EVENT_HANDLERS, APPLICATION_DESCRIPTOR_FILE_NAME, APPLICATION_DESCRIPTOR_LOAD_INITIALLY, APPLICATION_DESCRIPTOR_NAME, APPLICATION_DESCRIPTOR_PROPERTY, APPLICATION_DESCRIPTOR_SIMINOV, APPLICATION_DESCRIPTOR_VERSION, DATABASE_DESCRIPTOR, DATABASE_DESCRIPTOR_DATABASE_MAPPING, DATABASE_DESCRIPTOR_DATABASE_MAPPINGS, DATABASE_DESCRIPTOR_DATABASE_NAME, DATABASE_DESCRIPTOR_DESCRIPTION, DATABASE_DESCRIPTOR_EXTERNAL_STORAGE, DATABASE_DESCRIPTOR_IS_LOCKING_REQUIRED, DATABASE_DESCRIPTOR_LIBRARIES, DATABASE_DESCRIPTOR_LIBRARY, DATABASE_DESCRIPTOR_PATH, DATABASE_DESCRIPTOR_PROPERTY, DATABASE_DESCRIPTOR_PROPERTY_NAME, DATABASE_DESCRIPTOR_TYPE, DATABASE_DESCRIPTOR_VERSION, DATABASE_MAPPING_DESCRIPTOR_CHECK, DATABASE_MAPPING_DESCRIPTOR_CLASS_NAME, DATABASE_MAPPING_DESCRIPTOR_COLUMN, DATABASE_MAPPING_DESCRIPTOR_COLUMN_NAME, DATABASE_MAPPING_DESCRIPTOR_DATABASE_MAPPING, DATABASE_MAPPING_DESCRIPTOR_DEFAULT_VALUE, DATABASE_MAPPING_DESCRIPTOR_INDEX, DATABASE_MAPPING_DESCRIPTOR_NAME, DATABASE_MAPPING_DESCRIPTOR_NOT_NULL, DATABASE_MAPPING_DESCRIPTOR_NOT_NULL_FALSE, DATABASE_MAPPING_DESCRIPTOR_NOT_NULL_TRUE, DATABASE_MAPPING_DESCRIPTOR_PRIMARY_KEY, DATABASE_MAPPING_DESCRIPTOR_PROPERTY, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_CASCADE, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_LOAD, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_LOAD_FALSE, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_LOAD_TRUE, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_MANY_TO_MANY, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_MANY_TO_ONE, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_NO_ACTION, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_ON_DELETE, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_ON_UPDATE, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_ONE_TO_MANY, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_ONE_TO_ONE, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_REFER, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_REFER_TO, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_RESTRICT, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_SET_DEFAULT, DATABASE_MAPPING_DESCRIPTOR_RELATIONSHIPS_SET_NULL, DATABASE_MAPPING_DESCRIPTOR_TABLE, DATABASE_MAPPING_DESCRIPTOR_TABLE_NAME, DATABASE_MAPPING_DESCRIPTOR_TYPE, DATABASE_MAPPING_DESCRIPTOR_UNIQUE, DATABASE_MAPPING_DESCRIPTOR_UNIQUE_FALSE, DATABASE_MAPPING_DESCRIPTOR_UNIQUE_TRUE, DATABASE_MAPPING_DESCRIPTOR_VARIABLE_NAME, DATABASE_PATH_DATA, DATABASE_PATH_DATABASE, FALSE, FORM_ALTER_ADD_COLUMN_QUERY_COLUMN_NAME_PARAMETER, FORM_ALTER_ADD_COLUMN_QUERY_TABLE_NAME_PARAMETER, FORM_AVG_QUERY_COLUMN_PARAMETER, FORM_AVG_QUERY_GROUP_BYS_PARAMETER, FORM_AVG_QUERY_HAVING_PARAMETER, FORM_AVG_QUERY_TABLE_NAME_PARAMETER, FORM_AVG_QUERY_WHERE_CLAUSE_PARAMETER, FORM_COUNT_QUERY_COLUMN_PARAMETER, FORM_COUNT_QUERY_DISTINCT_PARAMETER, FORM_COUNT_QUERY_GROUP_BYS_PARAMETER, FORM_COUNT_QUERY_HAVING_PARAMETER, FORM_COUNT_QUERY_TABLE_NAME_PARAMETER, FORM_COUNT_QUERY_WHERE_CLAUSE_PARAMETER, FORM_CREATE_INDEX_QUERY_COLUMN_NAMES_PARAMETER, FORM_CREATE_INDEX_QUERY_INDEX_NAME_PARAMETER, FORM_CREATE_INDEX_QUERY_IS_UNIQUE_PARAMETER, FORM_CREATE_INDEX_QUERY_TABLE_NAME_PARAMETER, FORM_CREATE_TABLE_QUERY_CHECKS_PARAMETER, FORM_CREATE_TABLE_QUERY_COLUMN_NAMES_PARAMETER, FORM_CREATE_TABLE_QUERY_COLUMN_TYPES_PARAMETER, FORM_CREATE_TABLE_QUERY_DEFAULT_VALUES_PARAMETER, FORM_CREATE_TABLE_QUERY_FOREIGN_KEYS_PARAMETER, FORM_CREATE_TABLE_QUERY_NOT_NULLS_PARAMETER, FORM_CREATE_TABLE_QUERY_PRIMARY_KEYS_PARAMETER, FORM_CREATE_TABLE_QUERY_TABLE_NAME_PARAMETER, FORM_CREATE_TABLE_QUERY_UNIQUE_COLUMNS_PARAMETER, FORM_DELETE_QUERY_TABLE_NAME_PARAMETER, FORM_DELETE_QUERY_WHERE_CLAUSE_PARAMETER, FORM_DROP_INDEX_QUERY_INDEX_NAME_PARAMETER, FORM_DROP_INDEX_QUERY_TABLE_NAME_PARAMETER, FORM_DROP_TABLE_QUERY_TABLE_NAME_PARAMETER, FORM_FOREIGN_KEYS_DATABASE_DESCRIPTOR_PARAMETER, FORM_GROUP_CONCAT_QUERY_COLUMN_PARAMETER, FORM_GROUP_CONCAT_QUERY_DELIMITER_PARAMETER, FORM_GROUP_CONCAT_QUERY_GROUP_BYS_PARAMETER, FORM_GROUP_CONCAT_QUERY_HAVING_PARAMETER, FORM_GROUP_CONCAT_QUERY_TABLE_NAME_PARAMETER, FORM_GROUP_CONCAT_QUERY_WHERE_CLAUSE_PARAMETER, FORM_MAX_QUERY_COLUMN_PARAMETER, FORM_MAX_QUERY_GROUP_BYS_PARAMETER, FORM_MAX_QUERY_HAVING_PARAMETER, FORM_MAX_QUERY_TABLE_NAME_PARAMETER, FORM_MAX_QUERY_WHERE_CLAUSE_PARAMETER, FORM_MIN_QUERY_COLUMN_PARAMETER, FORM_MIN_QUERY_GROUP_BYS_PARAMETER, FORM_MIN_QUERY_HAVING_PARAMETER, FORM_MIN_QUERY_TABLE_NAME_PARAMETER, FORM_MIN_QUERY_WHERE_CLAUSE_PARAMETER, FORM_SAVE_BIND_QUERY_COLUMN_NAMES_PARAMETER, FORM_SAVE_BIND_QUERY_TABLE_NAME_PARAMETER, FORM_SELECT_QUERY_COLUMN_NAMES_PARAMETER, FORM_SELECT_QUERY_DISTINCT_PARAMETER, FORM_SELECT_QUERY_GROUP_BYS_PARAMETER, FORM_SELECT_QUERY_HAVING_PARAMETER, FORM_SELECT_QUERY_LIMIT_PARAMETER, FORM_SELECT_QUERY_ORDER_BYS_PARAMETER, FORM_SELECT_QUERY_TABLE_NAME_PARAMETER, FORM_SELECT_QUERY_WHERE_CLAUSE_PARAMETER, FORM_SELECT_QUERY_WHICH_ORDER_BY_PARAMETER, FORM_SUM_QUERY_COLUMN_PARAMETER, FORM_SUM_QUERY_GROUP_BYS_PARAMETER, FORM_SUM_QUERY_HAVING_PARAMETER, FORM_SUM_QUERY_TABLE_NAME_PARAMETER, FORM_SUM_QUERY_WHERE_CLAUSE_PARAMETER, FORM_TABLE_INFO_QUERY_NAME, FORM_TABLE_INFO_QUERY_TABLE_NAME_PARAMETER, FORM_TABLE_NAMES_NAME, FORM_TOTAL_QUERY_COLUMN_PARAMETER, FORM_TOTAL_QUERY_GROUP_BYS_PARAMETER, FORM_TOTAL_QUERY_HAVING_PARAMETER, FORM_TOTAL_QUERY_TABLE_NAME_PARAMETER, FORM_TOTAL_QUERY_WHERE_CLAUSE_PARAMETER, FORM_UPDATE_BIND_QUERY_COLUMN_NAMES_PARAMETER, FORM_UPDATE_BIND_QUERY_TABLE_NAME_PARAMETER, FORM_UPDATE_BIND_QUERY_WHERE_CLAUSE_PARAMETER, FORM_UPDATE_DATABASE_VERSION_QUERY_DATABASE_VERSION_PARAMETER, LIBRARY_DESCRIPTOR_DATABASE_MAPPING, LIBRARY_DESCRIPTOR_DATABASE_MAPPINGS, LIBRARY_DESCRIPTOR_DESCRIPTION, LIBRARY_DESCRIPTOR_FILE_NAME, LIBRARY_DESCRIPTOR_LIBRARY, LIBRARY_DESCRIPTOR_NAME, LIBRARY_DESCRIPTOR_PATH, LIBRARY_DESCRIPTOR_PROPERTY, QUERY_BUILDER_CASCADE, QUERY_BUILDER_IS_NULL, QUERY_BUILDER_NO_ACTION, QUERY_BUILDER_ON_DELETE, QUERY_BUILDER_ON_UPDATE, QUERY_BUILDER_RESTRICT, QUERY_BUILDER_SET_DEFAULT, QUERY_BUILDER_SET_NULL, SIMINOV_DESCRIPTOR_EXTENSION, SQLITE_DATABASE, SQLITE_DATABASE_BEGIN_TRANSACTION, SQLITE_DATABASE_COMMIT_TRANSACTION, SQLITE_DATABASE_ENABLE_LOCKING, SQLITE_DATABASE_END_TRANSACTION, SQLITE_DATABASE_EXTENSION, SQLITE_DATABASE_QUERY_TO_ENABLE_FOREIGN_KEYS_MAPPING, TRUE, XML_FILE_EXTENSION
 
Fields inherited from interface siminov.orm.database.design.IQueryBuilder
FORM_ALTER_ADD_COLUMN_QUERY_COLUMN_NAME_PARAMETER, FORM_ALTER_ADD_COLUMN_QUERY_TABLE_NAME_PARAMETER, FORM_AVG_QUERY_COLUMN_PARAMETER, FORM_AVG_QUERY_GROUP_BYS_PARAMETER, FORM_AVG_QUERY_HAVING_PARAMETER, FORM_AVG_QUERY_TABLE_NAME_PARAMETER, FORM_AVG_QUERY_WHERE_CLAUSE_PARAMETER, FORM_COUNT_QUERY_COLUMN_PARAMETER, FORM_COUNT_QUERY_DISTINCT_PARAMETER, FORM_COUNT_QUERY_GROUP_BYS_PARAMETER, FORM_COUNT_QUERY_HAVING_PARAMETER, FORM_COUNT_QUERY_TABLE_NAME_PARAMETER, FORM_COUNT_QUERY_WHERE_CLAUSE_PARAMETER, FORM_CREATE_INDEX_QUERY_COLUMN_NAMES_PARAMETER, FORM_CREATE_INDEX_QUERY_INDEX_NAME_PARAMETER, FORM_CREATE_INDEX_QUERY_IS_UNIQUE_PARAMETER, FORM_CREATE_INDEX_QUERY_TABLE_NAME_PARAMETER, FORM_CREATE_TABLE_QUERY_CHECKS_PARAMETER, FORM_CREATE_TABLE_QUERY_COLUMN_NAMES_PARAMETER, FORM_CREATE_TABLE_QUERY_COLUMN_TYPES_PARAMETER, FORM_CREATE_TABLE_QUERY_DEFAULT_VALUES_PARAMETER, FORM_CREATE_TABLE_QUERY_FOREIGN_KEYS_PARAMETER, FORM_CREATE_TABLE_QUERY_NOT_NULLS_PARAMETER, FORM_CREATE_TABLE_QUERY_PRIMARY_KEYS_PARAMETER, FORM_CREATE_TABLE_QUERY_TABLE_NAME_PARAMETER, FORM_CREATE_TABLE_QUERY_UNIQUE_COLUMNS_PARAMETER, FORM_DELETE_QUERY_TABLE_NAME_PARAMETER, FORM_DELETE_QUERY_WHERE_CLAUSE_PARAMETER, FORM_DROP_INDEX_QUERY_INDEX_NAME_PARAMETER, FORM_DROP_INDEX_QUERY_TABLE_NAME_PARAMETER, FORM_DROP_TABLE_QUERY_TABLE_NAME_PARAMETER, FORM_FOREIGN_KEYS_DATABASE_DESCRIPTOR_PARAMETER, FORM_GROUP_CONCAT_QUERY_COLUMN_PARAMETER, FORM_GROUP_CONCAT_QUERY_DELIMITER_PARAMETER, FORM_GROUP_CONCAT_QUERY_GROUP_BYS_PARAMETER, FORM_GROUP_CONCAT_QUERY_HAVING_PARAMETER, FORM_GROUP_CONCAT_QUERY_TABLE_NAME_PARAMETER, FORM_GROUP_CONCAT_QUERY_WHERE_CLAUSE_PARAMETER, FORM_MAX_QUERY_COLUMN_PARAMETER, FORM_MAX_QUERY_GROUP_BYS_PARAMETER, FORM_MAX_QUERY_HAVING_PARAMETER, FORM_MAX_QUERY_TABLE_NAME_PARAMETER, FORM_MAX_QUERY_WHERE_CLAUSE_PARAMETER, FORM_MIN_QUERY_COLUMN_PARAMETER, FORM_MIN_QUERY_GROUP_BYS_PARAMETER, FORM_MIN_QUERY_HAVING_PARAMETER, FORM_MIN_QUERY_TABLE_NAME_PARAMETER, FORM_MIN_QUERY_WHERE_CLAUSE_PARAMETER, FORM_SAVE_BIND_QUERY_COLUMN_NAMES_PARAMETER, FORM_SAVE_BIND_QUERY_TABLE_NAME_PARAMETER, FORM_SELECT_QUERY_COLUMN_NAMES_PARAMETER, FORM_SELECT_QUERY_DISTINCT_PARAMETER, FORM_SELECT_QUERY_GROUP_BYS_PARAMETER, FORM_SELECT_QUERY_HAVING_PARAMETER, FORM_SELECT_QUERY_LIMIT_PARAMETER, FORM_SELECT_QUERY_ORDER_BYS_PARAMETER, FORM_SELECT_QUERY_TABLE_NAME_PARAMETER, FORM_SELECT_QUERY_WHERE_CLAUSE_PARAMETER, FORM_SELECT_QUERY_WHICH_ORDER_BY_PARAMETER, FORM_SUM_QUERY_COLUMN_PARAMETER, FORM_SUM_QUERY_GROUP_BYS_PARAMETER, FORM_SUM_QUERY_HAVING_PARAMETER, FORM_SUM_QUERY_TABLE_NAME_PARAMETER, FORM_SUM_QUERY_WHERE_CLAUSE_PARAMETER, FORM_TABLE_INFO_QUERY_TABLE_NAME_PARAMETER, FORM_TOTAL_QUERY_COLUMN_PARAMETER, FORM_TOTAL_QUERY_GROUP_BYS_PARAMETER, FORM_TOTAL_QUERY_HAVING_PARAMETER, FORM_TOTAL_QUERY_TABLE_NAME_PARAMETER, FORM_TOTAL_QUERY_WHERE_CLAUSE_PARAMETER, FORM_UPDATE_BIND_QUERY_COLUMN_NAMES_PARAMETER, FORM_UPDATE_BIND_QUERY_TABLE_NAME_PARAMETER, FORM_UPDATE_BIND_QUERY_WHERE_CLAUSE_PARAMETER, FORM_UPDATE_DATABASE_VERSION_QUERY_DATABASE_VERSION_PARAMETER
 
Constructor Summary
QueryBuilder()
           
 
Method Summary
 java.lang.String formAlterAddColumnQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          Build query to alter add new column to table.
 java.lang.String formAvgQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates query to get average of column.
 java.lang.String formCountQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generated query to get count of tuples from table based on condition provided.
 java.lang.String formCreateIndexQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          Build query to create index.
 java.lang.String formCreateTableQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          Build query to create table.
 java.lang.String formDeleteQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates query to delete tuple from table.
 java.lang.String formDropIndexQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates query to drop index from table.
 java.lang.String formDropTableQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates query to drop table from database.
 java.lang.String formFetchDatabaseVersionQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          Build query to get database version.
 java.lang.String formForeignKeyQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates query to create foreign keys in table.
 java.lang.String formGroupConcatQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates query to get group concat value.
 java.lang.String formMaxQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates query to get maximum value of column based on group.
 java.lang.String formMinQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates query to get minimum value of column based on group by clause.
 java.lang.String formSaveBindQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates bind query to insert tuple in table.
 java.lang.String formSelectQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generated query to fetch tuples from table.
 java.lang.String formSumQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates query to get sum of column values.
 java.lang.String formTableInfoQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          Build query to get table info.
 java.lang.String formTableNames(java.util.Map<java.lang.String,java.lang.Object> parameters)
          Build query to get all table names exists in database.
 java.lang.String formTotalQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates query to get total of a column.
 java.lang.String formUpdateBindQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          It generates bind query to update tuple in table.
 java.lang.String formUpdateDatabaseVersionQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
          Build query to update database version.
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

QueryBuilder

public QueryBuilder()
Method Detail

formTableInfoQuery

public java.lang.String formTableInfoQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
Description copied from interface: IQueryBuilder
Build query to get table info.

Specified by:
formTableInfoQuery in interface IQueryBuilder
Parameters:
parameters - Required to build query.
Returns:
Table Info Query.

formFetchDatabaseVersionQuery

public java.lang.String formFetchDatabaseVersionQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
Description copied from interface: IQueryBuilder
Build query to get database version.

Specified by:
formFetchDatabaseVersionQuery in interface IQueryBuilder
Parameters:
parameters - Required to build query.
Returns:
Fetch Database Version Query.

formUpdateDatabaseVersionQuery

public java.lang.String formUpdateDatabaseVersionQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
Description copied from interface: IQueryBuilder
Build query to update database version.

Specified by:
formUpdateDatabaseVersionQuery in interface IQueryBuilder
Parameters:
parameters - Required to build query.
Returns:
Update Database Version Query.

formAlterAddColumnQuery

public java.lang.String formAlterAddColumnQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
Description copied from interface: IQueryBuilder
Build query to alter add new column to table.

Specified by:
formAlterAddColumnQuery in interface IQueryBuilder
Parameters:
parameters - Required to build query.
Returns:
Alter Add New Column Query.

formTableNames

public java.lang.String formTableNames(java.util.Map<java.lang.String,java.lang.Object> parameters)
Description copied from interface: IQueryBuilder
Build query to get all table names exists in database.

Specified by:
formTableNames in interface IQueryBuilder
Parameters:
parameters - Required to build query.
Returns:
Table Names Query.

formCreateTableQuery

public java.lang.String formCreateTableQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
Description copied from interface: IQueryBuilder
Build query to create table.

Specified by:
formCreateTableQuery in interface IQueryBuilder
Parameters:
parameters - Required to build query.
Returns:
Create Table Query.

formCreateIndexQuery

public java.lang.String formCreateIndexQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
Description copied from interface: IQueryBuilder
Build query to create index.

Specified by:
formCreateIndexQuery in interface IQueryBuilder
Parameters:
parameters - Required to build query.
Returns:
Create Index Query.

formDropTableQuery

public java.lang.String formDropTableQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates query to drop table from database.

Specified by:
formDropTableQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
Returns:
Generated query.

formDropIndexQuery

public java.lang.String formDropIndexQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates query to drop index from table.

Specified by:
formDropIndexQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
indexName - Name of index.
Returns:
Generated query.

formSelectQuery

public java.lang.String formSelectQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generated query to fetch tuples from table.

Specified by:
formSelectQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
whereClause - Condition based on tuples need to fetch.
columnNames - Column names.
groupBys - Group by clause.
having - Having clause.
orderBy - Order by column names.
limit - Limit of tuples needed.
Returns:
Generated query.

formSaveBindQuery

public java.lang.String formSaveBindQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates bind query to insert tuple in table.

Specified by:
formSaveBindQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
columnNames - Column names.
Returns:
Generated query.

formUpdateBindQuery

public java.lang.String formUpdateBindQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates bind query to update tuple in table.

Specified by:
formUpdateBindQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
columnNames - Column names.
whereClause - Condition of which tuple need to be update.
Returns:
Generated query.

formDeleteQuery

public java.lang.String formDeleteQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates query to delete tuple from table.

Specified by:
formDeleteQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
whereClause - Condition on which tuples need to delete.
Returns:
Generated query.

formCountQuery

public java.lang.String formCountQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generated query to get count of tuples from table based on condition provided.

Specified by:
formCountQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
whereClause - Condition on which count needed.
Returns:
Generated query.

formAvgQuery

public java.lang.String formAvgQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates query to get average of column.

Specified by:
formAvgQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
columnName - Column name of which average needed.
Returns:
Generated query.

formSumQuery

public java.lang.String formSumQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates query to get sum of column values.

Specified by:
formSumQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
columnName - Column name of which sum needed.
Returns:
Generated query.

formTotalQuery

public java.lang.String formTotalQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates query to get total of a column.

Specified by:
formTotalQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
columnName - Column name of which total needed.
Returns:
Generated query.

formMaxQuery

public java.lang.String formMaxQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates query to get maximum value of column based on group.

Specified by:
formMaxQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
columnName - Column name of which maximum value needed.
groupBy - Group by clause.
Returns:
Generated query.

formMinQuery

public java.lang.String formMinQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates query to get minimum value of column based on group by clause.

Specified by:
formMinQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
columnName - Column name of which minimum value needed.
groupBy - Group by clause.
Returns:
Generated query.

formGroupConcatQuery

public java.lang.String formGroupConcatQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates query to get group concat value.

Specified by:
formGroupConcatQuery in interface IQueryBuilder
Parameters:
tableName - Name of table.
columnName - Column name of which group concat needed.
delimiter - Delimiter value.
whereClause - Condition on which group concat needed.
Returns:
Generated query.

formForeignKeyQuery

public java.lang.String formForeignKeyQuery(java.util.Map<java.lang.String,java.lang.Object> parameters)
It generates query to create foreign keys in table.

Specified by:
formForeignKeyQuery in interface IQueryBuilder
Parameters:
relationships - References provided to create foreign key.
Returns:
Generated query.

Apache License 2.0

Copyright 2013