|
Produced by Siminov Software Solution | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectsiminov.orm.database.QueryBuilder
public abstract class QueryBuilder
Field Summary |
---|
Constructor Summary | |
---|---|
QueryBuilder()
|
Method Summary | |
---|---|
static java.lang.String |
formAvgQuery(java.lang.String tableName,
java.lang.String columnName)
It generates query to get average of column. |
static java.lang.String |
formCountQuery(java.lang.String tableName,
java.lang.String whereClause)
It generated query to get count of tuples from table based on condition provided. |
static java.lang.String |
formCreateIndexQuery(java.lang.String indexName,
java.lang.String tableName,
java.util.Iterator<java.lang.String> columnNames,
boolean isUnique)
It generates query to create index on table specified. |
static java.lang.String |
formCreateTableQuery(java.lang.String tableName,
java.util.Iterator<java.lang.String> columnNames,
java.util.Iterator<java.lang.String> columnTypes,
java.util.Iterator<java.lang.String> defaultValues,
java.util.Iterator<java.lang.String> checks,
java.util.Iterator<java.lang.String> primaryKeys,
java.util.Iterator<java.lang.Boolean> isNotNull,
java.util.Iterator<java.lang.String> uniqueColumns,
java.lang.String foreignKeys)
It generates query to create table in database. |
static java.lang.String |
formDeleteQuery(java.lang.String tableName,
java.lang.String whereClause)
It generates query to delete tuple from table. |
static java.lang.String |
formDropIndexQuery(java.lang.String tableName,
java.lang.String indexName)
It generates query to drop index from table. |
static java.lang.String |
formDropTableQuery(java.lang.String tableName)
It generates query to drop table from database. |
static java.lang.String |
formFetchQuery(java.lang.String tableName,
java.lang.String whereClause,
java.util.Iterator<java.lang.String> columnNames,
java.util.Iterator<java.lang.String> groupBys,
java.lang.String having,
java.util.Iterator<java.lang.String> orderBy,
java.lang.String limit)
It generated query to fetch tuples from table. |
static java.lang.String |
formForeignKeys(DatabaseMappingDescriptor child)
It generates query to create foreign keys in table. |
static java.lang.String |
formGroupConcatQuery(java.lang.String tableName,
java.lang.String columnName,
java.lang.String delimiter,
java.lang.String whereClause)
It generates query to get group concat value. |
static java.lang.String |
formInsertBindQuery(java.lang.String tableName,
java.util.Iterator<java.lang.String> columnNames)
It generates bind query to insert tuple in table. |
static java.lang.String |
formMaxQuery(java.lang.String tableName,
java.lang.String columnName,
java.lang.String groupBy)
It generates query to get maximum value of column based on group. |
static java.lang.String |
formMinQuery(java.lang.String tableName,
java.lang.String columnName,
java.lang.String groupBy)
It generates query to get minimum value of column based on group by clause. |
static java.lang.String |
formSumQuery(java.lang.String tableName,
java.lang.String columnName)
It generates query to get sum of column values. |
static java.lang.String |
formTotalQuery(java.lang.String tableName,
java.lang.String columnName)
It generates query to get total of a column. |
static java.lang.String |
formTriggerOnDeleteCascade(java.lang.String triggerName,
java.lang.String parentTable,
java.lang.String childTable,
java.util.Iterator<java.lang.String> foreignKeys)
It generates query to create trigger to put cascade delete constraint on table. |
static java.lang.String |
formTriggerOnDeleteOrUpdateSetNull(java.lang.String triggerName,
java.lang.String parentTable,
java.lang.String childTable,
java.util.Iterator<java.lang.String> foreignKeys)
It generates query to create trigger to put set null update constraint on table. |
static java.lang.String |
formTriggerOnInsertEnforceReferentialIntegrity(java.lang.String triggerName,
java.lang.String parentTable,
java.lang.String childTable,
java.util.Iterator<java.lang.String> foreignKeys)
It generates query to create trigger to put delete referential integrity. |
static java.lang.String |
formTriggerOnUpdateCascade(java.lang.String triggerName,
java.lang.String parentTable,
java.lang.String childTable,
java.util.Iterator<java.lang.String> foreignKeys)
It generates query to create trigger to put cascade update constraint on table. |
static java.lang.String |
formTriggerOnUpdateEnforceReferentialIntegrity(java.lang.String triggerName,
java.lang.String parentTable,
java.lang.String childTable,
java.util.Iterator<java.lang.String> foreignKeys)
It generates query to create trigger to put update referential integrity. |
static java.util.Iterator<java.lang.String> |
formTriggers(DatabaseMappingDescriptor child)
It generates query to create trigger based on parameters provided. |
static java.lang.String |
formUpdateBindQuery(java.lang.String tableName,
java.util.Iterator<java.lang.String> columnNames,
java.lang.String whereClause)
It generates bind query to update tuple in table. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public QueryBuilder()
Method Detail |
---|
public static java.lang.String formCreateTableQuery(java.lang.String tableName, java.util.Iterator<java.lang.String> columnNames, java.util.Iterator<java.lang.String> columnTypes, java.util.Iterator<java.lang.String> defaultValues, java.util.Iterator<java.lang.String> checks, java.util.Iterator<java.lang.String> primaryKeys, java.util.Iterator<java.lang.Boolean> isNotNull, java.util.Iterator<java.lang.String> uniqueColumns, java.lang.String foreignKeys)
tableName
- Name of table.columnNames
- All column names needed in table.columnTypes
- All column types, It can be TEXT, INTEGER, LONG, BLOG, FLOATdefaultValues
- Default value columns.checks
- Constraint needed on column value.primaryKeys
- Primary keys needed in table.isNotNull
- Weather column can contain empty value or not.uniqueColumns
- Weather column values should be unique or not.foreignKeys
- Foreign key contained in table.
public static java.lang.String formCreateIndexQuery(java.lang.String indexName, java.lang.String tableName, java.util.Iterator<java.lang.String> columnNames, boolean isUnique)
indexName
- Name of index.tableName
- Name of table on which index is required.columnNames
- Column names needed in index.isUnique
- true/false whether index needs to be unique or not. (A unique index guarantees that the index key contains no duplicate values and therefore every row in the table is in some way unique.)
public static java.lang.String formDropTableQuery(java.lang.String tableName)
tableName
- Name of table.
public static java.lang.String formDropIndexQuery(java.lang.String tableName, java.lang.String indexName)
tableName
- Name of table.indexName
- Name of index.
public static java.lang.String formFetchQuery(java.lang.String tableName, java.lang.String whereClause, java.util.Iterator<java.lang.String> columnNames, java.util.Iterator<java.lang.String> groupBys, java.lang.String having, java.util.Iterator<java.lang.String> orderBy, java.lang.String limit)
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.
public static java.lang.String formInsertBindQuery(java.lang.String tableName, java.util.Iterator<java.lang.String> columnNames)
tableName
- Name of table.columnNames
- Column names.
public static java.lang.String formUpdateBindQuery(java.lang.String tableName, java.util.Iterator<java.lang.String> columnNames, java.lang.String whereClause)
tableName
- Name of table.columnNames
- Column names.whereClause
- Condition of which tuple need to be update.
public static java.lang.String formDeleteQuery(java.lang.String tableName, java.lang.String whereClause)
tableName
- Name of table.whereClause
- Condition on which tuples need to delete.
public static java.lang.String formCountQuery(java.lang.String tableName, java.lang.String whereClause)
tableName
- Name of table.whereClause
- Condition on which count needed.
public static java.lang.String formAvgQuery(java.lang.String tableName, java.lang.String columnName)
tableName
- Name of table.columnName
- Column name of which average needed.
public static java.lang.String formMaxQuery(java.lang.String tableName, java.lang.String columnName, java.lang.String groupBy)
tableName
- Name of table.columnName
- Column name of which maximum value needed.groupBy
- Group by clause.
public static java.lang.String formMinQuery(java.lang.String tableName, java.lang.String columnName, java.lang.String groupBy)
tableName
- Name of table.columnName
- Column name of which minimum value needed.groupBy
- Group by clause.
public static java.lang.String formGroupConcatQuery(java.lang.String tableName, java.lang.String columnName, java.lang.String delimiter, java.lang.String whereClause)
tableName
- Name of table.columnName
- Column name of which group concat needed.delimiter
- Delimiter value.whereClause
- Condition on which group concat needed.
public static java.lang.String formSumQuery(java.lang.String tableName, java.lang.String columnName)
tableName
- Name of table.columnName
- Column name of which sum needed.
public static java.lang.String formTotalQuery(java.lang.String tableName, java.lang.String columnName)
tableName
- Name of table.columnName
- Column name of which total needed.
public static java.lang.String formTriggerOnUpdateCascade(java.lang.String triggerName, java.lang.String parentTable, java.lang.String childTable, java.util.Iterator<java.lang.String> foreignKeys)
triggerName
- Name of trigger needed.parentTable
- Name of parent table.childTable
- Name of child table.parentKeys
- Column names of parent table.childKeys
- Column names of child table.
public static java.lang.String formTriggerOnDeleteOrUpdateSetNull(java.lang.String triggerName, java.lang.String parentTable, java.lang.String childTable, java.util.Iterator<java.lang.String> foreignKeys)
triggerName
- Name of trigger needed.parentTable
- Name of parent table.childTable
- Name of child table.parentKeys
- Column names of parent table.childKeys
- Column names of child table.
public static java.lang.String formTriggerOnUpdateEnforceReferentialIntegrity(java.lang.String triggerName, java.lang.String parentTable, java.lang.String childTable, java.util.Iterator<java.lang.String> foreignKeys)
triggerName
- Name of table.parentTable
- Name of parent table.childTable
- Name of child table.parentKeys
- Column names of parent table.childKeys
- Column names of child table.
public static java.lang.String formTriggerOnInsertEnforceReferentialIntegrity(java.lang.String triggerName, java.lang.String parentTable, java.lang.String childTable, java.util.Iterator<java.lang.String> foreignKeys)
triggerName
- Name of table.parentTable
- Name of parent table.childTable
- Name of child table.parentKeys
- Column names of parent table.childKeys
- Column names of child table.
public static java.lang.String formTriggerOnDeleteCascade(java.lang.String triggerName, java.lang.String parentTable, java.lang.String childTable, java.util.Iterator<java.lang.String> foreignKeys)
triggerName
- Name of trigger needed.parentTable
- Name of parent table.childTable
- Name of child table.parentKeys
- Column names of parent table.childKeys
- Column names of child table.
public static java.util.Iterator<java.lang.String> formTriggers(DatabaseMappingDescriptor child)
childTable
- Name of child table.relationships
- References provided to create triggers.
public static java.lang.String formForeignKeys(DatabaseMappingDescriptor child)
relationships
- References provided to create foreign key.
|
Apache License 2.0 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |