siminov.orm.database.sqlite
Class QueryBuilder
java.lang.Object
siminov.orm.database.sqlite.QueryBuilder
- All Implemented Interfaces:
- Constants, IQueryBuilder
public class QueryBuilder
- extends java.lang.Object
- implements Constants, IQueryBuilder
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 |
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 |
QueryBuilder
public QueryBuilder()
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.
Copyright 2013