|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectcom.vaadin.data.util.sqlcontainer.query.generator.DefaultSQLGenerator
public class DefaultSQLGenerator
Generates generic SQL that is supported by HSQLDB, MySQL and PostgreSQL.
| Constructor Summary | |
|---|---|
DefaultSQLGenerator()
|
|
DefaultSQLGenerator(Class<? extends StatementHelper> statementHelperClazz)
Create a new DefaultSqlGenerator instance that uses the given implementation of StatementHelper |
|
DefaultSQLGenerator(String quoteStart,
String quoteEnd)
Construct a DefaultSQLGenerator with the specified identifiers for start and end of quoted strings. |
|
DefaultSQLGenerator(String quoteStart,
String quoteEnd,
Class<? extends StatementHelper> statementHelperClazz)
Same as DefaultSQLGenerator(String, String) but with support for
custom StatementHelper implementation. |
|
| Method Summary | |
|---|---|
protected Map<String,Object> |
generateColumnToValueMap(RowItem item)
|
StatementHelper |
generateDeleteQuery(String tableName,
List<String> primaryKeyColumns,
String versionColumn,
RowItem item)
Generates a DELETE query for deleting data related to the given RowItem from the database. |
StatementHelper |
generateInsertQuery(String tableName,
RowItem item)
Generates an INSERT query for inserting a new row with the provided values. |
protected StringBuffer |
generateLimits(StringBuffer sb,
int offset,
int pagelength)
Generates the LIMIT and OFFSET clause. |
protected StringBuffer |
generateOrderBy(StringBuffer sb,
OrderBy o,
boolean firstOrderBy)
Generates sorting rules as an ORDER BY -clause |
protected Map<String,Object> |
generateRowIdentifiers(RowItem item)
|
StatementHelper |
generateSelectQuery(String tableName,
List<Container.Filter> filters,
List<OrderBy> orderBys,
int offset,
int pagelength,
String toSelect)
Generates a SELECT query with the provided parameters. |
StatementHelper |
generateUpdateQuery(String tableName,
RowItem item)
Generates an UPDATE query with the provided parameters. |
protected StatementHelper |
getStatementHelper()
Returns the statement helper for the generator. |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
|---|
public DefaultSQLGenerator()
public DefaultSQLGenerator(Class<? extends StatementHelper> statementHelperClazz)
StatementHelper
statementHelper -
public DefaultSQLGenerator(String quoteStart,
String quoteEnd)
quoteStart - the identifier (character) denoting the start of a quoted
stringquoteEnd - the identifier (character) denoting the end of a quoted string
public DefaultSQLGenerator(String quoteStart,
String quoteEnd,
Class<? extends StatementHelper> statementHelperClazz)
DefaultSQLGenerator(String, String) but with support for
custom StatementHelper implementation.
quoteStart - quoteEnd - statementHelperClazz - | Method Detail |
|---|
public StatementHelper generateSelectQuery(String tableName,
List<Container.Filter> filters,
List<OrderBy> orderBys,
int offset,
int pagelength,
String toSelect)
SQLGenerator
generateSelectQuery in interface SQLGeneratortableName - Name of the table queriedfilters - The filters, converted into a WHERE clauseorderBys - The the ordering conditions, converted into an ORDER BY clauseoffset - The offset of the first row to be includedpagelength - The number of rows to be returned when the query executestoSelect - String containing what to select, e.g. "*", "COUNT(*)"
public StatementHelper generateUpdateQuery(String tableName,
RowItem item)
SQLGenerator
generateUpdateQuery in interface SQLGeneratortableName - Name of the table querieditem - RowItem containing the updated values update.
public StatementHelper generateInsertQuery(String tableName,
RowItem item)
SQLGenerator
generateInsertQuery in interface SQLGeneratortableName - Name of the table querieditem - New RowItem to be inserted into the database.
public StatementHelper generateDeleteQuery(String tableName,
List<String> primaryKeyColumns,
String versionColumn,
RowItem item)
SQLGenerator
generateDeleteQuery in interface SQLGeneratortableName - Name of the table queriedprimaryKeyColumns - the names of the columns holding the primary key. Usually just
one column, but might be several.versionColumn - the column containing the version number of the row, null if
versioning (optimistic locking) not enabled.item - Item to be deleted from the database
protected StringBuffer generateOrderBy(StringBuffer sb,
OrderBy o,
boolean firstOrderBy)
sb - StringBuffer to which the clause is appended.o - OrderBy object to be added into the sb.firstOrderBy - If true, this is the first OrderBy.
protected StringBuffer generateLimits(StringBuffer sb,
int offset,
int pagelength)
sb - StringBuffer to which the clause is appended.offset - Value for offset.pagelength - Value for pagelength.
protected Map<String,Object> generateColumnToValueMap(RowItem item)
protected Map<String,Object> generateRowIdentifiers(RowItem item)
protected StatementHelper getStatementHelper()
http://dev.vaadin.com/ticket/9148
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||